[Libreoffice-bugs] [Bug 127624] Add Excel-compliant version of COUNTIF

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #14 from b. <newbie-02 at gmx.de> ---
a little OT here, 

but please be aware that the format applied to a cell isn't evaluated after a
change (of the format), but needs a subsequent 'touch' to the content. 

thus there are two states of cells, one 'content matches formatting', and
another 'the content is evaluated according to the previous formatting'. 

(and plenty more or 'subtypes' where content and format contradict each other
...)

i mentioned that as a 'trap' earlier, but Mike Kaganski? insisted it has to be
kept that way. 

imho., as it's difficult to see which is what, it introduces difficulties in
use and debug ... 

reg. 



b.

-- 
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/20190926/4f90fed2/attachment.html>