Old or new bug in Calc Save As XSLX file

users
#1

I generated a simple ODS document that uses HLOOKUP. I can save this document as an ODS or an XLS document, but not as an XLSX document. Can someone verify this bug in any version other than the latest release candidate 4.1.1.1

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68242

You can probably grab the ODS file direction
https://www.libreoffice.org/bugzilla/attachment.cgi?id=84206

And then save as an XLSX document. Alternatively, can an older version of LO read this document (the xlsx doc)
https://www.libreoffice.org/bugzilla/attachment.cgi?id=84207

Just curious if it is only me.

On the bright side, I can now open my password protected documents with the latest release candidate; yeah!

#2

I resolved as invalid.

Turns out that on load, using a regular expression in an HLOOKUP is disabled for an XLSX file. If anything, the latest release candidate has improved behavior.... I went to it because saving in the version I had been using caused a crash.

Thanks to mariosv for figuring this our for me!

#3

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.

I have left my comment in the bug report.

Miguel Ángel.