https://bz.apache.org/bugzilla/show_bug.cgi?id=66173

            Bug ID: 66173
           Summary: Active pane constants in Sheet are wrong
           Product: POI
           Version: 5.2.2-FINAL
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

See answer in
https://stackoverflow.com/questions/73043152/is-there-a-way-to-create-a-split-plane-horizontally-using-the-apache-poi-library

The constant fields in Sheet are as follows:

PANE_LOWER_RIGHT  0
PANE_UPPER_RIGHT  1
PANE_LOWER_LEFT   2
PANE_UPPER_LEFT   3

But the corresponding values in
org.openxmlformats.schemas.spreadsheetml.x2006.main.STPane are:

INT_BOTTOM_RIGHT 1
INT_TOP_RIGHT    2
INT_BOTTOM_LEFT  3
INT_TOP_LEFT     4

To get PANE_UPPER_LEFT, you need:
   sheet.createSplitPane(0, 100*20, 0, 9, Sheet.PANE_UPPER_LEFT+1);

We probably can't just change the Sheet values because other people might
already use the workaround.

So let's deprecate the old values and add new ones.

-- 
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]

Reply via email to