Posted 8 September 2017, 2:14 pm EST
in my VB2008-Project, a Spread5 is bound to a DataSet. The DataSet get the data from a sql-database (table) and contains some numeric-fields.
The project works fine, I can store numeric data to the database in this format: 1000.333333
My question: Is there an easy way
- to display these numeric-cells with thousand-separator to the user in a format: 1,000.33 (the cell.text property ?)
- to edit these cells (or paste data from clipboard) in a format 1,000.333333 and store this value to the dataset/database (the cell.value property ?)
Like the behaviour in Excel: The cell could contain the value 1000.333333 but I can format the cell to display the value to the user like 1,000.33
Thank's for your feedback in advance,