Bug 68242 - FILESAVE: HLOOKUP fails when exported to XLSX file (Microsoft XML)
Summary: FILESAVE: HLOOKUP fails when exported to XLSX file (Microsoft XML)
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.1.1 rc
Hardware: Other Linux (All)
: lowest trivial
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-18 17:24 UTC by Andrew Pitonyak
Modified: 2013-08-18 22:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Cell B11 fails after save as to an XSLX file. (9.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-18 17:24 UTC, Andrew Pitonyak 		Details
Document saved as an XLSX file. (5.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-08-18 17:27 UTC, Andrew Pitonyak 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Pitonyak 2013-08-18 17:24:54 UTC 
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
Comment 1 Andrew Pitonyak 2013-08-18 17:27:43 UTC 
Created attachment 84207 [details]
Document saved as an XLSX file.

Cell B11 now contains #N/A
Comment 2 m_a_riosv 2013-08-18 18:54:39 UTC 
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.
Comment 3 Andrew Pitonyak 2013-08-18 20:59:49 UTC 
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".
Comment 4 m_a_riosv 2013-08-18 22:19:19 UTC 
Nice for me collaborate with an admired person.