Ordering by value not accurate enough

[Krukarius]

I have some values such a:

43

12 5 11 16 18 51

when sorted by table, I got:

11 12 16 18 18 43 5 51

Could you tell me where can I fix the code and make these values in right order?

[deltamualpha]

That comes in from the Sheetsee.js dependency; https://github.com/jlord/sheetsee-tables/blob/master/index.js#L20 looks to be your point of interest. It's doing a ASCIIbetical sort.

[Krukarius]

Hi,

I tried twice the example https://github.com/jlord/sheetsee-tables/blob/master/index.js#L20, but I see no reaction at all.

The code, coming from there feature only ShowInfo function, which is the same in your project. I entered sheetsee.js and found possibly relevant stuff inside:

1506 line: var sortable = [] for (var category in count) { sortable.push([category, count[category]]) } sortable.sort(function(a, b) {return b[1] - a[1]}) return sortable // returns array of arrays, in order }

7905 line: queue.sort(function (a, b) { return a.distanceTo(center) - b.distanceTo(center); });

16138 line:

module.exports.sortThings = sortThings function sortThings(opts, sorter, sorted, tableDiv) { if (opts.tableDiv != tableDiv) return opts.data.sort(function(a,b){ if (a[sorter]<b[sorter]) return -1 if (a[sorter]>b[sorter]) return 1 return 0 }) if (sorted === "descending") opts.data.reverse() makeTable(opts) var header $(tableDiv + " .tHeader").each(function(i, el){ var contents = resolveDataTitle($(el).text()) if (contents === sorter) header = el }) $(header).attr("data-sorted", sorted) }

Any advice cordially appreciated! Thank you

[deltamualpha]

@Krukarius hack-spots isn't my project; I just used to use it for a site (i've since rewritten it to not use sheetsee.js since I didn't need most of its functionality).

The sheetsee.js in this repository is a compiled, minified version of the one that I linked to above. If you want to modify it, you should fork sheetsee-tables, make your changes, compile+minify a version that has the sorting you want, then add it to your fork of hack-spots.

[Krukarius]

OK, thanks. So in this event maybe someone else can advise?