Apache OpenOffice (AOO) Bugzilla – Issue 123321
Exported as XLS-Spreadsheet does not recognize SHEET() function.
Last modified: 2013-09-22 06:04:14 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.
A1=#NAME? (=_xlfnodf.SHEET()) in Excel 2007. Rev. 1525015 Win 7