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
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!
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
Thanks for the update!
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!