TDBGrid Display format "#,##0.00" broken?

[Vingadero]

Hello

I'm using Lazarus-0.9.31-34078-fpc-2.5.1-20111210-win32

Have a DBGrid who shows numbers in various currency formats Ex: '$###,##0.00' , '€###,##0.00'

So I change the DBGrid.Columns[X].DisplayFormat before show the data.

Also try change: TFloatField(FieldByName('vl')).DisplayFormat:= '###,##0.00';
Still don't work..

Another edit: DisplayFormat 'yyyy-mm-dd' for Date fields works fine

It was working fine on version 9.30.2..

Its broken for anyone else?

thx!!

[Vingadero]

Attached an image that shows whats going on...

See that "dt" DisplayFormat: yyyy-mm-dd works perfect
but "vl" DisplayFormat: #,##0.00 don't...

Any help?!

thx alot

[jesusr]

here it works fine here using tdbf and TFloatField and TSmallInt, using Lazarus 0.9.31 r34164M FPC 2.7.1 i386-win32-win32/win64, what version of lazarus/fpc do you use? what kind of fields and database?

If you want to check in your current version, open the project at components/lazreport/samples/editor/ right click dbgrid and select columns, add a couple of columns and select PRICE and QTY fields, then set the display format one variant or your samples on each field and run it.

[Vingadero]

Hello, thx for reply

I'm using "Lazarus-0.9.31-34165-fpc-2.5.1-20111214-win32" from Daily Snapshots link.

And I'm using Sqlite

Where can I get your Lazarus version?

ty

[jesusr]

you seems to be using a newer version than I, so you don't need a new version, have you tried the dbf test program I mention in my comment? does it work for you?.

sqlite seems to use some weird field handling, maybe Luiz can shed some light on this, Luiz ... ?

[Vingadero]

Hello

Made a bugreport http://bugs.freepascal.org/view.php?id=20903