https://bugs.documentfoundation.org/show_bug.cgi?id=122096
Bug ID: 122096
Summary: FILEOPEN XLSX, Conditional formatting with cell
contains condition doesn’t work in LO.
Product: LibreOffice
Version: 6.2.0.0.beta1+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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:
--
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