https://bz.apache.org/bugzilla/show_bug.cgi?id=69127
Bug ID: 69127
Summary: The Cell style background is not applied when an input
spreadsheet is used with all the cells in a non
default style
Product: POI
Version: 5.2.2-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 39770
--> https://bz.apache.org/bugzilla/attachment.cgi?id=39770&action=edit
The test program
When you create a SXSSFWorkbook(new XSSFWorkbook(fis)) from a XSSFWorkbook(fis)
from a File, the Cell styles are usually applied, even the background colour.
But if the File contains, for example, a sheet (that will not be modified) that
has all the background in any colour, then only the first background colour
style is applied.
The input spreadsheet can be created in OpenOffice/LibreOffice/OneOffice in the
following way:
Create a sheet, click on the top-left header (all the cells are selected) and
change the background colour, then save it the .xlsx format.
Expected result: The styles are applied with any input spreadsheet (unless the
max limit of styles used is reached).
In the attached program, the third column should have a PALE_BLUE background,
instead it gets a default background.
--
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]
