I found this problem in 3.3.0 and tested 3.3.1.2 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. LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 WInXP Thanks, Ron -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***