Description: Tools->options->libreoffice calc->calculate->general calculations->limit decimals doesn't entirely work. In example, works for operands, first sum, no other sums (C-J22.) I'd like to override some areas (A2-3) to show short values less than 1, without having to have to alter setting to normally show integers. Steps to Reproduce: 1. Set to show integers. 2. Do more than one sum. 3. Second sum column and further show decimals, not integers. Actual Results: Second sum column and further show decimals, not integers. Expected Results: If set, show integers everywhere (but allow overriding it in a few places) including all sums (no exceptions as in example, which I didn't create exceptions.) Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Slackware64 15.1-current libreoffice-7.3.3-x86_64-1alien, but can test on FreeBSD Unix, perhaps other OS.
Created attachment 180050 [details] calculations This was set to display only integers (but includes decimals.)
Created attachment 180051 [details] screenshot screenshot (same calculations before I deleted empty columns)
I don't see bug here. Please use ask.libreoffice.org before reporting for help.
If you saw the .ods, everything is decimals but when ‘Tools->options->libreoffice calc->calculate->general calculations->limit decimals for decimal number format->0’ is set, it only hides most decimals (summed columns' operands, and the first column sum but not sums two to nine.) If this isn't a bug, what is it?
It's a user error. I can easily explain, but that defeats a purpose of BZ and converts it into help tool, loosing focus on bugs and overwhelming us volunteers. So please use ask.libreoffice.org.