poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 21884] - [RFE] Functions to hide gridlines of excel sheet using HSSF package not working
Date Fri, 25 Jul 2003 14:45:37 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21884>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21884

[RFE] Functions to hide gridlines of excel sheet using HSSF package not working

slaubach@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED



------- Additional Comments From slaubach@apache.org  2003-07-25 14:45 -------
Didn't get your email until after the commit but it meets your conditions.  It 
is just more code of the type I'm good at.

1.  Catch a record object and keep the reference (both in create and load).
2.  Add a couple of procedures that access values in the record object
3.  Give usermodel to said methods.

I did go a step further and found where the particular reference to the record 
was being retreived in a search and switched these over.  All hssf test cases 
ran and I can say that I improved performance (not enought to see but it is 
still an improvement).

So......

In answer to the question, to turn the display of gridlines off in the viewer, 
i.e. Excel, etc, make the following addition to your code.

sheet = wb.createSheet(sheetName);
                         /* Problem area */
 sheet.setGridsPrinted(false);             
 sheet.setPrintGridlines(false);
+sheet.setDisplayGridlines(false);

All of this brings up another issue, we have two methods that do the exact same 
thing, setGridsPrinted and setPrintGridlines in HSSFSheet, but that is another 
issue.

Mime
View raw message