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.