Issue 123321 - Exported as XLS-Spreadsheet does not recognize SHEET() function.
Summary: Exported as XLS-Spreadsheet does not recognize SHEET() function.
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.0.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-09-21 21:38 UTC by cfries
Modified: 2013-09-22 06:04 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description cfries 2013-09-21 21:38:26 UTC
An ODS spreadsheet which contains the SHEET() function and which is exported the XLS will not have the function recognized as SHEET() in Excel. Instead the sheet shows _xlfnodf.SHEET() resulting in #NAME.

To reproduce:
1. Create Spreadsheet in OO 4.0 with Formula "=SHEET()" in Cell A1
2. Save as... XLS
3. Open Spreadsheet in Excel 2013. Check formula.

Note: LibreOffice 4.1 does not show this bug.
Comment 1 Edwin Sharp 2013-09-22 06:04:14 UTC
A1=#NAME? (=_xlfnodf.SHEET()) in Excel 2007.

Rev. 1525015 Win 7