31–40 of 54 posts
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.
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.
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 ine…
XLSX and ODS support won't be trivial, but I see the value of having it. I added it to the roadmap: https://github.com/garritfra/cell/issues/22
Regarding your question: This idea has been sitting on my todo list [1] for over 3 years now. I don't usually work with large data files in my dayjob, but occasionally working with the odd CSV on macOS frustrated me enough to put it on the list. And now that spec-driven development has matured enough to be actually useful, there's no real excuse not to build this.
I genuinely see myself caring for this long-term. I'm comfortable with the scope, and there seems to be some real interest from the community.
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!
Saved you all a search: It seems like it is similar software written in C
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.
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!
Nonetheless, I think it's an intersting discussion to put on the roadmap: https://github.com/garritfra/cell/issues/23 (RFC sketched out by AI)
Thanks!
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.
> Supported Functions (v1) > SUM, AVERAGE, COUNT, MIN, MAX, IF
I 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...
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.
Thanks for bringing this up!