https://issues.apache.org/bugzilla/show_bug.cgi?id=47028
Summary: Inconsistent behavior between HSSF, XSSF:
Cell.setCellStyle(...)
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23490)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23490)
test.xlsm
I have two workbooks "test.xlsm" and "test.xls". I write following codes to set
the cell "B2" to blank. The result behavior are different, XSSFWorkbook will
clear the CellStyle of the blank cell but HSSFWorkbook won't.
--
Workbook source = (read "test.xlsm" or "test.xls")
Sheet sheet = source.getSheetAt(0);
Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
cell.setCellType(Cell.CELL_TYPE_BLANK);
source.write(...);
--
The expected behavior should follow HSSFWorkbook, i.e. CellStyle won't be clear
since only cell value is set to blank.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
