export wwdbgrid floats field error in excel

Follow

alexandre garcia

• May 18, 2023 13:06

Hi, 

I use delphi XE e infopower 2011

When I export the wwdbgrid to excel, the fields that are float goes to excel with error, this way:

1,30056869930622E-13

it doesn't obey the display format ###,###,##0.00000

is it a bug? What should I do?

 

thanks

 

 

 

0

• 

  Roy Woll

  • May 30, 2023 17:06

  The export to sylk should preserve the field type, but I don't think displayformat is used with that format. I think xml would use displayformat but then the export is done as a string for each field.

  1

  Comment actions Permalink
• 

  alexandre garcia

  • July 04, 2023 16:31

  thanks for you reply

  0

  Comment actions Permalink

Please sign in to leave a comment.