Dear support team,
I’m using aspose.cells for .net 18.5.0.
I have worksheet A. In cell A1, I have smart marker “&=entity.property(horizontal)”. In cell B1, I have a fixed value.
While in worksheet B, cell A1, I have formula “=worksheet_A!B1” or “=worksheet_A!$B$1”.
And I used Process() method of work book designer to process data.
Now In my worksheet A, original B1 moved to D1, because I have 3 items in “entity” list. But the formula in worksheet B, cell A1 doesn’t get update, it remains what it was. I need it to be “=worksheet_A!D1”.
I searched all over the forum, no solution found so far. Using “UpdateReference = true” at work book designer level doesn’t solve my problem, and I really need this feature.