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.