[Libreoffice-bugs] [Bug 124129] New: 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

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: software_bug at quantentunnel.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190317/7144040d/attachment-0001.html>