TMS (TAdvGridExcelIO) not work autocalculate sum()

VCL TMS VCL UI Pack
1
After export data from TAdvGridExcelIO to TAdvGridWorkBookceased to calculate AutoSum in cells. 

But after save to file TAdvGridExcelIO i see autosum - all is well. TAdvGridWorkBook - do not want to show my formula. Instead of the value I see "0" . Maybe need to send the message for component, for recalculate?
2
  1. TAdvStringGrid or TAdvGridWorkbook will not calculate formulas in XLS files
    2) When you set AdvGridExcelIO.Options.ImportFormulas =true, it will import the formula, otherwise it will import the formula result value.

    Please make sure you use the desired setting for AdvGridExcelIO.Options.ImportFormulas
3
I checked properties  ImportFormulas it does not affect. I see my calculate cell but only my test project. But When moving to a big project calculate not work(( in cell i see "0"

For Example:

Formula = SUM(D9:D11;D15:D25)

procedure TForm1.btn1Click(Sender: TObject);
var
  FExcelIO: TAdvGridExcelIO;
begin
  FExcelIO := TAdvGridExcelIO.Create(nil);
//  FExcelIO.Options.ImportCellProperties := True;
  FExcelIO.Options.ExportHiddenColumns  := True;
  FExcelIO.Options.ExportRawRTF         := True;
  FExcelIO.Options.ImportFormulas       := false; // true

  FExcelIO.AdvGridWorkbook := advgrdwrkbk1;
  FExcelIO.XLSImport('d:\xxx.xls');
end;
English Â»
 < id="SL_lng_to">< value="af">Afrikaans< value="sq">Albanian< value="ar">Arabic< value="hy">Armenian< value="az">Azerbaijani< value="eu">Basque< value="bn">Bengali< value="be">Belarusian< value="bg">Bulgarian< value="ca">Catalan< value="zh-CN">Chinese (Simp)< value="zh-TW">Chinese (Trad)< value="hr">Croatian< value="cs">Czech< value="da">Danish< value="nl">Dutch< value="en">English< value="eo">Esperanto< value="et">Estonian< value="tl">Filipino< value="fi">Finnish< value="fr">French< value="gl">Galician< value="ka">Georgian< value="de">German< value="el">Greek< value="gu">Gujarati< value="ht">Haitian Creole< value="iw">Hebrew< value="hi">Hindi< value="hu">Hungarian< value="is">Icelandic< value="id">Indonesian< value="ga">Irish< value="it">Italian< value="ja">Japanese< value="kn">Kannada< value="ko">Korean< value="lo">Lao< value="la">Latin< value="lv">Latvian< value="lt">Lithuanian< value="mk">Macedonian< value="ms">Malay< value="mt">Maltese< value="no">Norwegian< value="fa">Persian< value="pl">Polish< value="pt">Portuguese< value="ro">Romanian< value="ru">Russian< value="sr">Serbian< value="sk">Slovak< value="sl">Slovenian< ed="" value="es">Spanish< value="sw">Swahili< value="sv">Swedish< value="ta">Tamil< value="te">Telugu< value="th">Thai< value="tr">Turkish< value="uk">Ukrainian< value="ur">Urdu< value="vi">Vietnamese< value="cy">Welsh< value="yi">Yiddish  
4
and further: Аfter save data in file autacalculate work in my big project

procedure TAdvSpreadBook.SaveToFile(const aFileName: string);
var
  i: Integer;
begin
  for I := 0 to FExcelIO.SheetNamesCount -1 do
  begin
   FExcelIO.AdvStringGrid := GetGrids(I);
   FExcelIO.XLSExport(aFileName, FExcelIO.SheetNames);
  end;
end;
5

i understand i see formula becouse i save from FExcelIO

Ok how methotd i most rewrite for work autosum in my projects?
6

I'm not sure I understand your question.
You want to calculate the sum in your Delphi grid or you want to export a sum function to your XLS sheet.

7

i have xls file with formula SUM(D9:D11;D15:D25)


Formula = SUM(D9:D11;D15:D25)

procedure TForm1.btn1Click(Sender: TObject);
var
  FExcelIO: TAdvGridExcelIO;
begin
  FExcelIO := TAdvGridExcelIO.Create(nil);
//  FExcelIO.Options.ImportCellProperties := True;
  FExcelIO.Options.ExportHiddenColumns  := True;
  FExcelIO.Options.ExportRawRTF         := True;
  FExcelIO.Options.ImportFormulas       := false; // true

  FExcelIO.AdvGridWorkbook := advgrdwrkbk1;
  FExcelIO.XLSImport('d:\xxx.xls');
end;

this code work, but wnen i dragged to my project autosum not calculate in grid

8

understood i call recalc for all grid. All is work