<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC *URGENT* probably fatal failure of the internal file structure =IFERROR(IF(SEARCH(F$1;$C5)<1;"";1);"") now returns incorrect values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144294#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC *URGENT* probably fatal failure of the internal file structure =IFERROR(IF(SEARCH(F$1;$C5)<1;"";1);"") now returns incorrect values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144294">bug 144294</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=144294#c2">comment #2</a>) > Anyway, in order to reproduce the pb, please attach an example file. Without > this, I don't think it'll be easy to reproduce this and so to debug it. (In reply to Julien Nabet from <a href="show_bug.cgi?id=144294#c2">comment #2</a>) > > > Anyway, in order to reproduce the pb, please attach an example file. Without > this, I don't think it'll be easy to reproduce this and so to debug it. What's more important is to fully understand it. The circumstances are defined in the original text and also the difficulty with which to categorise it. 2 files attached The screen images refer to sheet 1 on either file. Simply place your cursor on the indicated cell, absorb the relevant circumstances of the new manifestation and perhaps then you will understand why it's so difficult to describe the error and why this report is nothing like the 27 open bugs already reported by me. Personally, I would have assumed that looking at the images and understanding the conflicting interpretation of the previously highly successful function would have been sufficient to not patronise a user. Certainly, identifying the difference between the correct and incorrect interpretation of the same function when a simple picture admirably demonstrates the issue is not rocket science - would you disagree?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>