Assuming that there is a table, the information on the table is currently imported into getSourceData and stored in the DB.
I was checking whether the data I brought to getSourceData was correct or not by turning it into the conditional statement I wrote, and when I happened to look it up in the document, there was a function called validatecell.
So I tried to use this function, but I didn’t think there was a related example, so I was curious how it was used exactly, so I left a question.
Currently, the action I want to do is simply to check whether the value that enters the cell is string or number.
Of course, I know that celltype can be changed to numbers and letters through rendering function, but only red is displayed on the screen, and exceptions are being processed separately.
Sorry for the late response. Alexandra, I posted a question but I couldn’t care about it irresponsibly.
It is difficult to post a related example. I just want to verify it.
For example, when only numbers should be entered in hands-on-table, the user entered characters in hands-on-table. After that, I just want to make an exception so that when I use a function or try to take action, I can’t move on to that action.
I think we look at each other differently. What I’m talking about is to validate if it’s entered incorrectly by the user like the table above.
If a character is entered in a cell where a number is to be entered, such as in the table above, and the next action (function) is executed without verification or exception processing, a problem will arise.
If this is a problem related to storing data in the DB, an error will occur because it does not fit the DB data type.
As a result, before executing a function related to the table, I want to identify the incorrectly entered cell and give a warning message to the user without executing the function if there is an error.
Are the things I said related to the validate cell?