Updating A Named Range Programmatically

7 posts, 0 answers
  1. Bryan
    Bryan avatar
    14 posts
    Member since:
    Jan 2015

    Posted 18 Sep 2015 Link to this post

    Hello,

     When I update a named range programmatically I am forced to remove the name and re-add it with the updated value. This is fine as a workaround but any cells that referred to the name can have strange visuals depending on the new value. For example, I have a named range 'Test' in which RefersTo ​is '=1'. I set A1 to be =Test and it displays 1 as expected. If I remove the name and re-add a new name 'Test' with RefersTo '=1000', A1 will extend into the neighboring cell.

  2. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 21 Sep 2015 Link to this post

    Hi Bryan,

    This is a known issue and it is with high priority in our backlog, but I can not give you any particular timeframe for fixing it. You can follow this public item in our feedback portal, this way you will be able to track is status.

    Regards,
    Nikolay Demirev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for WPF is Visual Studio 2017 Ready
  4. Bryan
    Bryan avatar
    14 posts
    Member since:
    Jan 2015

    Posted 21 Sep 2015 in reply to Nikolay Demirev Link to this post

    That's unfortunate, as it seems that this would be fairly common.

    I did manage to find a workaround that switching the active sheet away and back forces an update to the display. Is there a better way?

     

  5. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 23 Sep 2015 Link to this post

    Hello Bryan,

    We discussed this issue in the team and increased its priority. The fix is now scheduled for implementation and hopefully will be available in Q3 2015 SP1 which will be released around the beginning of October.

    Regards,
    Nikolay Demirev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Bryan
    Bryan avatar
    14 posts
    Member since:
    Jan 2015

    Posted 07 Feb Link to this post

    This is still not quite fixed

    On Sheet1 I have a named range 'Test' which refers to A1. The value in A1 is 1. On Sheet2 I have a cell which refers to 'Test' (ie. B5 value is "=Test"). Updating the A1 on Sheet1 programmatically while Sheet2 is active causes the visual bug.

    Switching tabs fixes it, but is slow. Is there a way to force a refresh as a workaround for now?

  7. Bryan
    Bryan avatar
    14 posts
    Member since:
    Jan 2015

    Posted 08 Feb Link to this post

    Setting the active cell to its own value forces the display to update which works for now.

  8. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 09 Feb Link to this post

    Hi Brian,

    I am glad to hear that you have found a workaround. 

    I can confirm that the problem that you have described still exists. It seems that we have misled you and the feedback item that we have provided doesn't cover this exact scenario. I have logged a new issue to our feedback portal where you can track our overall progress on this: 
    "Updating a cell in an inactive worksheet that is referenced by a cell from the active sheet breaks the alignment of the active sheet’s cell.".

    We apologize for the inconvenience and as a token of appreciation, I have updated your Telerik points.

    Regards,
    Svetoslav
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for WPF is Visual Studio 2017 Ready