<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 - FILEOPEN XLSX, Conditional formatting with cell contains condition doesn’t work in LO."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122096">122096</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX, Conditional formatting with cell contains condition doesn’t work in LO.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.0.beta1+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<pre>Description:
When you make a conditional formatting with cell contains a number with a “,”
symbol (eg.: 1,23) it doesn’t work when opened in LO.
Steps to Reproduce:
1. Create a new xlsx in LO.
2. Create a new rule in conditional formatting.
3. Set its condition to contains given text and set the text to 1,23
4. Write some numbers to the area some of which contain the number and
notice that the formatting works.
5. Save the file and open it in LO.
6. Notice the differences then write into one of the are this: “1,23” with
the “ symbols.
Actual Results:
In LO the formatting only works when “1,23” is in the cell.
Expected Results:
It should work as it does in MSO so with both 1,23 and “1,23”.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>