[Bug Rrport] Decimal Point and Decimal Comma in Document field calculation

Desktop editors
1

Report a bug
OS version: Windows 10 - German
App version: DesktopEdition 8.3.1.25
Downloaded from: ONLYOFFICE website
Additional information:
If you use the field function in a document and then calculate with it, there is a problem with the decimal point and decimal comma.
Currently, the program always expects a decimal point as a separator. In Germany and many other countries, however, the decimal point is required and the thousand separator is the dot.

Link to Document with the bug:
Document with bug

2

Hello @binghamfluid,
Please also demonstrate the issue reproduction steps for better clarity (provide the screen recording)

3

Here is the screenrecording:
test_Berechnung_screenrecording

and the File:
test_Berechnung.docx (27.1 KB)

The file starts with the correct results and then i’ve refresh the calculation inside ONLYOFFICE.

4

I’ve tested the same field formula ( =euro_kwh*(zs_am-zs_vm) # “#,##0.00 €;(#,##0.00 €)”
on the same number within MS Word and the result was the same -

image
image1274×533 28.7 KB

It seems there is an issue with the formula itself. Or please provide additional clarification

5

Hi DmitriiV,

the , 43.91 problem is a second problem. The main problem is the decimal point and decimal comma.
Here are two more videos showing the probem. I have used the same file for booth videos.
First Video is using MS Office:
Screenrecording MS Word
Second Video is using ONLYOFFICE:
Screenrecording ONLYOFFICE
Used document:
test_Berechnung.docx (27.1 KB)

6

Understood, thank you for the demonstration! We are analysing the issue

9

Hello @binghamfluid, we have reproduced the problem and registered the bug, sorry for the inconvenience, we will do our best to fix it on one of the future versions

1 Like