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.