README 5.92 KB
Newer Older
1
Gnumeric -- The GNOME spreadsheet
Jody Goldberg's avatar
Jody Goldberg committed
2
Jody Goldberg <jody@gnome.org>
3
Miguel de Icaza <miguel@ximian.com>
Karl Eichwalder's avatar
Karl Eichwalder committed
4

5
This is Gnumeric, the GNOME spreadsheet.  
6

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.

10
   The project aims to become a drop in replacement for commercial
11
12
13
spreadsheets.  Gnumeric is still a young program and it is advancing
steadily.  If you are interested in contributing to it's development please
send us some email, there are lots of projects available.
14

Morten Welinder's avatar
Morten Welinder committed
15
16
To report Gnumeric bugs, please visit bugzilla.gnome.org.

17
18
19
20
21
Requirements
------------

You need:

22
23
24
	glib		>= 1.2.7  (glib 1.3 is not supported)
	gtk+		>= 1.2.7  (gtk+ 1.3 is not supported)
	gnome-libs	>= 1.0.57 (gnome-libs 2.0 is not supported)
Chyla Zbigniew's avatar
Chyla Zbigniew committed
25
	xml-i18n-tools	>= 0.9	  (only required to build, not while running)
26
	libglade	>= 0.16
Jody Goldberg's avatar
Jody Goldberg committed
27
	gal		>= 0.16
Jody Goldberg's avatar
Jody Goldberg committed
28
	gnome-print	>= 0.29
29
	gnome-xml   	>= 1.8.14 (gnome-xml 2.x not supported yet)
30
	NOTE : gnome-xml is also known as libxml
31
	libole2	    	>= 0.2.4
32
	NOTE : libole2 is also known as libgnomeole2
33
34

Optionally:
35
	bonobo		>= 1.0.9
36
	NOTE : With bonobo you will need gnome-libs  >= 1.2.7
Jody Goldberg's avatar
Jody Goldberg committed
37
	gb		== 0.0.17  (Gnome Basic for macros)
38
39
	gda		>= 0.2.11  (GDA plugin, for accessing databases)
	guile		>= 1.5     ("Soon" to be releated Guile version)
40
41
	guppi		>= 0.40.0  (corresponds to 0.72)
	evolution	>= beta3
Karl Eichwalder's avatar
Karl Eichwalder committed
42

43
44
45
46
47
48
49
50
51
52
53
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
Jody Goldberg's avatar
update    
Jody Goldberg committed
54
other licenses, until then, the only setup available requires plugins
55
56
to fall under the GNU GPL license.

Jody Goldberg's avatar
Jody Goldberg committed
57
58
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
59

60
61
Mailing lists
-------------
62

Karl Eichwalder's avatar
Karl Eichwalder committed
63
   There is a mailing list used to discuss Gnumeric, to subscribe
64
65
66
67
send a mail to:

	gnumeric-list-request@gnome.org

Karl Eichwalder's avatar
Karl Eichwalder committed
68
   And in the body of the message write "subscribe"
69

Karl Eichwalder's avatar
Karl Eichwalder committed
70
   An archive of the mailing lists is available in:
Arturo Espinosa's avatar
Arturo Espinosa committed
71
72

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

Karl Eichwalder's avatar
Karl Eichwalder committed
74

75
76
77
Random notes:
-------------

78
79
80
81
This is a partial list of Features implemented in Gnumeric, we need
documentation for these:

	- Autofill
Karl Eichwalder's avatar
Karl Eichwalder committed
82
		Number autofill (computes delta, autofills from that).
83
	 	String autofill (daynames, months are built in).
Karl Eichwalder's avatar
Karl Eichwalder committed
84
		String+Number combo integer autofill.
85
86
		Formula autofill.

Karl Eichwalder's avatar
Karl Eichwalder committed
87
	- Drag and drop selection
88
89
90
91
92
93
94
95
96
		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
97
		- Walking selection.
98
99
100
101
		  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
102
		  the text in a selection and press control-enter.
103
104

	- Number formatting
105
		- The formatting of numbers is very powerful, we
Karl Eichwalder's avatar
Karl Eichwalder committed
106
		  emulate the Excel number formatting specification.
107
108

		- Format rules: you can use rules to specify which
Karl Eichwalder's avatar
Karl Eichwalder committed
109
		  format to use.
110
111
112
113

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

Jody Goldberg's avatar
update    
Jody Goldberg committed
114
115
		- Conditional colours and format strings.

116
117
	- Column/Row resizing
		- Drag the column/row division to adjust the column
Karl Eichwalder's avatar
Karl Eichwalder committed
118
		  and row dimensions.
119
120
121
122
123

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

124
125
126
127
128
	- Content
		- Merged Cells
		- Array formulas

	- Filters
Jody Goldberg's avatar
update    
Jody Goldberg committed
129
130
		- MS Excel (tm) Read/Write
		- Applix 	Read
131

132
133
134
135
136
137
138
139
140
141
142
	- 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.

143
144
145
	- 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
146
	  expression (it is on the bottom right corner).
147
148
149

	- 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
150
	  a list of possible options on actions to perform.
151
152
153

	- 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
154
155
	  to enter for example: =1+2.

Karl Eichwalder's avatar
Karl Eichwalder committed
156
	- Control-A selects all.
Jody Goldberg's avatar
Jody Goldberg committed
157
	- Alt-Space selects the row.
158
	- Control-Space selects a column.
Arturo Espinosa's avatar
Arturo Espinosa committed
159
160
161
162

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

Karl Eichwalder's avatar
Karl Eichwalder committed
163
	- Shift-Backspace:  Collapses selection to active cell.
164
165
166

	- Home: move to the beginning of the row.
	
167
168
169
170
171
172
	- 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
173
	  'array-formula'.
174

175
	- Control-Pg{Up,Down}: Switch to the previous/next worksheet.
176
	- Alt-Pg{Up,Down}: Page left and right.
177
178
	- Mouse-Wheel : scroll up/down
	- Alt-Mouse-Wheel : scroll left-right
Jody Goldberg's avatar
update    
Jody Goldberg committed
179
180
181
	- Arrow+ScrollLock

     o Frozen Panes.
182

183
184
185
186
187
188
189
190
191
     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.
192
193
194
195

     o Gnumeric command line debug arguments.
	- dump-func-defs
	- debug