aboutsummaryrefslogtreecommitdiffstats
path: root/doc
diff options
context:
space:
mode:
authorJonathan Yavner2007-10-25 20:13:19 +0000
committerJonathan Yavner2007-10-25 20:13:19 +0000
commita9afba2096d15e8121467b2513d92cc2d5be2199 (patch)
treec9dbab1969d67f3ff112119514aca8d923f69ded /doc
parent4eb3897c84d0e861a5346fd83d425690fbaa63e4 (diff)
downloademacs-a9afba2096d15e8121467b2513d92cc2d5be2199.tar.gz
emacs-a9afba2096d15e8121467b2513d92cc2d5be2199.zip
ses.texi (The Basics): Mention how to create a new spreadsheet. Mention the
new three-letter column identifiers. (More on cell printing): Calculate-cell and truncate-cell are now `c' and `t' rather than `C-c C-c' and `C-c C-t'. Mention the stupid error message when using `c' on an empty default with default printer. (Buffer-local variables in spreadsheets): `symbolic-formulas' was renamed to `ses--symbolic-formulas' some time ago.
Diffstat (limited to 'doc')
-rw-r--r--doc/misc/ChangeLog10
-rw-r--r--doc/misc/ses.texi29
2 files changed, 29 insertions, 10 deletions
diff --git a/doc/misc/ChangeLog b/doc/misc/ChangeLog
index 90c6da4b158..73677b121ee 100644
--- a/doc/misc/ChangeLog
+++ b/doc/misc/ChangeLog
@@ -1,3 +1,13 @@
12007-10-25 Jonathan Yavner <jyavner@member.fsf.org>
2
3 * ses.texi (The Basics): Mention how to create a new spreadsheet.
4 Mention the new three-letter column identifiers.
5 (More on cell printing): Calculate-cell and truncate-cell are now `c'
6 and `t' rather than `C-c C-c' and `C-c C-t'. Mention the stupid error
7 message when using `c' on an empty default with default printer.
8 (Buffer-local variables in spreadsheets): `symbolic-formulas' was
9 renamed to `ses--symbolic-formulas' some time ago.
10
12007-10-25 Jay Belanger <jay.p.belanger@gmail.com> 112007-10-25 Jay Belanger <jay.p.belanger@gmail.com>
2 12
3 * calc.texi (Default Simplifications, Making Selections) 13 * calc.texi (Default Simplifications, Making Selections)
diff --git a/doc/misc/ses.texi b/doc/misc/ses.texi
index 8e1b6f397f5..dc7e669b8b0 100644
--- a/doc/misc/ses.texi
+++ b/doc/misc/ses.texi
@@ -115,10 +115,14 @@ To report bugs, send email to @email{jyavner@@member.fsf.org}.
115@findex set-mark-command 115@findex set-mark-command
116@findex keyboard-quit 116@findex keyboard-quit
117 117
118To create a new spreadsheet, visit a nonexistent file whose name ends
119 with ".ses". For example, @kbd{C-x C-f test.ses RET}.
120
121
118A @dfn{cell identifier} is a symbol with a column letter and a row 122A @dfn{cell identifier} is a symbol with a column letter and a row
119number. Cell B7 is the 2nd column of the 7th row. For very wide 123number. Cell B7 is the 2nd column of the 7th row. For very wide
120spreadsheets, there are two column letters: cell AB7 is the 28th 124spreadsheets, there are two column letters: cell AB7 is the 28th
121column of the 7th row. 125column of the 7th row. Super wide spreadsheets get AAA1, etc.
122 126
123@table @kbd 127@table @kbd
124@item j 128@item j
@@ -658,21 +662,26 @@ SES could get confused by printer results that contain newlines or
658tabs, so these are replaced with question marks. 662tabs, so these are replaced with question marks.
659 663
660@table @kbd 664@table @kbd
661@item C-c C-t 665@item t
662Confine a cell to its own column (@code{ses-truncate-cell}). This 666Confine a cell to its own column (@code{ses-truncate-cell}). This
663allows you to move point to a rightward cell that would otherwise be 667allows you to move point to a rightward cell that would otherwise be
664covered by a spill-over. If you don't change the rightward cell, the 668covered by a spill-over. If you don't change the rightward cell, the
665confined cell will spill over again the next time it is reprinted. 669confined cell will spill over again the next time it is reprinted.
666 670
667@item C-c C-c 671@item c
668When applied to a single cell, this command displays in the echo area any 672When applied to a single cell, this command displays in the echo area
669formula error or printer error that occurred during 673any formula error or printer error that occurred during
670recalculation/reprinting (@code{ses-recalculate-cell}). 674recalculation/reprinting (@code{ses-recalculate-cell}). You can use
675this to undo the effect of @kbd{t}.
671@end table 676@end table
672 677
673When a printer function signals an error, the default printer 678When a printer function signals an error, the fallback printer
674@samp{"%s"} is substituted. This is useful when your column printer 679@samp{"%s"} is substituted. This is useful when your column printer
675is numeric-only and you use a string as a cell value. 680is numeric-only and you use a string as a cell value. Note that the
681standard default printer is ``%.7g'' which is numeric-only, so cells
682that are empty of contain strings will use the fallback printer.
683@kbd{c} on such cells will display ``Format specifier doesn't match
684argument type''.
676 685
677 686
678@node Import and export, Virus protection, More on cell printing, Advanced Features 687@node Import and export, Virus protection, More on cell printing, Advanced Features
@@ -871,12 +880,12 @@ You can add additional local variables to the list at the bottom of
871the data area, such as hidden constants you want to refer to in your 880the data area, such as hidden constants you want to refer to in your
872formulas. 881formulas.
873 882
874You can override the variable @code{symbolic-formulas} to be a list of 883You can override the variable @code{ses--symbolic-formulas} to be a list of
875symbols (as parenthesized strings) to show as completions for the ' 884symbols (as parenthesized strings) to show as completions for the '
876command. This initial completions list is used instead of the actual 885command. This initial completions list is used instead of the actual
877set of symbols-as-formulas in the spreadsheet. 886set of symbols-as-formulas in the spreadsheet.
878 887
879For examples of these, see file @file{etc/ses-example.ses}. 888For an example of this, see file @file{etc/ses-example.ses}.
880 889
881If (for some reason) you want your formulas or printers to save data 890If (for some reason) you want your formulas or printers to save data
882into variables, you must declare these variables as buffer-locals in 891into variables, you must declare these variables as buffer-locals in