[Feature] Input parsing setting, from dot-decimal to coma-decimal
Author: vanarebaneCreated Mar 1, 2026Updated Mar 9, 2026
Labelsenhancement 🚀
Initial checklist
- Is this really a problem?
- I have searched the Github Issues for similar issues, but did not find anything.
Problem
In univer 0.16.0 there is no setting to choose number input parsing. I looked at localization, and rest of the code, and all input numbers are parsed only US style with dot-decimal. So in EU countries, a 1,23 input is threated as a text.
Verified behavior (local test) 1,23 => null 1.23 => { v: 1.23 } 1234,56 => null 1,234.56 => { v: 1234.56, z: '#,##0.00' }
.setNumberFormat('#,##'); or pattern setting can change the number from dot-decimal to coma-decimal, but one has to input numbers still with dot-decimal. Also, this setting will make the entered numbers to round.
Feature request, have the decimal be configured on the workbook level to be coma or dot.
Source: dream-num/univer