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

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

 Resolution|--- |DUPLICATE
 Status|NEW |RESOLVED

--- Comment #10 from NISZ LibreOffice Team  ---
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   Thu Jun 13 20:25:49 2019 +0200
committer   Eike Rathke   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.

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

[bugzilla-daemon]

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

--- Comment #9 from QA Administrators  ---
Dear Gabor Kelemen,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Blocks||108897, 112581


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=112581
[Bug 112581] [META] Linked (non-embedded) external files bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #8 from Gabor Kelemen  ---
Created attachment 139869
  --> https://bugs.documentfoundation.org/attachment.cgi?id=139869=edit
Example file with reference to the external data source file - from Excel13

This is just for reference.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

Summary|FILESAVE XLSX Cell  |FILESAVE XLSX Cell
   |Reference #REF, with a  |Reference error #REF, with
   |reference external xlsx |a reference external xlsx
   |file cells  |file cells

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs