FNCDatagrid don't display correctly data with DislayFormat assigned (in TwebClientDataset)

Using TwebClientDataset with fields that have DisplayFormat ed EditFormat assigned (especially for currency fields), values displayed in FNCDatagrid ignore DisplayFormat settings.
Thanks

Hi,

TTMSFNCDataGrid uses pure data from the field, so it's possible to perform sorting, calculations and more. If you don't want this, you can use DisplayText by implementing the following event:

procedure TForm1.TMSFNCDataGridDatabaseAdapter1FieldToData(Sender: TObject;
  ACell: TTMSFNCDataGridCellCoord; AMasterField, AField: TField;
  var ACellValue: TTMSFNCDataGridCellValue; var Handled: Boolean);
begin
  ACellValue := AField.DisplayText;
  Handled := True;
end;

However, if you want to keep pure data and control formatting, you can implement this directly at grid level. you can read more about it here:

OK, Pieter,
I will try, Thanks