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.