Bug 36109 - Errors not detected for nested #REF! errors
Summary: Errors not detected for nested #REF! errors
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.2 release
Hardware: All All
: medium normal
Assignee: Eike Rathke
Whiteboard: target:3.5 target:3.4.6
Keywords: regression
Depends on:
Reported: 2011-04-10 02:14 UTC by Mykhailo Delegan
Modified: 2012-02-10 09:22 UTC (History)
0 users

See Also:
Crash report or crash signature:

Illustration of IsError bug (10.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-04-10 02:14 UTC, Mykhailo Delegan

Note You need to log in before you can comment on or make changes to this bug.
Description Mykhailo Delegan 2011-04-10 02:14:16 UTC
Created attachment 45455 [details]
Illustration of IsError bug

Neither ISERR() nor ISERROR() nor ERRRORTYPE() correctly detects an error on nested formula. E.g. when one enters 
it always returns "FALSE", regardless the existence of "NonExistingSheet" in current workbook. 

In contrast, when for example cell A1 contains formula 
evaluates to "TRUE", as expected. 

The same holds for functions ISERROR() and ERRORTYPE().
Comment 2 Henrique Loureiro 2012-02-08 05:29:02 UTC
This bug persist in versions 3.4.5. of LibreOffice
Comment 3 Markus Mohrhard 2012-02-10 09:22:57 UTC
Pushed now to 3-4 too.