[Libreoffice-bugs] [Bug 115244] FILESAVE XLSX Cell Reference error #REF, with a reference external xlsx file cells

Tue Sep 21 11:31:14 UTC 2021

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

NISZ LibreOffice Team <libreoffice at nisz.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |DUPLICATE
             Status|NEW                         |RESOLVED

--- Comment #10 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
I can no longer reproduce this with Calc formula syntax even in:

Version: 6.0.0.3
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (hu_HU); Calc: CL

When attachment 139377 is opened, a new reference is made to it in a new file
and that is saved as xlsx, then reloaded. The reference is correct, updated
value in the source file can be retrieved with a recalculation (F9).

In 5.4 it has duplicated the drive letter and I got an error 
"The following external file could not be loaded. Data linked from this file
did not get updated.

file:///C:/C:/Users/kelemengabo/Downloads/Cell_reference_source.xlsx".

With Excel formula syntax, it was bad for longer with Err:507 shown in the
editor until 6.3:

https://git.libreoffice.org/core/+/6e68110a916500a92a15357b6bf90e62dc631a01

commit  6e68110a916500a92a15357b6bf90e62dc631a01        [log]
author  Eike Rathke <erack at redhat.com>  Thu Jun 13 20:25:49 2019 +0200
committer       Eike Rathke <erack at redhat.com>  Fri Jun 14 02:49:21 2019 +0200

Resolves: tdf#113541 handle external reference in Excel syntax

*** This bug has been marked as a duplicate of bug 113541 ***

-- 
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/20210921/7391d0fe/attachment.htm>