Created attachment 126160 [details] File with the links If a linked cell in other file like in attached file: 'file:///g:/Users/xxxx/LinkIssue_Source.ods'#$Sheet1.A1 is empty, doing an operation with it results in #VALUE =+'file:///g:/Users/xxxx/LinkIssue_Source.ods'#$Sheet1.A1*1 = #VALUE While without operations, results is '0' =+'file:///g:/Users/xxxx/LinkIssue_Source.ods'#$Sheet1.A1 Using the N() function as expected works. =+N('file:///g:/Users/xxxx/LinkIssue_Source.ods'#$Sheet1.A1)*1 Win10x64 Version: 5.2.0.2 (x64) Build ID: a7567a46e5d2953c320b13eb88a3981c4f9bd1e0 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES) For me a regression since: Version: 5.1.4.2 (x64) Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a CPU Threads: 1; OS Version: Windows 6.19; UI Render: GL;
Created attachment 126161 [details] Source file
Investigating.
Note that the result in A9 depends on Tools - Options - Calc - Formula "Detailed Calculation Settings" Custom Details "Contents to Numbers" Conversion from text to number. Result in A2 is wrong though, an empty cell should be treated as 0 in numeric context.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=89a5464a21046821648ec77f03db8316ceb4e6f8 Resolves: tdf#100847 also external svEmptyCell is 0 in numeric context It will be available in 5.3.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/27111 for 5-2 https://gerrit.libreoffice.org/27112 for 5-2-0
Thanks @Eike, I'll test when available.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9c30e2aab23e34ba91dbe80b7dd5e5c352bbaeb0&h=libreoffice-5-2 Resolves: tdf#100847 also external svEmptyCell is 0 in numeric context It will be available in 5.2.1. 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 "libreoffice-5-2-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=def0ae82be7f9c4c31b9690fe7e95d8f05cf2210&h=libreoffice-5-2-0 Resolves: tdf#100847 also external svEmptyCell is 0 in numeric context 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.
Tested Ok. Win10x64 Version: 5.3.0.0.alpha0+ Build ID: b0d96a82a4f6a0832d03d185f4a53db669adcc99 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2016-07-12_09:25:31 Locale: es-ES (es_ES); Calc: CL
I don't see nothing about the verification for 5.2.0 and 5.2.1
It appears now with: Win10x64 Version: 5.1.5.1 (x64) Build ID: bb431b2be5fb7772067efc27a3cc98b6927c7b4c CPU Threads: 1; OS Version: Windows 6.19; UI Render: default; Locale: es-ES (es_ES); Calc: CL when it wasn't with Version: 5.1.4.2 (x64)
Ok with Version: 5.2.0.3 (x64) Build ID: 7dbd85f5a18cfeaf6801c594fc43a5edadc2df0c CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES)
Indeed, we need this also in 5-1, pending review https://gerrit.libreoffice.org/27372 for 5-1 https://gerrit.libreoffice.org/27373 for 5-1-5
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=38aceeda9df7a04bff344c82c4bc077217b1178d&h=libreoffice-5-1 Resolves: tdf#100847 also external svEmptyCell is 0 in numeric context It will be available in 5.1.6. 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 "libreoffice-5-1-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=11535b80816d131963eb8f916ba1791816513664&h=libreoffice-5-1-5 Resolves: tdf#100847 also external svEmptyCell is 0 in numeric context It will be available in 5.1.5. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/312cf9580c4b7846d217ce241c36f327a81f6cea tdf#100847: sc_uicalc: Add unittest It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.