On Fri, 28 Oct 2011, [email protected] wrote:
As part of the code we have, We are using setDisplayGridLines(false) to
hide the gridlines when the file is opened up on any PC. After upgrading
to SS package (to support both xls and xlsx), the same method seems to
work file for .xls files but not for .xlsx files. I am also calling the
setPrintGridlines(false) method though I think it is only relevant, when
the file is being printed.
From a first glance, the code for this looks fine, so we're probably
missing something a little subtle in the file format.
I'd suggest you create three files:
* A simple spreadsheet, with gridlines
* That spreadsheet, with gridlines "disabled" via POI
* That spreadsheet, with gridlines disabled by Excel
Then, unzip each file (.xlsx is a zip of xml files), and look for the
differences. Specifically, what has Excel done to disable gridlines, and
how does that compare to what POI has tried to do?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
