TAdvStringGrid - FloatFormat - ftExcel


I am not able to get a "ftExcel" FloatFormat working. When the format is set to ftVCL, it works, but setting it to ftExcel, makes everything I put into "FloatFormat" property just display in the cell (overwrite the cell content).
There is an example in the manual - $0.00 . It doesn't work either.

How to use it properly?

Thank you.

Are you using the latest version of TAdvStringGrid and do you implement the OnGetFloatFormat event to return the Excel-type format string via the FloatFormat parameter?

I am using the latest version, but I set the FloatFormat property in the design time in object properties. Using the OnGetFloatFormat works. Thank you