Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

[BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

Last post 08-29-2011, 2:47 AM by aspose.notifier. 6 replies.
Sort Posts: Previous Next

  •  08-18-2011, 2:29 PM 323269

    [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat .NET

    Attachment: Present (inaccessible)
    The subject says it all.  I'm using Aspose.Cells for .NET v6.0.1.0 (the most current version I think).  I've attached a Visual Studio 2010 console project written in VB.NET that demonstrates the problem.  It fills a worksheet full of data and autofits the columns.  Then it applies a NumberFormat to those columns and autofits them again.  Here's an example of the output that I get:

    # of rows:  2350
    # of cols:  145
    # of cells:  340750

    AutoFitting columns (before setting NumberFormat)... 2130 ms
    AutoFitting columns (before setting NumberFormat)... 2497 ms
    AutoFitting columns (before setting NumberFormat)... 2710 ms

    AutoFitting columns (after setting NumberFormat)... 22226 ms
    AutoFitting columns (after setting NumberFormat)... 20801 ms
    AutoFitting columns (after setting NumberFormat)... 22597 ms

    Press any key to continue . . .

    Excel 2010 can autofit all the columns almost instantly, both with and without a NumberFormat set.  Is there something you guys can do to speed this up?  20+ seconds is much too long to wait for something Excel does almost instantly and it has become a big problem for my customers.

    Thank you for your help!
    Filed under: aspose.cells;bug;performance;slow
     

  •  08-19-2011, 2:42 AM 323339 in reply to 323269

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    Hi,

    Well, Auto-Fit Rows/Columns are time consuming functions if there is large amount of formatted data. I have tested your project and can notice the performance of the features. Anyways, I have logged a ticket for it with an id: CELLSNET-29983. We will look into it if we can improve the performance of the features a bit, we will get back to you soon.

    thank you.
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  08-23-2011, 10:19 AM 324070 in reply to 323339

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    Thank you!
     

  •  08-24-2011, 6:15 AM 324257 in reply to 324070

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    Hi,  
     
    Please try this fix: Aspose.Cells for .NET v6.0.1.9
    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     

  •  08-25-2011, 12:05 PM 324577 in reply to 324257

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    Good improvement!  Here are the times that I'm getting now:

    # of rows:  2350
    # of cols:  145
    # of cells:  340750

    AutoFitting columns (before setting NumberFormat)... 1684 ms
    AutoFitting columns (before setting NumberFormat)... 2020 ms
    AutoFitting columns (before setting NumberFormat)... 2137 ms

    AutoFitting columns (after setting NumberFormat)... 3889 ms
    AutoFitting columns (after setting NumberFormat)... 4162 ms
    AutoFitting columns (after setting NumberFormat)... 3979 ms

    Press any key to continue . . .


    Thanks again!
     

  •  08-25-2011, 8:45 PM 324636 in reply to 324577

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    Hi,

    Thanks for testing the performance and sharing the results. Thanks for your appreciation.
    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     

  •  08-29-2011, 2:47 AM 324959 in reply to 323269

    Re: [BugReport] .AutoFitColumns() on WorkSheet extremely slow when columns have a NumberFormat

    The issues you have found earlier (filed as 29983) have been fixed in this update.

    This message was posted using Notification2Forum from Downloads module by aspose.notifier.
     
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat