Using XLS, Shape Rotation

[IceBlueKent]

Hi,

When I dim a Spire.Xls.Core.Spreadsheet.Shapes.XlsShape,
and add this shape using Spire.Xls.Worksheet.PrstGeomShapes.AddPrstGeomShape() method.
The rotation property on XlsShape has no effect on the shape.
I am using
spreadsheet version 3.1.2.8040
XLS version 9.1.4.60040

Is this normal?

Code: Select all

            Dim sp As Spire.Xls.Workbook
            sp = New Spire.Xls.Workbook

            sp.Worksheets.Add("1")

            Dim sheet1 As Spire.Xls.Worksheet
            sheet1 = sp.Worksheets("1")

            Dim XLSShape As Spire.Xls.Core.Spreadsheet.Shapes.XlsShape

            XLSShape = sheet1.PrstGeomShapes.AddPrstGeomShape(2, 2, 18, 18, Spire.Xls.PrstGeomShapeType.Star4)

            XLSShape.Rotation = 45
            XLSShape.LeftColumnOffset = 100
            XLSShape.TopRowOffset = 25

            sp.SaveToFile(Filepath & FileName)
 


Thanks for your help.

[Lisa.Li]

Hello,

Thank you for contacting us.
I tested your case both with Spire.Spreadsheet Version:3.1.2 (Spire.Spreadsheet.dll:3.1.2.8040 Spire.XLS.dll:9.1.4.60040) and the latest Spire.Spreadsheet Version:3.1.5(Spire.Spreadsheet.dll:3.1.5.8040 Spire.XLS.dll:9.1.15.18040), but didn't reproduce the issue you mentioned. The rotation property on XlsShape has effect on the shape. Here, I made an .exe application for you, please directly run it on your side. If your issue still occurs after testing, please provide your system configuration (Eg. Win7, 64-bit) and region settings (Eg. China, Chinese) to help us further look into it.

Sincerely,
Lisa
E-iceblue support team

[IceBlueKent]

Hi,

Thanks for your help.

One thing I notice that it's my website is built for framework 3.5, so I change the version to XLS 9.1.4.60035, and Spreadsheet 3.1.2.8035,
yet still does not work.

And My computer is running window 7, 32 bit. Region( united states, English).

Does it matter if I am using Microsoft Visual studio 2008?

Thanks again.

[Lisa.Li]

Hello,

Thanks for the details.
Your issue should not be related to Visual studio tool. But with the same testing environment, I still didn’t reproduce your issue on my side. Could you please let us know your testing result of previous .exe application? To help further look into this issue, please provide your testing output file as well as a runnable sample application which shows your problem. You could send them to us via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Lisa
E-iceblue support team

[IceBlueKent]

Hi,

I found out that the Rotation property does not work when I saveasfile to version before 2010.

It works when I save as file after version 2010.

Thanks.

[Lisa.Li]

Hello,

When saving the file with Excel Version2007, the rotation property works well. But I did notice it does not work when saving the file with Excel Version97to2003. Our Dev team will do a further investigation for it, if there is any update, we will keep you posted. Sorry for the inconvenience caused.

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello,

Glad to inform you the reported issue has been fixed in Spire.XLS Pack(Hotfix) Version:9.3.10. Welcome to download it from the following links.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello,

Greetings from E-iceblue.
Did the hotfix work for you? Thanks in advance for your feedback and time.

Sincerely,
Lisa
E-iceblue support team