Excel crash if i try to print the generated File

[Nadeo]

Hi,

I have generated

test.xlsx

Not Printable xlsx-File.

(3.18 KiB) Downloaded 493 times

with xlsx4j , but if I try to print it, Excel crashes and restarts. This is the Error message without information :

Excel Error Message

printError.png (18.17 KiB) Viewed 2571 times

What did I do wrong?

Regards, Nadeo

[jason]

It crashes for me too.

Please find attached a fixed version (which Excel 2010 x64 can open / print OK).

You can compare the 2 files to determine the important difference, then mimic that. Please let us know what you find out!

[Nadeo]

Thanks for the first try.

I have compared the two files and the result is that all Files inside are different from the Original "test.xlsx" :

result.PNG (34.14 KiB) Viewed 2557 times

I begin now to search important differences.

[jason]

The OpenXMLDiff tool referred to in http://stackoverflow.com/questions/4224 ... -documents might help a bit ...

[Nadeo]

I have found the Problem:

Without this Part, the Printer-Driver can`t find the Right "View" :
/xl/workbook.xml:

Code: Select all

<bookViews>
   <workbookView xWindow="510" yWindow="510" windowWidth="11175" windowHeight="9915"/>
</bookViews>

To add it I have do this:

Code: Select all

SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
      workBook = pkg.getWorkbookPart();

      // OF = "ObjectFactory OF = Context.getsmlObjectFactory();"
      Workbook wb = OF.createWorkbook();
      BookViews bookview = OF.createBookViews();
      CTBookView ctBookview = OF.createCTBookView();
      ctBookview.setXWindow(510);
      ctBookview.setYWindow(510);
      ctBookview.setWindowWidth(11175L);
      ctBookview.setWindowHeight(9915L);
      bookview.getWorkbookView().add(ctBookview);
      wb.setBookViews(bookview);
      // without this, there will be an "nullPointerException" in :
      // SpreadsheetMLPackage
      // _____createWorksheetPart([...])
      // _________sheets.getSheet().add(s); <<--sheets is null without the next line
      wb.setSheets(OF.createSheets());
      workBook.setJaxbElement(wb);   

@jason:
to Compare XML I use the "Compare"-Plugin from Notepad++ in combination with "XML Tools"-Plugin .

Thanks for Help!!!

Thread can be closed.

[jason]

Thanks for your great detective work

Based on http://social.msdn.microsoft.com/Forums ... um=oxmlsdk
I have added:

https://github.com/plutext/docx4j/commi ... bb4d8149c5

So you won't need to do this yourself.

Curiously, without this it seems to only fail to print on some worksheets, not others. I think it is OK if you have content in cell A1, but not otherwise - something like that.