Still problems in XLS-files with sums formulas.
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Soner · 2018-08-16 10:57

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)
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i aSh.WriteFo
rmula(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.

----------------------------------------------------------------------
wp · 2018-08-16 13:21

Try ccr-r6604. Looks as if the BIFF reader did not read the token for
relative cell ranges correctly.

----------------------------------------------------------------------
Soner · 2018-08-16 17:33

Thanks.