Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 390
    • Issues 390
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOMEGNOME
  • gnumericgnumeric
  • Issues
  • #423
Closed
Open
Issue created Oct 31, 2019 by Ghost User@ghost

sumif condition does not work with empty cells (regression)

Regression for Gnumeric 1.12.45 on Debian.

In sumif, the condition for an empty cell always returns false.

In the attached file the formulas in cells E3 and F3 should produce 1, but both produce 0 instead, which is wrong.

The same formulas produce the correct result when the file is read in Libreoffice 6.3.2 on Debian and in Gnumeric 1.10.17 on Ubuntu

bug.gnumeric

Assignee
Assign to
Time tracking