Author Topic: paste numbers w/commas to float column  (Read 2045 times)

jamey

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 1
    • View Profile
paste numbers w/commas to float column
« on: March 28, 2016, 06:44:02 pm »
Is it possible to paste numbers that have been formatted with commas to cells in a column with a dataType of 'float'?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6260
    • View Profile
Re: paste numbers w/commas to float column
« Reply #1 on: March 28, 2016, 10:00:35 pm »
By default only float numbers (without formatting) can be pasted to dataType: float columns.

But it can be customized by removing commas in beforeValidate event:

In this example jsfiddle, numbers with commas can be pasted to revenues column.

http://jsfiddle.net/o2uh67ue/1/
« Last Edit: March 28, 2016, 10:10:01 pm by paramquery »