Summary: | FILESAVE: HLOOKUP fails when exported to XLSX file (Microsoft XML) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Andrew Pitonyak <andrew> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED INVALID | ||
Severity: | trivial | CC: | miguelangelrv |
Priority: | lowest | ||
Version: | 4.1.1.1 rc | ||
Hardware: | Other | ||
OS: | Linux (All) | ||
Whiteboard: | BSA | ||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Cell B11 fails after save as to an XSLX file.
Document saved as an XLSX file. |
Created attachment 84207 [details]
Document saved as an XLSX file.
Cell B11 now contains #N/A
Hi Andrew, the issue is that regular expressions are disable for calculation. I am not sure but I think regular expressions are always disable opening a file with any of the excel formats. Thanks mariosv. This mean that (if anything), the release candidate fixes a bug (since in an earlier version of LO, this caused a crash on saving). I guess that it is not a bug. Saving to an XLS file opened properly (but I did not attempt a refresh so it might have been simply presentation data). Thanks. I work hard to NOT submit but that are not bugs but I failed in this instance. I am marking the bug as "resolved invalid". Nice for me collaborate with an admired person. |
Created attachment 84206 [details] 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