Smartmarker and array formula

Aspose.Cells Product Family
1

Hello

How do I setup cells for array formula when I use smartmarker?

Thanks

2

Hi,

I think you may try to use dynamic formulas to place your array formula in smart markers but it might not be accurate for your need.

e.g
&=&=FREQUENCY(A{r}:B{r},C{r}:D{r})

Thank you.

3

Hello,

Here is the formula I am trying to implement with smartmarker

{=SUM(IF(AG26:BN26<>"NA",IF($AG$18:$BN$18<$D$13,1,0)),0)}

the equivalent with SmartMArker is:

&=&=SUM(IF(AG{r}:BN{r}<>"NA",IF($AG$18:$BN$18<$D$13,1,0)),0) but to make it an array formula

Thanks

4

Hi,

Well, I think it is bit difficult to incorporate array formulas in smart markers’ dynamic formulas, the dynamic formula is processed for every line based on the other values in the cells in the same row.

I think you may try to add your array formulas using Cell.SetArrayFormula() method after your markers are processed (after the line WorkbookDesigner.Process() method) and the data is filled to the cells.

Thank you.