math formulas in cells

Discontinued products Uncategorized discussions
#1

Hello,



I have a question regarding use of math formulas in cells. I looked at the example offered in the documentation



setColTypes(“ed,ed,ed,ed,ed[=c2*c3]”);



I was wondering if it’s possible to change math formulas to cover cells in different rows (for example c2 in the previous row), similar to MS excel.



Thanks

#2

You can set math formulas directly in the cell tag:

For example:


    2
    3
    …


    …
    =[[2,0]]*[[2,1]]


In this case the value of the cell in the 3rd row will be 6.


#3

Thanks for the reply. I know about formulas in XML where I can use [row,col] but I was wondering if the same thing is possible with setColTypes where I could use something like ed[=cj*c3] where cj is a cell in a previous row.

#4

There is no way to include “previous” row in formula, you can define the absolute positioned cell ( =[[1,0]]*c3 ). But there is no way to use relative links in math formulas.