HN

Comments (43)

• Menu

  freedomben
  Very neat, a tool like this is badly needed. Also cool to see it's in rust (that means I can hack on it).To be really useful to me though (and I would imagine others), it will need to be able to at least view (but probably edit) xlsx and/or open document format spreadsheets. I know that's a huge task, but it would add immense value to the project. I'm not asking for it and I don't feel "entitled" to it (lest the inevitable replies of "add it youself" come flying in), just trying to provide some helpful feedback.Question: is this a project you see yourself staying committed to long term? (Obviously life events happen and things change, but at least for now, do you enjoy it? Do you use it as part of your workflow? Do you feel like it's something you'll want to own long term?)
• Menu

  rpassos
  I've been using https://github.com/medialab/xan for anything csv. It's the best tool there is for reading and analyzing csv files, but not for writing them. Something like cell-sheet-tui would fit my workflow very well, since I am using neovim to edit csv files manually (as well as some csv merging features offered by xan to simplify the process).The reason why I find your software promising is because dealing with csv in plain text is very disorienting with the inconsistent horizontal cell space. A csv-aware text editor would help a lot there with two issues in particular:- not having to set commas manually, especially not having to count them between empty cells- being able to navigate using h/j/k/l between cells instead of having to get creative with vim-motions on plain textOP, if you're reading this:I would greatly appreciate if this tool could focus on the writing experience and less with anything formula engine related, since xan is already a very performant tool for that, even at large data sets. Replacing or even competing with xan seems very difficult in my eyes, considering both tools are targeting a similar audience (rust, minimalist, and performance), which makes me think cell could focus more on the writing experience, like I said.There are some bugs I countered right away and I'll get to open issues in due time. Thanks for making this and I hope I can replace neovim with cell for anything csv in the future!
• Menu

  nanis
  This looks good, but, I noticed:> Supported Functions (v1) > SUM, AVERAGE, COUNT, MIN, MAX, IFI would recommend switching to numerically stable algorithms for adding numbers and taking their averages sooner rather than later.Looking at the code[1], it looks like you are simply summing the numbers and dividing by count. If that is indeed the case, please switch to a stable average[2]. See also [3].Additionally, I tried to test the executable[4] on Windows, but there is something wrong with input. Using Windows Terminal Version: 1.24.10921.0, characters are doubled on input. Regular Vim compiled using Visual C++ does not have this issue.When I press `:`, I get `::` in the COMMAND line. Then, every key I press gets doubled. This means I cannot `:q!`. :-)[1]: https://github.com/garritfra/cell/blob/99b0afc7a60a871b27452...[2]: https://www.nu42.com/2015/03/how-you-average-numbers.html[3]: https://en.wikipedia.org/wiki/Algorithms_for_calculating_var...[4]: https://github.com/garritfra/cell/releases/tag/v0.2.0
• Menu

  k2enemy
  Looks terrific! I have a suggestion as you continue to add features and think about scripting. sc-im has lua external functions, but you cannot pass a range of cells, only the value of one cell. This severely limits the usefulness of external lua scripts. If/when you add scripting, hopefully you can overcome this limitation. If so, you'll have at least one more user!
• daft_pink
  It’s really amazing how spreadsheet started in the terminal and have come full circle back to the terminal.This is fantastic thanks for your work
• Menu

  marcyb5st
  Pretty cool project! Congrats.QQ: does it support programmatic cell access/modifications?Eg `cell file.cell --write A2 "42"` or `cell file.cell --read "=SUM(A1:A10)"`? Couldn't surmise that from the glimpse I gave the README, but it would be pretty cool for scripting stuff.
• Menu

  pca2
  Very cool, I was just wishing for a tool like this today. A small feature request I would love to see: Support for custom delimiters. I sometimes work with CSVs that actually use pipe (|) as the delimiter to avoid issues with cells that contain commas as content.
• Menu

  SilentEditor
  Cool project!The Vim modal model feels almsot native for spreadsheets, and splitting the formula engine into a TUI-free core was prolly a great architectural choice.How are you thinking about recalculation, dependency tracking, and undo/redo as the sheet grows, especially once multi-cell edits and larger CSVs start stressing the core?
• teo_zero
  The equal operator should work on strings, too. It would allow formulas like IF(A1=C3,A2,0)
• Menu

  slu
  Nice. I've been using https://github.com/andmarti1424/sc-im for a while now. It would be great with a comparison.
• iammrpayments
  I wonder if you can beat the excel world champions with that: https://youtu.be/QwNoFOUiSiE?si=4tKFWCAuFtWFHo34
• Menu

  ximm
  I was working on something similar a while back (https://github.com/xi/spreadsheet) but ended up not using it. I just didn't end up being the first tool that came to mind when I was reaching for a spreadsheet. Not sure why.I will definitely try out your tool and check if it works better to me.Two random thoughts:- In excel I often use the dragging feature, i.e. use a formula like $A2 + B$1 and then drag it in both directions. Does your tool have something similar?- Another nice feature are visualizations. In my tool I added a bar() function that renders a value between 0 and 1 as a bar in the cell. Not sure how flexible that is, but I did have some fun with it.
• Menu

  WillAdams
  Was initially hopeful that this would rather than have A..B..C... and 1..2..3... for columns and rows would instead have one creating categories à la Javelin/Lotus Improv/Quantrix/Flexisheet --- give me that, and have a dynamic system for displaying a pane of formulae and one would have a _very_ nice tool.
• immccc
  The kind of stuff that once you see it, you think "how didn't come the idea up to me?" :)Only thing is that it would be great to have it as a vim plugin, so that after opening a .csv file or similar, you can make use of the spreadsheet tooling.
• reagle
  visidata is vim influenced.
• Menu

  Theaetetus
  This is great. I often want a low-latency, minimal-feeling option for this sort of thing. (And I get to use my Vim muscle memory less and less often these days!)Really, thanks for making and sharing this; so far, I feel calm and happy when I'm using it.
• lydericlandry
  This is very nice!See also: https://github.com/maaslalani/sheets
• Menu

  jzer0cool
  Looks great something I want to check out. For comparison anyone share some built-in tools to pretty print-only the csv? Usually what I need to start but formatting is quite off.
• Menu

  unlikelyusernam
  forgive me if I'm missing something obvious, but is there any plan to add jumping to a specific row? Usually when I scroll and find the row I'm looking for, I'll just nG there (where n is the row I found), which in vi-esque editors will jump to that specific line.
• bytejanitor
  Looks very nice at first glance.I have been looking for something like this for a long time. Maybe this has some potential to become somewhat popular.
• tpoacher
  i'll try this next time i'm on my laptop, but for now, how does it compare to visidata (which is a long standing peoject already?)
• Keyframe
  Lotus 1-2-3 flashbacks kicking in. I'll try it out for sure.
• voidtools
  Good luck