https://bugs.documentfoundation.org/show_bug.cgi?id=100847
Bug ID: 100847
Summary: EDITING: Operations with links to empty cells in other
files, gives #VALUE as result.
Product: LibreOffice
Version: 5.2.0.1 rc
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126160
--> https://bugs.documentfoundation.org/attachment.cgi?id=126160&action=edit
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;
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
