[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Emacs-diffs] Changes to emacs/man/ses.texi
From: |
Jonathan Yavner |
Subject: |
[Emacs-diffs] Changes to emacs/man/ses.texi |
Date: |
Fri, 18 Feb 2005 00:48:12 -0500 |
Index: emacs/man/ses.texi
diff -c emacs/man/ses.texi:1.10 emacs/man/ses.texi:1.11
*** emacs/man/ses.texi:1.10 Tue Jun 29 12:09:40 2004
--- emacs/man/ses.texi Fri Feb 18 05:48:09 2005
***************
*** 8,14 ****
@copying
This file documents SES: the Simple Emacs Spreadsheet.
! Copyright @copyright{} 2002 Free Software Foundation, Inc.
@quotation
Permission is granted to copy, distribute and/or modify this document
--- 8,14 ----
@copying
This file documents SES: the Simple Emacs Spreadsheet.
! Copyright @copyright{} 2002, 2005 Free Software Foundation, Inc.
@quotation
Permission is granted to copy, distribute and/or modify this document
***************
*** 71,76 ****
--- 71,77 ----
* The Basics:: Basic spreadsheet commands
* Advanced Features:: Want to know more?
* For Gurus:: Want to know @emph{even more}?
+ * Index:: Concept, Function and Variable Index
* Acknowledgements:: Acknowledgements
@end menu
***************
*** 79,84 ****
--- 80,86 ----
@node Sales Pitch, The Basics, Top, Top
@comment node-name, next, previous, up
@chapter Sales Pitch
+ @cindex features
@itemize @bullet
@item Create and edit simple spreadsheets with a minimum of fuss.
***************
*** 100,105 ****
--- 102,114 ----
@node The Basics, Advanced Features, Sales Pitch, Top
@comment node-name, next, previous, up
@chapter The Basics
+ @cindex basic commands
+ @findex ses-jump
+ @findex ses-mark-row
+ @findex ses-mark-column
+ @findex ses-mark-whole-buffer
+ @findex set-mark-command
+ @findex keyboard-quit
A @dfn{cell identifier} is a symbol with a column letter and a row
number. Cell B7 is the 2nd column of the 7th row. For very wide
***************
*** 147,152 ****
--- 156,168 ----
@node Formulas, Resizing, The Basics, The Basics
@section Cell formulas
+ @cindex formulas
+ @cindex formulas, entering
+ @findex ses-read-cell
+ @findex ses-read-symbol
+ @findex ses-edit-cell
+ @findex ses-recalculate-cell
+ @findex ses-recalculate-all
To enter a number into the current cell, just start typing:
***************
*** 193,198 ****
--- 209,223 ----
@node Resizing, Printer functions, Formulas, The Basics
@section Resizing the spreadsheet
+ @cindex resizing spreadsheets
+ @findex ses-insert-row
+ @findex ses-insert-column
+ @findex ses-delete-row
+ @findex ses-delete-column
+ @findex ses-set-column-width
+ @findex ses-forward-or-insert
+ @findex ses-append-row-jump-first-column
+
Basic commands:
***************
*** 240,245 ****
--- 265,280 ----
@node Printer functions, Clearing cells, Resizing, The Basics
@section Printer functions
+ @cindex printer functions
+ @findex ses-read-cell-printer
+ @findex ses-read-column-printer
+ @findex ses-read-default-printer
+ @findex ses-center
+ @findex ses-center-span
+ @findex ses-dashfill
+ @findex ses-dashfill-span
+ @findex ses-tildefill-span
+
Printer functions convert binary cell values into the print forms that
Emacs will display on the screen.
***************
*** 295,300 ****
--- 330,338 ----
@node Clearing cells, Copy/cut/paste, Printer functions, The Basics
@section Clearing cells
+ @cindex clearing commands
+ @findex ses-clear-cell-backward
+ @findex ses-clear-cell-forward
These commands set both formula and printer to @code{nil}:
***************
*** 309,314 ****
--- 347,364 ----
@node Copy/cut/paste, Customizing SES, Clearing cells, The Basics
@section Copy, cut, and paste
+ @cindex copy
+ @cindex cut
+ @cindex paste
+ @findex kill-ring-save
+ @findex mouse-set-region
+ @findex mouse-set-secondary
+ @findex ses-kill-override
+ @findex yank
+ @findex clipboard-yank
+ @findex mouse-yank-at-click
+ @findex mouse-yank-at-secondary
+ @findex ses-yank-pop
The copy functions work on rectangular regions of cells. You can paste the
copies into non-SES buffers to export the print text.
***************
*** 372,377 ****
--- 422,433 ----
@node Customizing SES, , Copy/cut/paste, The Basics
@section Customizing SES
+ @cindex customizing
+ @vindex enable-local-eval
+ @vindex ses-mode-hook
+ @vindex safe-functions
+ @vindex enable-local-eval
+
By default, a newly-created spreadsheet has 1 row and 1 column. The
column width is 7 and the default printer is @samp{"%.7g"}. Each of these
***************
*** 403,408 ****
--- 459,467 ----
@node Advanced Features, For Gurus, The Basics, Top
@chapter Advanced Features
+ @cindex advanced features
+ @findex ses-read-header-row
+
@table @kbd
@item C-c M-C-h
***************
*** 430,435 ****
--- 489,498 ----
@node The print area, Ranges in formulas, Advanced Features, Advanced Features
@section The print area
+ @cindex print area
+ @findex widen
+ @findex ses-renarrow-buffer
+ @findex ses-reprint-all
A SES file consists of a print area and a data area. Normally the
buffer is narrowed to show only the print area. The print area is
***************
*** 452,457 ****
--- 515,527 ----
@node Ranges in formulas, Sorting by column, The print area, Advanced Features
@section Ranges in formulas
+ @cindex ranges
+ @findex ses-insert-range-click
+ @findex ses-insert-range
+ @findex ses-insert-ses-range-click
+ @findex ses-insert-ses-range
+ @vindex from
+ @vindex to
A formula like
@lisp
***************
*** 505,510 ****
--- 575,583 ----
@node Sorting by column, Standard formula functions, Ranges in formulas,
Advanced Features
@section Sorting by column
+ @cindex sorting
+ @findex ses-sort-column
+ @findex ses-sort-column-click
@table @kbd
@item C-c M-C-s
***************
*** 531,536 ****
--- 604,615 ----
@node Standard formula functions, More on cell printing, Sorting by column,
Advanced Features
@section Standard formula functions
+ @cindex standard formula functions
+ @cindex *skip*
+ @cindex *error*
+ @findex ses-delete-blanks
+ @findex ses-average
+ @findex ses+
Oftentimes you want a calculation to exclude the blank cells. Here
are some useful functions to call from your formulas:
***************
*** 550,555 ****
--- 629,637 ----
@node More on cell printing, Import and export, Standard formula functions,
Advanced Features
@section More on cell printing
+ @cindex cell printing, more
+ @findex ses-truncate-cell
+ @findex ses-recalculate-cell
Special cell values:
@itemize
***************
*** 590,595 ****
--- 672,681 ----
@node Import and export, Virus protection, More on cell printing, Advanced
Features
@section Import and export
+ @cindex import and export
+ @cindex export, and import
+ @findex ses-export-tsv
+ @findex ses-export-tsf
@table @kbd
@item x t
***************
*** 606,611 ****
--- 692,698 ----
@node Virus protection, Spreadsheets with details and summary, Import and
export, Advanced Features
@section Virus protection
+ @cindex virus protection
Whenever a formula or printer is read from a file or is pasted into
the spreadsheet, it receives a ``needs safety check'' marking. Later,
***************
*** 632,637 ****
--- 719,726 ----
@node Spreadsheets with details and summary, , Virus protection, Advanced
Features
@section Spreadsheets with details and summary
+ @cindex details and summary
+ @cindex summary, and details
A common organization for spreadsheets is to have a bunch of ``detail''
rows, each perhaps describing a transaction, and then a set of
***************
*** 664,671 ****
@c ===================================================================
! @node For Gurus, Acknowledgements, Advanced Features, Top
@chapter For Gurus
@menu
* Deferred updates::
--- 753,761 ----
@c ===================================================================
! @node For Gurus, Index, Advanced Features, Top
@chapter For Gurus
+ @cindex advanced features
@menu
* Deferred updates::
***************
*** 677,682 ****
--- 767,775 ----
@node Deferred updates, Nonrelocatable references, For Gurus, For Gurus
@section Deferred updates
+ @cindex deferred updates
+ @cindex updates, deferred
+ @vindex run-with-idle-timer
To save time by avoiding redundant computations, cells that need
recalculation due to changes in other cells are added to a set. At
***************
*** 706,711 ****
--- 799,806 ----
@node Nonrelocatable references, The data area, Deferred updates, For Gurus
@section Nonrelocatable references
+ @cindex nonrelocatable references
+ @cindex references, nonrelocatable
@kbd{C-y} relocates all cell-references in a pasted formula, while
@kbd{C-u C-y} relocates none of the cell-references. What about mixed
***************
*** 732,737 ****
--- 827,834 ----
@node The data area, Buffer-local variables in spreadsheets, Nonrelocatable
references, For Gurus
@section The data area
+ @cindex data area
+ @findex ses-reconstruct-all
Begins with an 014 character, followed by sets of cell-definition
macros for each row, followed by column-widths, column-printers,
***************
*** 762,767 ****
--- 859,866 ----
@node Buffer-local variables in spreadsheets, Uses of defadvice in SES, The
data area, For Gurus
@section Buffer-local variables in spreadsheets
+ @cindex buffer-local variables
+ @cindex variables, buffer-local
You can add additional local variables to the list at the bottom of
the data area, such as hidden constants you want to refer to in your
***************
*** 794,799 ****
--- 893,902 ----
@node Uses of defadvice in SES, , Buffer-local variables in spreadsheets,
For Gurus
@section Uses of defadvice in SES
+ @cindex defadvice
+ @cindex undo-more
+ @cindex copy-region-as-kill
+ @cindex yank
@table @code
@item undo-more
***************
*** 814,823 ****
cell.
@end table
@c ===================================================================
! @node Acknowledgements, , For Gurus, Top
@chapter Acknowledgements
Coding by:
--- 917,940 ----
cell.
@end table
+ @c ===================================================================
+ @node Index, Acknowledgements, For Gurus, Top
+ @unnumbered Concept Index
+
+ @printindex cp
+
+ @heading Function Index
+
+ @printindex fn
+
+ @heading Variable Index
+
+ @printindex vr
+
@c ===================================================================
! @node Acknowledgements, , Index, Top
@chapter Acknowledgements
Coding by:
***************
*** 826,831 ****
--- 943,956 ----
Stefan Monnier @email{monnier@@gnu.org}
@end quotation
+ @noindent
+ Texinfo manual by:
+ @quotation
+ Jonathan Yavner @email{jyavner@@address@hidden
+ Brad Collins <brad@@chenla.org>
+ @end quotation
+
+ @noindent
Ideas from:
@quotation
Christoph Conrad @email{christoph.conrad@@address@hidden
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Emacs-diffs] Changes to emacs/man/ses.texi,
Jonathan Yavner <=