Change the decimal separator from Numeric keypad
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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Change the numeric decimal separator to "^" char. | |
GridWeb1.WorkSheets.NumberDecimalSeparator = '^'; |