Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

datagridxl.com

Post reply on HN
Print view View original

101–110 of 136 posts

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#101

Post by koheripbal »

robbiejs wrote: post #2

Hello HN, I’m Robbert, the creator of DataGridXL.js. DataGridXL is a free (and commercial) editable data table library written in ES6. My goal is to develop the most performant & user-friendly spreadsheet-like data table out there: - It has zero dependencies. You don’t need any framework to use DataGridXL. - It is lightweight (~200kb) and easy to use. It does not even require messing with CSS. - It has its own Virtua…

When it comes to reporting, I always get asked if I can have grouped rows that can be expanded/collapsed - it's such a frequent request.

Is that possible in your framework?

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#102

Post by robbiejs »

koheripbal wrote: post #101
robbiejs wrote: post #2

Hello HN, I’m Robbert, the creator of DataGridXL.js. DataGridXL is a free (and commercial) editable data table library written in ES6. My goal is to develop the most performant & user-friendly spreadsheet-like data table out there: - It has zero dependencies. You don’t need any framework to use DataGridXL. - It is lightweight (~200kb) and easy to use. It does not even require messing with CSS. - It has its own Virtua…

When it comes to reporting, I always get asked if I can have grouped rows that can be expanded/collapsed - it's such a frequent request. Is that possible in your framework?

Hi, that's not possible, sorry. DGXL is mainly meant to be an editable input component, it's not a data table for presentation purposes.

Also see Features & Limits page: https://www.datagridxl.com/docs/features-limits.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#103

Post by robbiejs »

janci wrote: post #96
robbiejs wrote: post #47

Earlier quoted context omitted.

Thanks! I'd to write a proper "How It's Made" article about it in the future, but this is basically how it's done: There is a blank DOM node "scrollArea" in front of all others that catches the native JS scroll event. It then converts these scroll offsets (scrollTop and scrollLeft) to cell/viewport coordinates, by default 40px actual pixels per row/column. So if the scrollArea has a scrollLeft of 40px and a scrollTop…

There is a bug that is caused directly by this whitespace hack. If you copy two lines of text and paste it to one cell, it displays as two cells and shifts the column content below the affected cell (if the affected cell is in the viewport)

I am not sure if this is actually a bug, that will probably also happen when pasting those two lines to Excel or G. Sheets. Correct me if I'm wrong.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#104

Post by robbiejs »

infinite8s wrote: post #99
robbiejs wrote: post #53

Earlier quoted context omitted.

Hi, The component actually did have fixed/frozen columns/rows in an earlier version, but I decided to leave out the feature for a v1. I plan to reintroduce it after more popular features have been implemented. DGXL is able to handle hundreds of columns. The reason why it says 60+ specifically is that, according to browser-vendors like Mozilla, a DOM node should ideally not have more than 60 child nodes - for performa…

Are columns virtualized as well? That could get over the child node restrictions for performance.

Yes. Let's say your data grid has 200 columns, but only 10 columns (DOM nodes) are rendered in the viewport. The other 190 columns are cached.

When scrolling horizontally, column nodes are appended/preprended on-the-fly. The old ones are only removed if the scrolling stops (until that time, column nodes that are outside the viewport are just made invisible by setting their opacity to 0).

If a user scrolls really fast without stopping in between, they might have 200 column nodes in the DOM. The DOM nodes are then only removed when scrolling stops.

Performance wise I haven't seen any problems with 200 columns or more.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#105

Post by robbiejs »

araker wrote: post #97

How does this compare to ag-grid? Https://ag-grid.com

Ag-grid has a lot more features. Very mature, big team I'd guess. However, Ag-grid does not offer quick Excel-like editing. If you're looking for this type of editing, don't bet on Ag-grid.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#107

Post by dkersten »

robbiejs wrote: post #94
dkersten wrote: post #91

Earlier quoted context omitted.

> You'll always lose on one of the other. Absolutely agree and the open source alternatives tend to do one or two things only (while HoT, DGXL etc seem to offer a lot more in a single package), so for me, it came down to deciding what exactly do I need and if I need something else, maybe I need to use a different one for that. > I have to make sure that in my marketing I don't think you need to do too much over what…

Thanks for your feedback, really appreciate it! I think you're right that the "Reliable" feature might not tell the user much. Perhaps I need to show GIFs of other products to show the numerous ways these products get messy. Anyway, just an idea. Will think about it more, very good point. You're allowed to adjust the color & type of the branding link, as long as it remains visible :-)

Ah, great, I will try it out when I get time! Thanks.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#109

Post by janci »

robbiejs wrote: post #103
janci wrote: post #96

Earlier quoted context omitted.

There is a bug that is caused directly by this whitespace hack. If you copy two lines of text and paste it to one cell, it displays as two cells and shifts the column content below the affected cell (if the affected cell is in the viewport)

I am not sure if this is actually a bug, that will probably also happen when pasting those two lines to Excel or G. Sheets. Correct me if I'm wrong.

Yes, it is possible to paste cells in excel and shift cells below in Excel. But here the cells are shifted if the corrupted cell is visible and shift back if it's not. Definitely a bug.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#110

Post by robbiejs »

janci wrote: post #109
robbiejs wrote: post #103

Earlier quoted context omitted.

I am not sure if this is actually a bug, that will probably also happen when pasting those two lines to Excel or G. Sheets. Correct me if I'm wrong.

Yes, it is possible to paste cells in excel and shift cells below in Excel. But here the cells are shifted if the corrupted cell is visible and shift back if it's not. Definitely a bug.

Ah I think I know what you mean now. I think you mean when you paste multi-line text inside the cell value editor! You're right, thanks for spotting it!

This does not happen when you paste when the editor is not open, am I correct?

Post reply on HN