Inserting CheckBox in chart-sheet using Aspose Cells

Aspose.Cells Product Family
1

There is a post about adding a checkbox to a chart-sheet from 2011 with a response that the functionality will be available “soon”. Is it available? Because I’ve tried multiple ways of doing this and the checkbox does not show up on the chart page.

Thanks!

2

@christina.chomel,
We are gathering details about the feature CELLSNET-40174 and will get back to you soon.

3

@christina.chomel,
If the cell contains a formula, you can find it from formula, else find object from the value. Refer to following code snippet and let us know your feedback.

        Workbook workbook = new Workbook();
        int index = workbook.Worksheets.Add(SheetType.Chart);
        Worksheet sheet = workbook.Worksheets[index];
        sheet.Charts.AddFloatingChart(ChartType.Column, 0, 0, 1024, 960);
        sheet.Charts[0].NSeries.Add("{1,2,3}", false);
        sheet.Charts[0].Shapes.AddShapeInChart(MsoDrawingType.CheckBox, PlacementType.Move, 400, 400, 1000, 600);
        sheet.Charts[0].Shapes[0].Text = "CheckBox 1";
        int width = sheet.Charts[0].Shapes[0].Width;
        workbook.Save(dir + "dest.xlsx");