Still problems in XLS-files with sum formulas.
I created the workbook in zip-file with lazarus program and saved it as xls-file.
Then I opened it in Excel Xp and wrote in the cell "I10" 10 and saved it.
Now when I open this file with my program or spready then in the cells H41-N41 are no sum-formulas.
But in the cell I49 is sum-formula visible.
I create al the sum-formulas with the same code:
(with different column and row numbers)
aSh.WriteFormula(r,c,'=SUM(N'+roZeit+1).ToString+':N'+arsum.ToString+')');
aSh.WriteNumberFormat(r,c,nfFixed,2);
Zip contains second file with the name "Stundenplan-2018-8-test-cut.xls".
I created this file form the first to make it easy debugable(deleted some cells and rows in Excel xp). But Spready shows sum-formulas from this file.