Transparent textbox not possible in v. 8.9.1

Aspose.Cells Product Family
1

Hello,
Transparent textboxes stopped working in Aspose.Cells 8.9.1. Please, fix or advice the way to do it now.

Shape textbox = worksheet.Shapes.AddTextBox

…

textbox.IsFilled = false;
OK. Not filled. Border present.

textbox.HasLine = false;
textbox.IsFilled = false;
Fail. No border. Filled with blue.

I can also see the way to do it via
textbox.Format.Fill.FillType = FillType.None;
textbox.Format.Line.FillType = FillType.None;
however, no combination worked for me.


Even the following code resulted in the blue object with the red border.
textbox.Format.Line.FillType = FillType.Solid;
textbox.Format.Line.SolidFill.Color = System.Drawing.Color.Red;
textbox.Fill.FillType = FillType.Solid;
textbox.Fill.SolidFill.Color = System.Drawing.Color.Yellow;


In addition, 2 properties we used are marked as obsolete now, with confusing comments.
Aspose.Cells.Drawing.Shape
[Obsolete(“Use Shape.Format.Outline property instead.”)]
public MsoLineFormat LineFormat { get; }
There is no Shape.Format.Outline

[Obsolete(“Use Shape.Format.FillFormat property instead.”)]
public MsoFillFormat FillFormat { get; }
There is no Shape.Format.FillFormat
I guess it should be Use Fill and Line.

Regards,
Alex

2
Hi Alex,

alex-rkn:

Transparent textboxes stopped working in Aspose.Cells 8.9.1. Please, fix or advice the way to do it now.

Shape textbox = worksheet.Shapes.AddTextBox
...

textbox.IsFilled = false;
OK. Not filled. Border present.

textbox.HasLine = false;
textbox.IsFilled = false;
Fail. No border. Filled with blue.

I can also see the way to do it via
textbox.Format.Fill.FillType = FillType.None;
textbox.Format.Line.FillType = FillType.None;
however, no combination worked for me.

I am able to notice the said problem, that is; it is impossible to make a TextBox fully transparent while using the latest revision of Aspose.Cells for .NET 8.9.1. As per my testing, only one of the portions (Line / Fill) can be made transparent at a time. If we comment one statement, other seems to take effect but not both at the same time. Moreover, the TextBix.IsFilled & TextBox.HasLine has the same behaviour. that is; if we set TextBix.IsFilled to false alone, the fill be transparent but it we use it with TextBox.HasLine set to false, the fill is blue. I have logged this incident as CELLSNET-44671 for further investigation by the product team.

alex-rkn:

Even the following code resulted in the blue object with the red border.
textbox.Format.Line.FillType = FillType.Solid;
textbox.Format.Line.SolidFill.Color = System.Drawing.Color.Red;
textbox.Fill.FillType = FillType.Solid;
textbox.Fill.SolidFill.Color = System.Drawing.Color.Yellow;

This issue is possibly related to the problem discussed above, however, I have logged it under a separate ticket CELLSNET-44672 for investigation.

alex-rkn:


In addition, 2 properties we used are marked as obsolete now, with confusing comments.
Aspose.Cells.Drawing.Shape
[Obsolete("Use Shape.Format.Outline property instead.")]
public MsoLineFormat LineFormat { get; }
There is no Shape.Format.Outline

[Obsolete("Use Shape.Format.FillFormat property instead.")]
public MsoFillFormat FillFormat { get; }
There is no Shape.Format.FillFormat
I guess it should be Use Fill and Line.

Could you please paste your executable code using the obsoleted APIs for further investigation?
3

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44671 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

babar.raza:
alex-rkn:


In addition, 2 properties we used are marked as obsolete now, with confusing comments.
Aspose.Cells.Drawing.Shape
[Obsolete(“Use Shape.Format.Outline property instead.”)]
public MsoLineFormat LineFormat { get; }
There is no Shape.Format.Outline

[Obsolete(“Use Shape.Format.FillFormat property instead.”)]
public MsoFillFormat FillFormat { get; }
There is no Shape.Format.FillFormat
I guess it should be Use Fill and Line.

Could you please paste your executable code using the obsoleted APIs for further investigation?



It’s very simple. Just use those properties in any way:

Shape shape = null;

object o1 = shape.LineFormat;

object o2 = shape.FillFormat;
There would be warnings
warning CS0618: ‘Shape.LineFormat’ is obsolete: 'Use Shape.Format.Outline property instead.'
warning CS0618: ‘Shape.FillFormat’ is obsolete: 'Use Shape.Format.FillFormat property instead.'

And there is no
Shape.Format.Outline
Shape.Format.FillFormat

No impact on our product. I’ve just reported misleading warnings.

5

Hi Alex,


Thank you for the elaboration. I have raised these concerns with the product team under the ticket CELLSNET-44674. Please spare us little time to look further into this matter and get back with updates in this regard.
6

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44672 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

7

The issues you have found earlier (filed as CELLSNET-44671;CELLSNET-44674) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
8

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan