Remove formula references to source sheet when merging/copying sheet from another workbook

Aspose.Cells Product Family
1

Thread Link:

Hi Shakeel, Couldn’t Reply on thread due to migration issue so mailing you. I did tried implementing your suggested solution of Copy options . It is not working for me as it is not drawing the charts present in Sheet 1 of Workbook. Attached is the copied workbook which gives error.Regards

This Topic is created by shakeel.faiz using the Email to Topic plugin.

2

Hi,

Thanks for using Aspose.Cells.

We have looked into your issue and it seems to be a bug of Aspose.Cells but we could not verify it completely.

Please provide us your full sample code as well as your Excel files used inside the code, so that we could replicate the issue at our end with the most recent version and log it in our database for an investigation and for a fix.

Thanks for your cooperation in this regard and have a good day.

3

Hi,

Thanks for considering Aspose.Cells.

We have looked into your issue further and we think, you should not copy worksheets but combine workbook and then hide the worksheets that you don’t want to show.

Here is the sample code that explains how to combine workbook and hide the unnecessary worksheets.

C#
//Load your sample workbook
Workbook sample = new Workbook(path + “1_2_VB.xlsx”);

//Calculate the formula - it is recommended
sample.CalculateFormula();

//Source worksheet to be copied
Worksheet sheet = sample.Worksheets[“Valuation Benchmarking Data”];

//Create a new workbook
Workbook wb = new Workbook(path + “1_1_SPP.xlsx”);
wb.Combine(sample);
wb.Worksheets[“Peers”].IsVisible = false;
wb.Worksheets[“Input”].IsVisible = false;
wb.Worksheets[“Inputs”].IsVisible = false;