Sorting generic cell type with numeric values

Sorting generic cell type with numeric values

Posted by: mmeghani on 20 February 2018, 7:37 am EST

• 

  mmeghani

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 February 2018, 7:37 am EST

  I have generic cell type that has numeric values. When sorting it the result sorts as string. I want to sort the column as Numeric.
  
  eg:
  
  1,228.00
  
  1,473.00
  
  1,596.00
  
  1,718.00
  
  1,964.00
  
  2,209.00
  
  2,455.00
  
  21,180.00
  
  246.00
  
  246.00
  
  491.00

  It sorts the string and not as numeric values.

  How can I use the SortColumnCommand to accomplish this. Please provide sample in c#.
  
  Thanks

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2018, 1:15 am EST

  Hello,

  With GeneralCellType the string values will be sorted as strings always. You would need to either create a custom celltype or simply use some number /integer cell type.

  Thanks,
  
  Deepak Sharma