[Libreoffice-bugs] [Bug 113541] New: EDITING - Link to external documents is not created correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113541

            Bug ID: 113541
           Summary: EDITING - Link to external documents is not created
                    correctly
           Product: LibreOffice
           Version: 5.4.2.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bunk3m at gmail.com

LO 5.x Mac will transpose the link location for an external link between two
spreadsheets in such a way that ERR:501/ERR:507/ERR:509 will occur.

The link created by LO Mac will not work on the Win or Linux version of LO.

However linked cells created by Win or Linux versions of LO do work in Mac
version.

I've tested LO 5.1, 5.3 & 5.4 on Mac, 
LO 5.1 Win, LO 3.5.7.2 Linux, 
and OO 3.3 and OO 4.1 on Mac.

In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked cell and
press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper case
letters to lower case, changes some of the characters ie. #, $ and ! are
removed and you get an error message.

If you try to manually change the text entry changes from (3), when you press
the enter key it reverts to the incorrect text.

Using the same spreadsheets and following steps (1) & (2) and using Win LO 5.2
& Linux Xubuntu LO 3.5.7.2, the linking works without error.

Using the same spreadsheets and following steps (1) & (2) and using Mac OO 3.3
and 4.1, the links work without error.

So at this point I opened the spreadsheet in LO Mac and the links created by
Win and Linux versions are still OK.

If I use Mac LO to copy and paste the entire cell created by Win & Linux
versions of LO and OO,there is no transformation and the linking works.

If I use Mac LO and select in the cell, highlight and copy the link formula,
and paste the formula into another cell, Mac LO transposes the formula and
ERROR. 

Further check of Automatic Spell Checking on/off yields the same behaviour on
Mac.  Please note that with Automatic Spell Check off, the transformation of
case occurs but the "!" does not get removed.

The link created by Win LO, Linux LO, OO Mac are all the same and work.
ie. here is a link that works created by Win/Linux/OO Mac
[code]=['file:///Users/me/Documents/Time & Expense
Forms/TIMEEX201703.ods']'Details of Expenses 3'!I54[/code]


and here is the links created by LO Mac:
[code]='file:///users/me/documents/time & expense
forms/timeex201703.ods']'details of expenses 3' I54[/code]

Please note the chase difference and the missing "!".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171030/35637d03/attachment-0001.html>