[Libreoffice-bugs] [Bug 143950] Calc conditional formatting based on formula misfunction

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Aug 19 15:43:45 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=143950

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #5 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 174420
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174420&action=edit
Sample file

The issue it's not related with the conditional format, seems the problem it's
that COUNTIF() taking care of the cell format.

In the attached file, cells Sheet1.A16:B25 has a format "BA "Estandar, on the
second sheet the format is Estandar, with LO 7.2 gives different results in
E2:F11 and C15:C25 between the two sheets, and the only difference it's the
mentioned format.
Do a hard recalc on 7.2 to see the issue.

-- 
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/20210819/e62b64f7/attachment.htm>


More information about the Libreoffice-bugs mailing list