Worksheet refresh problem when updating values using code

[Anthony]

Hi,

I have two worksheets,

The first worksheet has a set of Defined Names and their values.

The second worksheet has a set of formulas that reference many of the Defined Names from the first worksheet. This is also the active worksheet.

If I set the value of the cell referenced by a Defined Name via code using Cells.SetValue, the value is updated on the first worksheet but the values on the second worksheet (that use the Defined Names) are not updated.

If I swap away and then back to the second worksheet, or make a modification to any cell on the second worksheet, all of the values on the second worksheet then correctly update.

It seems that worksheets not directly updated by Cells.SetValue are not being refreshed, even when they reference the updated cell?

Thanks
Anthony

[Anna]

Hello Anthony,

Thank you for pointing out this issue to us, it seems the UI was not properly updated in this particular scenario. The fix will be available in the next LIB.

Please, do not hesitate to let us know if you encounter any further issues.

Regards,
Anna
Telerik

 

 

[Anthony]

Hi,

I tested this in the latest release and this issue was not fixed. Was the fix included?

Thanks
Anthony

[Nikolay Demirev]

Hello Anthony,

The fix is included in the Q2 2014 SP1. I have tested it and it works fine. Could you update your binaries and verify if it is fixed. If you still can reproduce the issue after the update, I kindly ask you to send us a sample project where the issue can be reproduced, so we can further investigate it.

I am looking forward to your reply.

Regards,
Nikolay Demirev
Telerik

 

 

[Anthony]

Hi,

I have the latest binaries and have done a full rebuild and the issue is still there in my project.

However, If I create a sample project so it can be demonstrated to you, I cannot get the issue to occur and it works as expected.

I have a workaround at the moment (setting a value on the sheet that is not being updated), which may have to suffice unless I can get it to happen in a sample project.

Thanks
Anthony

[Boryana]

Hi Anthony,

Let us know when you are able to replicate the issue in a sample project. Do not hesitate to contact us if you need further assistance on the matter.

Regards,
Boryana
Telerik