Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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+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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.