https://bugs.documentfoundation.org/show_bug.cgi?id=170840
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #8 from Regina Henschel <[email protected]> --- You need to catch an error already before you call your Basic function: =SOM(IFERROR(A5:A10+B5:B10;0)) The error #VALUE! becomes NaN inside the Basic function. You could catch it with If CStr(Liste(i,1))<>"NaN" then ..., so that Basic does not produce a run-time error. However, that will not change the result for the cell. It might be useful, if you want your function to produce a message for the user in such case. Perhaps the help about error handling in Basic could be expanded to explain why such situation shows the error #VALUE! in the cell? -- You are receiving this mail because: You are the assignee for the bug.
