Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: A terminal spreadsheet editor with Vim keybindings

github.com

Post reply on HN
Print view View original

41–50 of 54 posts

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#41

Post by garritfra »

nanis wrote: post #39

This looks good, but, I noticed: > 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…

This is valuable feedback. I opened two issues to track this:

Use numerically stable algorithms for SUM and AVERAGE: https://github.com/garritfra/cell/issues/43

Keystrokes doubled in Windows Terminal: https://github.com/garritfra/cell/issues/44

Thanks!

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#42

Post by marcyb5st »

garritfra wrote: post #18
marcyb5st wrote: post #4

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.

Update: This just landed in v0.1.7. Thanks again for bringing this up!

My pleasure!

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#43

Post by teo_zero »

garritfra wrote: post #15
ximm wrote: post #14

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 bo…

Thanks for trying it, and the spreadsheet repo is great prior art — I'll dig through it. Drag-fill. Not yet, but the parts are mostly there. The formula layer already carries abs_col/abs_row through tokenization → AST → eval, so $A2 + B$1 parses correctly today; what's missing is the editing op that copies a formula across a range and shifts only the relative components. Opened #17 for it. The tricky part isn't the r…

> Vim doesn't have an obvious idiom for "drag," so I'm leaning toward a visual-selection + fill-from-anchor key (Y is a candidate)

Better I or A, to mimick vim's multiple insert after a block selection.

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#45

Post by adilkhanovkz »

WillAdams wrote: post #3

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.

Dimensions over A1/B2 is the right move. Rust is a good base for the engine — formula propagation in dimensional models needs to be fast. Curious whether the bigger challenge is the engine or the UI layer

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#48

Post by PaulBunch »

This is really cool. The cell alignment and overall scannability are excellent.

One thing I’ve noticed in many TUI tools is that even small inconsistencies in character width or icon rendering quickly become annoying. Did you run into any tricky rendering/alignment issues while building on ratatui?

Re: Show HN: A terminal spreadsheet editor with Vim keybindings

#49

Post by akshayKMR »

Looks cool! Reminded me of ironcalc - rust based project that aims to have full excel parity. Linking it in case you might want to reuse/contribute to that engine.

- https://www.ironcalc.com - Also found a tui interface for it - https://github.com/zaphar/sheetsui

Post reply on HN