https://bugs.documentfoundation.org/show_bug.cgi?id=149014
Bug ID: 149014
Summary: enhancement: use all decimals for calculations but
don't require displaying
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I do scientific and other calculations, but many cases one wants all decimals
in calculations but typically only five or two significant digits, or integer,
results (tools->options->libreoffice calc->calculate->general
calculations->limit decimals.)
I decided to round to two decimals (but looks messy so,) now integers.
However it's now hiding results that should be integers in hundreds of
thousands. For example, I calculate, at various multiples of 10,000 to
2,000,000, between 0.01 and 0.09999999 bitcoin (BTC) and others, which that
much BTC rounds to zero for display but earlier this year, 0.09999999*70,000
was almost 7,000 so most people wouldn't want even 0.0001 dropped, but if I set
cells to integers, drops, despite 0.0001 at certain values being large
integers. Other ones (not well-known as BTC but) were approaching 200,000/ea
so even much smaller amounts result in large integers but keeping that many
decimals looks extremely messy: unreadable for average people. For my
calculations, US cent/dime positions are distracting, as a dime (from
inflation) is worth what a penny was as a kid (practically worthless.)
For some scientific calculations, if all decimals aren't still used,
it's even worse. If a physicist uses Planck's constant (6.62607015×10⁻³⁴) for
cosmic-scale calculations, they'd typically want only five significant digits,
but will be dropped. If a mathematician/programmer calculates with π or e,
they may use many digits (maybe even more than a spreadsheet might normally
handle) or certain results start to 'drift' into increasing inaccuracy, but
likewise, five significant digits in official science, except integers in some
programming, which will be dropped (bad if someone wants to create a sinusoid
calculation lookup-table.)
We should be able to keep all/hidden decimals in calculation but for
readability, only view rounding to five or two or zero or whatever chosen
decimal places, and in future perhaps specify/override decimals per row and/or
column or cell... related to this: overall formatting
(tools->options->libreoffice calc->calculate->general calculations->limit
decimals) only rounded my operands to integers but left all sums in last row
with two decimal points (these days becoming undesirable.)
Steps to Reproduce:
1. Use very long decimals in calculation.
2. Hide some decimals because often less relevant in reading nowadays.
3. Relevant calculations/results get dropped.
Actual Results:
Relevant calculations/results get dropped.
Expected Results:
Use all decimals in calculations, but only show however many the reader feels
comfortable with.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Slackware64 15.1-current libreoffice-7.3.3-x86_64-1alien, can also test on
*BSD/IllumOS Unix and perhaps other OS later.
--
You are receiving this mail because:
You are the assignee for the bug.
