poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: DO NOT REPLY [Bug 21884] - [RFE] Functions to hide gridlines of excel sheet using HSSF package not working
Date Fri, 25 Jul 2003 16:10:58 GMT
Shouldn't those be different.  Isn't one to do with them being printed and
one to do with them being displayed on the screen.

On 7/25/03 10:45 AM, "bugzilla@apache.org" <bugzilla@apache.org> wrote:

> 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.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


Mime
View raw message