ONLYOFFICE regional-settings practice recipe
Original synthetic exercise; prepared 2026-10-22.
Plain UTF-8 text, not a spreadsheet or an importable table.
Enter individual cells manually in a disposable local XLSX workbook.
Documentation-qualified for free Desktop Editors 10.0.0, Windows/Linux;
not executed in the application and no screenshots supplied.

Record existing Formula Language, Region, separator mode and custom characters.
Use English Formula Language to construct this starting fixture.
Sheet: LocaleCheck
A2: First amount
A3: Second amount
B2: =125/10
B3: =1325/100
B4: =SUM(B2:B3)
D2: =B2*100
D3: =B3*100
D4: =B4*100
B6: =DATE(2026,4,3)
D6: =YEAR(B6)*10000+MONTH(B6)*100+DAY(B6)

Expected numeric values, independently calculated, not observed in ONLYOFFICE:
B2 = 12.5
B3 = 13.25
B4 = 25.75
D2 = 1250
D3 = 1325
D4 = 2575
B6 means April 3, 2026.
D6 = 20260403

Reserve B8 for entering the sum function through the function dialog after
changing Formula Language; supply B2:B3. Expected result: 25.75.
Change only one setting at a time and compare the integer control values.
Before the Region test, inspect the recorded separator mode. If region-based
separators were off, enable that option alone, Apply and check the controls.
Only then change Region and recheck. Restore the original separator mode later.
Keep the date-system setting unchanged. Never perform workbook-wide punctuation
replacement to repair a display difference. Restore all recorded settings.
Save/reopen the separate practice copy and repeat checks before using real data.
See the full tutorial for scope, procedures, limitations and troubleshooting.