Author Topic: Attempt to print Excel sheet exported from PQGrid cause Excel crashed  (Read 2767 times)

[email protected]

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 30
    • View Profile
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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6296
    • View Profile
Re: Attempt to print Excel sheet exported from PQGrid cause Excel crashed
« Reply #1 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

[email protected]

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 30
    • View Profile
Re: Attempt to print Excel sheet exported from PQGrid cause Excel crashed
« Reply #2 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