[Solved] How to change decimal separator to current culture comma ',' on spreadsheet ?

[Florian]

On the spreadsheet, the default decimal separator seems to be  dot ".", it's possible to change decimal separator to comma ',' ?

And the same thing for thousand separator ?

Regards.

 

Florian.

[Mihaela]

Hi Florian,

By enabling the UseCultureDecimals() functionality, the Spreadsheet formula parser will obey the decimal separator of the current culture.

@(Html.Kendo().Spreadsheet()
    .Name("spreadsheet")
    .UseCultureDecimals(true)
    ...
)

Client-side API: https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/configuration/useculturedecimals

If you have any additional questions, please let me know.

 

Regards, Mihaela Progress Telerik

[Florian]

Thanks, i found it, but he's not convert format in the formula.

ex format % : TEXTE(Source_Tableau_1!I4;"##0,00%"))

Display in Excel : 11,41%

Display in Telerik SpreadSheet : 011%

[Mihaela]

Thank you for your feedback.

It appears that this is a bug and I have logged an item in our feedback portal on your behalf. You can follow the report status here:

https://feedback.telerik.com/kendo-jquery-ui/1539474-the-text-function-does-not-format-a-cell-with-decimal-separator-comma

I encourage you to cast your vote so that the item could gain traction and be implemented in any of the next releases. While an official fix is provided, you could use the formula with a dot: =TEXT(A1; "##0.00%")