Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Fri Sep 15, 2017 9:09 am

Hello,

I have an issue with AutoFit Column not apply.

Code: Select all
var workbook = new Workbook();
Worksheet sheet = (Worksheet)workbook.Worksheets.First();

sheet.Range["B2"].Value = "1";
sheet.Range["B2"].AutoFitColumns();

workbook.SaveToFile(Chemin + "Sample - OutSample.xlsx", ExcelVersion.Version2016);


Column B is not reduced.
Do you reproduce the issue ?

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Fri Sep 15, 2017 9:31 am

Dear VincentB,

So sorry for the issue.
And I have reproduced and logged it into our bug system, and we will let you know once there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3067
Joined: Tue Sep 06, 2016 8:30 am

Thu Sep 28, 2017 8:27 am

Dear VincentB,

Thanks for waiting.
Now the issue has been fixed in Spire.XLS Pack Hotfix Version:7.12.90. Welcome to download it and have a try.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3067
Joined: Tue Sep 06, 2016 8:30 am

Mon Oct 09, 2017 9:24 am

Hello,

Greetings from E-iceblue.
Did the hotfix resolve your issue?
Thanks in advance for your valuable feedback and time.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri Oct 13, 2017 7:13 am

Hello

This hotfix resolve partially this issue : an autofit is affected, but it's not the same as Excel.

If we select all columns in Excel and re-set autofit, columns move.

Regards

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Fri Oct 13, 2017 7:24 am

Dear VincentB,

Thanks for your feedback.
I have noticed the width adjusted by Spire is not same as MS Excel. And I have logged the issue in our bug system. We will let you know as soon as there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3067
Joined: Tue Sep 06, 2016 8:30 am

Tue Feb 20, 2018 7:47 am

Hello

Have you been able to advance on this problem?

Regards,

Vincent

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Feb 20, 2018 8:04 am

Hello Vincent,

Thanks for your inquiry. I am sorry the issue has not been fixed yet. As we are on our Spire Festival Vacation, we will continue looking into it on 02/22/2018.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Return to Spire.XLS