https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
Bug ID: 54720
Summary: [PATCH] Support for Row Area Range
Product: POI
Version: 4.0-dev
Hardware: PC
Status: NEW
Severity: enhancement
Priority: P2
Component: POI Overall
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Created attachment 30067
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30067&action=edit
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
--
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]
