Bug 306245 - Wrong input in function helper.
Summary: Wrong input in function helper.
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: functions (show other bugs)
Version: unspecified
Platform: unspecified Linux
: NOR major
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-04 10:24 UTC by Simply
Modified: 2022-12-19 21:18 UTC (History)
2 users (show)

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


Attachments
FV function result (6.45 KB, image/png)
2018-11-17 10:01 UTC, Simply
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Simply 2012-09-04 10:24:03 UTC
Using Calligra Sheets, and testing the financial functions, I end up with wrong results, as the input given to the function helper, misplaces the values in the function. Concretely:
In Sheets the input
=FV(0,1;10;0;1000) ----> 2593,74246 , which is correct,
while the one suggested by the wizard is, finally
=FV(1000;0,1;10) ----> -0,00995462

same applies to FV, PMT at least. (Don't mind the commas, should be dots, it's due to localization, the greek variant is with commas).

For reference, the similar example in Libreoffice Calc is:
=FV(0.1,10,0,1000), and gives the expected result.

Reproducible: Always

Steps to Reproduce:
1.In Calligra sheets, press the function button.
2.Use any of the aforementioned functions, filling in the form that emerges.
3.Check the result.
4.Now, fill it in by hand in the top bar, using the schema I propose.
5.Results are right now.
Actual Results:  
input:
=FV(1000;0,1;10) 
result:
-0,00995462


Expected Results:  
input:
=FV(0,1;10;0;1000)
result:
2593,74246


=FV(0,1;10;0;1000)  should give the value 2593,74246
Comment 1 Andrew Crouthamel 2018-11-09 00:57:02 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 2 Simply 2018-11-17 10:01:13 UTC
Created attachment 116368 [details]
FV function result

Hello, 
Now the functions seems broken altogether, I cannot reproduce the example documented in the helper:

FV(1000;0.08;2) gives -0.00147588 instead of 1166.40 .

Thanks
Comment 3 Andrew Crouthamel 2018-11-18 03:15:25 UTC
Thanks for the update!
Comment 4 Justin Zobel 2022-12-19 00:13:25 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!