ParamQuery grid support forum

General Category => Bug Report => Topic started by: jkoci@volny.cz on October 15, 2017, 10:52:35 pm

Title: Attempt to print Excel sheet exported from PQGrid cause Excel crashed
Post by: jkoci@volny.cz on October 15, 2017, 10:52:35 pm

Hello.

Using standard export to excel feature works well, Excel sheet contain desired data. When I try to print the sheet directly exported, Excel crashes (tested on multiple computers). When user saves the excel sheet first, any trouble while printing occurred.

Any idea what is wrong?

Thanks,

Jan

Title: Re: Attempt to print Excel sheet exported from PQGrid cause Excel crashed
Post by: paramvir on October 16, 2017, 11:57:57 am

I'm unable to reproduce the issue. Which version of grid and Excel you have been testing on?

Your issue may be unrelated to grid.

https://www.google.co.in/search?q=excel+crash+print+preview&oq=excel+crash+print+preview

Title: Re: Attempt to print Excel sheet exported from PQGrid cause Excel crashed
Post by: jkoci@volny.cz on October 19, 2017, 11:47:19 am

Hello,

googling around it seems to be known Excel2010 behavior cause by wrong workbook.xml file generated by pqgrid.
The fix is to add   
  <bookViews>
    <workbookView />
  </bookViews>
before <sheets> element.  I have attached fixed xml which work for me.
Let me know when new version of fixed pqgrid is released.

Thnx,
Jan