[Libreoffice-bugs] [Bug 122096] New: FILEOPEN XLSX, Conditional formatting with cell contains condition doesn’t work in LO.

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

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