README 5.53 KB
Newer Older
1 2 3
Gnumeric -- The GNOME spreadsheet program
Miguel de Icaza <miguel@kernel.org>

Karl Eichwalder's avatar
Karl Eichwalder committed
4

5 6
This is the Gnumeric, the GNOME spreadsheet program.  

Karl Eichwalder's avatar
Karl Eichwalder committed
7
   Gnumeric is licensed under the terms of the GNU GPL included in the
8 9
file COPYING.

Karl Eichwalder's avatar
Karl Eichwalder committed
10 11 12
   The goal of this spreadsheet is to become as powerful as other
spreadsheets on the market and do this cleanly and smartly.  We have to
do this while being as compatible as possible with Excel.
13

Karl Eichwalder's avatar
Karl Eichwalder committed
14 15 16
   If you are familiar with Excel, you should be ready to use Gnumeric.
We have tried to clone all of the good features and stay as compatible
as possible with Excel in terms of usability.
17 18 19 20 21

   Gnumeric is still a young program and it is advancing steadily.  If
you are interested in contributing to the development of Gnumeric, you
probably will want to read the doc/Design file.  I have scribbled my
ideas on how Gnumeric should be developed in the future in the file
Karl Eichwalder's avatar
Karl Eichwalder committed
22 23
doc/Future-Roadmap.

24

25 26 27 28 29
Requirements
------------

You need:

30
	gnome-libs-1.0.57
31
	gnome-print-0.19
32
	gnome-xml-1.8.5
Morten Welinder's avatar
Morten Welinder committed
33
	libglade-0.11
34 35

Optionally:
36
	bonobo-0.13
37

Karl Eichwalder's avatar
Karl Eichwalder committed
38

39 40 41 42 43 44 45 46 47 48 49 50 51 52
Notes regarding plugins
-----------------------

   The current plugin setup in Gnumeric is just a way to dynamically
load code at runtime into the address space of Gnumeric: they use and
invoke pieces of Gnumeric code directly.  This means that any plugin
written under this scheme has to fall under the license of the GNU
GPL.

   In the future, an alternative method based on CORBA will be
provided and then it will be possible to create Gnumeric plugins with
other license, until then, the only setup available requires plugins
to fall under the GNU GPL license.

Jody Goldberg's avatar
Jody Goldberg committed
53 54
The perl, gda, and plan-perfect plugins are not meant to be installed.
They are included for informational purposes only.
Karl Eichwalder's avatar
Karl Eichwalder committed
55

56 57
Mailing lists
-------------
58

Karl Eichwalder's avatar
Karl Eichwalder committed
59
   There is a mailing list used to discuss Gnumeric, to subscribe
60 61 62 63
send a mail to:

	gnumeric-list-request@gnome.org

Karl Eichwalder's avatar
Karl Eichwalder committed
64
   And in the body of the message write "subscribe"
65

Karl Eichwalder's avatar
Karl Eichwalder committed
66
   An archive of the mailing lists is available in:
Arturo Espinosa's avatar
Arturo Espinosa committed
67 68

	http://www.gnome.org/mailing-lists/archives/gnumeric-list/
69

Karl Eichwalder's avatar
Karl Eichwalder committed
70

71 72 73
Random notes:
-------------

74 75 76 77
This is a partial list of Features implemented in Gnumeric, we need
documentation for these:

	- Autofill
Karl Eichwalder's avatar
Karl Eichwalder committed
78
		Number autofill (computes delta, autofills from that).
79
	 	String autofill (daynames, months are built in).
Karl Eichwalder's avatar
Karl Eichwalder committed
80
		String+Number combo integer autofill.
81 82
		Formula autofill.

Karl Eichwalder's avatar
Karl Eichwalder committed
83
	- Drag and drop selection
84 85 86 87 88 89 90 91 92
		Select an area and use the border to drag the
	 	contents (shift/control/alt are modifiers to copy
		or move)

	- Selection
		- Multiple selection is supported, hold down control
		  key to augment the existing selection (it might be
		  discotinuous).

