rowsncolumns

8 ms·

1. 31.▲
   by rowsncolumns 3y ago

   Yes. We are working on adding support for aggregation and pivoting using https://github.com/finos/perspective
2. 32.▲
   by rowsncolumns 3y ago

   Thank you :)
3. 33.▲
   by rowsncolumns 3y ago

   Ah. Could you share more on how you got this error, Maybe i should setup sentry.io for the demo.
4. 34.▲
   by rowsncolumns 3y ago

   Oops. Fixed, thats the handle i wanted, but it was taken :)
5. 35.▲
   by rowsncolumns 3y ago

   Could you share which phone you were using? We use virtual rendering at both row and column level.
6. 36.▲
   by rowsncolumns 3y ago

   Thank you. Collaboration is always a hard-one which requires both UI and database sync.
7. 37.▲
   by rowsncolumns 3y ago

   Hi, Its not related to that project. Its an update to an already existing project under RownsColumns, hence the name.
8. 38.▲
   by rowsncolumns 3y ago

   I think the question can be will a user wants to see 1M rows at a time. Probably no. Spreadsheet uses virtualisation to display data, ie only data viewable in a Row x Column viewport is displayed. This improves rendering performance. Data p
9. 39.▲
   Show HN: React Spreadsheet 2(rowsncolumns.app)

   356 points by rowsncolumns 3y ago|132 comments
10. 40.▲
    by rowsncolumns 3y ago

    Create your own Google sheets like Spreadsheet UI in your application using RowsnColumns Spreadsheet 2. Declaratively render cells, embed external content, use custom formulas, collaborate with other users all using composable ReactJS UI co
11. 41.▲
    by rowsncolumns 6y ago

    Images are now supported in cells. Global key handlers for copy paste is now optional, you can pass a prop to enable it. https://rowsncolumns.app/demo
12. 42.▲
    by rowsncolumns 6y ago

    Thanks. Pivot table is a hard one. Doable. In a new Sheet, like how google sheets does. Some kind of a Layout Component that has top/left/right/bottom bounds, and access to sheet data
13. 43.▲
    by rowsncolumns 6y ago

    Hey Robbert.. Thank you :) And congrats on your launch too. Wish you all the best.
14. 44.▲
    by rowsncolumns 6y ago

    Yes. If you are able to write custom formulas and async handlers for these formulas, I think this is certainly possible.
15. 45.▲
    by rowsncolumns 6y ago

    Thanks for reporting. 1. Fixed 2. Thats because React State of all the cells are updated. One way is to reduce the number of columns. Currently the grid size is 1000 x 1000, which means 1 million objects needs to change. Need to think of a
16. 46.▲
    by rowsncolumns 6y ago

    Formula support is in our roadmap. Keybindings can be added easily. I disabled global key handler for copy/paste/undo/redo for now, but that can be enabled. Images inside cells are pretty straightforward. I will update the do
17. 47.▲
    by rowsncolumns 6y ago

    This is mainly targetted at companies who wants to have an in house web-based excel-like grid in their application. 1. It can be a used to build Apps that render multiple tables in a Sheet. Or a CryptoCurrency trading app where numbers tick
18. 48.▲
    by rowsncolumns 6y ago

    On Mobile, you can view and scroll through the data, but lacks support for selection and editing. This is something that I am looking at. Will come back to this depending on urgency :)
19. 49.▲
    by rowsncolumns 6y ago

    Hi, I don't have an exact timeline yet. If you are looking for simple calculations, you can try this workaround - https://rowsncolumns.app/docs/formula Do note that this wont scale for larger applications. You wou
20. 50.▲
    by rowsncolumns 6y ago

    Thanks.. There are some areas of improvement with Copy/Paste, especially formatting. Right now, i strip out formatting during paste https://github.com/rowsncolumns/grid/blob/master/packages/gr..
21. 51.▲
    by rowsncolumns 6y ago

    Hi, I have not shipped Core support for formula yet. Working on it actively Multi-Selection mode is a WIP https://rowsncolumns.app/docs/formula#multi-selection-mode
22. 52.▲
    by rowsncolumns 6y ago

    Good find. Tracking the issue here https://github.com/rowsncolumns/grid/issues/62
23. 53.▲
    by rowsncolumns 6y ago

    Thank you. 1. Commercial pricing is per developer. Otherwise it can be misused 2. No 3. Formula parsing module that I am building is capable of running in a Web Worker or in the same UI thread. For lag-free calculations, Web Worker is prefe
24. 54.▲
    by rowsncolumns 6y ago

    I can only give you the reasons why I picked canvas. So here you go. 1. Scroll performance is much better than HTML 2. Drawing on canvas is cheap compared to modifying DOM or attributes 3. Streaming updates are much smoother in canvas as dr
25. 55.▲
    by rowsncolumns 6y ago

    On mobile, we support view only mode. Edit mode is not compatible. But we can add it to our roadmap if more users ask for this. I doubt a lot of people edit excel files on mobile. I maybe wrong.
26. 56.▲
    by rowsncolumns 6y ago

    This is something i was very particular about from Day 1. It's quite hard to get smooth scrolling, even in canvas. Still lots of optimisations to be done, but i will never sacrifice anything for a smooth scrolling experience :)
27. 57.▲
    by rowsncolumns 6y ago

    Thanks for the support :)
28. 58.▲
    by rowsncolumns 6y ago

    Yes you can https://rowsncolumns.app/docs/features/hidden-rows-columns I did not add this options to the Context Menu yet.
29. 59.▲
    by rowsncolumns 6y ago

    For a web based excel tool, Google Sheets has really good performance IMO. Other alternative is Microsoft Online Excel, which is quite slow, bloated and cough horrible. If you have highly interactive data in cells, (eg: svg graphs), scrol
30. 60.▲
    by rowsncolumns 6y ago

    Awesome Glad you liked it.