Worksheet refresh problem when updating values using code

6 posts, 0 answers
  1. Anthony
    Anthony avatar
    58 posts
    Member since:
    Aug 2011

    Posted 18 Jul 2014 Link to this post

    Hi,

    I have two worksheets,

    The first worksheet has a set of Defined Names and their values.

    The second worksheet has a set of formulas that reference many of the Defined Names from the first worksheet. This is also the active worksheet.

    If I set the value of the cell referenced by a Defined Name via code using Cells.SetValue, the value is updated on the first worksheet but the values on the second worksheet (that use the Defined Names) are not updated.

    If I swap away and then back to the second worksheet, or make a modification to any cell on the second worksheet, all of the values on the second worksheet then correctly update.

    It seems that worksheets not directly updated by Cells.SetValue are not being refreshed, even when they reference the updated cell?

    Thanks
    Anthony
  2. Anna
    Admin
    Anna avatar
    99 posts

    Posted 22 Jul 2014 Link to this post

    Hello Anthony,

    Thank you for pointing out this issue to us, it seems the UI was not properly updated in this particular scenario. The fix will be available in the next LIB.

    Please, do not hesitate to let us know if you encounter any further issues.

    Regards,
    Anna
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. UI for WPF is Visual Studio 2017 Ready
  4. Anthony
    Anthony avatar
    58 posts
    Member since:
    Aug 2011

    Posted 31 Jul 2014 in reply to Anna Link to this post

    Hi,

    I tested this in the latest release and this issue was not fixed. Was the fix included?

    Thanks
    Anthony
  5. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 01 Aug 2014 Link to this post

    Hello Anthony,

    The fix is included in the Q2 2014 SP1. I have tested it and it works fine. Could you update your binaries and verify if it is fixed. If you still can reproduce the issue after the update, I kindly ask you to send us a sample project where the issue can be reproduced, so we can further investigate it.

    I am looking forward to your reply.

    Regards,
    Nikolay Demirev
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  6. Anthony
    Anthony avatar
    58 posts
    Member since:
    Aug 2011

    Posted 05 Aug 2014 in reply to Nikolay Demirev Link to this post

    Hi,

    I have the latest binaries and have done a full rebuild and the issue is still there in my project.

    However, If I create a sample project so it can be demonstrated to you, I cannot get the issue to occur and it works as expected.

    I have a workaround at the moment (setting a value on the sheet that is not being updated), which may have to suffice unless I can get it to happen in a sample project.

    Thanks
    Anthony
  7. Boryana
    Admin
    Boryana avatar
    330 posts

    Posted 07 Aug 2014 Link to this post

    Hi Anthony,

    Let us know when you are able to replicate the issue in a sample project. Do not hesitate to contact us if you need further assistance on the matter.

    Regards,
    Boryana
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
Back to Top
UI for WPF is Visual Studio 2017 Ready