https://bz.apache.org/bugzilla/show_bug.cgi?id=63509
Bug ID: 63509
Summary: XSSFSheet addIgnoredErrors(CellReference cell,
IgnoredErrorType... ignoredErrorTypes) creates corrupt
file
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
This bug is in POI 4.1.0
It works OK on POI 4.0.1
I am using XSSFSheet addIgnoredErrors(CellReference cell, IgnoredErrorType...
ignoredErrorTypes) like this:
XSSFSheet sheet;
Cell cell;
sheet.addIgnoredErrors(new CellReference(cell),
IgnoredErrorType.NUMBER_STORED_AS_TEXT);
When the XSSFWorkbook is saved to "file.xlsx" Excel reports an error when
opening it:
"Excel found unreadable content in file.xlsx"
Inside the Excel file at sheet1.xml I see this:
<ignoredErrors>
<ignoredError sqref="SheetName!A1" numberStoredAsText="true" />
</ignoredErrors>
In POI 4.0.1 the same thing is written as:
<ignoredErrors>
<ignoredError sqref="A1" numberStoredAsText="true" />
</ignoredErrors>
So it seems that 4.1.0 is prefixing the Sheet name to to sqref and Excel barfs.
--
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]
