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.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!
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
To unsubscribe e-mail to: users+unsubscr...@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