[Libreoffice-bugs] [Bug 143950] Calc conditional formatting based on formula misfunction, xxxxIF functions tanking care of cell format to calculate

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Viktor <sorix at web.de> ---
(In reply to m.a.riosv from comment #5)
> Created attachment 174420 [details]
> 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.

Hi (Matrisov)?,

yeah, you are right!
When I change the cell formating to "normal" decimal the conditionaL formating
the conditional formating is workiung again. But I woul like to keep the
asigned "BA " in front of our "BA" → is our "Job Number"...

The Solution for me is in the moment to switch the format-code to: ["BA "0]
instead of  ["BA "Standard]
→ so it is possible for me to work as before but with the newer Version (I love
the Autofilter update ☺ )

Thanks again for your advice

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