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

            Bug ID: 66614
           Summary: The OFFSET function cannot handle cells after the
                    257th column
           Product: POI
           Version: 5.2.3-FINAL
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: kabeya...@cabinetwork.jp
  Target Milestone: ---

In /java/org/apache/poi/ss/formula/functions/Offset.java

There is a line:

private static final int LAST_VALID_COLUMN_INDEX = 0xFF;

So OFFSET doesn't work if the result column > 0xFF.
(Also the rows are restricted to 0xFFFF)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to