https://bugs.documentfoundation.org/show_bug.cgi?id=172797
--- Comment #5 from JF <[email protected]> --- After verifying again, the result is 0 whenever the link is internal or external. To keep the value as Null, I would have to use a formula in B32 such as this: =IF(LEN( 'file:///C:/Users/marti/Documents/LibreOffice Test/External links corrupted (source).ods'#$Source_Data.B32)=0; ""; 'file:///C:/Users/marti/Documents/LibreOffice Test/External links corrupted (source).ods'#$Source_Data.B32) Unless you have a better way, this approach works, but it makes it very cumbersome. I guess it comes back to the behaviour of LibreOffice. A Null value is treated as a zero when the source returns a null or empty value and is therefore converted it into a hard zero in the target cell. This is true being an internal or external link. Any chances that this behaviour could be changed? -- You are receiving this mail because: You are the assignee for the bug.
