AdvSpreadGrid - ftExcel formatting - thousands separator & others

Could you please tell how could I format a cell value using FormatType ftExcel when the cell contains a formula?

I need to apply '#,##0' and/or '#,###' as formats, but it always fail when the cell has a formula. "IsFloat" argument (OnGetFloatformat) come as False sometimes when there's a formula, but formatting results doesn't change when it comes True.

BTW, AdvSprd.pas GetCellText function does not check the grid FormatType property. It always format as if it was ftVCL. This format does not support thousands separator.

It works fine when I use OnGetFloatFormat, set a '#,##0' format, and there's no formula/calculation.

We traced & solved this issue. The next update will address this.