From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Stefan Monnier Newsgroups: gmane.emacs.help Subject: Re: ses Date: Mon, 04 Jan 2010 10:34:56 -0500 Organization: UseNetServer.com Message-ID: References: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: ger.gmane.org 1262710218 22955 80.91.229.12 (5 Jan 2010 16:50:18 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Tue, 5 Jan 2010 16:50:18 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Tue Jan 05 17:50:11 2010 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1NSCZm-0003TD-Oy for geh-help-gnu-emacs@m.gmane.org; Tue, 05 Jan 2010 17:48:11 +0100 Original-Received: from localhost ([127.0.0.1]:48891 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NSCZn-0004hT-8S for geh-help-gnu-emacs@m.gmane.org; Tue, 05 Jan 2010 11:48:11 -0500 Original-Path: news.stanford.edu!usenet.stanford.edu!cgl.ucsf.edu!newsfeed.berkeley.edu!ucberkeley!solaris.cc.vt.edu!news.vt.edu!news.glorb.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!post02.iad.highwinds-media.com!TEKSAVVY.COM-Free-a2kHrUvQQWlmc!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1.50 (gnu/linux) Cancel-Lock: sha1:fKP/X/QqfONtgU7oY7bIogocP3s= Original-X-Complaints-To: abuse@usenetserver.com Original-Lines: 48 Original-X-Trace: 9d8644b420aa06b5d066330744 Original-Xref: news.stanford.edu gnu.emacs.help:175983 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:71062 Archived-At: > Got a minute to explain an SES spreadsheet? You may get a bit disappointed: SES is a very primitive spreadsheet, so some of the features you're asking for simply don't exist. > - name cell A `Date' and right align it? Not sure what you mean by "name". You can set its value to "Date" (a string) or to `Date' (a symbol), so that's what will be printed at that spot. Depending on whether you use a string or a symbol, it will either be right aligned or left-aligned, so, the answer to your question may be: ' D a t e RET > - name cell A1 `Expense' and left align it? That would then be: " E x p e n s e RET > (or can one do both of the above in two lines in cell A?) No, SES doesn't handle multi-line cells. > - enter today's date in cell B? There's no such automatic facility in SES. You'll have to define a corresponding function for that. > - make column A auto-fit and data right-aligned beneath the > right-aligned column name? There's no "auto-fit" feature. Numbers are right-aligned, so the alignment might just work. Note that the alignment is fairly naive, e.g. it doesn't know how to align on the decimal ".". > - (assuming I can then add subsequent dates by inserting new columns > in the future,) name cell C `Subtotal' and enter a formula for that > column that adds the amounts of the row? Something like: = (apply 'ses+ (ses-range A2 A20)) RET -- Stefan