ParamQuery grid support forum

General Category => Help for ParamQuery Grid (free version) => Topic started by: arti on March 06, 2024, 04:51:05 pm

Title: decimal separator in copy / paste operations
Post by: arti on March 06, 2024, 04:51:05 pm

I'm testing ParamQuery for some project that will have to accept paste values from Excel sheet. In my country we use , (colon) as decimal separator, and this is why ParemQuery grid doesn't accept float values pastes from Excel that has decimal value. Similar problem is with copying values from grid to Excel. Is there any way to fix it?

Title: Re: decimal separator in copy / paste operations
Post by: paramvir on March 06, 2024, 05:42:23 pm

try to use beforeVaildate event to replace decimal operator "," with "."

Similar post is here: https://paramquery.com/forum/index.php?topic=1496

API of beforeValidate event: https://paramquery.com/api#event-beforeValidate