https://bugs.documentfoundation.org/show_bug.cgi?id=124129
Bug ID: 124129
Summary: Above v6.0.7.3: Spreadsheet names that contain a dot
and are used in conditional formatting formulas cause
an non existent external link to the "documents" user
folder in Windows
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Spreadsheet names that contains a dot and are therefore enclosed in quotation
marks, creates a non-existent link to the "Documents" folder of the Windows
user directory, if they are used in conditional formatting formulas.
The link cannot be removed permanently and removing the link even deletes the
formula of the field that is to be affected by the conditional formatting, so
that the last result is then shown as static.
Steps to Reproduce:
New spreadsheet with two sheets, the second of them must contain a dot in its
name (test1 and test.2).
Enter the following formula in A1 of the "test1" sheet:
IF($'test.2'.$A$1>=5; "yes"; "no")
Enter a value in A1 of the "test.2" sheet.
For A1 of the "test1" sheet, enter the following conditional formatting:
Condition 1: Formula is IF($'test.2'.$A$1>=5) with template "good"
Condition 2: Formula is IF($'test.2'.$A$1<5) with template "error"
Save and close the spreadsheet.
Actual Results:
Open the spreadsheet and now LibreOffice versions 6.1.x.x and above show the
yellow warning bar for external links. If you delete the link and save the
spreadsheet, the formula in A1 of "test1" is deleted after reopening. The link
is back again, but A1 of the sheet1 shows no more its formula but the last
value as static.
Expected Results:
Same as with version <=6.0.7.3 (no external link).
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Test-Spreadsheet for the english version:
https://filehorst.de/d/ctvaGeHh
The bug is confirmed by Harald Köster for the german version:
https://listarchives.libreoffice.org/de/discuss/msg22796.html
--
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
