Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Jun 02, 2015 11:20 am

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

tkeegan
 
Posts: 1
Joined: Tue Jun 02, 2015 10:35 am

Wed Jun 03, 2015 9:43 am

Hello,

Thanks for your inquiry.
So sorry that our product doesn't support this feature at this stage.

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS