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