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
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
Could you please share template file created with MS Excel. We will then provide our feedback after analysis.
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~
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