<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124129">124129</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>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
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>software_bug@quantentunnel.de
</td>
</tr></table>
<p>
<div>
<pre>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:
<a href="https://filehorst.de/d/ctvaGeHh">https://filehorst.de/d/ctvaGeHh</a>
The bug is confirmed by Harald Köster for the german version:
<a href="https://listarchives.libreoffice.org/de/discuss/msg22796.html">https://listarchives.libreoffice.org/de/discuss/msg22796.html</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>