Standard spreadsheet capability is to be able to reference data cells in external spreadsheets. Behaviour: create a test.ods sheet with some data values. save the file. Create a second new spread sheet. Use any cell in the second spreadsheet and pick a reference a cell that holds a value from the first sheet. E.g. cell A1 in test.ods holds the value '3'. Set cell A1 in the second spread sheet equal to cell test.A1 (ie ='file:///[location]/test.ods'#$Sheet1!A1'). The result should be '3' in the second sheet. The results: The cell result holds '#NAME?'. In the file descriptor, any caps are reduced to small letters. The '$' is dropped. This occurs with 3.3.1.2 OOOm19(Build:8) Ubuntu package 1:3.3.1-1ubuntu3-maverick. The reason for major is that when previously created files are opened that have external links, any cells with references became invalid. Hence, the spread sheets become unusable with this version. I've tried this with a 3.4 snapshot running on Ubuntu marverick and OOO330m19 (Build:6) tag libreoffice-3.3.0.4 running on Fedora 14. Neither exhibit the problem. Also the problem does not occur in 3.3.1.2 OOO330m19(Build:8) tag libreoffice-3.3.1.2 running in Windows 7
Not reproducible.
I have similar problem. References to external spreadsheets don't work with 'Index()' command. For example, I have a file 'Calc.ods' on a local drive. The cell A1 holds '=INDEX('file:///Users/kosvlad/Downloads/Price-list.ods'#$Price.A1:D10;1;1)'. So, the 'Price-list.ods' is placed on a local drive too. Its name and its sheet name contain latin characters only without spaces. The A1 of 'Calc.osd' returns 'Err:502'. When I open this file in Open Office 3.2, it works properly, so there is no errors in formulas. Even if external 'ODS' file is placed on a file server and its full name contains cyrillic characters. I tested localised Libre Office (RU) and I have the same problem. Mac OS 10.6.7 LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2
This works in Windows 7. create a test.ods sheet with some data values. save the file. Create a second new spread sheet. Use any cell in the second spreadsheet and pick a reference a cell that holds a value from the first sheet. E.g. cell A1 in test.ods holds the value '3'. To set cell A1 in the second spread sheet equal to cell test.A1 1. In test, name cell A1 as a range and save it. 2. In the second sheet, select any cell. A. Under menu Insert select "Link To External Data. B. From the drop down menu, select test.ods C. Press OK 3. The result should be '3' in the second sheet.
(In reply to comment #0) > Set cell A1 in the second spread sheet equal to > cell test.A1 (ie ='file:///[location]/test.ods'#$Sheet1!A1'). When using Calc A1 syntax the sheet separator is a '.' dot, so the correct formula would be ='file:///[location]/test.ods'#$Sheet1.A1 And this works in 3.4.2 and 3.3.4 The Excel A1 syntax (which uses '!' exclamation mark as sheet separator but again is different from the example you gave) however seems to be broken in both, 3.4.2 and 3.3.4
It seems that the problem never has been reproduced, only user errors with wrong syntax! @mrh / others: Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to <http://wiki.documentfoundation.org/BugReport> (especially BugReport Details), especially a test kit
RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO.