Hi,
I have just found the Spire.XLS and starting to play with the free version.
I know that if I am using Microsoft Excel, i can move a sheet from one place to another and that the formula references will be updated to include a file reference if needed.
e.g. I have Sheet1 and Sheet2
Sheet1 has a formula like =Sheet1!A1
So if i move sheet one out of the current workbook, then I am expecting that the formula will be updated to:
='C:\.....\[MyWorkbook]Sheet2'!A1
Is there any way to do this with Spire.XLS?
Regards
Trevor Keegan