0

So I have been working in an office that deals a ton with spreadsheets (mostly non-numeric data). With some things SES mode is a perfect alternative to the standard Excel sheet. I have found one thing that is a huge limitation so far though. I have tried, but cannot find a way to copy formulas smartly in Emacs SES. For example, if the formula in cell C1 is (+ A1 B1), I would like to be able to copy the formula from C1 into C2 and have the formula be (+A2 B2) instead of (+ A1 B1). Also, a way to fill in series in columns would be great.

Improve this question
1
  • Could you elaborate on "a way to fill in series in columns"? What precisely are you wanting to achieve?
    – phils
    Commented Jun 10, 2017 at 4:35

1 Answer 1

Reset to default
1

if the formula in cell C1 is (+ A1 B1), I would like to be able to copy the formula from C1 into C2 and have the formula be (+A2 B2) instead of (+ A1 B1).

That's how it does work, though.

If I set a formula (+ A1 B1) in cell C1, then mark and copy that cell, and yank it into cell C2, the resulting formula in C2 is (+ A2 B2).

This is using C-SPC <right> M-w to mark and copy the formula, and C-y to yank it.

Improve this answer
3
  • Seriously? That's what I have been doing, and it doesn't seem to be working for me. This is both on Debian at home and Emacs for Windows at work.
    – CigEmacs
    Commented Jun 12, 2017 at 10:41
  • Which version of Emacs is this? I tested in 25.2. I feel like this is how it always worked, but I rarely use SES, so I can't say for certain.
    – phils
    Commented Jun 12, 2017 at 21:09
  • The version in Debian I am using is 24.5 (Debian stretch). And the version that I "installed" at work is the 25.2 64 bit version from the Gnu FTP website. I feel stupid now though. I wasn't copying the cell itself, I was copying the formula from the minibuffer. It's working just fine now. Of course it would just kill the formula itself and not change it when I used C-y to yank. Now that I am working in an office environment, I'm trying to introduce as much free software as I can. I used SES mode for about half the day yesterday. Now that I understand this, I should be able to utilize it more.
    – CigEmacs
    Commented Jun 13, 2017 at 11:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.