Hi,
I am creation a spreadsheet from scrats, and i have made a table, and everything is fine. Now i try to add a totalsRow (calculationChain) but i keep getting error when i try to open excel file.
I have tried to google, to find a good sample how to this part, and i have tried to look at Productivity tool to see how, but with no luck
I hope some of you hava a url for a torturial or a sample i could look at.
Regards
Michael Frostholm
Nobodo can tell me what to do , to add a total row, wich some fomula in it
You mention the Productivity tool, so it sounds like you have done the process of taking your working spreadsheet, making a copy, then adding the totalsRow using Excel and then comparing the two. Is that correct?
Yes i have tried to do that, and i cant see that i am missing anything. I have done table definition containing rowfunctions, added calculationChain, but no luck :-(
Hi Michael,
Suppose if you are using the formula,
' =Sum(A1:A10)'
then you can see the total value calculated in CellValue -> Text property. If you are trying to achieve this through code, I am not sure there is any built-in method which does this. However, you can do this by adding the values from cell A1 (start cell) to cell A10 (end cell). You can try writing a small method which can actually do this.
I really need to use TotalTow function, so the users of my spreadsheet easely can choose new formulas. So i think i am looking for sample where one have done this.