DO NOT REPLY [Bug 21884] New: - Functions to hide gridlines of excel sheet using HSSF package not working

[bu...@apache.org]

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

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

           Summary: Functions to hide gridlines of excel sheet using HSSF
                    package not working
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: Arshi.Singh@geind.ge.com


I have been using the apache.poi.hssf package for my project, version 1.10.0. I 
have made an excel sheet using HSSFSheet class in org.apache.poi.hssf.usermodel
package. 
This class has the following 2 member functions for setting properties of
gridlines on the sheet.

       void setGridsPrinted(boolean value)
       void setPrintGridlines(boolean newPrintGridlines)

 I tried to hide the gridlines using both these functions but they are not
working. On the printout there are no gridlines but on the excel sheet that i 
view on my PC i still see them in the background. Where am i going wrong?
The code is given below.
 
 import org.apache.poi.poifs.filesystem.POIFSFileSystem;
 import org.apache.poi.hssf.usermodel.*;
 import org.apache.poi.hssf.util.*;
 
 HSSFWorkbook wb;
 HSSFSheet sheet;
 HSSFRow sheet_row;
 .....
 
 { ....
 
 FileReader fr= new FileReader("abc.txt");
 BufferedReader br = new BufferedReader(fr);
 String sheetName="abc";
 String fileName ="xyz.xls";
 
 FileOutputStream fileOut = new FileOutputStream(fileName);
 
 wb = new HSSFWorkbook();
 sheet = wb.createSheet(sheetName);
                         /* Problem area */
 sheet.setGridsPrinted(false);             
 sheet.setPrintGridlines(false);
 ....
 ....
 
 wb.write(fileOut);
 fileOut.close();
 fr.close();
 }