[Bug 62810] New: AreaReference ctor looses sheet name if rows or columns swapped

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 62810] New: AreaReference ctor looses sheet name if rows or columns swapped

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=62810

            Bug ID: 62810
           Summary: AreaReference ctor looses sheet name if rows or
                    columns swapped
           Product: POI
           Version: 4.0.0-FINAL
          Hardware: PC
                OS: Mac OS X 10.1
            Status: NEW
          Severity: major
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

The constructor

public AreaReference(CellReference topLeft, CellReference botRight,
SpreadsheetVersion version)

loses the sheet name if the topLeft is below or to the right of botRight.

The unit test below writes the following to the System console:

topLeft=Sheet0!$B$2
bottomRight=Sheet0!$K$6
goodAreaRef=Sheet0!$B$2:$K$6
badAreaRef=$B$2:$K$6

/*** Start of unit test code ***/

 private static void areaReferenceCtorTest(XSSFSheet sheet) {
  final String sheetName = sheet.getSheetName();
  final CellReference topLeft = new CellReference(sheetName, 1, 1, true, true);
  final CellReference bottomRight = new CellReference(sheetName, 5, 10, true,
true);
  final AreaReference goodAreaRef = new AreaReference(topLeft, bottomRight,
SpreadsheetVersion.EXCEL2007);
  final AreaReference badAreaRef = new AreaReference(bottomRight, topLeft,
SpreadsheetVersion.EXCEL2007);

  System.out.println(String.format("topLeft=%s", topLeft.formatAsString()));
  System.out.println(String.format("bottomRight=%s",
bottomRight.formatAsString()));
  System.out.println(String.format("goodAreaRef=%s",
goodAreaRef.formatAsString()));
  System.out.println(String.format("badAreaRef=%s",
badAreaRef.formatAsString()));

 }



/*** End of unit test code ***/

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]