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/05 08:16:43 UTC

[Bug 120818] New: When import the .ods file which contain duplicate names, it will not update and refresh the formula result

https://issues.apache.org/ooo/show_bug.cgi?id=120818

          Priority: P3
            Bug ID: 120818
          Assignee: ooo-issues@incubator.apache.org
           Summary: When import the .ods file which contain duplicate
                    names, it will not update and refresh the formula
                    result
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: polo8495@hotmail.com
          Hardware: All
            Status: CONFIRMED
           Version: AOO350-dev
         Component: open-import
           Product: spreadsheet

Created attachment 79292
  --> https://issues.apache.org/ooo/attachment.cgi?id=79292&action=edit
Sample

Find this bug 120478:Name Scope enhancement for spreadsheet
In this Enhancement there have a limitation

Limitation:
1. If duplicate names are used in a formula,save file to ODF format, the
formula for the name("aaa") defined in a sheet is of:=SUM(aaa) the formula for
the anme defined in a workbook is of:=SUM(aaa) if reload the exported file to
Aoo,all will be marked as the name in a sheet. 

But In my testing, when i Import the sample file and save it to .ods, then
reload the .ods file in AOO, i find the formula result are correct, this is not
as the Limitation description.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

Shenfeng Liu <li...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |liushenf@gmail.com
         Resolution|FIXED                       |INVALID

--- Comment #5 from Shenfeng Liu <li...@gmail.com> ---
Let's me clarify, if this defect is due to test environment, we should not set
Resolution as FIXED. The FIXED means there is code change in the product.
So I changed it to INVALID. Please tell me if any one has any concern.
Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

zhaoshzh <ao...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |aoo.zhaoshzh@gmail.com

--- Comment #3 from zhaoshzh <ao...@gmail.com> ---
Can be refreshed on the Aoo version of 20120904.
the root cause is my testing executed in read-only mode.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

--- Comment #1 from Terry Yang <po...@hotmail.com> ---
Build:AOO Trunk Revision :1380503 
Add build info

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

Terry Yang <po...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

--- Comment #2 from Terry Yang <po...@hotmail.com> ---
This bug is about when import .ods file, AOO can't refresh after open the file.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

Terry Yang <po...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
         Resolution|---                         |FIXED

--- Comment #4 from Terry Yang <po...@hotmail.com> ---
Change the status

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120818] When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120818

Terry Yang <po...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|When import the .ods file   |When import the saved .ods
                   |which contain duplicate     |file which contain
                   |names, it will not update   |duplicate names, it will
                   |and refresh the formula     |not update and refresh the
                   |result                      |formula result

-- 
You are receiving this mail because:
You are the assignee for the bug.