Connecting Shapes in Excel using connectors in c#.net

Aspose.Cells Product Family
1

Is it possible to connect shapes in Excel using c#.net Aspose cells ?

like below.
https://docs.aspose.com/display/slidesjava/Connecting+shapes+using+Connectors+in+Ruby

2

@kozmo12345,

Could you please share template file created with MS Excel. We will then provide our feedback after analysis.

3

Thank you for answer.

It’s my sample code

    public void TestMethod()
    {
        //Instantiate a new Workbook.
        Workbook workbook = new Workbook();

        //Get the first worksheet in the book.
        Worksheet worksheet = workbook.Worksheets[0];

        //Get Cell Height
        var cellHeight = worksheet.Cells.GetRowHeightPixel(1);
        //Get Cell Width
        var cellWidth = worksheet.Cells.GetColumnWidthPixel(1);

        //Create boxes
        TextBox box1 = worksheet.Shapes.AddTextBox(1, 0, 1, 0, 2*cellHeight, cellWidth);
        TextBox box2 = worksheet.Shapes.AddTextBox(1, 0, 3, 0, 2*cellHeight, cellWidth);

        //Create connector
        Shape connector = worksheet.Shapes.AddAutoShape(AutoShapeType.ElbowConnector, 2, 0, 2, 0, 0, cellWidth);

        workbook.Save("d:/test.xlsx", SaveFormat.Xlsx);
    }

It is result.
result.PNG (1.8 KB)

I expected that TextBoxes are connected each other with connector line. But It’s not

like below.

moving.png (3.9 KB)

help me~

5

@kozmo12345,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigations. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46586 - Move connector with shapes