Bug 323022

Summary:	Some operations don't work well. It's because they don't use "decimal floating types" like std::decimal::decimal64?
Product:	[Applications] calligrasheets	Reporter:	Ganton <kubry>
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	CONFIRMED ---
Severity:	normal	CC:	mecirt
Priority:	NOR
Version First Reported In:	2.6.3
Target Milestone:	---
Platform:	Kubuntu
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

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.