We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Name.RefersTo and Name.R1C1RefersTo breaking changes


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];


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!


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.

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