(UTC)
  The MindFusion Forums › Grid and Spreadsheet Components › Windows Forms › How to detect a cell content change?
(Moderator: Iva_P)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic How to detect a cell content change? (Read 453 times)
Ale
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 14
Joined: May 26th, 2023
How to detect a cell content change?
May 26th, 2023 at 8:13am
Print Post  
Hello,
I'm new in the forum since I'm evaluating the Spreadsheet.
THe documentation is poor and I have some problems to find the answers.
Now I need to detect in the spreadsheet component every cell content change. I tried to use the event "InplaceEditEnded" but does not fire when, for example, I do copy/paste (pasted content in the cell does not fire that event).
I need to detect every cell change, also when the spreadsheet load a sheet, in fact if the cell contains some specific text I need to perform some activities. This is true also when I load the sheet since I need to know which cells contain the text.
How can I achieve this?

Thank you for your help!
  
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3154
Joined: Oct 19th, 2005
Re: How to detect a cell content change?
Reply #1 - May 26th, 2023 at 9:41am
Print Post  
Hi,

CellChanged event should be raised for edited values, copy/paste and auto-fill.

You won't get change events while a file loads. You could loop over non-empty cells after loading to get their content:

Code
Select All
foreach (var cell in worksheet.Cells)
	Debug.WriteLine(cell);


Regards,
Slavcho
Mindfusion
  
Back to top
 
IP Logged
 
Ale
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 14
Joined: May 26th, 2023
Re: How to detect a cell content change?
Reply #2 - May 26th, 2023 at 1:44pm
Print Post  
OK, understood. Thank you  Smiley
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

The MindFusion Forums » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge