float number format with '0.00' sort in the wrong way

[frostynova]

Issue Summary

float number format with '0.00' sort in the wrong way

Steps to Reproduce

1. create a query with a float column
2. edit visualization, set its 'number format' to '0.00'
3. press the column sort button, the result is not in the number order

Technical details:

• Redash Version: v9.0.0-beta
• Browser/OS: Chrome 85.0 / Centos 8.2
• How did you install Redash: from github

[kravets-levko]

Hi @frostynova! Can you please share a screenshot with visualization with a bug, and sample of raw data? Also, if possible, try to reproduce this issue on our preview instance: https://redash-preview.netlify.app/ (it's built from latest master). Thanks!

[frostynova]

@kravets-levko it is a 'table' visualization

the 'order_price' column should be in descending order, but actually not

[kravets-levko]

Hm, looks like it's sorted using formatted string instead of raw values. @rafawendel can you please take a look? Thanks!