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.


    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.



  • 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.



  • 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.




Need extra support?

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

Learn More

Forum Channels