Recent

Author Topic: Still problems in XLS-files with sums formulas.  (Read 4127 times)

Soner

  • Sr. Member
  • ****
  • Posts: 305
Still problems in XLS-files with sums formulas.
« on: August 16, 2018, 12:57:27 pm »
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][+][-]
  1. aSh.WriteFormula(r,c,'=SUM(N'+roZeit+1).ToString+':N'+arsum.ToString+')');    
  2. 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

  • Hero Member
  • *****
  • Posts: 11830
Re: Still problems in XLS-files with sums formulas.
« Reply #1 on: August 16, 2018, 03:21:18 pm »
Try ccr-r6604. Looks as if the BIFF reader did not read the token for relative cell ranges correctly.

Soner

  • Sr. Member
  • ****
  • Posts: 305
Re: Still problems in XLS-files with sums formulas.
« Reply #2 on: August 16, 2018, 07:33:06 pm »
Thanks.

 

TinyPortal © 2005-2018