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 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
