Online Documentation for Advanced Excel Report for RAD Studio
property FieldSign: Char;
The FieldSign property defines the character which denotes the field name in the template Excel file. This can be either DataSet field name or an arbitrary field name which value you define in the OnGetFieldValue event handler or which contain constant value defined by the Dictionary property.
The default property value is '#'. Note that if you want to use a field sign as a simple symbol, you can set two signs one after another, and they will be treated as one symbol not field sign (just as apostrophes in Delphi). The field sign is also ignored if it precedes the equality symbol ('='). This may be necessary if an error occurs on entering an Excel formula to the template cell.