[Libreoffice-bugs] [Bug 136876] New: Strange behaviours with "Link to external files".

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136876
           Summary: Strange behaviours with "Link to external files".
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: argasoft at argasoft.it

Description:
Hi!

I think the enclosed snapshots clarify the bug.

Furthermore:
- I used a model for a new file
- I added some lines to an external file (manual update)
- these are used for a drop-down in A1
- I saved the "external file"
- I updated the link in the new file
- all OK in the new file
- I saved the new
- I closed Calc

I use the value of A1 for formulas in other cells using "vertical search".

When I re-open the "new":
- all the "just added" rows in the external file are OK in A1 but has an error
in the cells that refer to A1 in the row
- Calc informs that automatic update is disabled so I click OK
- all is fine again
- BUT
- the link for A1 formula has changed to another one that is used in this file
- BUT
- value in A1 and cells referring to A1 are OK

If needed, tell me how to submit model with the linked files.

Thanks.

Actual Results:
See above.

Expected Results:
See above.


Reproducible: Always


User Profile Reset: No



Additional Info:
See above.

-- 
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/20200918/480f8349/attachment-0001.htm>