This is a migrated thread and some comments may be shown as answers.

Updating A Named Range Programmatically

6 Answers 36 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Bryan
Top achievements
Rank 1
Bryan asked on 18 Sep 2015, 10:32 PM

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.

6 Answers, 1 is accepted

Sort by
0
Nikolay Demirev
Telerik team
answered on 21 Sep 2015, 12:42 PM
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
0
Bryan
Top achievements
Rank 1
answered on 21 Sep 2015, 01:35 PM

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?

 

0
Nikolay Demirev
Telerik team
answered on 23 Sep 2015, 03:23 PM
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
0
Bryan
Top achievements
Rank 1
answered on 07 Feb 2016, 05:08 PM

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?

0
Bryan
Top achievements
Rank 1
answered on 08 Feb 2016, 04:12 PM

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

0
Svetoslav
Telerik team
answered on 09 Feb 2016, 02:06 PM
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
Tags
Spreadsheet
Asked by
Bryan
Top achievements
Rank 1
Answers by
Nikolay Demirev
Telerik team
Bryan
Top achievements
Rank 1
Svetoslav
Telerik team
Share this question
or