I’m trying to use a dynamic formula for a column in my Excel workbook for populating data but I am getting an error when rendering the workbook. The formula I am using is “&=&=(B{r}/100+1)(C{r-1})". And when I call the Process command on the WorkbookDesigner object I get the error ""Invalid dynamic formula:=(B{r}/100+1)(C{r-1})”. I tried to follow the example given in your documentation for setting up a dynamic formula. Do you see something wrong with this syntax? Can I use parentheses? I have attached the worksheet that I am using as an example.
Never mind. I figured it out. I thought the syntax would be {r-1} to indicate the previous row, but I guess it’s just {-1}.
Hi,
Thanks for your posting and using the Aspose.Cells for .NET.
It’s good to know that you were able to sort out this issue. If you find any other problem, please feel free to post it, we will help you asap.