incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120820] New: Define name which cell range is in other file will saved incorrect after saved to .xls and .ods
Date Wed, 05 Sep 2012 08:49:00 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=120820

          Priority: P3
            Bug ID: 120820
          Assignee: ooo-issues@incubator.apache.org
           Summary: Define name which cell range is in other file will
                    saved incorrect after saved to .xls and .ods
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: polo8495@hotmail.com
          Hardware: All
            Status: CONFIRMED
           Version: AOO350-dev
         Component: save-export
           Product: spreadsheet

Build: AOO3.4.1 rev.1372282
Steps:
1.Create a Souce.xlsx file in MS office, in put string in A1 

2.Create a sample.xlsx file in MS office, Define 2 different names test and
test1, one scope for Sheet1, one scope for workbook, the cell range point to
Cell A1 in Souce.xlsx.
In Sheet1 select cell A1, input "=test", and in Sheet2 select cell A1, input
"=test"

3.Open those 2 file in AOO, update the links, then saved the sample.xlsx to
sample.xls, then reload sample.xls.

4.After reload, update the link, but the cell value, there are 2 "#REF!" error
type in those 2 cell range is wrong in Define name.

If we saved sample.xlsx to .ods in step 3, we also will get this error type,
and Edit->Links->Update even the name cell range is correct.

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

Mime
View raw message