diff options
| author | Jonathan Yavner | 2007-10-25 20:13:19 +0000 |
|---|---|---|
| committer | Jonathan Yavner | 2007-10-25 20:13:19 +0000 |
| commit | a9afba2096d15e8121467b2513d92cc2d5be2199 (patch) | |
| tree | c9dbab1969d67f3ff112119514aca8d923f69ded /doc/misc | |
| parent | 4eb3897c84d0e861a5346fd83d425690fbaa63e4 (diff) | |
| download | emacs-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/misc')
| -rw-r--r-- | doc/misc/ChangeLog | 10 | ||||
| -rw-r--r-- | doc/misc/ses.texi | 29 |
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 @@ | |||
| 1 | 2007-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 | |||
| 1 | 2007-10-25 Jay Belanger <jay.p.belanger@gmail.com> | 11 | 2007-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 | ||
| 118 | To 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 | |||
| 118 | A @dfn{cell identifier} is a symbol with a column letter and a row | 122 | A @dfn{cell identifier} is a symbol with a column letter and a row |
| 119 | number. Cell B7 is the 2nd column of the 7th row. For very wide | 123 | number. Cell B7 is the 2nd column of the 7th row. For very wide |
| 120 | spreadsheets, there are two column letters: cell AB7 is the 28th | 124 | spreadsheets, there are two column letters: cell AB7 is the 28th |
| 121 | column of the 7th row. | 125 | column 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 | |||
| 658 | tabs, so these are replaced with question marks. | 662 | tabs, so these are replaced with question marks. |
| 659 | 663 | ||
| 660 | @table @kbd | 664 | @table @kbd |
| 661 | @item C-c C-t | 665 | @item t |
| 662 | Confine a cell to its own column (@code{ses-truncate-cell}). This | 666 | Confine a cell to its own column (@code{ses-truncate-cell}). This |
| 663 | allows you to move point to a rightward cell that would otherwise be | 667 | allows you to move point to a rightward cell that would otherwise be |
| 664 | covered by a spill-over. If you don't change the rightward cell, the | 668 | covered by a spill-over. If you don't change the rightward cell, the |
| 665 | confined cell will spill over again the next time it is reprinted. | 669 | confined cell will spill over again the next time it is reprinted. |
| 666 | 670 | ||
| 667 | @item C-c C-c | 671 | @item c |
| 668 | When applied to a single cell, this command displays in the echo area any | 672 | When applied to a single cell, this command displays in the echo area |
| 669 | formula error or printer error that occurred during | 673 | any formula error or printer error that occurred during |
| 670 | recalculation/reprinting (@code{ses-recalculate-cell}). | 674 | recalculation/reprinting (@code{ses-recalculate-cell}). You can use |
| 675 | this to undo the effect of @kbd{t}. | ||
| 671 | @end table | 676 | @end table |
| 672 | 677 | ||
| 673 | When a printer function signals an error, the default printer | 678 | When 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 |
| 675 | is numeric-only and you use a string as a cell value. | 680 | is numeric-only and you use a string as a cell value. Note that the |
| 681 | standard default printer is ``%.7g'' which is numeric-only, so cells | ||
| 682 | that are empty of contain strings will use the fallback printer. | ||
| 683 | @kbd{c} on such cells will display ``Format specifier doesn't match | ||
| 684 | argument 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 | |||
| 871 | the data area, such as hidden constants you want to refer to in your | 880 | the data area, such as hidden constants you want to refer to in your |
| 872 | formulas. | 881 | formulas. |
| 873 | 882 | ||
| 874 | You can override the variable @code{symbolic-formulas} to be a list of | 883 | You can override the variable @code{ses--symbolic-formulas} to be a list of |
| 875 | symbols (as parenthesized strings) to show as completions for the ' | 884 | symbols (as parenthesized strings) to show as completions for the ' |
| 876 | command. This initial completions list is used instead of the actual | 885 | command. This initial completions list is used instead of the actual |
| 877 | set of symbols-as-formulas in the spreadsheet. | 886 | set of symbols-as-formulas in the spreadsheet. |
| 878 | 887 | ||
| 879 | For examples of these, see file @file{etc/ses-example.ses}. | 888 | For an example of this, see file @file{etc/ses-example.ses}. |
| 880 | 889 | ||
| 881 | If (for some reason) you want your formulas or printers to save data | 890 | If (for some reason) you want your formulas or printers to save data |
| 882 | into variables, you must declare these variables as buffer-locals in | 891 | into variables, you must declare these variables as buffer-locals in |