Bug 81240 - EDITING: weird IFNA() and IFERROR() behaviour on inner IF() when errors occurs in condition
Summary: EDITING: weird IFNA() and IFERROR() behaviour on inner IF() when errors occur...
Status: RESOLVED DUPLICATE of bug 80195
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-11 16:23 UTC by Modestas Vainius
Modified: 2014-09-12 20:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Modestas Vainius 2014-07-11 16:23:52 UTC 

    


    


      



        
          Comment 1
        

        
          Modestas Vainius

        

        
        

        
          2014-07-11 16:31:34 UTC
        

      






Hello,

I have noticed weird =IFNA() and =IFERROR() interaction with inner =IF() when error occurs in the condition. For example:

=IFNA(IF(NA()="AA";"";0);"It was NA") -> #NA while it should have been "It was NA"
=IFERROR(IF("AA"+"BB";"";0);"It was ERROR") -> #VALUE! while it should have been "It was ERROR"

but there is a workaround:

=IFNA(IF(NA()="AA";"";0+0);"It was NA") -> "It was NA"
=IFERROR(IF("AA"+"BB";"";0+0);"It was ERROR") -> "It was ERROR"

So basically IF/IFERROR does not seem to work when there is a constant in IF's else part. If there is a formula in IF's else part, IFNA/IFERROR works.

Tested on 4.3.0 RC2 (windows), will test on 4.2.5 (Linux) later.

P.S. Sorry for posting an empty initial bug.

    


    


      



        
          Comment 2
        

        
          Modestas Vainius

        

        
        

        
          2014-07-12 05:59:16 UTC
        

      






Just checked, same on 4.2.5.2 (Debian build).

    


    


      



        
          Comment 3
        

        
          raal

        

        
        

        
          2014-09-12 20:06:50 UTC
        

      






Hello,
I copied all of your formulas into new spreadsheet, and results are "It was NA" and "It was ERROR". Please, could you test with newer version? Setting bug as needinfo, set as unconfirmed again if problem still occurs in newer version. Thank you.

Tested LO 4.3.1, WIN7.
Version: 4.3.2.0.0+
Build ID: 4b8a0159ca80dad05ddcaad5897b786484fc8afb
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-09-10_12:58:37

    


    


      



        
          Comment 4
        

        
          Modestas Vainius

        

        
        

        
          2014-09-12 20:40:19 UTC
        

      






Just tested, it seems to work in 4.3.1 on Windows/Linux.

It seems this bug could be a dupe of https://bugs.freedesktop.org/show_bug.cgi?id=80195 which has been fixed in this version. Marking accordingly.

*** This bug has been marked as a duplicate of bug 80195 ***