Summary: | [RFE] Functions to hide gridlines of excel sheet using HSSF package not working | ||
---|---|---|---|
Product: | POI | Reporter: | arshi singh <Arshi.Singh> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 2.0-pre2 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All |
Description
arshi singh
2003-07-25 13:00:16 UTC
I really wish you'd begin by asking this as a question on the list and verify that these do what you think before filing a bug. Keyword in the code below is print. That only turns gridlines off in the printout. To answer the question, it is not possible with the current code. Give me about 30 more minutes and it should be implemented. please don't stick this in 2.0 unless its stable and innoculous. We need to work towards having less bugs in 2.0 so we can release it and focus on 3.0. Its you're call of course. 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. In which version can i find this newly added function. Currently i am using 1.10. Should i look for it in 2.0 Either in the CVS REL_2_0 branch (check it out and build it) or wait a few days for the 2.0-pre3 release. |