https://issues.apache.org/bugzilla/show_bug.cgi?id=52910
Bug #: 52910
Summary: Not Finding all Merged Regions in Worksheet
Product: POI
Version: 3.8-dev
Platform: PC
OS/Version: Mac OS X 10.5
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
I am getting inconsistent results with the methods for getting merged cells in
a worksheet, using the following code:
for(int m=0;m<sheet.getNumMergedRegions();m++){
CellRangeAddress addr =sheet.getMergedRegion(m);
int[] coordinates = {addr.getFirstRow(), addr.getFirstColumn(),
addr.getLastRow(), addr.getLastColumn()};
System.out.println(coordinates[0] + ":" + coordinates[1] + " - " +
coordinates[2] + ":" + coordinates[3]);
}
I am getting .XLS files that were created on Windows PC as .XLSX and then saved
as .XLS.
When I then save the .XLS file on a Mac, then the API does find the merged
cells.
--
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]
