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

          Priority: medium
            Bug ID: 79957
          Assignee: [email protected]
           Summary: EDITING: IFNA() IFERROR() have an strange behaviour
                    inside SUMPRODUCT, fine inside an array SUM()
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.0.6.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 100943
  --> https://bugs.freedesktop.org/attachment.cgi?id=100943&action=edit
Sample file to test

Win7x64Ultimate

With attached file results are wrong in cells
A1:A4 , A7:G10 , G1:G4 , G7:G10 with:
Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)
Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a

But results are only wrong in cells
A1 , A4 , A7 , A10 , G1 , G4 , G7 , G10 with:
Version: 4.2.4.2 Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
Version: 4.3.0.0.beta2+Build ID: 939c5b7c2421b226e555cfd14d35d699be787b32
       TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-06-12_08:59:41
Version: 4.4.0.0.alpha0+ Build ID: 9885c35ddb9188e5b1549edf8697f6946232f7d3
       TinderBox: Win-x86@39, Branch:master, Time: 2014-06-12_06:31:56

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to