Summary: | [PATCH] Support for Row/Col Area Range like 8:8 or H:H | ||
---|---|---|---|
Product: | POI | Reporter: | opensource |
Component: | POI Overall | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | ||
Priority: | P2 | ||
Version: | 3.10-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: |
patch for row area
testdata patch for row area patch for row area patch for row area patch for row area and col area testdata patch for row area and col area testdata |
Created attachment 30068 [details]
testdata
Created attachment 30069 [details]
patch for row area
Created attachment 30070 [details]
patch for row area
Created attachment 30071 [details]
patch for row area
Created attachment 30072 [details]
patch for row area and col area
Created attachment 30073 [details]
testdata
Patch now also support col area in the form of NameType.COLUMN:NameType.COLUMN like B:B e,g = INDIRECT("Indirect"&"!"&"B:B",TRUE) Created attachment 30074 [details]
patch for row area and col area
Created attachment 30075 [details]
testdata
Commit #1514812 |
Created attachment 30067 [details] patch for row area Issues explained =INDIRECT("Indirect"&"!"&$H$3&":"&$H$3) is OK in POI when in cell H3 we have I3 as value (a reference to another cell) =INDIRECT("Indirect"&"!"&$H$7&":"&$H$7) is failing in POI when H7=8 an integer What this patch is adding Range support in the form of NameType.ROW:NameType.ROW like 8:8 or 6:8 See testcase IndirectFunctionTestCaseData.xls * new class org.apache.poi.ss.formula.functions.TestIndirectFunctionFromSpreadsheet * new spreadsheet test-data\spreadsheet\IndirectFunctionTestCaseData.xls * modified org.apache.poi.ss.formula.OperationEvaluationContext