
Originally Posted by
Erwin69
In my grid I have also columns with percentages (e.g. 7.3% and 54.9%) and columns with dimensions (e.g. 7.2cm and 14.6cm or 3.1" and 6.2"). MSFlexgrid sorts these without problems using the Numeric sorts, but the VBFlexGrid doesn't. What is the recommended way to sort these?
Need to test... and if something needs to be enhanced.
Worst case "custom sort option" which raise event.
Edit: you may store the percentage as number only and use .ColFormat property to add the "%" char as formatting. Thus the sort would work as immediate solution.
Btw. you can sort also using the cell property
Code:
.Cell(FlexCellSort, Row1, Col1, Row2, Col2) = flexSortStringAscending
This way you don't need to bother change row col etc. and to restore it..
Edit: please continue in the VBFlexGrid thread!