Telerik Forums RSShttp://www.telerik.com/urn:uuid:aee544c2-b342-4961-ac20-781b8510b001http://www.telerik.com/forums/permalink/wkTlrkKzYUmsIHgbhRCwAQDetecting a Formula Value changeHello,<br />
<br />
The CellPropertyChanged event is raised only when some value in the data structures holding all spreadsheet values changes. When you modify a value in a cell that is referred by a formula actually the data stored in the cell holding the formula stays unmodified. Only the result value of the formula is invalidated and is calculated the next time the result value is accessed. That is why CellPropertyChanged event is not raised for the cell containing the formula.<br />
<br />
I have attached a sample project showing how to track if a CellFormulaValue is invalidated.<br />
<br />
I hope this helps. If you have any further questions, please do not hesitate to contact us again.<br />
<br />
Regards,<br />
Nikolay Demirev <br />
Telerik
<div class="forumBaloonTop"> </div>
<div class="forumBaloon">
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. <a href="http://www.telerik.com/videos/analytics" alt="Telerik Analytics Videos" title="Telerik Analytics Videos"><strong>Watch the videos</strong></a> and start improving your app based on facts, not hunches.
</div>
<div class="forumBaloonBottom"> </div>urn:uuid:2efdaac8-b2e7-4994-a793-90416c75b35ehttp://www.telerik.com/forums/permalink/yKr9LueylEmnk5BBbHWzXgDetecting a Formula Value changeHow can one detect when the value of a formula has changed within the radspreadsheet control?<br />
<br />
I have a cell that is a formula ="Anothercell*4"<br />
<br />
I have the spreadsheet.ActiveWorksheet.Cells.CellPropertyChanged event wired, <br />
<br />
BUT the cellPropertyChangedEvent only fires ONCE when the "anothercell" cell is changed (property = 'CellValue')<br />
<br />
Shouldn't the event fire twice? Once for AnotherCell and again for the formula cell (with a e.Property value of something other than CellValue?<br />
<br />
thanks