You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2003/06/18 19:46:02 UTC
DO NOT REPLY [Bug 20881] New: -
error occured in MS Excel:"Error in file: some number formats may be lost"
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=20881>.
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=20881
error occured in MS Excel:"Error in file: some number formats may be lost"
Summary: error occured in MS Excel:"Error in file: some number
formats may be lost"
Product: POI
Version: 1.5.1
Platform: PC
OS/Version: Windows NT/2K
Status: NEW
Severity: Critical
Priority: Other
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: pjanouskovec@cscploenzke.de
Hello,
I have problem with HSSF component. I use MS Office 2000 (Czech localize). When
I read and write workbook:
POIFSFileSystem fs =
new POIFSFileSystem(new FileInputStream("c:\\workbook1.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
//HSSFSheet sheet1 = wb.getSheetAt(1);
HSSFRow row = sheet.getRow(3);
HSSFCell cell = row.getCell((short)3);
if (cell == null)
cell = row.createCell((short) 2);
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
cell.setCellValue(80);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook2.xls");
wb.write(fileOut);
fileOut.close();
When I open workbook2.xls in MS Excel error occured in MS Excel "Error in file:
some number formats may be lost" and some data are losted in last sheet (I have
two sheets in workbook- first sheet is OK, but second sheet have some data
lost). I try use MS Excel 97, but I get same result.
Do you have any idea?
Best Regards
Pavel