[Libreoffice-bugs] [Bug 143950] xxxxIF functions taking care of cell format to calculate. (Calc conditional formatting based on formula misfunction)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
Seeing that change mentioned in comment 10 uses ScDocument::RoundValueAsShown()
this is fixed with the commit for bug 144209
https://git.libreoffice.org/core/commit/71b003a12f8afdff42a25786ad0a12ddd6609d59

I tried the "Sample file"
https://bugs.documentfoundation.org/attachment.cgi?id=174420 and results after
Shift+Ctrl+F9 hard recalc are the same as in 7.1.5.
Note that E2 =COUNTIFS($A$2:$B$30;A2)>1 loads as (however) stored TRUE in both
versions and is recalculated to FALSE, which is correct, the value 1 occurs
only one time.

-- 
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/20210901/db978c2e/attachment.htm>