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/04 08:49:09 UTC
[Bug 120804] New: Test plan:Name Scope enhancement for spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=120804
Priority: P3
Bug ID: 120804
Assignee: ooo-issues@incubator.apache.org
Summary: Test plan:Name Scope enhancement for spreadsheet
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: polo8495@hotmail.com
Hardware: All
Status: CONFIRMED
Version: AOO350-dev
Component: editing
Product: spreadsheet
Objectives:
>From Enhancement bug 120478
This enhancement will be completed in 2 steps.
In step 1, we want to just focus on the interoperability of MS Excel range
based defined name.
When user open a Excel file which has range based defined name, the duplicated
range name will be kept. AOO will use sheet scoped name in prior to workbook
scoped name when do calculation. And some indicator is shown in name define
dialog.
In step 1 we will not modify the ODF file format. When save Excel xls/xlsx file
with sheet scoped defined name to ods file, AOO will rename sheet scoped
defined name as "sheet_name" plus "defined name", like SheetName_DefinedName.
In step 2, we want to support create worksheet scope defined name from GUI. We
will refer the file format from LibreOffice if their implementation is in ODF
standard or ODF standard candidate.
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.
2. If a formula references a name that is defined in other workbook,load the
file in Aoo,it will be displayed as "#NAME?".
Key point in testing:
1. Test load duplicate names from MS 2003 file.
2. Test save duplicate names to MS 2003 file.
3. Test load duplicate names from MS 2007 file.
4. Test load duplicate names form ODF file.
5. Test save duplicate names to ODF file.
6. Test 2 limitation will cause other issue
7. Test Duplicate names in different sheet
8, Test Duplicate names in sheet and workbook
9. Test Duplicate names in 2 or more sheet and workbook
10.Test Define Duplicate names in one file and use it in anther file.
11. Test duplicate names use in every SC type file(.ods/.xls/.xlsx), and test
duplicate names in formula and DataPilot
Platform:
Will cover Windows/Linux/Mac
Case list
Test case stored in TestLink system, http://aootesting.adfinis-sygroup.org/
I will write test case later in TestLink
Execution rate:
200%
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan:Name Scope enhancement for spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
--- Comment #1 from Terry Yang <po...@hotmail.com> ---
Change the Test Key Point
Key point in testing:
1. Test load duplicate names from MS 2003 file(Create by MS Office 2010).
2. Test save duplicate names to MS 2003 file.
3. Test load duplicate names from MS 2007 file.
4. Test load duplicate names form ODF file(Create by LO).
5. Test save duplicate names to ODF file.
6. Test 2 limitation will cause other issue
7. Test Duplicate names in different sheet
8, Test Duplicate names in sheet and workbook
9. Test Duplicate names in 2 or more sheet and workbook
10.Test Define Duplicate names in one file and use it in anther file.
11. Test duplicate names use in every SC type file(.ods/.xls/.xlsx), and test
duplicate names in formula
12.Test Change the duplicate names and cell ranges in AOO
13.Test Delete the duplicate names in AOO
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan for bug 120478:Name Scope enhancement for
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--- Comment #4 from Terry Yang <po...@hotmail.com> ---
Close this bug
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan for bug 120478:Name Scope enhancement for
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Test plan:Name Scope |Test plan for bug
|enhancement for spreadsheet |120478:Name Scope
| |enhancement for spreadsheet
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan for bug 120478:Name Scope enhancement for
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |FIXED
--- Comment #3 from Terry Yang <po...@hotmail.com> ---
Test done change the status to resolved status
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan:Name Scope enhancement for spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
--- Comment #2 from Terry Yang <po...@hotmail.com> ---
Created attachment 79286
--> https://issues.apache.org/ooo/attachment.cgi?id=79286&action=edit
Test case screenshot
Test case is ready on http://aootesting.adfinis-sygroup.org/index.php
I have add screenshot of the case, you can review it in TestLink
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120804] Test plan:Name Scope enhancement for spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120804
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Issue Type|DEFECT |TASK
--
You are receiving this mail because:
You are the assignee for the bug.