https://issues.apache.org/ooo/show_bug.cgi?id=123321

            Bug ID: 123321
        Issue Type: DEFECT
           Summary: Exported as XLS-Spreadsheet does not recognize SHEET()
                    function.
           Product: Calc
           Version: 4.0.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

Reply via email to