I found this problem in 3.3.0 and tested 126.96.36.199 and it still exists.
We have sheets that have several relative links to another sheet but not all
are saving. When you update the links all the values are correct. Save the sheet and
close. Open the sheet and only the first link is valid the rest are zero's. For example "File A" has
3 links (c4, c5, c6) to "upgrade". Open "File A" and select update and then calculated value
E13=13.825. Save the sheet and close. Open "File A" and C5 and C6 are 0 and
E13=1.250. This becomes a problem when "File B" tries to link to the value E13 in "File A".
In our real set up we have several "File A's" that "File B" summarizes for us. The only way I could
fix this was to install Openoffice 3.3. Does anyone know how to get this working properly?
I have sample spreadsheets but I am not attaching them in case that is why several past post
attempts have failed to show up.
Unsubscribe instructions: E-mail to email@example.com
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
- [libreoffice-users] Calc links not all saving · Ron Gregor
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy