https://bugs.documentfoundation.org/show_bug.cgi?id=148805
--- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to m.a.riosv from comment #1) > You have a zero after quotes at the end of the formula, before the last > parenthesis. Deleting it, the formula don't result in error. Exactly. SEARCH function [1] takes optional third "Position" argument; and that argument, as *all* string positions in Calc, counts from 1, not 0. It is obvious from the example given there, which, although not showing the third argument itself, has the return result - and since the return from SEARCH is also position in string, 1-based count is shown: > =SEARCH(54;998877665544) returns 10. [1] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html?DbPAR=CALC#bm_id3151005 -- You are receiving this mail because: You are the assignee for the bug.
