3 ms·
I use Option-Enter (on Mac, which is probably Alt-Enter on Windows) to insert line breaks in formulas: https://imgur.com/a/kXHzU9T https://imgur.com/a/kXHzU9T
by sokoloff 4y ago
I use Option-Enter (on Mac, which is probably Alt-Enter on Windows) to insert line breaks in formulas:
https://imgur.com/a/kXHzU9T https://imgur.com/a/kXHzU9T
- ketralnis 4y agoRight they explicitly mentioned it in the comment you replied to. They're asking for a regular normal human multiline text entry box that doesn't require a special mode where all of the keys mean different things than they're used to in code editors.
- sokoloff 4y agoDid they? > to do that I have to hold down [Alt] and mash the spacebar like a caveman.
- function_seven 4y agoI don't know why I wrote it that way. For the indenting, I have to use the space bar to line things up. No [Alt] needed in that scenario.
- function_seven 4y agoYeah, I do the same, but I wish I didn't have to. It's opposite of how I write text in all other contexts, and is really annoying when I forget to hold down [Alt] and get a modal admonishing me for having written a shit formula. Then I have to dismiss that modal, click on the cell again, and get back to where I was. Even worse, I spend a good chunk of time in Power BI, and it has a similar formula field (for DAX expressions), that mimics Excel a bit, but there you use [Shift] to insert newlines. So I'm always using the wrong modifier key and spewing insults at my computer.