[Libreoffice-bugs] [Bug 131100] New: : Link to external .ods file returns incorrect data

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131100
           Summary: : Link to external .ods file returns incorrect data
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: g_e_fox at hotmail.com

Created attachment 158347
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158347&action=edit
zip file containing 7 calc worksheets illustrating link problem

I have a group of spreadsheets, one for each "month", where the value of a cell
in a given month is intended to be set equal to a value in the previous month,
but the link sometimes returns an incorrect value.  The attached zip file
contains 7 such spreadsheets to illustrate the problem.

In the attachment, the September sheet is not linked to any other sheet, and
successive months sheets are linked to the previous month.  There are sheets
attached for September though March.

Note that the link for the October through February sheets returns the correct
values from the previous month's spreadsheet but that for March returns 0 when
the correct value is 160.  The problem cannot be corrected by "updating" the
link.

This problem has proven very difficult to replicate and sometimes disappears
(or appears) if the associated files are moved to a different directory.

-- 
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/20200303/d9cc64e0/attachment.htm>