Hello Joel,

First of all, I am glad to hear that you were able to find a solution that satisfies your requirements. I understand the importance of the matter and how it is affecting you for which I once again apologize.

We highly value the time and effort you've spent getting back to us with this information and I would be glad if you could elaborate further on the workaround that you have settled with. Any feedback is always welcome and appreciated as it will become part of this thread that others can benefit from. 

Regards,
Yoan
Progress Telerik

Hello Joel,

I completely understand the importance of this case, how it might be affecting you, and the setbacks it can cause in certain scenarios.

However, we have a system that prioritizes the logged tasks in our Feedback Portal by taking into consideration various factors like demand, complexity, resources, etc. We are doing everything in our power to answer customer requests and needs by resolving these tasks as fast as possible, but some receive less attention than others, which is why they can sometimes be delayed, just like this one.

Currently, this task is not on our roadmap for the foreseeable future and I also wouldn't want to mislead you by giving you any incorrect information just for the sake of it. Once any item is resolved, we immediately update the public feedback page to notify our clients so the best thing I can offer is to subscribe to the task in order to track its progress and don't miss potential updates.

Thank you for your understanding.

Regards,
Yoan
Progress Telerik

Hi,

A possible workaround when you need to set a large number of cells it to suspend the ProertyChanged event of the Cells. Currently, this can be done only with reflection:

Worksheet worksheet = workbook.Worksheets[0];

var field = worksheet.Cells.GetType().GetField("propertyBag", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(worksheet.Cells);
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Telerik.Windows.Documents.Spreadsheet.dll");
Assembly assembly = Assembly.LoadFile(path);
Type propertyBag = field.GetType();
MethodInfo suspend = propertyBag.GetMethod("SuspendPropertyChanged", BindingFlags.NonPublic | BindingFlags.Instance);
MethodInfo resume = propertyBag.GetMethods(BindingFlags.NonPublic | BindingFlags.Instance).Where(x => x.Name == "ResumePropertyChanged").FirstOrDefault();

suspend.Invoke(field, null);

//Update cells values

resume.Invoke(field, null);

Regards,
Dimitar
Progress Telerik

Hello Diego,

The item is with status "Approved", which means it is included in our backlog. However, the issue is not scheduled for fixing in the next release and I am unable to say when a fix might be available.

Regards,
Tanya

@Adel do you mean the Speadsheet control or the SpreadProcessing library?

Thanks for the additional information @Mark. We will update the item with our latest findings. If you find any other relevant information, let us know - here or in the support system.