Mistake with Plan ?

Questions and answers about FreeOffice PlanMaker 2018 for Windows
Post Reply
omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Mistake with Plan ?

Post by omer92 » Wed Feb 24, 2021 9:33 am

Good morning,
I found an error that I can't explain on FreeOffice's Plan 2018.
I had a table on Excel 2003, it was a very simple accounting table with only additions and subtractions, no multiplications, no divisions, no percentage calculations.
I wanted to open and use this table with Plan, it worked without difficulty. Then I added a formula like =if(a1=a2;"YES";"NO"). It wasn't working properly. After research I realized that several numbers of the Excel table as for example 75.67 with only 2 decimal places became on the table Plan 75.67000000000016.
This has happened on several tables
The solution was to use a rounding formula, but I would like to know why the numbers were changed.
Thank you in advance,
Kind regards.

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1416
Joined: Wed Mar 11, 2020 5:31 pm

Re: Mistake with Plan ?

Post by SuperTech » Wed Feb 24, 2021 1:26 pm

Thanks for reporting this problem. Please share the associated original file of Excel in which you are getting this problem without opening/saving it with PlanMaker and the modified file saved with PlanMaker with the screenshots of unexpected changes so that we can do further investigation for resolution.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=318&t=20960

omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Mistake with Plan ?

Post by omer92 » Wed Feb 24, 2021 5:39 pm

Thank you for your message.
I am sending you the Excel 2003 file and the Plan file which was obtained.
The numbers are imaginary.
Thank you in advance,
Cordially.
A. Omer
Attachments
Budget SIMPLE 1.xls
(156 KiB) Downloaded 16 times
Budget SIMPLE.pmdx
(55.67 KiB) Downloaded 16 times
Budget SIMPLE 2.xls
(156 KiB) Downloaded 15 times

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1416
Joined: Wed Mar 11, 2020 5:31 pm

Re: Mistake with Plan ?

Post by SuperTech » Wed Feb 24, 2021 6:46 pm

Thanks for sharing the sample files. Please also share the screenshots pointing out where you found the differences so that we can check those specific cells/range.

omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Re: Mistake with Plan ?

Post by omer92 » Wed Feb 24, 2021 7:30 pm

Good evening,
I send you the screenshots of Excel and Plan tables.
Cordially
Attachments
Budget SIMPLE 1.xls
(156 KiB) Downloaded 15 times
Budget SIMPLE 2 XLS.JPG
Budget SIMPLE PMK.JPG

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1416
Joined: Wed Mar 11, 2020 5:31 pm

Re: Mistake with Plan ?

Post by SuperTech » Thu Feb 25, 2021 2:51 pm

Thanks for sharing the file and screenshots. I was able to reproduce the problem and forwarded the details to our development team for further investigation of the problem.

omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Re: Mistake with Plan ?

Post by omer92 » Thu Feb 25, 2021 6:56 pm

Good evening,
I just tested the Plan 2018 spreadsheet again. Using a new sheet, I entered some numbers, manually, directly, without going through Excel, with only 2 decimal places. Then I formatted these numbers to 15 decimal places, there should only be zeros after the second decimal place, but I see numbers starting from the 11th decimal place. I did this test several times, on new sheets each time I find this problem…
Attachments
TEST PMK.JPG
TEST PMK.JPG (24.13 KiB) Viewed 370 times

omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Re: Mistake with Plan ?

Post by omer92 » Tue Apr 20, 2021 8:23 am

Hello,
Is there no solution to this problem ?

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1416
Joined: Wed Mar 11, 2020 5:31 pm

Re: Mistake with Plan ?

Post by SuperTech » Fri Apr 23, 2021 1:00 pm

As I mentioned earlier I have forwarded the details to our developers team and whenever I receive any response, I will update here.

However, it seems you are expecting a numeric accuracy up to the n-th decimal which is simply not there with floating-point operations:

https://en.wikipedia.org/wiki/Numeric_p ... soft_Excel

omer92
Posts: 6
Joined: Wed Feb 24, 2021 9:18 am

Re: Mistake with Plan ?

Post by omer92 » Sat Apr 24, 2021 8:25 am

Hello,
I do not understand why if I type for example 52.33, Plan inscribed 52.330000000000005
(post feb 25, 2021)

Post Reply

Return to “FreeOffice PlanMaker 2018 for Windows”