Erroneous currency sorting

  • Resolved lucaspanjaard

    (@lucaspanjaard)


    8 years, 1 month ago

    Dear Madam/Sir,

    I’ve noticed that sorting € currency doesn’t work properly if the to be sorted amounts contain both hundreds as thousands.

    Considering my tables at milan-rent-averages/ sorting seems to be working fine when the to be sorted amounts only contain hundreds (see Rent P/M at Room table) or only thousands (see Rent P/M at Apartment table).

    However, when the to be sorted amounts contain both hundreds and thousands, sorting malfunctions. See Rent P/M at Apartment table at naples-rent-averages/.

    I’ve copy pasted the amounts straight from Excel. The amounts are both currencies in Excel as in the Supystic back-end.

    In the Sypystic back-end, I can remove the thousand-dot. Then sorting works fine. But I’d like to keep the dot format. Any suggestions?

    With kind regards,

    Luca

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author supsystic

    (@supsysticcom)

    Hello!
    Thank you for contacting us regarding this issue.
    We will fix this problem in next version of Data Tables plugin. I will inform you about the updates.

    Plugin Author supsystic

    (@supsysticcom)

    Also please that in Rent P/M column you are using separator for fractional part. Therefore sorting feature works incorrect in your table. You need to use only numbers in your table (remove dot for all cells, because dote is recognized as separator for fractional part in your table) and enable “Use Number Format” option. Then set such format – “1,000” for “Number Format” feature and your table will show correct data and will sort these data in correct way. Also you can set currency format for Rent P/M column and remove this symbol “€” from cells.
    Besides we will fix fractional part for “Number Format” in next version of plugin, and you will be able

    Plugin Author supsystic

    (@supsysticcom)

    Hello!
    We have fixed the Sorting issue in Data Tables plugin and released new version with fixes. Update plugin and check sorting feature in your table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Erroneous currency sorting’ is closed to new replies.