https://bugs.documentfoundation.org/show_bug.cgi?id=145602
V Stuart Foote <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Summary|Ctrl+Shift+Enter in cell |Ctrl+Shift+Enter in cell |C10 |C10 ( | |Recalculate/Recalculate | |Hard?) for string search | |and count Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from V Stuart Foote <[email protected]> --- It is not clear what the issue is. Test doc C10 cell holds "=SUM(--ISNUMBER(SEARCH("Кумыс",A2:A6)))", so assume the Ctrl+Shift+Enter is local specific for "Recalculate Hard"? Though simple <F9> would refresh. But isn't the needed syntax for doing the string search here: =(COUNTIF(A2:A28,"*Кумыс*")) And this is NAB? A helpful tutorial for COUNTIF usage is here: https://www.libreofficehelp.com/count-cells-strings-numbers-countif-function-calc-example/ -- You are receiving this mail because: You are the assignee for the bug.
