Named Ranges issue ?2

Aspose.Cells Product Family
1

Hello, Aspose Team!

Thanks for previous fix. It worked for case, that I reported. But another issue arised (hopefully the last one related to named Ranges)
In the attached sample app we copy xls worksheet onto xlsm. And some of the named ranges dissappear (particulary C11 “ForecastName” It present in the source and in the destination, but missing from output file).
I don’t know, what so special in this named range. Other named ranges can be copied without errors.

Thank You in advance,
Denis

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

I was able to notice the issue after running your project with the latest version:
Aspose.Cells
for .NET v7.2.0.4

We have logged this issue in our database. We will look into it and resolve the issue.

Once, the issue is resolved or we have some update relating to it, we will let you know asap.

This issue has been logged as CELLSNET-40630.

Please see the test code below, I have attached the source files and output file and screenshot for a reference.


C#


string sourceFile1 = @“F:\SourceSheet.xls”;

string sourceFile2 = @“F:\TemplateSheet.xlsm”;


var sheets = new[]

{

“Setup For Storage”

};


var loadOptions = new LoadOptions(LoadFormat.Auto)

{

LoadDataOnly = false,

ParsingFormulaOnOpen = true,

ConvertNumericData = false,

};




var source = new Workbook(sourceFile1, loadOptions);



var loadOptions2 = new LoadOptions(LoadFormat.Auto)

{

LoadDataOnly = false,

ParsingFormulaOnOpen = true,

ConvertNumericData = false,

};


var dest = new Workbook(sourceFile2, loadOptions2);


foreach (var sheetName in sheets)

{

var destWorksheet = dest.Worksheets[sheetName];

var sourceWorksheet = source.Worksheets[sheetName];

destWorksheet.Copy(sourceWorksheet);

}


var saveOptions = new OoxmlSaveOptions(SaveFormat.Xlsm);


// Named ranges for cells A2 and A5 on sheet Levels are gone

dest.Save(sourceFile1 + “.out.xlsm”, saveOptions);


Screenshot:

3

Hi,

We have fixed this issue.

Please download and try the fix: Aspose.Cells for .NET v7.0.2.5
.

4

Hi!
Thanks! This issue is really resolved and not reproducible anymore.

Thank You,
Denis

5

Hi,

Thanks for your feedback.

It is good to know that your issue is now resolved. We have closed the ticket associated with this issue.

If you get any other question or face any problem, please feel free to let us know, we will help you asap.

6

The issues you have found earlier (filed as CELLSNET-40630) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.