https://bugs.documentfoundation.org/show_bug.cgi?id=143950
--- Comment #7 from Viktor <[email protected]> --- (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.
