Document Processing Localization
Compare how the same workbook parses input, displays values, and localizes formulas in different
cultures. Formulas and values are always stored in canonical invariant form - XLSX and CSV files
read and write identically on every host - while SetValue, GetValue, and
GetDisplayText follow Workbook.Culture.
Each row below is a Workbook with a different Culture. The canonical
Cell.Formula stays identical in every culture - only user-facing entry and display change.
Workbook.Culture defaults to CultureInfo.CurrentCulture; set it explicitly in
server-side code so results do not depend on the host locale.
Culture | Formula as the user types it | Canonical Cell.Formula | 1234.5 as #,##0.00 | Typing "10,50" produces |
|---|---|---|---|---|
| en-US | =SUM(A1,A2)*1.5 | =SUM(A1,A2)*1.5 | 1,234.50 | 1050 (Number) |
| de-DE | =SUM(A1;A2)*1,5 | =SUM(A1,A2)*1.5 | 1.234,50 | 10.5 (Number) |
| es-ES | =SUM(A1;A2)*1,5 | =SUM(A1,A2)*1.5 | 1.234,50 | 10.5 (Number) |
| fr-FR | =SUM(A1;A2)*1,5 | =SUM(A1,A2)*1.5 | 1 234,50 | 10.5 (Number) |
| it-IT | =SUM(A1;A2)*1,5 | =SUM(A1,A2)*1.5 | 1.234,50 | 10.5 (Number) |
| ja-JP | =SUM(A1,A2)*1.5 | =SUM(A1,A2)*1.5 | 1,234.50 | 1050 (Number) |
Radzen Blazor Components, © 2018-2026 Radzen.
Source Code licensed under
MIT