Free Support Forum -

Prevent SetSharedFormula from applying formula to all rows


I have the following:

cells[“A14”].SetSharedFormula("=IF(AND(AllSales3=“Location”, (AllSales1<>"")), VLOOKUP(AllSales1,AllSales2,1,FALSE),0)", 17, 1);

AllSalesN are Named ranges

I noticed that this formula is being applied from cell A1 rather from cell A14. How can I get the formula to be only applied from cell A14 downwards?


Thanks for your posting and using Aspose.Cells.

Aspose.Cells deals with shared formulas quite well. However, kindly provide us your expected excel file which you can create manually using Microsoft Excel. We will then look into your expected file and let you know how to apply your formula using Aspose.Cells APIs. Thanks for your cooperation in this regard and have a good day.