Version: 4.5.0.0.alpha0+ Build ID: 7f476fea47f06a7f8cc961dd4f6595a524346fa5 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-27_23:36:28 Steps to reproduce: 1. Launch Calc, make sure that in menu 'Tools -> Options -> Load/Save -> General - Save - "Save URLs relative to file system"' is checked. 2. create some directory, for example /tmp/test_relative 3. create empty file data.ods in this directory 4 create file test.ods in this directory; write formula =ROWS('file:///tmp/test_relative/data.ods'#$Sheet1.A1) result is 1 - correct 5. save file 6. rename directory test_relative to test_relativ (delete 'e') and reopen file test.ods; refresh links actual results: error message: The following external file could not be loaded. Data linked from this file did not get updated. file:///tmp/test_relative/data.ods expected results: formula became =ROWS('file:///tmp/test_relativ/data.ods'#$Sheet1.A1) and works The same for ROWS(),SHEETS(), COLUMNS() functions. workaround: create formula =LEFT('file:///tmp/test_relative/data.ods'#$Sheet1.A1;1). This create in content.xml relative reference <table:table-source xlink:type="simple" xlink:href="../data.ods" table:table-name="Sheet1" table:filter-name="calc8" table:mode="copy-results-only"/>
Same problem already in 3.5. In 3.3.0, the result was Err:504 in any case even though no warning was displayed, when updating the links after renaming folder (saved file in 3.3.0 first). Severity -> minor because of workaround. Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+ Build ID: 7201fa0dddd7dd0352f69fd2b2b64efcb361ccad TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2015-01-11_23:28:55 LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
(In reply to Beluga from comment #1) Hi Beluga, > Same problem already in 3.5. > In 3.3.0, the result was Err:504 in any case even though no warning was > displayed, when updating the links after renaming folder (saved file in > 3.3.0 first). Because of bug 43700 . I've found this bug 88061 when I tried to create unit test for bug 43700. > > Severity -> minor because of workaround. There is not easy workaround, only you can rewrite formula. Imagine lots of formulas or when I send files to other man - impossible to repair formulas.. Setting back to normal.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.