Live data from Hacker News

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

datagridxl.com

121–130 of 136 posts

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

#121
Hello everyone,

Not sure if anyone is still reading this thread. Just wanted to express that I am very grateful for all the positive responses that we got in this thread and by e-mail.

Also, good news: We just released a new minor version today that adds the much requested Sort Feature to the grid: https://www.datagridxl.com/demos/sorting-columns.

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

#122

Earlier quoted context omitted.

Hi. Can you explain what you mean by "incremental updates"? Regarding other bullet points: * Nested Grids: no * Formulas: no / not anytime soon * Column based filtering: not on top of the list, but definitely doable.

Hi, for an example, check out how the devxtreme datagrid uses a datasource object to manipulate the data in the grid in real time. Which means, instead of loading all the data into the grid before it is rendered at the time of declaration, the data can be appended, updated or deleted as it streams from a backend.

My issue with most grids (and charting libraries for that matter) is that the API is push based (ie they all have some kind of API like setData, etc), instead of pull based (where the grid utilizes an adapter model with simple functions like getRowCount, getColumnCount, getData(row, column) and you can build subclasses that adapt to any data model you have). This means that it's really difficult to implement highly performant grids that support changing data, more data than can fit in the current viewport, etc. It also makes it difficult to share large datasets between different views - ie a chart and table both showing the same data, or two tables showing different sections of the same dataset, without multiple copies of the data in memory.

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

#123

Earlier quoted context omitted.

Hi, for an example, check out how the devxtreme datagrid uses a datasource object to manipulate the data in the grid in real time. Which means, instead of loading all the data into the grid before it is rendered at the time of declaration, the data can be appended, updated or deleted as it streams from a backend.

My issue with most grids (and charting libraries for that matter) is that the API is push based (ie they all have some kind of API like setData, etc), instead of pull based (where the grid utilizes an adapter model with simple functions like getRowCount, getColumnCount, getData(row, column) and you can build subclasses that adapt to any data model you have). This means that it's really difficult to implement highly p…

Not 100% sure what you mean, but it sounds like a "server-side first" approach (if that word exists). As grid & chart libs are always built by (front-end) Javascript experts, you'll always see a front-end first approach.

However, have a look at this Codepen example: https://codepen.io/datagridxl/pen/XWXGGGq?editors=0010. It combines amCharts and DataGridXL. Update any value in the grid and see the chart adjust. Quite snappy right?

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

#124
post #109

Earlier quoted context omitted.

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?

Yes, exactly.

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

#125
post #124

Earlier quoted context omitted.

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?

Yes, exactly.

Thanks! Bug will be fixed in next update (upcoming week)

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

#126

Earlier quoted context omitted.

Hi, for an example, check out how the devxtreme datagrid uses a datasource object to manipulate the data in the grid in real time. Which means, instead of loading all the data into the grid before it is rendered at the time of declaration, the data can be appended, updated or deleted as it streams from a backend.

Ah, sounds good. Do you mean the grid keeps front-end and back-end data synced? DGXL does not offer that at this moment. You could probably recreate something like it by using getData and setData methods and implement some kind of AJAX communication.

The grid itself doesn't proactively try to equalize frontend and backend data, but I utilize backend orm signals to generate websocket events which are then captured by a javascript callback in the frontend and sent to the grid. The grid then updates immediately reflecting the changes. There is no need to send the entire dataset, though, just the changes.

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

#127

Earlier quoted context omitted.

In the docs they precisely tell that this is not supported https://www.datagridxl.com/docs/features-limits

Hi, you're right. At this time it's not supported, but we're working on it. Probably next week. The other features are still a definite "no" for now :-)

Thanks for the update!

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

#128

Earlier quoted context omitted.

Ah, sounds good. Do you mean the grid keeps front-end and back-end data synced? DGXL does not offer that at this moment. You could probably recreate something like it by using getData and setData methods and implement some kind of AJAX communication.

The grid itself doesn't proactively try to equalize frontend and backend data, but I utilize backend orm signals to generate websocket events which are then captured by a javascript callback in the frontend and sent to the grid. The grid then updates immediately reflecting the changes. There is no need to send the entire dataset, though, just the changes.

Is that what "dataSource" does? (https://js.devexpress.com/Documentation/ApiReference/UI_Widg...)

I don't know DevExtreme and I have to admit that I find the API Reference a little overwhelming. If I can introduce more ways to communicate between back-end and front-end, I am all for it of course.

Do you think the websocket approach for grid/tables is a common one among web devs? A link to a specific code example would help me understand the approach better.

Thanks for your feedback!

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

#129
post #124

Earlier quoted context omitted.

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?

Yes, exactly.

Hi janci, just letting you know that the bug has been fixed. Thank you for spotting it!

The current solution that I came up with: replace \n with Return HTML-entity. Not sure if that is the best solution for you (or anybody else) but at least it prevents the unwanted shift of column contents.

Thanks again!

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

#130
post #8

Earlier quoted context omitted.

That title flashing "1 new message" nonsense is incredibly distracting. Is there a UI way to quickly sort by a column?

sorting + filtering would be awesome too

Hi,

I've just released a new version that adds a Sort Feature to the grid: https://www.datagridxl.com/demos/sorting-columns.

Post reply on HN