RadioButton.LinkedCell incorrect

Aspose.Cells Product Family
1

Questionnaire.zip (10.9 KB)

Hi,

I’ve attached an example Excel workbook where I have 4 radio buttons, the first two is linked to cell $F$2 and the last two is linked to cell $F$3. When I use the following code to read the radio buttons, LinkedCell property says all four are linked to cell $F$3. Can you please have a look?

        var book = new Workbook("Questionnaire.xlsx");
        var sheet = book.Worksheets["Questions"];
        var shapes = sheet.Shapes;
        for (int i = 0; i < shapes.Count; i++)
        {
            var item = shapes[i];
            var cell = item.LinkedCell;
        }
2

@llawryy

Thanks for using Aspose APIs.

We were able to observe this issue as per your description and sample code. We have logged this issue in our database for investigation and for a fix. Once, this issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45899 - Shape.LinkedCell property is giving incorrect Linked Cell for first two Radio Buttons

C#

Workbook wb = new Workbook("Questionnaire.xlsx");

Worksheet ws = wb.Worksheets["Questions"];

for(int i=0; i<ws.Shapes.Count; i++)
{
    Shape sh = ws.Shapes[i];

    Debug.WriteLine(i + " --- " + sh.LinkedCell);
}

Console Output

0 --- $F$3
1 --- $F$3
2 --- $F$3
3 --- $F$3
4 --- 
5 ---
3

@llawryy,

This is to inform you that we have fixed your issue CELLSNET-45899 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

@llawryy

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

5

Thanks! Just tested it. The problem is fixed.

6

@llawryy

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.