Skip to main content
Emacs

Return to Question

deleted 13 characters in body
Source Link
Drew
Drew
  • 79.1k
  • 10
  • 123
  • 257

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.

Thank you

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.

Thank you

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.

Source Link
CigEmacs
CigEmacs
  • 15
  • 5

Getting SES mode to act somewhat like a regular spreadsheet

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.

Thank you