https://bugs.documentfoundation.org/show_bug.cgi?id=91434
Bug ID: 91434
Summary: External links - update problem with custom formatting
(regression)
Product: LibreOffice
Version: 4.4.0.0.beta1
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Calc does not update all external links if user defined conditional cell
formatting ([>0]General;[<0]General;"";"") is used. The purpose of this
formatting is to prevent links to empty external cells displaying as zero. This
bug appeared in LO 4.4.0.0.beta1 and has existed since.
Unfortunately, I can't identify the change that caused it.
https://wiki.documentfoundation.org/Releases/4.4.0/Beta1
I have used external links in the way:
='file:///C:/LinkTest/TargetFile.ods'#$Sheet1.A1
This is the same syntax that LO uses to create links, when starting a formula
and then clicking a cell in a another spreadsheet.
However, if the external link is done by copying the cell in the external
spreadsheet and then pasteing it as a link through the "paste as
special"-dialog, LO ads curly brackets before and after the formula.
{='file:///C:/LinkTest/TargetFile.ods'#$Sheet1.A1}
These type of links work correctly with the user defined formatting, but LO
updates these link without asking the user.
I will attach three files to demonstrate the bug.
First download all files to the same folder (ie. C:\LinkTest\)
TargetFile.ods = Cells in this file are referenced from the other documents.
LinkTestUnFormatted.ods = When opening the file, LO ask updating the links and
updates them correctly
LinkTestFormatted.ods = When opening the file, LO ask updating the links, but
updates only certain cells.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
