Inserting CheckBox in chart-sheet using Aspose

Aspose.Cells Product Family
1

Hi,


I need to insert check-box into chart sheet using Aspose. Check-box should allow me to hide or unhide particular series in chart.

Please fine the snap-shot of expected and obtain output.

Thank You
2
Hi,

I am afraid, you cannot add check boxes to chart type sheets or inside charts. We will support this feature soon. Currently we can add 4 controls to chart, e.g
Label, Textbox, Picture, TextEffect controls. See the topic for reference:
Insert controls in charts


A ticket is logged for the feature with an id: CELLSNET-40174.

Thank you.
3

Hi,

Please create an template file(not a snapshot) here, we will check it soon.

4

What is the excepted time for implementing the feature.


thanks

5

Hi,

We only find that checkbox with macro can support it.
We do not support macro now, so could not support inserting such
checkbox.

If you can create such a checkbox without Macro, please share
your template file here. We will check it soon.

6

@aniket10101,

Sorry for the delay.

We are pleased to inform you that we have fixed your issue now. We will provide the fix, i.e., Aspose.Cells for .NET v19.12.1 in the next few days.
Here is the sample code that you will use with the new fix:
e.g
Sample code:

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(Constants.destPath + " CELLSNET-40174.xlsx");
7

The issues you have found earlier (filed as CELLSNET-40174) have been fixed in Aspose.Cells for .NET v20.1. This message was posted using Bugs notification tool by Amjad_Sahi