[Libreoffice-bugs] [Bug 41214] New: ODFF: implement SUMIFS()

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Mon Sep 26 11:14:06 CEST 2011


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

           Summary: ODFF: implement SUMIFS()
           Product: LibreOffice
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: landas at gmail.com


>From the OpenOffice bug report (angeldeath82):
With Microsoft Excel 2007 they added a function (SUMIFS) which functions as 
follows: SUMIFS(SumRange,SearchRange,Criteria).  They added this to deal with 
unsorted values in SearchRange, as their implementation of SUMIF is based on 
SearchRange being sorted.

OpenOffice bug report:
http://openoffice.org/bugzilla/show_bug.cgi?id=95144

Calc/ODFF Implementation/Examine functions:
http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions

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



More information about the Libreoffice-bugs mailing list