https://bugs.documentfoundation.org/show_bug.cgi?id=154058
--- Comment #2 from Jaroslaw <j.fli...@siewierz.pl> ---
(Translate by Google)
Hello
I noticed that CALC functions like:
- FIND
- FINDB (FINDB)
and similar operating on text, if they do not find a result, they return the
error message #VALUE (#ARG).
The results in text strings are counted from 1 so I suggest instead of #ARG
that these functions return 0 (string not found) - it would make their use much
easier.
e.g. instead of writing:
IF(ISERROR(FIND(",",F1)),"",CONCATENATE(J1,F2))
would be simpler (more readable):
IF(FIND(",",F1)=0;"";CONCATENATE(J1,F2))
above the problem is quite troublesome when tables with a large amount of text
are processed in CALC, because the FIND function without ISERROR is a bit weak.
Kind regards
--
You are receiving this mail because:
You are the assignee for the bug.
