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


I'm looking for some help in debugging an issue that I've had since LO 5.4 on Mac. (I've been using LO since it forked.) I'm now running LO 6.3alpha

When I attempt to link a cell in one spreadsheet to another, the linking action using "=spreadsheet/cell location" transposes the link location to lowercase and I get ERR:501/ERR:507/ERR:509.

ie.
correct link:
'file:///Users/me/Documents/Time & Expense Forms/TIMEEX201703.ods']'Details of Expenses 3'!I54

link when made on the Mac or edited on the Mac it looks like this:
'file:///users/me/documents/time & expense forms/timeex201703.ods']'details of expenses 3' I54

I have tried the exactly same linking with exactly the same spreadsheets using LO on Win & Linux and there is no problem. As soon as I try this on the Mac it breaks.

I've posted a bug and it's now nearly 2 years old. It was temporarily fixed in one beta version but I can't find it anymore.

I've been testing alpha and beta builds with the hope that this issue would be resolved but no luck.

I'm frustrated that the bug is still open and want to help figure out why there is a problem but I don't know what to try. I use the linking daily but am stuck on Excel because I can't get it to work on LO.

Any suggestions are appreciated.

Thanks.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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.