Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | [From Symphony]Chart data lost if the source data refers to a range name which is defined as a reference formula | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Clarence GUO <clarence.guo.bj> | ||||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CLOSED FIXED | QA Contact: | |||||||
Severity: | Major | ||||||||
Priority: | P3 | CC: | leiw, shanzhu33 | ||||||
Version: | 3.4.0 | ||||||||
Target Milestone: | 4.0.0 | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Created attachment 79593 [details]
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.
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. "leiw" committed SVN revision 1388342 into trunk: #i120962 Chart data lost if the source data refers to a range name which is d... Submit in revision 1388342 Verified on AOO350m1 1391367. Passed. |
Created attachment 79498 [details] 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".