Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
gnumeric
gnumeric
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 375
    • Issues 375
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 2
    • Merge Requests 2
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • GNOME
  • gnumericgnumeric
  • Issues
  • #346

Closed
Open
Opened Jul 12, 2018 by Pelle Hjek@hjek

Serious rounding error

In Gnumeric 1.12.28 on FreeBSD 11.2-RELEASE; when I enter 0.02 into a cell in a new spreadsheet, it is displayed as 0.020000000000000001 (because binary floating-point, so that's ok), but when I hit Ctrl+Shift+4 to format it as currency, it rounded up and displayed as $0.03.

When displaying fewer decimals, I'd expect Gnumeric to round to nearest rather than always rounding up.

Gnumeric rounding up

Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: GNOME/gnumeric#346