Karl Eichwalder's avatar
Karl Eichwalder committed
93
		- Walking selection.
94 95 96 97
		  Use return/tab and shift-return/shift-tab to capture 
		  information in a selection.

		- Fill quickly a region with the same text: just enter
Karl Eichwalder's avatar
Karl Eichwalder committed
98
		  the text in a selection and press control-enter.
99 100 101

	- Number formatting
		- The formatting of numbers is very powerful, we do
Karl Eichwalder's avatar
Karl Eichwalder committed
102
		  emulate the Excel number formatting specification.
103 104

		- Format rules: you can use rules to specify which
Karl Eichwalder's avatar
Karl Eichwalder committed
105
		  format to use.
106 107 108 109 110 111

		- Format colors: you can specify a color to format
		  with in the format.

	- Column/Row resizing
		- Drag the column/row division to adjust the column
Karl Eichwalder's avatar
Karl Eichwalder committed
112
		  and row dimensions.
113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

		- To make changes to various columns/rows
		  simultaneously, select the columns and then change
		  the dimension of one of them.  

	- To edit the contents of a cell that already has a value,
	  press F2 key.

	- When typing a formula, you can use the cursor keys to select
	  a cell or a cell range in the expression.  This will only
	  work if a cell name is valid at the cursor point.

	  To specify a cell range, just move to the start of the cell
	  range and then hold down the shift key while making the size
	  of the selection cursor bigger.

129 130 131
	- An expression is evaluated constantly on top of the current
	  selection.  There is a number of pre-defined auto-compute
	  expressions, you can change this by right clicking on this
Karl Eichwalder's avatar
Karl Eichwalder committed
132
	  expression (it is on the bottom right corner).
133 134 135

	- If you drag a selection with button 3 instead of button one
	  there is no default action, rather, a menu pops up with 
Karl Eichwalder's avatar
Karl Eichwalder committed
136
	  a list of possible options on actions to perform.
137 138 139

	- Gnumeric distinguishes regular text from formulas by preceding
	  formulas with an equal sign.  So to enter an expression you have	
Arturo Espinosa's avatar
Arturo Espinosa committed
140 141
	  to enter for example: =1+2.

Karl Eichwalder's avatar
Karl Eichwalder committed
142 143
	- Control-A selects all.
	- Shift-Space selects the row.
144
	- Control-Space selects a column.
Arturo Espinosa's avatar
Arturo Espinosa committed
145 146 147 148

	- Selection-keys + control extend the selection to boundary of
	  worksheet.

Karl Eichwalder's avatar
Karl Eichwalder committed
149
	- Shift-Backspace:  Collapses selection to active cell.
150 151 152

	- Home: move to the beginning of the row.
	
153 154 155 156 157 158
	- Control-Home: move to the cell A1

	- Control-Enter: copies current edit text to the selected range.

	- Control-Shift-Enter: If there is a single range selected and the
	  current edit text is a formula, the formula is made into an
Karl Eichwalder's avatar
Karl Eichwalder committed
159
	  'array-formula'.
160

161
	- Control-Pg{Up,Down}: Switch to the previous/next worksheet.
162
	- Alt-Pg{Up,Down}: Page left and right.
163 164
	- Mouse-Wheel : scroll up/down
	- Alt-Mouse-Wheel : scroll left-right
165

166 167 168 169 170 171 172 173 174
     o Auto-convert-on-input features: When you enter text in Gnumeric
       it is now matched against the known formats of Gnumeric and if
       possible, converted to a (number, format) pair.  This works
       when you enter a formula and when you type in text.

       This means you can use now dates and times in expressions, like
       this: ="10-Jan"+45.  

       Autofill will also work on this.
175 176 177 178 179 180 181 182

     o Gnumeric command line debug arguments.
	- dump-func-defs
	- debug
	- debug_excel_read
	- debug_excel_formulas
	- debug_excel_color
	- debug_excel_chart