Resolves: tdf#35636 implement match on empty cells

Desktop / LibreOffice - Eike Rathke [redhat.com] - 31 March 2015 07:32 UTC

This implements search criteria "" and "=" to match empty cells in spreadsheet functions SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS and COUNTIFS.

01b6156 Resolves: tdf#35636 implement match on empty cells
sc/inc/queryentry.hxx | 3 ++-
sc/inc/queryparam.hxx | 5 ++++-
sc/source/core/data/dociter.cxx | 20 ++++++++++++++++++--
sc/source/core/data/table3.cxx | 2 +-
sc/source/core/tool/doubleref.cxx | 2 +-
sc/source/core/tool/interpr1.cxx | 18 +++---------------
sc/source/core/tool/queryentry.cxx | 2 +-
sc/source/core/tool/queryparam.cxx | 17 ++++++++++++++++-
8 files changed, 46 insertions(+), 23 deletions(-)

Upstream: cgit.freedesktop.org

  • Share