Ask Your Question
0

Link to external file in LO Calc returns incorrect data

asked 2020-03-01 21:56:52 +0100

FrogFan gravatar image

Hello,

I've built a workbook to track membership data for a women's club. There is a workbook for each month the club meets. One section of the workbook takes the number of members at the end of the previous month, adds members who join in the current month, and subtracts members who've either resigned or died in the current month to obtain the number of members in the club at the end of the current month. For a given month, the number of members at the end of the previous month is obtained via a reference to the cell containing this data in the previous month's workbook.

The problem I'm having is that sometimes this external reference returns correct data, and sometimes it returns incorrect data, and I have no idea why. I've tried to be very careful to define the external references correctly, but perhaps I've made an error.

I've attached five small .ods files containing excerpts from workbooks for Sept, Oct, Nov, Dec, and Jan. These files are all saved in the same directory on my Windows 10 computer. I'm running LO 6.2.5.2. If I open the Oct workbook, it correctly links to the end of month data for Sept, and similarly for Nov and Dec. However, when I open the Jan workbook, the link returns 0 as the number of members at the end of December, which is incorrect. If I open the Dec workbook, save it, keep it open, then open the Jan workbook and "update" the link, I get correct data for Jan. Then if I save and close both workbooks and later come back and open Jan, the link returns 0 again, or sometimes it returns correct data.

Thanks for any help.

C:\fakepath\Sep 2019 Sign-In Sheet.ods C:\fakepath\Oct 2019 Sign-In Sheet.ods C:\fakepath\Nov 2019 Sign-In Sheet.ods C:\fakepath\Dec 2019 Sign-In Sheet.ods C:\fakepath\Jan 2020 Sign-In Sheet.ods

edit retag flag offensive close merge delete

Comments

Please file a bug report, https://www.libreoffice.org/get-help/..., add to it your sample files and add to your question the report number.

m.a.riosv gravatar imagem.a.riosv ( 2020-03-03 11:04:33 +0100 )edit

Report number 131100 created today. Thank you.

FrogFan gravatar imageFrogFan ( 2020-03-03 17:43:44 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-03-02 21:06:04 +0100

gregors15 gravatar image

Hi, I had problems with links to external files after version 6.1.5.0, however recently I downloaded the LO pre-release version 6.4. RC3 (windows 10 64 bit). and so far the links I have tried seem to be working OK. This is the link https://wiki.documentfoundation.org/Q...

If you try it, let us know if it helps.

edit flag offensive delete link more

Comments

Thank you for the suggestion. I installed 6.4 RC3 and opened a file that did not link properly under 6.2.5.2. It did not link properly to 6.4, either. It returned the same (zero) value.

Here is some more detail, in case it's helpful. I have a file for April data. This file gets the number of members at the end of March from the March file. When I open the April file, the number of members at the end of March is returned as zero. When I open the March file, that value is 160.

With the March file opened, I saved it to ensure that the 160 value was saved. Then, with both the March and April files open, I updated the relevant link in the April file, and the correct number, 160, was returned. I saved the April file and, for good ...(more)

FrogFan gravatar imageFrogFan ( 2020-03-03 02:00:26 +0100 )edit

I suspect the problem relates to the cascaded nature of the linkages in which the value in the source cell is, through a formula, dependent on an analogous link to the previous month, etc., through several months. I say this because I have numerous other data links in these workbooks that "usually" work, and if they don't, updating them via Edit > Links to External Files will correct them. Updating does not fix this problem.

I mention this in case it helps diagnose the problem.

FrogFan gravatar imageFrogFan ( 2020-03-03 02:29:23 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-01 21:56:52 +0100

Seen: 104 times

Last updated: Mar 02