We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formula with smart marker not working?

I am trying to do something like this - &=&=(Summary.qty_d)*2

but the formula is not calculating at all?

Hi,

Well, dynamic formulas does not work in this way, it work in the following way.

e.g (Excel template file can be like)
A B

&=Summary.qty_d &=&=(A{r}*2)


Another example:

e.g
A B

&=Datos.Estado &=&=UPPER(A{r}) --> You may use any Excel Formula in place of "UPPER"

See the topic for reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html

Thank you.