Please refer to the attached spreadsheet. I have one excel file(Testing_Split_ReferOtherWorksheets.xlsx), with two sheets(Pool Summary, Center Summary), Center Summary sheet refers to the values in Pool Summary sheet. I need to create two files one sheet each. The values are lost in second file which contains Center Summary.
I am using Aspose cells version 220.127.116.11 I think the copy does copies the whole sheet as it is. How the values can be copied in place of formulas.
are there any methods added to the product to do it simpler than mentioned in the thread above. I am using below code to get the result
var inputDocument = new Workbook(inputFileName);
var outputDocument = new Workbook();
var sourceWorksheet = inputDocument.Worksheets[name];
var destinationWorksheet = outputDocument.Worksheets.Add(name);
Please respond ASAP, because the fix needs to go immediately to PROD environment. I appreciate it.