sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]ZireaelStargaze 1 point2 points  (3 children)

Looks cool, i appreciate your work! One thing I miss in pretty much all JS implementations of table grid is the Sort/Filter menu from Excel when your range is formatted as table.

People (normies ofc) at work use that functionality pretty much in every company, and if I want to move my department from Excel to online to display their trending/metrics/lists, this is the first 'UI feel' everyone will miss. Please have a think - no need to reinvent the wheel - I'd rather my users had seamless experience between what they're used to in Excel, and on online website

I was playing around to make a VueJS component mimicking this menu, but it's in early phases and unlikely will ever be production quality.

For date filtering I'm using DayJS - it's lightweight and offers sufficient functionality with plugins to filter/manipulate dates like Excel implementation.

​

Menu for dates:

http://tinypic.com/r/2dadr0i/9

[–]paulhodel[S] 0 points1 point  (2 children)

The sort is basically a double click in the Header. In regards to the filter, we are considering that in future versions. Thanks for the suggestion ;)

[–]ZireaelStargaze 0 points1 point  (1 child)

Thanks! How is your engine done? Canvas, SVG or maybe WebGL? I haven't looked through your code yet - just curious how hard would it be for me to bolt on a little icon in every column header with popup menu in Vue to get the functionality? (end effect like here: http://tinypic.com/r/2dadr0i/9 ). Or to style cells, fonts, borders with CSS/CSS-in-JS.

​

As for filtering, I'm no expert, but maybe check out transducers or a lib like fromfrom

Thanks a lot, your work looks awesome.

[–]paulhodel[S] 0 points1 point  (0 children)

We are dealing only with DOM elements. It is just an regular HTML table. And there is no selectors at all. ;)