Issue 119915 - [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.
Summary: [From Symphony]Save .xlsx as .xls in OO3.4, the cell range reference with cus...
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Anders Kvibäck
Keywords: needmoreinfo
Depends on:
Blocks: 120823
  Show dependency tree
Reported: 2012-06-08 06:42 UTC by Shan Zhu
Modified: 2017-05-20 09:58 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---

a .xlsx file with formula using cell range reference as parameter (9.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-06-08 06:42 UTC, Shan Zhu
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Shan Zhu 2012-06-08 06:42:12 UTC
Created attachment 78184 [details]
a .xlsx file with formula using cell range reference as parameter

Build info:AOO3.4_1327774

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.

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!.
Comment 1 Wang Lei 2012-06-29 06:03:19 UTC
This may not be a bug.
Excel 2003 only support 256 columns(IV), while Excel 2007 support 16384 columns(XFD). 
Column KL is larger than IV. Because AOO 3.4 support 1024 columns, it is OK when AOO3.4 open this xlsx file. But saving in xls file format will make column KL invalid. This is same behavior with Excel 2007.
Comment 2 Anders Kvibäck 2013-02-12 15:10:15 UTC
I can't reproduce the bug. Are you still facing problem with this bug?

This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the
the latest version of OpenOffice - the problem(s) may already be addressed.

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
Comment 3 Anders Kvibäck 2013-02-21 15:29:28 UTC
I'm marking this issue as RESOLVED/IRREPRODUCIBLE. If we receive more information on how to reproduce the issue, we can reopen.