https://issues.apache.org/bugzilla/show_bug.cgi?id=53611
Priority: P2
Bug ID: 53611
Assignee: [email protected]
Summary: Incorret dimension set in created workbook sheet xml
file
Severity: normal
Classification: Unclassified
OS: Linux
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
Created attachment 29120
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29120&action=edit
Small java project build with maven to create example .xlsx file having
incorrect dimension ref value set in workbook sheet xml file
After creating and writing an XSSFWorkbook with some rows and cells to a file
the sheet XML file included in .xlsx archive has an incorrect value for
attribute 'ref' of tag 'dimension':
<worksheet>
<dimension ref="A1"/>
<sheetViews>
<sheetView ...
It's always set to 'A1' no matter how many rows and cells are actually in the
sheet. The dimension is only initialized on creation of worksheet in class
XSSFSheet:
XSSFSheetworksheet.newSheet(){
...
worksheet.addNewDimension().setRef("A1");
...
}
I included a example java app showing the. Build it with maven:
cd poi-bug
mvn package
java -jar target/poi-bug-0.1-SNAPSHOT-jar-with-dependencies.jar
After successful execution the project folder contains the file 'poi-bug.xlsx'.
Unzip file and open 'xl/worksheets/sheet1.xml' containing the dimension tag.
--
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]
