[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 --- Comment #6 from Mike Kaganski --- (In reply to Cubic Consult from comment #4) > Though it work in version 5. Sure: since commit 07157107a3b7fd3d1b55db9ce1aeb9f6d4e204ab Author Winfried Donkers Sate Wed Feb 08 16:48:58 2017 +0100 tdf#105772 apply all ODFF constraints with function SEARCH. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 --- Comment #5 from Cubic Consult --- (In reply to m.a.riosv from comment #1) > I guess, your formula separator, it's the comma. > > 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. You are right about the last 0 parameter being the cause. 1 should have been used. Thanks. NB: The comma works fine. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 --- Comment #4 from Cubic Consult --- Confirmed. Though it work in version 5. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 --- Comment #3 from m.a.riosv --- Function [1] has syntax error. You have that 'zero' without the separator after last quotes. Please attach a sample file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 --- Comment #2 from Mike Kaganski --- (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.
[Libreoffice-bugs] [Bug 148805] The SEARCH function is not working since after version 5.3.7.2
https://bugs.documentfoundation.org/show_bug.cgi?id=148805 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m.a.riosv --- I guess, your formula separator, it's the comma. 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. -- You are receiving this mail because: You are the assignee for the bug.