Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Propagate Formula in Table or List Object automatically while entering data in new rows
Contents
[
Hide
]
Possible Usage Scenarios
Sometimes, you want a formula in your Table or List Object to automatically propagate to new rows while entering new data. This is the default behavior of Microsoft Excel. In order to achieve the same thing with Aspose.Cells, please use ListColumn.Formula property.
Propagate Formula in Table or List Object automatically while entering data in new rows
The following sample code creates a Table or List Object in such a way that the formula in column B will automatically propagate to new rows when you enter new data. Please check the output Excel file (5115469.xlsx) generated with this code. If you enter any number in cell A3, you will see that the formula in cell B2 automatically propagates to cell B3.