Sort fails on currency and commas

INN / responsive-tables

Responsive Table embed generator; 🚨no longer supported 🚨

hxxps://inn.github.io/responsive-tables/

MIT License

25 stars 10 forks source link

Sort fails on currency and commas #16

Open akanik opened 10 years ago

akanik commented 10 years ago

I thought at first my issue was related to having a number in the column header, but removing that and do some trial and error made me realize that the column sorting wouldn't work on currency columns or columns where thousands are separated by commas.

Is this a known issue?

akanik commented 10 years ago

Sorry, here is the spreadsheet I'm trying to use: https://docs.google.com/a/publicsource.org/spreadsheets/d/1tFSamPr7x3s16dLJnsQfQZZsQKbD1SIyZSaYSziJtBw/edit#gid=0

rnagle commented 10 years ago

I think this is related to issue #13. Unfortunately the only workaround I can offer right now is removing commas and dollar signs from the data.

akanik commented 10 years ago

Update: I tried to create a chart using google spreadsheet and the same issue occurred. Searching for google spreadsheet issues brought up nothing...

benlk commented 8 years ago

A duplication: http://sarahglen.com/chalkbeat/RTTTmoneyspent/index.html

but the money spent column isn't sorting correctly. at first i thought it was because of the dollar signs i included, but after removing those it's still not sorting the money spent column correctly and i'm not sure why. have you seen this happen before?