Re: [sc-dev] String Operations in Calc and Advanced Utilities

2006-10-31 Thread Niklas Nebel
Leonard Mada wrote: Exactly this is the problem. It returns an *ERROR*, so searching for string 1 OR string 2 will fail grandiosely. Actually, it is impossible to perform this search in calc. This is a *BUG*. (the full comments can be found for issue 66590) It's possible using ISERROR. One

Re: [sc-dev] String Operations in Calc and Advanced Utilities

2006-10-31 Thread Eike Rathke
Hi Leonard, On Tuesday, 2006-10-31 19:57:17 +0200, Leonard Mada wrote: It's possible using ISERROR. One day, for compatibility, we'll need an IFERROR-like function, which will also make such cases easier to handle. Easier to handle sounds a little bit cynical. Here are the 2 search