Setting some properties of each cell is too slow in 14.45.20213.0 version

Posted by: lee.hs on 15 April 2022, 6:21 pm EST

  • Posted 15 April 2022, 6:21 pm EST


    We had upgraded Farpoint Spread to 14.45.20213.0 from 4.0.3512.2008 in this year. With same cases, their are such a massive gap in performance between them.

    Example) Conditions : 103 Columns / 430 rows

    Setting BackColor for each cell takes 00:00:00.0000020~30 in old ver. Setting BackColor for each cell takes about 00:00:00.0001021~33025 in new ver.

    Setting Renderer, NoteIndicatorColor are seriously slow too.

    It seems more data take more times for setting each cell`s properties.

    Could you guide us what makes these get so much slower than old ver.?



  • Posted 17 April 2022, 5:00 pm EST

    Hi Lee,

    Could you please share a small sample replicating how you are setting the properties for these cells? We check for a range of 103 columns and 430 rows and got similar results in both versions. Please share a sample so that we can investigate further at our end.

    Regards Avnish

  • Posted 18 April 2022, 1:54 pm EST

    Hi Avnish,

    Thanks for your reply.

    I made a sample and uploaded to the link below.

    The sample looks quite messy(sorry), but only you need to see is [TSpreadGrid.cs - line 288] cell.Renderer = renderer as IRenderer;

    During make this sample, we figured out that setting [cell.Renderer] makes all these performance gaps.

    Here is the steps.

    1. Run this sample.
    2. Maximize the Winform.
    3. Do auto sorting with the [InVoy] column twice.
    4. See the performance and output prompt logs.(There is time elapse for setting cell`s fore/back colors.)

    Guide video is here.

    When you delete [TSpreadGrid.cs - line 288], you would see it much get faster. Our [CodeRenderer] do nothing further in here, and even while do something, it was not a problem with old ver.

    I hope it would be helpful.

    Thanks, Lee

  • Posted 18 April 2022, 2:33 pm EST

    Hi Lee,

    We could not access the files using the links you provided. We have created a case on our support portal [Case ID: CAS-30669-K8R8S1]. Please continue the thread there.

    You can find your support cases in the “My Support” section of your grapecity account. Link: The benefits of your GrapeCity account...

    Regards Avnish

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels