SetValue issue

Posted by: p.feenstra on 19 September 2021, 6:57 pm EST

  • Posted 19 September 2021, 6:57 pm EST

    After upgrading from v12 to v14 I discovered another problem.

    The correct value of a cell is sometimes not immediately displayed after using SetValue.

    Using

    A databound sheet with datasource = List(of …)

    Preset data fields and cell types for the columns.

    It seems to me that the number cells are the most sensitive to it.

    v12 does not have this issue.

    Regards Piet

  • Posted 20 September 2021, 6:38 pm EST

    Hi Piet,

    I tried updating cell values at regular intervals, however, I was not able to observe any delay.

    Can you please specify how much delay you are observing and how are you updating your cell values (in response to some events, etc.)?

    Thanks,

    Jitender

  • Posted 21 September 2021, 1:31 am EST

    Hi Jitender,

    as soon as I click in another cell it’s updated.

    Cells(row, col).Invalidate() also works.

    So it seems that the cell text is now (sometimes) not updated.

    Regards Piet

  • Posted 21 September 2021, 3:56 pm EST - Updated 30 September 2022, 4:16 am EST

    Hi,

    I’m still unable to replicate the issue.

    Here’s what I observe:

    Could you please share a small sample with the issue so we can investigate what might be the cause for this?

    Regards,

    Jitender

  • Posted 21 September 2021, 5:31 pm EST

    Hi Jitender,

    Don’t have much time these days but if you send me your sample then I’ll try to build on it.

    Regards Piet

  • Posted 21 September 2021, 6:32 pm EST

    Sure, please check this sample:

    SetValueDelay.zip

    Thanks.

  • Posted 22 September 2021, 4:00 am EST

    Hi Jitender,

    Replace Form1 with Form2.

    1. Select a cell
    2. Click on the SetValue button.
    3. Then (in my environment) the Text is not updated.
    4. Activate another cell and notice that the value has been updated.

    Regards Piet

    Form2.zip

  • Posted 22 September 2021, 6:43 pm EST - Updated 30 September 2022, 4:16 am EST

    That’s strange, I still could not observe any issues:

    Is it an intermittent issue? Could you please share your environment details?

    Thanks,

    Jitender

  • Posted 22 September 2021, 8:22 pm EST

    Hi Jitender,

    are you working with another version?

    I’m using 14.45.20201.0.

    Not too long ago I already sent you my system specifications.

    Regards Piet

  • Posted 22 September 2021, 11:25 pm EST

    Hi Piet,

    I checked the issue with 14.45.20201.0 and I was able to observe the issue.

    This has been fixed in the Service Pack updates.

    Please use the latest Service Pack update (14.45.20213.0) to avoid this and other issues which have been fixed.

    Regards,

    Jitender

  • Posted 22 September 2021, 11:58 pm EST

    Hi Jitender,

    Glad we found it.

    Where can we download the latest service pack and where can we find the fixed issues?

    Sorry, this is still not obvious on your site.

    Regards Piet

  • Posted 23 September 2021, 6:21 pm EST

    Hi Piet,

    You can use this link for the latest Spread installer:

    https://cdn.grapecity.com/SpreadNET/installer/current/Spread.NET+Installer.exe

    Or just visit the page for Spread.NET and download from there:

    https://www.grapecity.com/spreadnet/download

    You can also check the release notes page for all documented fixes/enhancements:

    https://www.grapecity.com/spreadnet/docs/v14/readme/rnotes.html.

    However, your issue is not mentioned on this page. It is possible that this issue was fixed as part of one of the documented fixes.

    Regards,

    Jitender

Need extra support?

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

Learn More

Forum Channels