You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/09/14 04:43:23 UTC
[Bug 120962] New: [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
https://issues.apache.org/ooo/show_bug.cgi?id=120962
Priority: P3
Bug ID: 120962
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference
formula
Severity: major
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: clarence.guo.bj@gmail.com
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: open-import
Product: spreadsheet
Created attachment 79498
--> https://issues.apache.org/ooo/attachment.cgi?id=79498&action=edit
Sample
Open the sample Xls file, the chart becomes empty.
The reason is the data series was refered to a range name, while the name was
defined as a reference formula. However, AOO only support simple range like
"Sheet1.A1:B4".
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120962] [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120962
Shan Zhu <sh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED
CC| |shanzhu33@gmail.com
--- Comment #5 from Shan Zhu <sh...@gmail.com> ---
Verified on AOO350m1 1391367. Passed.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120962] [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120962
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |leiw@apache.org
Resolution|--- |FIXED
Target Milestone|--- |AOO 3.5.0
--- Comment #4 from Wang Lei <le...@apache.org> ---
Submit in revision 1388342
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120962] [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120962
--- Comment #3 from SVN Robot <sv...@dev.null.org> ---
"leiw" committed SVN revision 1388342 into trunk:
#i120962 Chart data lost if the source data refers to a range name which is
d...
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120962] [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120962
--- Comment #2 from Clarence GUO <cl...@gmail.com> ---
This fix is indeed a feature gap. Chart of AOO doesn't support range name which
use a reference formula, not only in UI, but also in core function and filter.
Although it needs a total solution to make the feature available, I still want
this temporary solution at a bug fix level because it needs some time to
implement. The fix will translate a range name which use a reference formula to
a actural range. So that means after saving, the range instead of the formula
will be saved, the original formula will be lost.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120962] [From Symphony]Chart data lost if the source data
refers to a range name which is defined as a reference formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120962
--- Comment #1 from Clarence GUO <cl...@gmail.com> ---
Created attachment 79593
--> https://issues.apache.org/ooo/attachment.cgi?id=79593&action=edit
patch
Root Cause:
The data series was refered to a range name, which was defined a reference
formula. However, AOO only support simple range like "Sheet1.A1:B4"
Solution:
Remember the referenced token during formula intepretion, then translate the
source range from formula name to ScToken.
--
You are receiving this mail because:
You are the assignee for the bug.