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
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Mozilla/4.76 [en] (X11; U; Linux 2.4.2-2 i686) [Netscape]">
<title>KOffice filters status: HTML FILTER</title>
</head>
<body text="#000000" bgcolor="#FFFFFF" link="#000099" vlink="#666666" alink="#666666">
<a NAME="START"></a>
<center>
<h1>
KOffice filters status: GNUmeric (GNOME spreadsheet)</h1></center>
<hr NOSHADE SIZE=2 WIDTH="70%"><b><font size="-1"><a href="#import">Import</a>
| <a href="#export">Export</a></font></b>
<br>
<br>
<br>
<br>
<center>
<p><a NAME="import"></a></center>
<b><font size="-1"><a href="#START">Up</a></font></b>
<center><table BORDER=0 CELLSPACING=0 WIDTH="100%" BGCOLOR="#000000" >
<tr>
<td>
<table BORDER=0 CELLPADDING=2 WIDTH="100%" BGCOLOR="#FFFFFF" >
<tr BGCOLOR="#DDFFDD">
<td COLSPAN="2">
<center><b><i><font size="+1">Import GNUmeric for Kspread</font></i></b></center>
</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP NOWRAP WIDTH="1%"><b><font size="+1">Last update</font></b></td>
<td>February 6, 2005</td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">Features</font></b></td>
<td>Vertical & Horizontal Alignment, text wrapping, indention
<br>Background, Patter & Foreground color
<br>Fonts:
<br>
Size
<br>
Underline
<br>
Italic
<br>
Bold
<br>
Family
<br>Multiple Sheets (Tables)
<br>Formulas!!! (ExprID)
<br>Selections: selected cells, last selected table
<br>Cell Formats (e.g. Date, Time, Percent, different currencies ...)
<br>Number formating (in brackets, red colored)
<br>Comments
<br>Page: size, orientation, borders, header and footer
<br>Border: color, style, width for all 6 types
<br>Background pattern: style, color
<br>Cell Size: horizontal & vertical
<br>Hidden Columns
<br>Default row heights and column widths
<br>Area name
<br>Links
<br>merge cells
<br>Text Rotation
<br>Print repeate col/row
<br>Cell validation
<br>Document Information
<br> Author
<br> Company
<br> Comments
<br> Title
<br> Keywords</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Todo</font></b></td>
<td>Cell Size: horizontal & vertical (Export) (kspread doesn't
support retriving the first "rowFormat" and colFormat".)
<br>
<br>
19 Applix small circle
<br>
20 Applix semicircle
<br>
21 Applix small thatch
<br>
22 Applix round thatch
<br>
23 Applix Brick => all unsupported by KSpread
<br>(a=b) for gnumeric vs. (a==b) for kspread
<br>if(a,b,c) for gnumeric vs. if(a;b;c) for kspread
<br>GNUmeric version differentiation
<br>border style: double, hair (KSpread doesn't support them)
<br>charts
<br>exact number, time and date formats (need the upcoming style engine)
<br>pictures (unsupported by KSpread)
<br>Alignment: fill, justify, center across selection (not supported by kspread)
<br>Accurate progress bar
<p>Document Information
<br> Application
(kspread doesn't support it.)
<br> Category (kspread
doesn't support it.)
<br> Manager (kspread
doesn't support it.)
<p>Vertical Text (gnumeric doesn't
support it.)
<br>Zoom
(kspread doesn't support it.)
<br>Multiple Selections (kspread doesn't support it.)
<br>Double Underline (kspread doesn't support it.)
</td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">History</font></b></td>
<td>Jun/Jul 2001 - Initial Revision
<br>Jul 10, 2001 - Support for hidden columns
<br>Jul 12, 2001 - Support for Document Information
<br>Jul 15, 2001 - Preliminary support for background patterns.
<br>Aug 21, 2002 - text/number formats, border, patters, page/print info, comments
<br>Aug 21, 2002 - font family, wrap text, number formating, precisions
<br>Sep 05, 2002 - bugfixes, default sizes, row and column layouts
<br>Sep 07, 2002 - bugfixes, preliminery date/time support
<br>Feb 03, 2005 - export area name
<br>Feb 06, 2005 - cells merged
<br>Feb 08, 2005 - Text Rotation
<br>Feb 19, 2005 - Cell validation
</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Authors</font></b></td>
<td><a href="mailto:phillipezolt@hotmail.com">Phillip Ezolt</a>
<br><a href="mailto:nandres@web.de">Norbert Andres</a>
<br><a href="mailto:montel@kde.org">Laurent Montel</a>
<br>This filter is based on the CSV filter by <a href="mailto:faure@kde.org">David
Faure</a> <a href="mailto:trobin@kde.org">Werner Trobin</a></td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">Links</font></b></td>
<td>www.koffice.org
<br>www.gnumeric.org</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Progress report </font></b></td>
<td>This has been tested against GNUmeric v0.70 and koffice v1.3-alpha.
<p>I've tried to keep the import/export filters pretty much in sync. </td>
</tr>
</table>
</td>
</tr>
</table></center>
<b><font size="-1"><a href="#START">Up</a></font></b>
<br>
<p>
<hr NOSHADE SIZE=1>
<br>
<br>
<br>
<br>
<center>
<p><a NAME="export"></a></center>
<b><font size="-1"><a href="#START">Up</a></font></b>
<center><table BORDER=0 CELLSPACING=0 WIDTH="100%" BGCOLOR="#000000" >
<tr>
<td>
<table BORDER=0 CELLPADDING=2 WIDTH="100%" BGCOLOR="#FFFFFF" >
<tr BGCOLOR="#FFDDDD">
<td COLSPAN="2">
<center><b><i><font size="+1">Export Kspread to GNUmeric</font></i></b></center>
</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP NOWRAP WIDTH="1%"><b><font size="+1">Last update</font></b></td>
<td>February 14, 2005</td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">Features</font></b></td>
<td>Vertical & Horizontal Alignment
<br>Background & Foreground color
<br>Fonts:
<br>
Size
<br>
Underline
<br>
Italic
<br>
Bold
<br>Multiple Sheets (Tables)
<br>Formulas!!! (ExprID)
<br>Selections
<br>Cell Size: horizontal & vertical
<br>Hidden columns/rows
<br>Selected Tab
<br>Paper layout
<br>area name
<br>Cell comment
<br>Text Rotation
<br>Borders
<br>Repeate print column/row
<br>Cell validation
<br>(a=b) for gnumeric vs. (a==b) for kspread
<br>Document Information
<br> Author
<br> Company
<br> Comments
<br> Title
<br> Keywords</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Todo</font></b></td>
<td>
Formats:
<br>
Percentages
<br>
Money
<br>Background patterns & Colors
<br>
If color is the default color do NOT set it in the export file.
<br>Font:
<br>
Face Name
<br>if(a,b,c) for gnumeric vs. if(a;b;c) for kspread
<br>GNUmeric version differentiation
<br>Accurate progress bar
<p>Document Information
<br> Application
(kspread doesn't support it.)
<br> Category (kspread
doesn't support it.)
<br> Manager (kspread
doesn't support it.)
<br>Vertical Text (gnumeric doesn't
support it.)
<br>Zoom
(kspread doesn't support it.)
<br>Multiple Selections (kspread doesn't support it.)
<br>Double Underline (kspread doesn't support it.)
</td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">History</font></b></td>
<td>Jun/Jul 2001 - Initial Revision
<br>Jul 10, 2001 - Support for hidden columns
<br>Jul 12, 2001 - Document Information
<br>Feb 5, 2005 - Cell comment
<br>Feb 8, 2005 - Text Rotation
<br>Feb 10, 2005 - Repeate print col/row
<br>Feb 14, 2005 - Cell Validation
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Authors</font></b></td>
<td><a href="mailto:phillipezolt@hotmail.com">Phillip Ezolt</a>
<br><a href="mailto:montel@kde.org">Laurent Montel</a>
<br>This filter is based on the CSV filter by <a href="mailto:faure@kde.org">David
Faure</a> <a href="mailto:trobin@kde.org">Werner Trobin</a></td>
</tr>
<tr BGCOLOR="#CCCCFF">
<td VALIGN=TOP><b><font size="+1">Links</font></b></td>
<td>www.koffice.org
<br>www.gnumeric.org</td>
</tr>
<tr BGCOLOR="#EEEEFF">
<td VALIGN=TOP><b><font size="+1">Progress report </font></b></td>
<td>This has been tested against GNUmeric v1.4.2 and koffice v1.4cvs.
<p>I've tried to keep the import/export filters pretty much in sync. </td>
</tr>
</table>
</td>
</tr>
</table></center>
<b><font size="-1"><a href="#START">Up</a></font></b>
</body>
</html>
|
