https://issues.apache.org/ooo/show_bug.cgi?id=119915
Priority: P3
Bug ID: 119915
Assignee: [email protected]
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: [email protected]
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.
