Created attachment 109460 [details] tgz of screenshot and example files File ods (file-4.2.5.2.ods) created with libreoffice < 4.3 with link to csv (file.csv) Sins release >= 4.3, opening ods and update link says #REF! (20141114-BugOO_4.jpg 20141114-BugOO_6.jpg) With libreoffice 4.2 no problem (20141114-BugOO_1.jpg 20141114-BugOO_3.jpg)
Hi @tsalmon18, thanks for reporting. Reproducible Win7x64 Version: 4.3.4.0.0+ Build ID: e812aaaf31050c29a9499d3936cf07079b1a5f86 TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-11-10_11:36:56 Seems now sheet name it's the same as file name. changing 'sheet1' with 'file' in the link works fine, with last versions but fail with 4.2.5.2.
With v4.2.7.2 Build ID: 420m0(Build:2) under mint 17 x64 it seems already partially broken. Only A2 and B2 have #REF!
I am suffering from this too, with my own ODS sheets and CSV files. Lubuntu 14.04 LTS and Libreoffice versions for the last year or so. I've had to roll back to 4.1.something The import dialog box fails to open i.e. when you open the ODS then click "Yes" to update the cell contents from the external CSV file there is normally a dialog box for selecting the character encoding, delimiter character, etc. This doesn't open. Bug still present in LO 4.4.2.2 Any news on whether this is being looked at or an estimated date for a fix?
After a bit of tinkering I now understand m.a.riosv's comment as a workaround. In the formulae on the ODS sheet the file & cell reference has changed from 'Sheet1' to the filename. (minus the extension) So updating all my formulae to reference 'filename' rather than 'Sheet1' I can import from the external CSV as before.
This issue is still reproducible in Version: 5.2.0.0.alpha0+ Build ID: d6bf3bcd8b51012d55a2ec962800a8549e2b85e1 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-04-15_06:45:16 Locale: es-ES (es_ES)
Hum.. indeed, the "name sheet after file" should be decoupled for external references.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=43030487c45f49bccdfad987c60d9483b938ebac Resolves: tdf#86282 do not use file name as sheet name for linked documents It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ec693d9b9df631605028271f62daa7dfbe8e273d tdf#86282 handle both, base name and Sheet1, as external reference sheet name It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d9e7a54809c88c4ac166630c11038188c8f50a6f tdf#86282 switch to base name sheet name again for external references CSV It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=386b284241a16d96eaf792e2385c41f57ce3d870 remove now moot comment, tdf#86282 follow-up It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/25471 for 5-1
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=06197fca43d12848e49ad0d3e4240b814032a27b&h=libreoffice-5-1 tdf#86282 handle both, base name and Sheet1, as external reference sheet name It will be available in 5.1.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.