Array formula + SortNames

Aspose.Cells Product Family
1

Hi,

My Excel workbook contains named ranges and some array formulas (like "{=Test1*Test2}"). The array formulas are made with the named ranges. I open the workbook with AsPose.Cells, add some named ranges, then I use the function SortNames and save the workbook. After this operation the array formulas are wrong and reference bad named ranges.

I use Aspose.Cells.dll V4.4.0.5, here is a sample code I have made to reproduce the issue and a demo workbook is attached:

_workbook = new Workbook();

_workbook.Open(_filepath);

Worksheet worksheet = _workbook.Worksheets[_worksheet_codename];

Cell cell1 = worksheet.Cells[1,1];

Range range1 = worksheet.Cells.CreateRange(cell1.Row, cell1.Column, 1, 1);

range1.Name = "ASCell1";

Cell cell2 = worksheet.Cells[2, 2];

Range range2 = worksheet.Cells.CreateRange(cell2.Row, cell2.Column, 1, 1);

range2.Name = "ASCell2";

_workbook.Worksheets.SortNames();

_workbook.Save(_filepath);

If I don't use SortNames the array formulas are good. But in my application, I really need to use SortNames because I create a large amout of named range.

Please, can you fix this issue, it is critical for us.

Thank you,

Gregory

2

Hi Gregory,

Thanks for the template file.

Yes, we found the problem, we will fix it soon.

Thank you.

3

Please try this attached fix for this issue.

4

The fix works very well.

Thank you

Gregory