https://bugs.freedesktop.org/show_bug.cgi?id=88061
Bug ID: 88061
Summary: ROWS(),SHEETS(), COLUMNS() functions - relative path
to other file
Product: LibreOffice
Version: 4.5.0.0.alpha0+ Master
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
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"/>
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
