QTableWidgetItem visual format

**aekilic** · 6th October 2007, 14:22

Dear All

Actually we have another problem for this one...

We are using a QTableWidget, for one column we bring a double value. After that we have made a delegate for this column for QSpinBox.

What we would like to is we would like to

1st. Bring the values to QTable like 999,999,999.00
2nd. edit them in spin, and put it back to table 888,888,888.00
3rd we would like to save them to sql as 888888888

is it clear?

**jpn** · 6th October 2007, 16:21

What's the problem? It gets stored as a number to the database, doesn't it? No formatting will be stored.

**aekilic** · 6th October 2007, 17:18

no formatting is going to store to database, only what we like to do is to show them like i said...

**jpn** · 6th October 2007, 17:48

You can always reimplement your model's data() and return numbers in localized format with help of QLocale. Item views localization support was significantly improved in Qt 4.3, so you could also try playing with table views locale.