[Libreoffice-bugs] [Bug 36109] New: Errors not detected for nested #REF! errors

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=36109

           Summary: Errors not detected for nested #REF! errors
           Product: LibreOffice
           Version: LibO 3.3.2 release
          Platform: x86-64 (AMD64)
        OS/Version: Windows (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: meseer at gmail.com


Created an attachment (id=45455)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=45455)
Illustration of IsError bug

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

In contrast, when for example cell A1 contains formula 
   =INDIRECT(ADDRESS(1;1;2;1;"NonExistingSheet"))
then 
   =ISERR(A1)
evaluates to "TRUE", as expected. 

The same holds for functions ISERROR() and ERRORTYPE().

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.