search

tgrosinger / md-advanced-tables

A text editor independent library to enable formatting and Excel-style navigation, and spreadsheet formulas to Markdown tables.
MIT License
149 stars 30 forks source link

Sorting dates by ascending / descending #60

Open tjex opened 2 years ago

tjex commented 2 years ago

Is your feature request related to a problem? Please describe. Sorting ascending or descending for date is either not yet integrated, or is buggy. I am trying with format 2021-11-30 (YYY-MM-DD)

Describe the solution you'd like To be able to sort dates / numbers ascending and descending via a button in the sidebar (currently where other options are also found)

Additional context Obsidian v0.12.19 Choosing Ascending / descending simply swaps the two months of November with each other. It does not move December to the top or bottom.

Screenshot 2021-12-10 at 00 04 25

julianmueller commented 2 years ago

Also some unexpected behavior with sorting ascending/descending with capital letters. It sorts all capital letters at first and afterwards those with small letters.

What I expect to be sorted:

antilope
Cat
date
Dog
elefant
Fancy
girl

What the plugin does:

Cat
Dog
Fancy
antilope
date
elefant
girl

Maybe it needs an option to toggle these?

architchandra commented 1 year ago

I also need this. Would be fantastic if the plugin has the ability to understand dates and sort the table based on date and datetime timestamps. Thanks!

tgrosinger commented 1 year ago

This also might relate to #31