Bug 323022 - Some operations don't work well. It's because they don't use "decimal floating types" like std::decimal::decimal64?
Summary: Some operations don't work well. It's because they don't use "decimal floatin...
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (other bugs)
Version First Reported In: 2.6.3
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-30 20:52 UTC by Ganton
Modified: 2022-12-03 12:09 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Ganton 2013-07-30 20:52:56 UTC 
Some operations don't work well. This is critical in financial operations, for example. 
It's because they don't use "decimal floating types" like std::decimal::decimal64?

Reproducible: Always

Steps to Reproduce:
1. Enter =IF(100.01-100=0.01;"Ok";"Not true")

Actual Results:  
It returns "Not true".

Expected Results:  
It should return "Ok".
Comment 1 Ganton 2013-07-30 21:04:07 UTC 
Yes, I know that binary floating types are faster, but the quantity of users that want a correct result... is huge, for example in financial operations.

Thanks for all the Calligra software!
Comment 2 Andrew Crouthamel 2018-11-10 03:21:03 UTC 
Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond.

Thank you for helping us make KDE software even better for everyone!
Comment 3 Ganton 2018-11-14 17:59:58 UTC 
The problem still happens using Calligra 3.1.0 under Kubuntu 18.10...
Comment 4 Justin Zobel 2022-12-03 09:01:33 UTC 
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Comment 5 Tomas Mecir 2022-12-03 12:09:38 UTC 
Confirmed in latest git.