https://bugs.freedesktop.org/show_bug.cgi?id=68242

          Priority: medium
            Bug ID: 68242
          Assignee: [email protected]
           Summary: FILESAVE: HLOOKUP fails when exported to XLSX file
                    (Microsoft XML)
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.1.1.1 rc
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 84206
  --> https://bugs.freedesktop.org/attachment.cgi?id=84206&action=edit
Cell B11 fails after save as to an XSLX file.

Problem description: 

=HLOOKUP(".*Elder1.*", $E2:$O$4, 3, 0)

This properly exports to an XLSX but not to an XLSX file.

Steps to reproduce:
1. Save the attached document to Microsoft Excel 2007/2010 XML (.xlsx)
2. Cell B11 no longer has the value "b".

Current behavior:
Cell B11 no longer has the value "b".


Expected behavior:
Cell B11 has the value "b".

Note that this does work with an XLS file.


Operating System: Fedora
Version: 4.1.1.1 rc

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to