1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
The Gnumeric feature list for gnumeric 1.3.1
* Core capabilities
** Functions
- 100% of builtin Excel (North America) functions.
- 100% of Standard Addin functions.
- 60 functions not included in MS Excel.
** Computation
- Inter sheet dependencies.
- User defined Names (for ranges and functions).
- Arrays and Array functions.
- Implict iteration
- Computed dependencies
** Misc
- Cell comments.
- Toolbar for common operations.
- Cell Merging.
- Multiple Views.
- Zoom.
- Auto Filter
- Data Consolidate
- Rich text in cells
** Sheet Objects
- Lines, Elipses, squares.
- Button, combo, list, checkbutton, scrollbar, slider
** Printing
- Cell contents.
- Style information.
- Per sheet printer setups.
- Print preview.
*** Print Options
- Page orientation.
- 6 margins + paper size.
- Headers + footers.
- Grid lines, comments, headings.
- Print order.
** Formats
- All builtin Excel like formats: number, currency, acounting,
date, time, percentage, fraction, scientific, text, special.
- Compatible format description language.
** Styles
*** Borders
- Outer and inner, colors, diagonals, 13 line types.
*** Colors
- Foreground, background, pattern, 18 patterns.
*** Font
- Font name, size, style ( bold, italic ), color.
*** Alignment
- Horizontal (general, left, center, right, fill, justify).
- Vertical (top, center, bottom, justify).
- Center across selection.
- Indention.
- Wrap text.
** Autofill
Autofill for various sequences is supported.
** Automatic guessing of input
Gnumeric will try to parse user entered input as a number
with a format applied (so you can enter dates directly, and
they will be stored internally as a number + a format to
render it).
* International
Gnumeric has been localized to various languages, and
we welcome new contributions. It handles numeric formats
properly for various countries and languages.
* Import filters
** Excel
Summary information.
All sheet text + formulas.
Styles, selection.
Embedded images.
Printer setups.
Charts
** XML ( gnumeric native format )
** HTML various
** CSV adaptive ( comma separated values )
** Lotus 1-2-3 wk1 format
** GNU oleo ( rudimentary )
** Plan-Perfect
** SYLK
** X-Base
** Applix
** SC/XSpread
** Quattro Pro
** Open Office
* Export filters
** Excel
Summary Information.
All sheet text + formulae.
Names.
** XML ( gnumeric format )
All data except embedded objects.
** HTML various
** LaTeX, Troff
** PDF, DVI
** CSV various
|
