You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/03/18 14:43:56 UTC
[Bug 54720] New: [PATCH] Support for Row Area Range
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: dev@poi.apache.org
Reporter: opensource@innoveo.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row Area Range
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30069|0 |1
is obsolete| |
--- Comment #3 from opensource@innoveo.com ---
Created attachment 30070
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30070&action=edit
patch for row area
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30073|0 |1
is obsolete| |
--- Comment #9 from opensource@innoveo.com ---
Created attachment 30075
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30075&action=edit
testdata
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30068|0 |1
is obsolete| |
--- Comment #6 from opensource@innoveo.com ---
Created attachment 30073
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30073&action=edit
testdata
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
Cédric Walter <ce...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #10 from Cédric Walter <ce...@gmail.com> ---
Commit #1514812
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row Area Range
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30067|0 |1
is obsolete| |
--- Comment #2 from opensource@innoveo.com ---
Created attachment 30069
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30069&action=edit
patch for row area
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30072|0 |1
is obsolete| |
--- Comment #8 from opensource@innoveo.com ---
Created attachment 30074
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30074&action=edit
patch for row area and col area
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30071|0 |1
is obsolete| |
--- Comment #5 from opensource@innoveo.com ---
Created attachment 30072
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30072&action=edit
patch for row area and col area
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|[PATCH] Support for Row |[PATCH] Support for Row/Col
|Area Range |Area Range like 8:8 or H:H
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row Area Range
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
opensource@innoveo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30070|0 |1
is obsolete| |
--- Comment #4 from opensource@innoveo.com ---
Created attachment 30071
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30071&action=edit
patch for row area
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
--- Comment #7 from opensource@innoveo.com ---
Patch now also support col area in the form of NameType.COLUMN:NameType.COLUMN
like B:B e,g
= INDIRECT("Indirect"&"!"&"B:B",TRUE)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54720] [PATCH] Support for Row Area Range
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54720
--- Comment #1 from opensource@innoveo.com ---
Created attachment 30068
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30068&action=edit
testdata
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org