Possible error in AdvGridExcelIO

Good morning,

I encounter an unexpected message with assigning an event to a procedure with the AdvGridExcelIO component.

in code:
....
AdvGridExcelIO1.AdvStringGrid := aGrid;
AdvGridExcelIO1.OnCellFormat := AdvGridExcelIO1CellFormat; <---------- error line
AdvGridExcelIO1.XLSExport(....);
...

procedure TfmMain.AdvGridExcelIO1CellFormat(Sender: TAdvStringGrid;
const GridCol, GridRow, XlsCol, XlsRow: Integer; const Value: WideString;
var Format: TFlxFormat);
begin
...
end;

This gives an error in the compiler:
E2010 Incompatible types: tmsUFlxFormats.TFlxFormat and _UFlxFormats.TFlxFormat.TFlxFormat.

Using the Object Inspector to assign this methode "AdvGridExcelIO1CellFormat" to the OnCellFormat event gives no problems at compiling.

I don't know if it's just me or a fixable bug.

With kind regards,
Frans

Delphi 10.4.2 Sydney Version 27.0.40680.4203
TMS VCL UI Pack 10.7.3.0: February 8 2022

I'm not sure where your _UFlxFormats comes from. This is not our unit.
Add the unit tmsUFlxFormats to the uses list and make sure TFlxFormat is from this namespace.
I retested this here and it works as expected.

It seems it has something to do with VCL.FlexCel.Core.

TFlxBorderStyle = _UFlxFormats.TFlxBorderStyle.TFlxBorderStyle;
and more.

I search further....
Thanks for the answer so far,
Frans

Try to change the unit ordering in the uses list and/or prefix this type with its correct namespace tmsUFlxFormats