Hi,
thanks for your post, and sorry for the trouble.
Most likely, you are having issues in the columns that have a #N/A entry, right?
The reason for this is that those entries are not numbers, but text strings, and because of that the JS library that is used for the sorting will sort the entire column with a text string sorting algorithm, which is different to a number sorting algorithm.
The only real chance to change this is to remove those entries with numbers, unfortunately.
Regards,
Tobias
Thx for answer Tobias,
well It doesn’t have to be #N/A can be anything else. Do you have any suggestion what I could put there instead?
Hi,
it should be a number, so that it can be sorted appropriately… Is that possible?
Regards,
Tobias
Hi,
it could be zero but it would look stupid 🙂 In worst case I’m gonna put it there but would be much better to put sg like ?,-,N/A you know what I’m saying.
Thx a lot m8!
Hi,
I understand that something else would be great, but the sorting algorithm then simply doesn’t know how to interpret ? or N/A.
You would need to rewrite the sorting algorithm, or use the 0.
Regards,
Tobias
I see,
thanks a lot Tobias for your great work!!!
Hi,
no problem, you are very welcome! 🙂 Sorry that I didn’t have a better solution here.
Best wishes,
Tobias
