Change the decimal separator from Numeric keypad
Contents
[
Hide
]
Possible Usage Scenarios
By default, Aspose.Cells.GridWeb displays numeric data accordingly based on the locale/regional settings on the machine. You can change the decimal separator from Numeric keypad programmatically using Aspose.Cells.GridWeb API. So, when a file is imported into GridWeb matrix or you input some numeric data (from the numeric keypad) into a new worksheet cell, it should have your desired decimal separator set visually.
Change the decimal separator from Numeric keypad
Using the GridWorksheetCollection.NumberDecimalSeparator property, you may change the decimal separator from Numeric keypad programmatically. Please see the screenshots that show how it works
Sample Code
Please note, decimal separator change is only for users' visual experience in GridWeb. When you edit and save your workbook, it will still store the numeric values (in the spreadsheet) as per your locale/regional decimal separator.