I am trying to use SetCellFormula on several sheets with a reference to a single sheet with a template(not creating any of these sheets with NPOI).
For each sheet trying to reference MySheet I use:
The generated Excel file will have a REF# in place of the sheet.
If I set the cell to a string value, open up the Excel and run the formula it works fine.
=VLOOKUP("StringValue",MySheet!$A$2:$B$700,2,FALSE) //Added to cell by formula not value
If I use INDIRECT ( INDIRECT('C1')) in the SetCellFormula with that reference to MySheet!$A$2:$B$700 the formula works fine when the file is generated.
So can another sheet be used directly in references with SetCellFormula or can SetCellFormula only directly reference cells on the current sheet?