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 2012/03/14 15:03:46 UTC

DO NOT REPLY [Bug 52910] New: Not Finding all Merged Regions in Worksheet

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: dev@poi.apache.org
        ReportedBy: bscartine@yahoo.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 52910] Not Finding all Merged Regions in Worksheet

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52910

--- Comment #1 from bscartine@yahoo.com 2012-03-14 14:06:53 UTC ---
To clarify, the POI API is not finding merged cells in the original XLS file
that was created on Windows.  I opened the original XLS file in OpenOffice on a
Mac, and saved to a new file, and then was able to get the merged cells using
the POI API.

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org