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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Ed <g_e_fox at hotmail.com> ---
If you open the files in order, you will not see the problem.  

My expectation is that if I open the current month's file, it will fill the
destination cell on that file with whatever has been saved to the source cell
in the previous month's file, even though that value is dependent on it's
source, which could have changed, etc.  That expectation was born of three
years of experience with OpenOffice.  I stopped using OpenOffice some time ago
because its performance had deteriorated significantly.  LibreOffice performed
much better and "linking" behavior was as I had come to expect with OpenOffice.
 At some point in the past six months or so, that behavior changed.

Here is a little more background, in case it's helpful:  I've built a rather
complex spreadsheet for my sister-in-law to track attendance for a women's
club.  She is not computer-savvy, so I've tried very hard to hide complexity
from her while accounting for some of the crazy rules that are used by the club
to "excuse" absences and predict needs for lunches tables, and chairs for their
monthly meetings.

When I used OpenOffice, when I told it to update links upon opening a file for
a month, I didn't see what it was doing in that process, but, as I've said, I
always got the results I expected.  It took whatever had been saved in the
previous month and put its value in the appropriate linked cell in the current
file.  

When I switched to LibreOffice, if I opened the file for, say January, it asked
if I wanted to update the links (there are many other links between months),
and when I said yes, it proceeded to ask me if I wanted to update links for all
previous months; i.e, December, November, October, and September (the year
starts in September).  I concluded from that that LibreOffice actually opened
all preceding months in the course of opening the current one.  I suspect that
it's getting "hung up" in the cascading dependencies rather than simply copying
the value I want transferred to this month's file.

I suspect a way to "fix" this problem is to have my sister-in-law open the
current month and all preceding months, in the correct order, in order to
ensure that the value used for the current month is correct.  Either that or
I'll have to write her a macro that does that for her.  That seems like an
awful lot of work to do to recover functionality that I've had for at least
three years in OpenOffice.  If you or anyone has a better solution, I'd very
much like to hear it.

The above said, I actually tried to fall back to OpenOffice, but guess what? 
It now behaves the same was as LibreOffice does!

I'd like to be able to continue to use LibreOffice if I can get it to behave
how I expect it to.  Meanwhile, I've begun to port the application to Excel. 
I'm hoping you can save me from that task!

Thank you for your support.

-- 
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/20200515/46843954/attachment.htm>