Initial checklist
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.
Initial checklist
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.