Formula through sheets


#1

Hi,

I wish to create a formula on a sheet, using subtotal function on cells of another sheet.
Is it possible ?

I get an error while trying this :

Formula = SUBTOTAL(9;‘feuille’!A1:A4)

Thanks for help,
Laurent.


#2

Hi Laurent,

In Aspose.Excel, the formula string is same as MS Excel. So please try:

Cell.Formula = “=SUBTOTAL(9, feuille!A1:A4)”