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 2018/09/04 16:23:27 UTC
[Bug 62673] New: XSSF worksheet has column range in dimension off by
one
https://bz.apache.org/bugzilla/show_bug.cgi?id=62673
Bug ID: 62673
Summary: XSSF worksheet has column range in dimension off by
one
Product: POI
Version: 3.17-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: richard.evans@blueallegro.net
Target Milestone: ---
XSSFSheet has this code in the write method:
if(row.getLastCellNum() != -1) {
maxCell = Math.max(maxCell, row.getLastCellNum());
...
if(minCell != Integer.MAX_VALUE) {
String ref = new CellRangeAddress(getFirstRowNum(),
getLastRowNum(), minCell, maxCell).formatAsString();
if(worksheet.isSetDimension()) {
worksheet.getDimension().setRef(ref);
} else {
worksheet.addNewDimension().setRef(ref);
}
}
Arguments to the CellRangeAddress are zero-based:
/**
* Creates new cell range. Indexes are zero-based.
However row.getLastCellNum() returns the zero-based last cell number PLUS ONE:
* @return short representing the last logical cell in the row <b>PLUS
ONE</b>,
* or -1 if the row does not contain any cells.
*/
As a result the dimension in the worksheet has the last column number off by
one. A single column sheet with five rows is written with
<dimension ref="A1:B5"/>
instead of
<dimension ref="A1:A5"/>
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 62673] XSSF worksheet has column range in dimension off by one
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62673
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |DUPLICATE
Status|NEW |RESOLVED
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
As far as I see this is already fixed on trunk via bug 61798, r1819404. The
next release POI 4.0.0 will be released shortly and will include this fix.
*** This bug has been marked as a duplicate of bug 61798 ***
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org