Updating A Named Range Programmatically

[Bryan]

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.

[Nikolay Demirev]

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

[Bryan]

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?

 

[Nikolay Demirev]

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

[Bryan]

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?

[Bryan]

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

[Svetoslav]

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