SC-IM: Vim-based Terminal Spreadsheet Editor!

Thanks to Michael Novella for this recommendation!
---

[and]

Thanks for reviewing the app I am working on! Answering some of your questions.. you can :set overlap to have the behaviour you want in 3:45. Regarding pasting content adapting cell reference, s you should yank with normal 'y' and then you should paste content with 'Pc'.. Hope you make another video showing sort content, add subtotals, colors, plot, etc.. Thanks again!

[kruruneiwyn]

i'm subscribed to a shit ton of people on youtube but your uploads never fail to satisfy me.
love the videos, keep it up buddy

[АлександрГнатюк-къ]

What can bring more happiness than a way to move yet another part of my workflow to the terminal! I was literally clapping when I saw you using all these key bindings :)

[desktorp]

Gotta sit down with young Terence about that GPA. >:(

[eliasgill]

So many years latter, but you can insert ranges quickly with marks. To make a mark use visual mode, select the cells you want, then press "m" and another letter (just like vim marks).


I hope you can try it out. It makes life way easier.

[mxmedley]

This video is ages old, but to paste with offsets like at 9:40 you can use `Pc` or "paste, copy offsets" (capitalization matters)

[xtnctr]

Jesus this will change my life. Luv you, Luke.

[finndriver]

Linux had SC (spreadsheet calculator) for decades. The major advantages over SC are colour and unlimited undo.
(I mean, org mode is my preferred method, but yanno)

[lsutoob]

Great overview. Would love to see you revisit sc-im more in-depth.

[julietta]

Dude thanks for this. This is the only reason I still have Libre office installed. Now I'm gui free!

[Argletrough]

I've looked at sc and sc-im and prefer the keybindings in sc.
The aim of sc-im seems to be to emulate Vim superficially, whereas sc does things in a way that seem to work better for what it does.
As a nice bonus, sc does a better job of self-documentation, with man sc, /usr/share/doc/sc/tutorial.sc and the ? menu within the program itself giving you most of what you need to know.

[seanrodgers]

What a great find. Never been happy with spreadsheets since I could no longer use Lotus 123 in text mode.

[lumumbria]

This is great, Luke!! CLI-spreadsheets!!

[shawnmurdock]

Wow I am just seeing this. I guess I have been in IT/Computers so long I have come full circle. This is how I started with spread with a little program called 123.

[reimarpb]

I love the shortcuts for insering text (<, >, \) simply because I'm Danish and on the standard Danish keyboard layout, those are all on the same key

[thingyee]

To move that avg and make it relative you probably need to add a relative tag / character such as a $ dollar sign or something. Excel has something like this for relative cells in long formulas. e.g. $A$1

[PaniacThrilla]

He keeps saying Excel. I really hope he means like a libreoffice sort of thing. The thought of Luke Smith using Windows even four years ago makes my blood run cold.

[Eugensson]

It is super funny. As a heavy excel user i really miss Excel bindings when i am using VIM. Usually when you are an excel ninja, you never use mouse and rely on shortcuts and bindings heavily.

[TuxxFF]

0:03 lol holy shit, is that how you move a window in a tiling manager 😅

[Cheng]

Hey man, I really like this kind of videos, it's really really cool, thank you so much