Author Topic: decimal separator in copy / paste operations  (Read 366 times)

arti

  • Newbie
  • *
  • Posts: 1
    • View Profile
decimal separator in copy / paste operations
« 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?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: decimal separator in copy / paste operations
« Reply #1 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