Unplanned
Last Updated: 30 Dec 2022 10:11 by ADMIN
ADMIN
Deyan
Created on: 25 Jul 2018 12:53
Category: SpreadProcessing
Type: Bug Report
1
SpreadProcessing: Named or absolute values are not updated when cells are inserted or removed
The named ranges need to be translated when used in a certain cell just like the data validation rules.

WORKAROUND: When you use RowSelection.Insert() method, for instance, after the row insertion you may iterate all defined names in the document. Parse their RefersTo property and if it is affected by the insertion, delete and recreate the DefinedName in the corresponding NameCollection by updating the RefersTo text value. Sample code for parsing the RefersTo property may be seen in the description of this feedback item: 

https://feedback.telerik.com/Project/184/Feedback/Details/190061-spreadprocessing-add-api-to-get-the-list-of-ranges-to-which-a-defined-name-refer
2 comments
ADMIN
Peshito
Posted on: 30 Dec 2022 10:11

Hello Brandon,

Thank you for pointing this out. Yes, this issue is valid for absolute references as well. I updated the title of this feedback item so it gives more appropriate information. 

Regards,
Peshito
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Brandon
Posted on: 29 Dec 2022 16:21
Does this bug report refer only defined names? Or to functions using absolute references as well?