Spreadsheet strange behaviour of =TEXT-Function

Suggestions on Community Server Installation/Functionality
Post Reply
kleymann
Posts: 3
Joined: Mon Sep 16, 2019 10:35 am

Spreadsheet strange behaviour of =TEXT-Function

Post by kleymann » Mon Sep 16, 2019 10:55 am

Good Day to All.
It´s my first time here on the forum - please be patient with me.
I´m testing Verion 5.4.0

I figure a strange behaviour in =TEXT function.
Row 18/19/20 are from the help text for the =Text function.

Starting from row 23 i startet with 0 decimals up to four decimals after the comma.
Everything after 2 decimals is giving this strange result.
Anmerkung 2019-09-16 125129.png
Anmerkung 2019-09-16 125129.png (33.77 KiB) Viewed 91 times
Maybe you have some ideas what is going wrong here...

Best,
Konrad

Andrew
Posts: 59
Joined: Mon Apr 01, 2019 1:09 pm

Re: Spreadsheet strange behaviour of =TEXT-Function

Post by Andrew » Mon Sep 16, 2019 12:54 pm

Hello,

Thank you for your post with testing results, could you please send us your test document for analysis?

kleymann
Posts: 3
Joined: Mon Sep 16, 2019 10:35 am

Re: Spreadsheet strange behaviour of =TEXT-Function

Post by kleymann » Mon Sep 16, 2019 1:15 pm

Sure!
Find zipped sheet attached.

When open - find the values are correct.
Once entering the cell and updating (with enter) - the wrong values come back.

Also note - summing over the fields does not work either...

Konrad.
Attachments
Dateien.zip
(8.51 KiB) Downloaded 2 times

Andrew
Posts: 59
Joined: Mon Apr 01, 2019 1:09 pm

Re: Spreadsheet strange behaviour of =TEXT-Function

Post by Andrew » Fri Sep 20, 2019 6:20 am

Hello,

Thank you for test document, it is a bug with German locale user settings. I added it to our bug tracking system, it will be fixed in future versions of ONLYOFFICE. Sorry for temporary inconvenience concerning this issue.

kleymann
Posts: 3
Joined: Mon Sep 16, 2019 10:35 am

Re: Spreadsheet strange behaviour of =TEXT-Function

Post by kleymann » Fri Sep 20, 2019 6:25 am

Good to know - and looking forward to seeing things getting better...!
Keep up the good work.
Thank You!

Post Reply