Name.RefersTo and Name.R1C1RefersTo breaking changes

Aspose.Cells Product Family
1

Hi,

We’re using Aspose.Cells 21.9.0 before and in the process of trying to upgrade to 22.3.0. Unfortunately, it looks like Name.RefersTo and Name.R1C1RefersTo behaviours have been changed. I was wondering if I can confirm whether this is expected.

Here’s the code that was used for testing

using Aspose.Cells;
using System;
using Range = Aspose.Cells.Range;

namespace DummyApp
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets.Add("sheet2");

            Range range = worksheet.Cells.CreateRange("A1");

            range.Name = "identifer";

            Name name = workbook.Worksheets.Names[0];

            Console.WriteLine(name.RefersTo);
            Console.WriteLine(name.R1C1RefersTo);
        }
    }
}

In 21.9.0,
name.RefersTo was “=sheet2!$A$1” and name.R1C1RefersTo was “=sheet2!R1C1”.

However, in 22.3.0,
name.RefersTo was “=sheet2!$A$1:$A$1” and name.R1C1RefersTo was “=sheet2!R1C1:R1C1”.

I was wondering if you guys can confirm if this changed behaviour is correct. If you need any more info regarding this, please let me know.

Thanks a lot!

2

@keeryun.park,

Thank you for the example code. We think the result of old versions should be better than that of 22.3. So we will recover the result as =sheet2!$A$1 for such kind of situations in later fix/versions. We have created one ticket(CELLSNET-50695) for this task and will update here when the fix/new version available.

3

The issues you have found earlier (filed as CELLSNET-50695) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi