Where to find line shape arrow options in object model

Aspose.Cells Product Family
1

Hi,

I’m converting word to excel with aspose and now I have the problem, that all connector shapes loose their arrow options.

I’m not able to find attributes about arrow … in object model.

Where can I find these options and how to convert to word?

I attached dialog from excel.

2

Hi,


Well, I am not sure about your issue, could you elaborate it more. Do you use Aspose.Words APIs, if this is the case, please post your issue to Aspose.Words forum.

If you are using Aspose.Cells APIs, kindly create a sample (demo) console application, zip it and post it here, we will check it soon.

Thank you.

3

Hi, I created new post in aspose.words …

4

I find options in Aspose.Words:
(shape.Stroke.EndArrowType …)

But where ist the information in Aspose.cells about line arrows??
.LineFormat, I can`t find …

Do you need more informations to answer?

5

Hi,


Well, the Shape.LineFormat is there in the APIs Set.
Please see the document, especially the sub topic in the document:“Adding an ArrowHead to the Line”
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/working-with-controls.html

Thank you.

6

Hi,

but if I read out all shapes by worksheet.Shapes I only get a list of shapes. The connectors are shapes too - type CellsDrawing.
Only LineShapes have the informations about Arrow … (Cellsdrawings don’t have)

Is there a method to get the right class of shapes.

So it is not possible for me to get the neccassary informations.

Do you need an excel example?


7

Hi,


Well, we have LineShape class only, and you may use its Arrow attributes (e.g “BeginArrowheadWidth/Style/Length” and “EndArrowheadWidth/Style/Length” etc.).

I think you may use Shape.GetType() method to know about the shape type. See the code segment below, e.g:

foreach (Aspose.Cells.Drawing.Shape shape in wrkb.Worksheets[0].Shapes)
{

if (shape.GetType().ToString() == “Aspose.Cells.Drawing.LineShape”)
{
LineShape line = (Aspose.Cells.Drawing.LineShape)shape;
//Your code goes here.
}
else if (…)
{
//…
}
}