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! On 08/18/2013 01:35 PM, Andrew Douglas Pitonyak wrote:
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.1https://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=84206And 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!
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted