AnnaP
  • AnnaP
  • Newbie Topic Starter
2020-07-21T15:26:02Z
Hello,
I noticed an error in sorting when there are negative whole numbers. See screenshot for details. What is the workaround to this?
Bug in sorting.jpg

Click to View Image25 View(s)


Sergiy/10Tec
2020-07-22T03:01:24Z
It happens because you mix int and float values into the column. The workaround would be use floats for all cells.
Like this:
Rows(1).Cells(0).Value=-1235.0;
Rows(5).Cells(0).Value=1235.0;