Excel formulas in the BIFF export


Starting from FR VCL 4.11.15 the BIFF export can export formulas. For example, to export the formula SUM(A1:B2) put a TfrxMemoView on a report and write in it

=SUM(A1:B2)

The first character of the text must be the equality sign “=”, and the rest of it – a correct Excel formula. Exporting of formuals is controlled by the BIFF export’s property ExportFormulas and to disable this option, simply write

procedure DisableFormulas(Exp: TfrxBIFFExport);
begin
Exp.ExportFormulas := False
end;


(more…)

Posted in All reports. No Comments »

Using MS Word as report generator

Why not use the MS Word as report generator in your projects? We can easyly build the report and allow user to modify it using well known editor in any way he wants
(more…)

Posted in All reports. No Comments »