Peace,
we want to do something like this:
&==IF(F22>0,&=Client.iban,“otherIban”)
This is not possible, because Client.iban will not be evaluated or replaced. Is there a way to have a formular and a smart marker within this formular ?
Yes, this is not directly possible to embed another marker inside smart marker dynamic formula. Aspose.Cells’ Smart Markers feature has its own rules and specifications, so you cannot use it in your own custom way. You may workaround it to accomplish your task. For example, you may embed this marker “&=Client.iban” into some other column (but it should be pasted into a column before the dynamic formula column (cell)). You may even hide this column (if you want). See the structure of Excel sheet with markers for your reference.
A----------------B--------------C-------------D------------E--------------F-------------G …
_________ &=Client.iban ____ ____ ______ __________________ &=&=IF(F{r}>0, B{r}, “otherIban”)
For complete reference on Smart Markers, please see the document with examples for your reference.
Another way to cope with it is, you process the markers first and then add Excel formula manually into the relevant cells (once the markers are processed and data is filled into the cells) via Cell.Formula attribute.
Hope, this helps a bit.