Jspreadsheet CE VS React Data Grid

For the spreadsheet, we use the excellent Jspreadsheet library. If there are no errors, the import happens in two steps because importing a lot of locations requires a lot of calls to the Mapbox geocoding API (geocoding is converting an address to longitude and latitude), which is rate limited.

There is a presentation at FOSDEM 2021 about FDL: https://fosdem.org/2021/schedule/event/fosstaxbreak/

Title: Give open source a (tax) break

Cash that gets into FDL/LEF is then spent to sponsor existing FLOSS projects or to acquire intellectual property rights of existing works and change their license to FLOSS.

Case 1: https://bossanova.uk/jspreadsheet/v4/ got financed partly by FDL/LEF

Case 2: the radio hardware of the Open Radio Station (a 4G/5G vRAN base station based on Amarisoft stack and SlapOS) is in the process of being acquired and released as open source hardware. See https://shop.rapid.space/product_module/241/Resource_viewAsS...

The requirement for PhD is here to ensure that all projects that are financed by FDL/LEF have some kind of general interest or innovation, something which is useful to comply with Tax Law

Yeah maybe in that case you can use jspreadsheet

It’s called a DataGrid. I would not implement my own. https://github.com/adazzle/react-data-grid

Data Grid - https://github.com/adazzle/react-data-grid

Do you mean grid like CSS grids https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Grid_Layout or do you mean grid like data grid https://www.npmjs.com/package/react-data-grid ? Because I think people are assuming in their answers you mean the former. If its the second one its a whole other discussion.

I am using react-data-grid component. It provides a grid structure with edit and lot more options. When we click on each cell, we are able to edit the content of the cell. In my project, I have a situation like when the date column is focused I want to bind a UI where the user can able to select the date.for that, I have used react-datepicker component. I am able to give react-datepicker component as a formatter in the date column option. I can able to change the date in the react datepicker component, but that is not updating the cell value (when you click on the console data button you can able to see the changes have been updated or not).so guys help me how I can update the cell value when a different date is selected in the react-datepicker component. It happening automatically when the value is changed in other cells.

no, i missed that one when i was searching, but from the homepage and a quick glance through the docs it doesn't seem like it does what i need. what i want is something like react-data-grid [https://github.com/adazzle/react-data-grid] but with a backend component that handles collaborative updates. essentially a stripped down and actively maintained alternative to ethercalc [https://ethercalc.net/]

baserow had a lot of what i wanted, but the top-level feature set seemed very oriented towards a db admin tool rather than a programmatically managed user interface to single tables or views.

I have a bulk of tabular data that I'd like for my users to be able to manipulate with a lot of the kind of standard spreadsheet functions like filter, sort, search. Generally I'm more interested in read than write. I can across: https://github.com/adazzle/react-data-grid

I has dnd grouping, but it falls short on server side rendering. It seems like the maintainers are not interested in implement this feature(https://github.com/adazzle/react-data-grid/pull/1459)

I'm trying to add excel like filtering to react-data-grid with primereact multiselect and running into some problems with the dropdown closing. By excel like filtering I mean when you apply a filter that updates all the other filters options instead of keeping the total options always. Here is a codesandbox that show the problem. So basically I want the dropdown to stay open even when the dropdown options change. Also you would notice this kind of makes a multiselect useless since the current filter your on will always be filter down to 1 option. So the current filter being changed should not change options but all the others filter options should change.