[Libreoffice-bugs] [Bug 144294] CALC *URGENT* probably fatal failure of the internal file structure =IFERROR(IF(SEARCH(F$1; $C5)<1; ""; 1); "") now returns incorrect values

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Julien Nabet <serval2412 at yahoo.fr> ---
On version 6 file:
- I clicked on AllHits sheet (so sheet number 1)
- E1 contains "=Stats.N$4" and displays "04"
- C6 contains "05 07 12 19 26"
- I clicked on E6, "=IFERROR(IF(SEARCH(E$1;$C6)<1;"";1);"")", displays nothing
=> nothing wrong here, there's no "04" in the string

On version 7 file:
- I clicked on AllHits sheet (so sheet number 1)
- E1 contains "=Stats.M$4" and displays "5"
- C6 contains "05 07 12 19 26"
- I clicked on E6, "=IFERROR(IF(SEARCH(E$1;$C6)<1;"";1);"")", displays 1
=> nothing wrong here, the 5 is in the string.

About the rest of your comment, if just asking for clear and simple steps to
reproduce the pb is correspond to patronize, sorry for you.

-- 
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/20210904/f8b484ec/attachment.htm>