Shape is created but it is not visible

Aspose.Cells Product Family
,
1

When i create a shape it is created and i also can select shape from Page Layout → Selection Pane but it is not visible directly
How can i fix this issue can you repair ma sample code which is mentioned below.

ShapePath ALCBufferLinePath = new ShapePath();
ALCBufferLinePath.MoveTo(0F, 0F);
ALCBufferLinePath.MoveTo(0F, 5F);
ALCBufferLinePath.MoveTo(5F, 1.5F);
ALCBufferLinePath.MoveTo(200, 1.5F);
ALCBufferLinePath.MoveTo(212, 5F);
ALCBufferLinePath.MoveTo(212, 0F);
ALCBufferLinePath.MoveTo(0F, 0F);

Shape alcBufferLine = worksheet.Shapes.AddFreeform(0, 0, 0, 0, 0, 0, new ShapePath[] { ALCBufferLinePath });
alcBufferLine.Placement = PlacementType.MoveAndSize; //Set the placement type as the Shapes will move and resize with cells.
alcBufferLine.Width = ALCBufferLinePath.WidthPixel;
alcBufferLine.Height = ALCBufferLinePath.HeightPixel;
alcBufferLine.X = 500;
alcBufferLine.Y = 200;
alcBufferLine.Fill.FillType = FillType.Solid;
alcBufferLine.Fill.Transparency = 0.5F;
alcBufferLine.Fill.SolidFill.Color = Color.Red; // Set the Fill color
alcBufferLine.Line.FillType = FillType.Solid;
alcBufferLine.Line.Transparency = 0.5F;
alcBufferLine.Line.SolidFill.Color = Color.Red;
2

@tejas.patel

Cause

The shape you created may not be visible due to its size, position, or properties such as transparency. Additionally, if the shape is not properly defined or if its dimensions are set to zero, it won’t be rendered on the worksheet.

Solution

To ensure the shape is visible, you should check the following:

  1. Shape Path: Ensure that the shape path is correctly defined and closed.
  2. Positioning: Verify that the X and Y coordinates are within the visible area of the worksheet.
  3. Dimensions: Set the width and height of the shape to non-zero values.
  4. Transparency: Adjust the transparency settings if necessary.

Here’s a revised version of your code that addresses these points:

Code

ShapePath ALCBufferLinePath = new ShapePath();
ALCBufferLinePath.MoveTo(0F, 0F);
ALCBufferLinePath.LineTo(0F, 5F); // Use LineTo instead of MoveTo to create a line
ALCBufferLinePath.LineTo(5F, 1.5F);
ALCBufferLinePath.LineTo(200F, 1.5F);
ALCBufferLinePath.LineTo(212F, 5F);
ALCBufferLinePath.LineTo(212F, 0F);
ALCBufferLinePath.LineTo(0F, 0F); // Close the path

Shape alcBufferLine = worksheet.Shapes.AddFreeform(0, 0, 0, 0, 0, 0, new ShapePath[] { ALCBufferLinePath });
alcBufferLine.Placement = PlacementType.MoveAndSize; // Set the placement type
alcBufferLine.Width = 212; // Set a non-zero width
alcBufferLine.Height = 5; // Set a non-zero height
alcBufferLine.X = 500; // Adjust X position as needed
alcBufferLine.Y = 200; // Adjust Y position as needed
alcBufferLine.Fill.FillType = FillType.Solid;
alcBufferLine.Fill.SolidFill.Color = Color.Red; // Set the Fill color
alcBufferLine.Line.FillType = FillType.Solid;
alcBufferLine.Line.SolidFill.Color = Color.Red; // Set the Line color

Next Steps

  1. Run the updated code to see if the shape appears correctly.
  2. Adjust the X, Y, Width, and Height values as needed to fit your layout.
  3. If the shape is still not visible, check for any overlapping elements or if the worksheet is protected.

Please proceed with these steps, and let me know if you need further assistance!

3

@Professionalize.Discourse
Thank you

4

how can i set 50% transparency to line and fill?
below code is not working

alcBufferLine.Fill.FillType = FillType.Solid;
alcBufferLine.Fill.Transparency = 0.5F;
5

@tejas.patel
Please try the following code.

alcBufferLine.Fill.FillType = FillType.Solid;
alcBufferLine.Fill.SolidFill.Color = Color.Red;  
alcBufferLine.Fill.Transparency = 0.5f;

alcBufferLine.Line.FillType = FillType.Solid;
alcBufferLine.Line.SolidFill.Color = Color.Red;
alcBufferLine.Line.Transparency = 0.5f;

Hope helps a bit!

6

@xinya.zhu
Thank you

7

@tejas.patel
You are welcome. If you have any questions, please feel free to contact us at any time.