We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Get Cell Value

Thread ID:

Created:

Updated:

Platform:

Replies:

149603 Dec 2,2019 11:57 PM UTC Dec 23,2019 11:09 AM UTC Angular - EJ 2 5
loading
Tags: Spreadsheet
Umair Ahmed
Asked On December 2, 2019 11:57 PM UTC

Hi,

Can you please provide a sample to get the cell value after user clicks on a particular cell, there seems to be an event called "oncellclick" but looks like its not working in angular.

Thanks 

Arunkumar Devendiran [Syncfusion]
Replied On December 3, 2019 02:39 PM UTC

Hi Umair Ahmed, 
 
We have checked your reported query and you can achieve this by using getData method in select event. We have created the sample for your reference in that we have logged the selected cell value in the console. Please refer the below sample link, 
 
Sample link: 
 
Regards, 
Arunkumar D 


Umair Ahmed
Replied On December 4, 2019 09:49 PM UTC

Thanks Arunkumar, that worked but if I try assign the cell some value it doesn't refreshes on the grid, one of the requirements is to open an existing excel file, read data from every row and cell, make changes and display it on the grid.

Madhan Venkateshan [Syncfusion]
Replied On December 9, 2019 01:05 PM UTC

Hi Umair, 
 
Good day to you. 
 
We would like to suggest you to use beforeCellRender event to read data for every cell before the creation of cell, you can modify the cell value using updateCell method, but using the updateCell method inside beforeCellRender event have some issues as of now but it is a known issue in our end and we will include the fix for this issue in Volume 4 release which will be available in the mid of December month 2019 and appreciate your patience until then. 
 
Regards, 
Madhan V 


Umair Ahmed
Replied On December 21, 2019 12:47 AM UTC

Hi,

Any updates on this ? if its fixed, please share a sample of updateCell method inside beforeCellRender. 

Thanks.

Madhan Venkateshan [Syncfusion]
Replied On December 23, 2019 11:09 AM UTC

Hi Umair, 
 
Sorry for the inconvenience caused. 
 
We are facing more complexity while fixing the reported issue, so we are not able to include the fix in the Volume 4 release. We will include the fix in the second week patch release of January 2020 and appreciate your patience until then. 
 
Regards, 
Madhan V 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon