I open the file and save. All formulas are lost

[veb86]

Hello. I'm back.
I tried to work with OLE but it is very slow.
I have a large number of calculations that I want to do in Excel. I am ready to add the formulas I need that are not in the library, but under your control.
Now I decided to try this library again, how many formulas will be lost. As a result, I lose absolutely everything. I think I'm making some mistake. Please help me. Revision:9261

my code:

Code: Pascal  [Select][+][-]

1. MyWorkbook := TsWorkbook.Create;  
2. MyWorkbook.ReadFromFile('d:\4.xlsx', sfOOXML);
3. MyWorkbook.Options := MyWorkbook.Options + [boAutoCalc];
4. MyWorkbook.WriteToFile('d:\444.xlsx', sfOOXML,true);  
5.  

[wp]

By default, fpspreadsheet does not read formulas. You must activate this by adding [boReadFormulas] to the Workbook.Options. And do the BEFORE reading.

https://wiki.lazarus.freepascal.org/FPSpreadsheet#Formulas

[veb86]

Thank you. It worked. Now we will need to add new formulas.
For now it is very necessary:
INDEX
MATCH
ROUNDUP

I think it's worth starting with ROUNDUP)))

Please tell me where to read about adding new formulas.

[wp]

Read the wiki article a bit further down: https://wiki.lazarus.freepascal.org/FPSpreadsheet#Extending_FPSpreadsheet_by_user-defined_formulas