Preserve Formulas in Smart Marker Row

Aspose.Cells Product Family
1

I am trying to generate some rows using Smart Markers, but I want to preserve the formulas that are in the existing cells. I find the &=&= syntax to be difficult to write and I want to be able to give the template to business owners to make changes. Is there a reason we can’t do something like this? As long as the formula is relative, then when using the smart marker collection to copy the row and styling it should also be possible to copy the relative formula.

preserve formula example.JPG (16.2 KB)

2

@derek.jarvis,

Thanks for the screenshot.

Well, Smart Markers has it’s own marker style and architecture, so you cannot embed normal MS Excel into the same row (where smart markers reside), it is by design. You may easily cope with it by using repeat dynamic formulas options. For example. you may change the normal formulas as following:

  1. =A2+B2 —> &=&=A{r}+B{r}
  2. =D2+E2 ----> &=&=D{r}+E{r}

Alternatively, you may insert your desired formulas into the specific cells after your have processed smart markers and data is inserted into the cells.