incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119915] New: [From Symphony]Save .xlsx as .xls in OO3.4, the cell range reference with customized sheet name in formula can not be parsed, they will be inseaded by #REF! error.
Date Fri, 08 Jun 2012 06:42:12 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119915

          Priority: P3
            Bug ID: 119915
          Assignee: ooo-issues@incubator.apache.org
           Summary: [From Symphony]Save .xlsx as .xls in OO3.4, the cell
                    range reference with customized sheet name in formula
                    can not be parsed, they will be inseaded by #REF!
                    error.
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: shanzhu33@gmail.com
          Hardware: PC
            Status: UNCONFIRMED
           Version: AOO340
         Component: save-export
           Product: spreadsheet

Created attachment 78184
  --> https://issues.apache.org/ooo/attachment.cgi?id=78184&action=edit
a .xlsx file with formula using cell range reference as parameter

Build info:AOO3.4_1327774

Steps:
1. Open the .xlsx sample file attached. (There are 7 formulas in it, all of
them use a cell range in other sheet as its parameter.)
2. Save it as .xls in OO3.4, reload it.

Issue:
The formula in A1, A4,B4,C4 and D4 will return #REF!.
The cell range in formula can not be parsed.

Notes:I've tried =SUM('2012 June Testing'!$H$1:$K$1), it works.
but =SUM('2012 June Testing'!$H$1:$KL$1), it returns #REF!.

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

Mime
View raw message