NEWS 248 KB
Newer Older
Morten Welinder's avatar
Morten Welinder committed
1 2
Gnumeric 1.10.14

3 4
Andreas:
	* Fix width of translated lists in various dialogs [#641626]
5
	* Allow function tooltips to be closed temporarily [#641355]
6
	* Import & export list validation from and to ODF files. [#640701]
7
	* Minor histogram improvements.
8

9 10 11
Jean:
	* Fix cursor position inside a cell edited in a zoomed sheet. [#641709]

12 13
Morten:
	* Import wide sc files.  [#641581]
14
	* Fix problem with single-cell names and 'r'-type arguments.  [#613273]
Morten Welinder's avatar
Morten Welinder committed
15
	* Plug a few leaks.
16
	* Fix potential crash on quick exit.
17

Morten Welinder's avatar
Morten Welinder committed
18
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
19 20
Gnumeric 1.10.13

21 22
Andreas:
	* Calculate residuals when using the regression tool. [#635064]
23
	* Permit data entry by-passing autocorrection.
24
	* Work around OpenOffice date formatting bugs. [#636131]
25
	* Export text formats to and import from ODF. [#636158]
26
	* Fix ODF import of sheets with far forward references. [#636968]
27
	* Add EEK support to EURO and EUROCONVERT.
28
	* Fix leaks in potentially failing analysis tools.
29 30
	* Make the row and column headers and selection match the theme better.
	  [#639019]
31
	* Fix locale specific sorting. [#638874]
32
	* Ensure we have sub- and sperscript icons. [#639086]
33
	* Fix advanced filter. [#639444]
34
	* Suppress function tooltips on text-formatted cells. [#638832]
35
	* Fix documentation of ATAN2. [#640344]
36 37

Jean:
38
	* Only disable the formula bar when a chart sheet is selected. [#636031]
39
	* Make sheet objects invisible outline from .xls files persistent. [#637393]
40
	* Fixed arrows and line object position when zoomed. [#637453]
41 42
	* Fixed series lines color export to .xls. [#637658]
	* Fixed sheet objects position on zoomed sheets. [#637739]
43
	* Override edition-canceled property for GnmExprEntry. [#639287]
44

45 46
Morten:
	* Fix array intersection problem with IF.  [#633433]
47
	* Make sure columns are wide enough for dates in csv import.
Morten Welinder's avatar
Morten Welinder committed
48
	* Plug a few leaks.
49
	* Fix number-match issue regarding fraction.
Morten Welinder's avatar
Morten Welinder committed
50
	* Fix problems with pivot reading from xls.  [#638776]
51
	* Allow version-agnostic template files.  [#630247]
52

Morten Welinder's avatar
Morten Welinder committed
53
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
54 55
Gnumeric 1.10.12

56 57
Andreas:
	* Add argument to FOURIER to separate parts.
58
	* Extend TREND function to handle multiple regression. [#630085]
59
	* Fix selection for sheet object lists and combos. [#631322]
60 61
	* Preserve selection for sheet object lists when we change 
	  content. [#631327]
62 63
	* Add option to sheet object lists and combos to enter values
	  rather than index. [#629333]
64
	* Fix manual pagebreak handling when printing. [#631570]
65
	* Add menu items to remove and add manual page breaks.
66
	* Improve the sc import.
67
	* Fix button sensitivity in sort dialog. [#632999]
68
	* Fix ODF export of files with large formatted sheets. [#634135]
69
	* Fix extensions of supported ODF files. [#635111]
70

71 72 73
Hans de Goede:
	* Fix import of dib format images in XLS. [#553098]

74 75
Jean:
	* Fixed maximum for col/row number in sheet resize dialog. [#631702]
76
	* Eliminate glade usage.  [#631717]
77
	* Fixed crash in print setup. [#634149]
78
	* Fixed image bounds in zoomed sheets.
79

80 81
Morten:
	* Fix crash related to broken xls.  [#632050]
82
	* Fix print area problem from broken xls.
83
	* Fix printing crash.  [#632439]
84
	* Partially fix problem with undefined names.  [#633140]
85
	* Fix analysis tools problems when "as values" is chosen.
86
	* Fix gtk+/X crash with large tooltips.
87
	* Take care of dead kittens.
88
	* Fix text object clipping issue.  [#634597]
89
	* Fix problem with disappearing window for empty file.  [#634792]
Morten Welinder's avatar
Morten Welinder committed
90
	* Fix ranges-in-expression criticals.
91

92 93
Sameer Morar:
	* Add key combinations to move sheets. [#634139]
94 95
	* Modify quit dialog to be able to discard multiple files without 
	saving.  [#527133]	
96

Morten Welinder's avatar
Morten Welinder committed
97
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
98 99
Gnumeric 1.10.11

100 101
Andreas:
	* Fix image-fill, pattern and gradient export. [#628762]
102
	* Read tab colors from OOo config in ODF files.
103
	* Improve some ODF chart import/export.
104
	* Import/export all sheet objects from and to ODF files.
105
	* Fix reformatting of cells on expression entry. [#629303]
106
	* Allow multiple selection in manage sheet dialog.
107
	* Permit ctrl-click specification of sort columns.
108
	* Set ODF files to save by default as ODF files. [#629962]
109
	* Fix ssconvert crash on form controls. [#630335]
110
	* Improve printing of the form controls.
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
111
	* Permit choice whether to print sheet objects.
112

113
Jean:
114
	* Export/import tick label rotation angle. [#629675]
115
	* Read and write cell comments from/to OpenXML. [#630627]
116
	* New contextual menu item: copy a graph to a new graph sheet.
117

J.H.M. Dassen (Ray)'s avatar
J.H.M. Dassen (Ray) committed
118 119 120 121 122
J.H.M. Dassen (Ray):
	* Revised ssconvert man page.
	* Fix several potential and actual problems highlighted by
	  LLVM/clang static analysis.

123 124
Morten:
	* Fix date entry problem.  [#630177]
125 126
	* Fix problem with inter-process empty-value paste.  [#629302]
	* Fix problem with inter-process object paste.  [#629302]
127
	* Allow user-defined templates.  [#630247]
128
	* Improve test suite.
129

Morten Welinder's avatar
Morten Welinder committed
130
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
131 132
Gnumeric 1.10.10

133
Andreas:
134
	* Significantly improve chart export and import to/from ODF.
135
	* Improve handling of corrupted ODF files.
136
	* Fix percentage style import from ODF. [#627517]
137
	* Fix INTERPOLATION documentation. [#627461]
138 139
	* Provide progress info in ODF export.
	* Improve warnings dialog in ODF import.
140
	* Fix button sensitivity in sort dialog.
141

142 143
Jean:
	* Fix some interpolation and periodogram issues.
144
	* Fixed graph scalar data editor behavior. [#628721]
145

Morten Welinder's avatar
Morten Welinder committed
146 147
Morten:
	* Plug sylk importer leak.
Morten Welinder's avatar
Morten Welinder committed
148
	* Plug xml importer leak.
Morten Welinder's avatar
Morten Welinder committed
149
	* Plug odf importer leak.  [#627759]
150
	* Extend domain of IMPOWER.  [#627775]
151
	* Allow use of glib's memory profiler.
152
	* Fix some confusion of char vs. xmlChar.
153
	* Fix elapsed-time entry.  [#628082]
154
	* Fix problems with limits for date axes.
155
	* Improve function docs self test.
156
	* Fix errors in function docs.
Morten Welinder's avatar
Morten Welinder committed
157

Morten Welinder's avatar
Morten Welinder committed
158
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
159 160
Gnumeric 1.10.9

161 162
Andreas:
	* Clarify autofilter dialog. [#625688]
163
	* Make the tooltips theme-independent. [#625966]
164
	* Adjust and fix WORKDAY and NETWORKDAY.
165
	* Fix crash on certain handcrafted ODF files. [#626632]
166
	* Fix import of some ODF 1.0 charts. [#626632]
167
	* Fix crash on paste into an empty expression entry. [#626648]
168
	* Import and export boxplots to and from ODF files. [#626653]
169
	* Improve handling of corrupted ODF files. [#626654][#626655]
170
	* Fix autocorrection when entering in ranges. [#626781]
171 172
	* Fix column wdth and row height adjustments when entering in ranges.
	  [#626789]
173
	* Fix autofitting on data entry. [#626861]
174
	* Avoid some of the multiple undos when entering existing text in
175
	  ranges. [#626797]
176 177
	* Adjust formats when autofitting new entries. [#626903]
	* Autofit rows and columns when entering an array expression. [#626904]
178
	* Fix column and row fitting on paste. [#359404][#611181]
179
	* Export images to ODF.
180
	* Fix import of graphs from rich ODF files. [#626961]
181
	* Some ring and pie plot ODF export improvements.
182
	* Export legends to ODF.
183

184 185
Jean:
	* Import Guppi graphs from gnumeric-1.0.x files. [#567953]
186
	* Survive malformed guppi graphs. [#625726]
187
	* Use theme foreground color for row and column headers. [#625727]
Jean Bréfort's avatar
Jean Bréfort committed
188 189
	* Force column span recalculation when switching between number and
	  error. [#625994]
190
	* Fix scroll when selecting a merged cell. [#626065]
191 192
	* Fix objects dragging when zoomed. [#626484]
	* Fix control points behavior when zooming.
Jean Bréfort's avatar
Jean Bréfort committed
193
	* Fix in-cell editing when zoom < 100%. [#626279]
194

195 196
Morten:
	* Survive malformed xml files.
197
	* Fix win32 random problem.  [#533779]
198
	* Fix IMPOWER problem.  [#627014]
Morten Welinder's avatar
Morten Welinder committed
199
	* Avoid criticals in ODS import.
200
	* Fix problem with collect cache.  [#627079]
201

Morten Welinder's avatar
Morten Welinder committed
202
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
203 204
Gnumeric 1.10.8

205 206
Andreas:
	* Add new Excel and Openformula units ("pica" and "picapt") to CONVERT.
207
	* Save default search settings. [#105615][#625185]
208
	* Improve configurable text export of numbers. [#126444]
209
	* Improve horizontal fill. [#594193]
210
	* Improve function syntax tooltips. [#623317]
211
	* Add weekend specifier to WORKDAY and NETWORKDAYS. [#172458]
212
	* Fix ngettext usage.
213
	* Fix undo text for sheet object duplication. [#623557]
214
	* Fix additional undo entry for sheet object duplication. [#623559]
215
	* Fix undo of object creation followed by duplication. [#623566]
216
	* Avoid creating interacting auto filters. [#607086]
217
	* Improve items of the cell context menu. [#74359]
218
	* Fix various function docs issues.  [#623669][#624559][#625102]
219 220
	* Improve the presentation of the examples in the function
	  documentation. [#623455]
221
	* Fix HDATE and friends. [#623764][#625177]
222
	* New functions DATE2HDATE, DATE2HDATE_HEB and DATE2JULIAN.
223
	* Add hyperlink and comment removal menu items.
224
	* Add merge and unmerge menu items.
225 226
	* Add menu item to autofit column width or row height based on the 
	  selection only. [#125595]
227
	* Add autofit actions to cell context menu.
228
	* Add new function ARRAY. [#570689]
229
	* Add new function SORT. [#59144]
230
	* Add menu item to wrap SORT around an existing range.
231
	* Show the number of rows filtered by the auto filter. [#346002]
232
	* Improve function tooltips. [#623322]
233 234
	* Improve expression entry range selection. 
	  [#80725][#624288][#624289][#624581]
235 236
	* Add preference setting to disable the extension check for the 
	  configurable text exporter. [#594151]
237 238
	* Add optional marker to indicate that a cell contains an expression. 
	  [#55124]
239
	* Add merge and unmerge items to the cell context menu.
240
	* Permit double-clicking of functions in the function selector.
241
	* Allow single merge to single merge copying. [#87296]
242 243
	* Make the font style buttons override the character attributes. 
	  [#163410]
244
	* Provide name completion (F4) when entering functions. [#587084]
245 246 247 248
	* Implement access to the function selector to paste function
	  names while editing cells (Shift-F4).
	* Add preference settings whether to show function name and/or
	  argument tooltips.
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
249
	* Fix undo of Clear->All and Clear->Comments. [#625151][#623803]
250
	* Add menu items to allow clearing of filtered rows only.
251
	* Fix editing of hyperlinks.
252 253 254
	* Work around OOo's failure to correctly define its named ranges. 
	  [#625332]
	* Remove range hightlighting while not editing expressions. [#625361]
255
	* Reduce the size of the text import dialog. [#625281]
256 257
	* Fix import of underlined/double underlined comments from xls.
	  Part of [#405951]
258
	* Improve xl import of underlines.
259
	* Correctly size the autoexpressions. [#625521]
260
	* Fix row height dialog. [#625543]
261 262
	* Add menu to specify whether to enter as array, into multiple cells,
	  etc. Part of [#53733]
263
	* Make autofilter condition changes undoable. [#625143]
264

265 266
Jean:
	* Fix strong/weak cursor display. [#623241]
267 268
	* Fix regression in ms_excel_chart_read. [#623960]
	* Fix a regression in chart series evaluation. [#624263]
269
	* Fix crash in cell_calc_span. [#624274]
270
	* Install a self-consistent headers list.
271
	* Fixed borders display in cell format dialog.
272

273 274 275
Morten:
	* Ask user to locate solver binaries when plain search fails.
	[#619519]
276
	* Fix problem with solver target cell entry.
Morten Welinder's avatar
Morten Welinder committed
277
	* Fix date function docs issues.  [#623669]
278
	* Fix gtk_show_uri problem affecting win32.  [#623605]
Morten Welinder's avatar
Morten Welinder committed
279
	* Fix mistakes pointed out by sparse.
280
	* Fix win32 versioning problem.  [#624171]
281
	* Improve function doc checks.
282
	* Eliminate almost all remnaining GdkGC usage.
283

Morten Welinder's avatar
Morten Welinder committed
284
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
285 286
Gnumeric 1.10.7

287 288
Andreas:
	* Improve function syntax and formula guru tooltips.
289
	* Avoid superfluous redo items under validation failure. [#622509]
290
	* Fix validation for array and range entry. [#622511]
291
	* Autofit column widths in stf import. [#427382]
292 293
	* Ensure the table range is unlocked before allowing the data
	  table to be configured.
294 295
	* Also store any markup if entering text in several cells at once.
	  [#622530]
296
	* Read HTML files with nested tables. [#594789]
297

298
Jean:
299
	* Fixed autofilter (and other) combo positions. [#621817]
300

301 302
Morten:
	* Improve function syntax tooltips.
303
	* Fix excessive memory use problem with xlsx.  [#622365]
304
	* Make BackSpace work as Delete on pane.  [#622599]
Morten Welinder's avatar
Morten Welinder committed
305
	* Improve handling of MS-style HTML in clipboard.  [#617801]
306

Morten Welinder's avatar
Morten Welinder committed
307
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
308 309
Gnumeric 1.10.6

310
Andreas:
311
	* Add Wilcoxon Signed Rank Test tools for one and two populations.
312 313
	* Fix spin button handling in various tool dialogs. [#619971]
	* Redesign define-named-expressions dialog. [#465840] 
314
	* Add paste-names dialog. [#613325]
315
	* Make changing the scope of a named expression undoable.
316
	* Add search tool to paste- and define-names dialogs. [#465840]
317
	* Check whether defined names are in use before deleting them.
318 319 320 321
	* Add option to the regression tool to allow for multiple Y. 
          [#620505]
	* Ensure that names cannot be mistaken as cell references.
	  [#409997]
322
	* Add search function to function selector. [#495776]
323
	* Add function help menu item. [#156777]
324
	* Improve ACCRINT and its description. [#611436]
325 326
	* Fix tests for homogeneity and independence for non-square
	  tables. [#621227]
327
	* Show all ranges while editing. [#166653]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
328
	* Provide a tool tip showing function syntax. [#56172]
329 330
	* Provide more navigation options. [#15010]
	* Check with user before hiding all rows or columns. [#316976]
331
	* Check with user before pasting too many copies. [#530956]
332

333 334
Jean:
	* Do not ungrab a not grabbed item. [#620369]
335
	* Always update the right series entry. [#620719]
336
	* Fixed multi-line item edit selection. [#621235]
337

338 339
Morten:
	* Make sure windows for help commands show up on right screen.
340
	* Fix dependency tabulation undo issue.
Morten Welinder's avatar
Morten Welinder committed
341
	* Fix critical when inserting graph using keys.
342
	* Automate win32 help generation.
343
	* Mark a sheet dirty when its tab colour is changed.  [#621191]
344
	* Fix SERIESSUM issue.
345
	* Modernize code for LINEST, LOGEST, and  LOGREG.  [#317426]
346 347
	* GEOMDIST: avoid overflow in extreme cases.
	* SFTEST: improve extreme-case precision.
348
	* Fix RANDLEVY.
349
	* Fix hidden-sheet problem.  [#621463]
350
	* Improve help text sanity checks.
351
	* Fix minor parsing problem.
352
	* Handle missing data in FORECAST properly.  [#621417]
353
	* Handle missing data in GROWTH properly.  [#621418]
354
	* Improve BINOM.DIST.RANGE.
Morten Welinder's avatar
Morten Welinder committed
355
	* Modernize STEYX.
356
	* Plug evaluation leak.
357
	* Fix memory handling issue for dependents.
358

Morten Welinder's avatar
Morten Welinder committed
359
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
360 361
Gnumeric 1.10.5

362 363 364
Andreas:
	* Add Wilcoxon-Mann-Whitney test tool.

Morten Welinder's avatar
Morten Welinder committed
365 366
Morten:
	* Fix stf crash.  [#619283]
367
	* Persist solver model type.
368
	* Add non-linear solver.  [#614865]
Morten Welinder's avatar
Morten Welinder committed
369
	* Feed the gtk+ deprecation monster.  [#572240]
370
	* Fix win32/paradox problem.  [#619942]
Morten Welinder's avatar
Morten Welinder committed
371

372 373 374
Sameer Morar:
	* Improve page setup dialog. [#619421]

Morten Welinder's avatar
Morten Welinder committed
375
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
376 377
Gnumeric 1.10.4

378 379
Andreas:
	* Include version number in HTML export.
380

381
Jean:
382
	* Fixed autofill issues. [#618687]
383 384 385

Morten:
	* Linear regression test suite.
386
	* Fix TABLE problem.  [#618829]
387 388
	* Handle "Jan 2010" and "January 2010" better.
	* Fix date parsing problems for invalid years.
389

390 391 392
Sameer Morar:
 	* Fix sheet order dialog layout. [#619056]

Morten Welinder's avatar
Morten Welinder committed
393
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
394 395
Gnumeric 1.10.3

396 397
Andreas:
	* Fix CHITEST for rectangular ranges. [#615920]
398
	* Fix printing and preview of graph only sheets. [#616475]
399
	* Make even active sheets invisible. [#616474]
Morten Welinder's avatar
Morten Welinder committed
400
	* Improve date and time import from and export to ODF. [#617208]
401
	* Protect against accidentally pushing data off the sheet. [#98562]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
402
	* Make Advanced Filter (except filter-in-place) undoable.
403
	* Fix Data->Filter->ShowAll for Advanced Filter. [#611079]
Morten Welinder's avatar
Morten Welinder committed
404
	* Remove undesired interaction between Advanced Filters and
405
	  Autofilters.
406
	* Make the par argument to ACCRINT optional. [#323545]
407 408
	* Improve keyboard navigation of the configurable text
	  importer. [#614939,#614941]
409

410
Jean:
411
	* Implement graph only sheets. [#158170]
412
	* Fix chart title import when excel automagically uses the unique
Morten Welinder's avatar
Morten Welinder committed
413
	  series label. [#616262]
414
	* Allow multiple and block selection for graph vector data.
Morten Welinder's avatar
Morten Welinder committed
415
	  [#494685,#616068]
416
	 * Use the "combo-activate" signal where appropriate? [#583175]
417

418 419
Morten:
	* Make sure an empty string is shown with a quote.
420
	* Fix problem loading cells with empty strings.  [#616139]
421
	* Fix WEEKNUM problems.  [#616330]
Morten Welinder's avatar
Morten Welinder committed
422
	* Fix hidden-sheet problem.  [#616549]
423
	* Fix auto-expr problem.  [#575104]
424
	* Fix xls-save problems with custom autofilters.
425
	* Fix auto-filter problem.  [#383400]
426
	* Fix advanced-filter problem with multiple criteria.  [#164169]
Morten Welinder's avatar
Morten Welinder committed
427
	* Fix problem parsing complex numbers.
428
	* Improve error handle for complex functions.
429
	* Improve IMPOWER.
430
	* Fix sheet duplicate bugs.  [Part of #617469]
431
	* Clean-up handling of pango contexts.
432
	* Fix old graph problem.  [#142412]
433

Morten Welinder's avatar
Morten Welinder committed
434
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
435 436
Gnumeric 1.10.2

437 438 439
Alexander Kahl & Sven Mantei:
	* Some documentation updates

440
Andreas:
441 442
	* Fix build with --disable-solver. [#612820]
	* Fix column and row header display under Quartz. [#600085]
443
	* Fix preferences in gconf-less situations. [#613523]
444
	* Implement first letter capitalization. [#613768]
445 446
	* Extend regression tool to perform multiple simple regressions.
	  [#614031]
447
	* Fix ZTEST description. [#614746]
448
	* Don't write unnecessary manifest entries in ODF export.
449
	* Various ODF export fixes.
450
	* Adjust regression tool to reflect the changes to TDIST.
451
	* Basic import and export of text boxes from ODF files.
452
	* Watch for the null date in OOXML import. [#615777]
453
	* Write the null date in OOXML export.
454

455 456 457
Jean:
	* Print pattern backgrounds. [#615365]

458 459
Morten:
	* Improve object sizing tooltip positioning a bit.
460
	* Fix filter critical.  [#611073]
461
	* Make more menu entries available when an object is selected.
462
	* Improve partitioning of status area.
463
	* Fix goal seek problem affecting XIRR.  [#614147]
464
	* Fix export xls of XIRR, FVSCHEDULE, and XNPV.  [#614257]
465
	* Set win32 stack size to 64M.  [#571346]
Morten Welinder's avatar
Morten Welinder committed
466
	* Patch gtk+ so GtkEntry widgets on win32 draw right.  [#603667]
467
	* Fix xls export of cell comments.  [#615845]
468
	* Fix error propagation problem.  [#615772]
469
	* Partially clean up INDEX implementation.
470 471
	* Make regression functions return a result when goffice reports
	  that the problem is near singular, but still good.
472

Morten Welinder's avatar
Morten Welinder committed
473
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
474 475
Gnumeric 1.10.1

476 477
Andreas:
	* Fix storing of error-literals in ODF. [#610175]
478
	* Don't export filter combos to ODF. [#610399]
479
	* Apply filter on ODF import. [#610399]
480 481
	* Fix display of autocomplete suggestions. [#610537]
	* Fix formatting of multirow cells in LaTeX export. [#611633]
482
	* Protect exported LaTeX files from babel shorthands.
483

484
Jean:
Morten Welinder's avatar
Morten Welinder committed
485
	* Fix a crash in excelplugin. [#610012]
486
	* Fix cursor appearance. [#611076]
487

488 489
Morten:
	* Turn off -Wstrict-prototypes for the stable series.
490 491
	* Fix ODF read problem.  [#610178]
	* Fix rendering problem with iterated evaluation.
492
	* Fix solver undo problem.  [#611406]
493
	* Fix graph label problem.  [#611362]
494
	* Fix GLPK solver issue.  [#611407]
Morten Welinder's avatar
Morten Welinder committed
495
	* Fix ssindex crash.  [#611842]
496
	* Fix ODF export of intersection.  [#611824]
497
	* Fix cell comment critical.
498

Morten Welinder's avatar
Morten Welinder committed
499
--------------------------------------------------------------------------
500
Gnumeric 1.10.0
Morten Welinder's avatar
Morten Welinder committed
501

502 503
Andreas:
	* Fix ODF contour/surface plot confusion. [#607631]
504 505
	* Include compatibility info in the gnumeric manual.
	* Fix confidence interval in simulation output. [#607970]
506

507 508
Morten:
	* Fix TRIMMEAN border case.  [#607562]
Morten Welinder's avatar
Morten Welinder committed
509
	* Fix TDIST border case.  [#607008]
510
	* Fix problem with hpaned for tabs/scrollbar.  [#607794]
Morten Welinder's avatar
Morten Welinder committed
511

Morten Welinder's avatar
Morten Welinder committed
512 513 514
Peter Jaeckel:
	* Support for XLL files.  [#597849]

Morten Welinder's avatar
Morten Welinder committed
515
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
516 517
Gnumeric 1.9.18

518
Andreas:
519
	* Add paste special flip horizontally and vertically. [#393367]
520
	* Add EIGEN function to calculate eigenvalues and eigenvectors
521 522 523 524
	  of real symmetric matrices.
	* Add principal components analysis.
	* Load graph series labels and categories from ODF files. [#379220]
	* Write series labels to ODF files.
525
	* Fix tab behaviour. [#388344]
526
	* Print sheet widget objects. [#144787]
527
	* Allow sheet object size and position to be specified via a dialog.
528
	* Allow the sheet object name to be specified. [#596545]
529
	* Add menu item to select sheet objects. [#338615]
530
	* Enable sheet tab menu when objects are selected. [#604496]
531
	* Fix empty cell handling of the advanced filter. [#599064]
532
	* Fix scroll bar problem with large frozen panes. [#68603]
533
	* Singleton selections now cause the sort buttons to sort the
534 535
	  whole sheet below the selection. [#141313]
	* Have the formula guru auto-quote unparsable expressions. [#442941]
536
	* Create default tip for hyperlinks. [#316974]
537
	* Add GET.LINK. [#128534]
538
	* Add "Don't change formulae" to paste special. [#123326]
539
	* Select pasted objects. [#604227]
540
	* Add auto expression menu items to add formula. [#8872]
541
	* Some updates to the Gnumeric manual.
542
	* Fix tool tip position for recent gtk (2.18 or newer). [#605723]
543
	* Fix NPV documentation. [#22381]
544
	* Fix type errors. [#606066]
545
	* Add surface plot description. [#604285]
Morten Welinder's avatar
Morten Welinder committed
546
	* Include the short functions descriptions in the documentation.
547
	  [#606354]
548
	* Fix sheet handling in validation setup. [#606458]
Morten Welinder's avatar
Morten Welinder committed
549
	* Allow some of the text export properties to be saved as default.
550
	  [#559749]
551
	* Fix printing of repeated rows and columns. [#607451]
552

553
Jean:
554
	* Fix import export of line type in scatter plots. [#605043]
555
	* Force sharing of first series in line plots when requested. [#605330]
556
	* Fixed mouse cursor for object resizing in RTL mode. [#605514]
557

558 559
Jody:
	* Fix use of ExprEntry from glade on win32.
560
	* More win32 build fixes (xslt for libgda & poppler).
561
	* Fix pango test harness.
562
	* Fix use of Tab in ExprEntry for gurus.
563
	* Adapt to latest gtk-2.19.3 GSEAL.
564

565 566 567
Morten:
	* Fix GCD border case.  [#606870]

Morten Welinder's avatar
Morten Welinder committed
568
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
569 570
Gnumeric 1.9.17

571
Andreas:
572
	* Update EURO and EUROCONVERT with currencies added in 2007 to 2009.
573
	* Export hyperlinks to ODF. [#603533]
574 575
	* Make EUROCONVERT Excel compatible [#603755]
	* Update modification times. [#603099]
576
	* Add RANK.AVG (rank function returning average rank for ties)
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
577
	* Added Sign Test to statistical analysis tools
578

579 580 581
Gabriel Kerneis:
	* Implement --one-file-per-sheet in ssconvert [#604549]

582 583
Jean:
	* Fixed problem with row headers. [#603862]
584
	* Fixed pane origin when zoomed. [#604373]
585
	* Make the cell comment red triangle visible in RTL mode. [#604580]
586

Morten Welinder's avatar
Morten Welinder committed
587 588
Morten:
	* Elminate use of "float".
589
	* Fix selection problem.  [#601107]
Morten Welinder's avatar
Morten Welinder committed
590
	* Automate solver testing.
591
	* Fix SUMIF problems.  [#603671] [#604214]
592
	* Fix DATEDIF problem across bogus 1900-02-29.  [#599461]
593
	* Fix graph editor crash.  [#604223]
Morten Welinder's avatar
Morten Welinder committed
594
	* Fix goal seek problems.
595
	* Fix ODS import crash.  [#604615]
Morten Welinder's avatar
Morten Welinder committed
596

Morten Welinder's avatar
Morten Welinder committed
597
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
598 599
Gnumeric 1.9.16

600 601
Andreas:
	* Clarify distinction between Document and View Properties.
602 603
	* Sort the translated labels in the preference dialog.
	* Turn view properties dialog into instant-apply dialog.
604
	* Temporarily remember the sort setups. [#100541]
605
	* Work around GTK bug #601922.
606
	* Add ADTEST (Anderson-Darling Test for Normality).
607 608 609 610
	* Add normality test tool.
	* Add LKSTEST (Lilliefors (Kolmogorov-Smirnov) Test of Normality).
	* Add SFTEST (Shapiro-Francia Test of Normality).
	* Add CVMTEST (Cramér-von Mises Test of Normality).
611

612
Jean:
Jean Bréfort's avatar
Jean Bréfort committed
613
	* Fix cursor and cell edition on dark backgrounds. [#600656]
614
	* Fix multiple error message boxes in graph guru. [#152517]
Jean Bréfort's avatar
Jean Bréfort committed
615 616
	* Invert selected text in a cell when editing. [#122176]
	* Allow selection when the click occur after the last character. [#388342]
617
	* Fixed selecting text in a cell. [#337521]
Morten Welinder's avatar
Morten Welinder committed
618

619 620 621 622
Jody:
	* turnkey win32 build on 32bit host.
	* update desktop file to follow new guidelines.

623 624
Morten:
	* Resurrect long-double support.
625
	* More solver fixes.
Morten Welinder's avatar
Morten Welinder committed
626
	* Plug another mps leak.
627
	* Fix problem with remote uris.  [#601274]
628
	* Use external solver program.
629
	* Allow constants on solver constraints' rhs.  [#369728]
630
	* Fix extreme case for R.PGAMMA.
631 632
	* Fix solver undo/redo.
	* Make solver parameter changes always persist.  [#440664]
Morten Welinder's avatar
Morten Welinder committed
633
	* Re-implement MPS importer.
634
	* Fix matching of "Sep 23 2008".  [#603116]
635 636
	* Major scenario code cleanup.
	* Implement load and save of scenarios.
637

Morten Welinder's avatar
Morten Welinder committed
638
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
639 640
Gnumeric 1.9.15

641 642
Andreas:
	* Add RANDSNORM and RANDSTDIST. [#144717]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
643
	* Add R.PSNORM, R.DSNORM and R.DST.
644
	* Fix small sort dialog problem. [#599091]
645
	* A few functions from the christian liturgical calendar.
Morten Welinder's avatar
Morten Welinder committed
646
	* Add ODF compatibility functions DAYS, ISFORMULA, IFNA, SHEETS,
647
	  SHEET and NUMBERVALUE.
648
	* Work around OpenOffice.org saving function names in lowercase.
649
	* Add BINOM.DIST.RANGE (equivalent to the ODF function B).
650 651
	* Make Autofilter addition & removal undoable. [#478152]
	* Fix autocorrection exception lists. [#600055]
652
	* Move autocorrection setup into preferences.
653
	* Fix HTML export of strikethrough and subscript/superscript. [#600163]
654

655 656 657
Jean:
	* Fixed graph size issues. [#599887]

658 659 660
Jody:
	* First steps towards a turnkey win32 build.

661 662
Morten:
	* Fix sheet-resize vs. merges issue.  [#582030]
663 664 665
	* Fix xls export of check boxes and radio buttons.  [Part of #597035]
	* Add xls export of spin buttons.  [Part of #597035]
	* Add xls export of scroll bars.  [Part of #597035]
666
	* Add xls export of list widgets.  [Part of #597035]
667 668
	* Add xls export of combo widgets.  [Part of #597035]
	* Add xls export of button widgets.  [Part of #597035]
669 670 671
	* Make it possible for arrows to have arrow heads in both ends.
	* Implement round arrow heads.
	* Fix xls import and export of line styles.
672
	* Save and read new arrow attributes in xml format.
673
	* Fix Excel-to-Gnumeric paste problem.  [#381732, #388531].
674
	* Fix Alt-Enter problems.  [#597295]
675
	* Make DATE work for pre-1900 dates.  [#599365]
676
	* Add lpsolve output format.
Morten Welinder's avatar
Morten Welinder committed
677
	* Plug solver leaks.
678
	* Some solver cleanups.
679
	* Fix reading of solver constraints.
680

681 682 683
Yaacov Zamir:
       * Hebrew Calendar functions.  [#153738]

Morten Welinder's avatar
Morten Welinder committed
684
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
685 686
Gnumeric 1.9.14

687 688
Albert Gräf:
        * Add button sheet object.
689
        * Add radiobutton sheet object.  [#595670]
690

691 692
Andreas:
	* Add more ODF elements on ODF read. [#595750]
693 694 695 696
	* Fix 2-factor ANOVA with replication.
	* Fix diagonal borders in ODF export/import.
	* For freezing of panes consider edit cell A1 special. [#594875]
	* Don't convert blank cells to 0 in LINEST. [#551234]
697
	* Fix histogram tool.
698

699 700
Jean:
	* Make plugins GUI labels translatable. [#159806]
701
	* Fix more canvas issues.
702
	* Enable image filling in shapes.
703

704 705
Morten:
	* Fix inter-process pasting of merged regions.
706
	* Make inter-process pasting use the sax parser.
707
	* Make auto-format templates use the sax parser.
708
	* Fix loading of diagonal border styles.
709
	* Improve consistency when moving toolbars around.
Morten Welinder's avatar
Morten Welinder committed
710
	* Fix translation problem with toolbar menu.  [#587250]
711 712
	* Fix printing of coloured sheet objects.
	* Fix printing of lines and arrows.
713
	* Fix sheet object/clipboard related critical on exit.  [#596509]
714
	* Fix Excel-crashing export problem with objects.  [#596886]
715
	* Add name property to sheet objects.
716
	* Start cleaning up xls sheet object writing.
717
	* Plug xls export leaks.
718
	* Implement export of lines and arrows to xls.  [Part of #597035]
719
	* Fix xls reading of sheet object colours.
720
	* Export line and textbox colouring and widths.  [Part of #597035]
721

Morten Welinder's avatar
Morten Welinder committed
722
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
723 724
Gnumeric 1.9.13

725
Jean:
726 727
	* Fix grab issue after dragging an object. [Debian bug #546559]
	* Reimplement double-click in item-cursor. [Debian bug #546690]
Jean Bréfort's avatar
Jean Bréfort committed
728
	* Fix access to GocWidget in sheet widgets. [#595627 and #595648]
729

730 731
Morten:
	* Fixes text export GUI issue.  [#594155]
732
	* Fix minor status line issue.  [#594469]
Morten Welinder's avatar
Morten Welinder committed
733
	* Fix print crash for sheet object.  [#594862]
734
	* Limit memory usage for rendered values.
735
	* Fix auto-format.
736
	* Fix API installation problem.  [#595317]
737
	* Put zoom action on vertical toolbars too.  [#590889]
738

Morten Welinder's avatar
Morten Welinder committed
739
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
740 741
Gnumeric 1.9.12

Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
742 743
Andreas:
	* Add CHOLESKY.
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
744
	* Fix ODF background colour export. [#593816]
745
	* Handle super/subscript in html export. [#593851]
746
	* Fix crash on unknown chart type. [#594041]
Morten Welinder's avatar
Morten Welinder committed
747
	* Handle ODF import/export of surface plots originally created in
748
	  XL [#594041]
Morten Welinder's avatar
Morten Welinder committed
749
	* Remember text import configuration for export. [#142395]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
750

751 752 753
Jean:
	* Don't use simple GOData when importing xls files. [#594068]

754 755
Morten:
	* Fix menu sensitivity problem.  [#593624]
756
	* Simplify GnmColor.
Morten Welinder's avatar
Morten Welinder committed
757
	* Fix grab problem.  [Debian #544975]
758
	* Simplify GnmFont.
759

Morten Welinder's avatar
Morten Welinder committed
760
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
761 762
Gnumeric 1.9.11

Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
763
Andreas:
764
	* Add AVERAGEIF, MUNIT, RRI, SEARCHB, REPLACEB, COMBINA, ARABIC.
765
	* Improve import of ODF functions
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
766

767 768 769
Jean:
	* Use GocCanvas instead of FooCanvas.

Morten Welinder's avatar
Morten Welinder committed
770 771
Morten:
	* Add GAMMA.
Morten Welinder's avatar
Morten Welinder committed
772
	* Fix Insert-Date+Time.  [#592545]
773 774
	* Fix problem with VLOOKUP and HLOOKUP when both are used on the
	  same data range.  [#593238]
Morten Welinder's avatar
Morten Welinder committed
775

Morten Welinder's avatar
Morten Welinder committed
776
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
777 778
Gnumeric 1.9.10

779
Andreas:
780 781 782 783 784 785
	* Improve ODF export.
	* Add OpenFormula comp. descriptors to some function documentations.
	* Implement new functions CSC, CSCH, SEC, and SECH.
	* Implement new functions LEFTB, MIDB, RIGHTB.
	* Implement ASC and add new function JIS.
	* Fix printing crash. [#586672]
786
	* Fix import of currency symbols from ODF.
787
	* Improve import of elapsed time from ODF.
788
	* Import some conditional cell formats from ODF.
789
	* Fix "not-between" conditional styles. [#586818]
790
	* Show existence of conditional styles in format dialog.
791
	* Add an initialy hidden long format toolbar.
792
	* Fix std error for intercept in non-affine case of LINEST. [#550933]
793
	* Fix loading of charts from MS generated ODF files. [#588107]
794
	* Add some sheet object support to ODF export.
795
	* Export basic charts to ODF.
796
	* Fix format labels in configurable text importer. [#590257]
797
	* Add warning for missing plugins needed by tools. [#590175]
798
	* Fix percentage histogram . [#590375]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
799
	* Fix non-label 2-factor ANOVA with replication.
800
	* Fix various minor bugs.
801
	* Convert old help texts to new format.
802

803 804 805
Jody:
	* Fix col/row resize. [#588297]

806
Morten:
807 808
	* Make SUMIF/COUNTIF and the D* functions understand pattern. [#586215]
	* Make dialogs remember their sizes and positions.
809
	* Fix crash with new-from-template.
Morten Welinder's avatar
Morten Welinder committed
810
	* Rework loading of configuration.  [#585701]
Morten Welinder's avatar
Morten Welinder committed
811
	* Support evaluated examples in function docs.
812
	* Simplify Win32 build.
813
	* Convert old help texts to new format.
814
	* Fix problem with print area.
815
	* Fix problems with in-sheet combos.  [#587992]
816
	* Fix translation textdomain confusion.  [#588110]
817
	* Avoid using gtk_tree_view_column_get_cell_renderers.  [#589105]
818
	* Fix DEC2HEX and friends for large values.  [#588997]
819
	* Make undo/redo visible for vertical toolbar.
820
	* Add some checking of help texts' sanity.
821

Morten Welinder's avatar
Morten Welinder committed
822
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
823 824
Gnumeric 1.9.9

825
Almer S. Tigelaar:
Morten Welinder's avatar
Morten Welinder committed
826
        * Fix scrolling via mouse wheels [#533051]
827

828
Andreas:
829 830 831 832
	* Export some data formats to ODF.
	* Fix comment export to ODF.
	* Remove distinction between label and filled rectangle.
	* Add superscipt and subscript buttons. [#583327]
833
	* Improve ODF import.
834 835 836 837 838 839 840 841 842 843 844 845
	* Improve 2 factor ANOVA tool.
	* Improve Rank & Percentiles tool.
	* Improve Fourier transform tool.
	* New FOURIER function.
	* Added Tests for Independence and Homogeneity.
	* Make imported manual page breaks work.
	* Improve print area handling and export to ODF.
	* Some minor menu rearrangement.
	* Let the sort dialog guess whether there is a header.
	* Fix xls import of sheet labels.  [#586066]
	* Fix html export.  [#586028]
	* Avoid analysis tool crashes if required plugins are not loaded.
846

847 848 849 850 851 852 853
Jody:
	* GOString start of richtext and phonetic support.
	* Extend cell combo to allow support for toggles
	* XLS/XLSX import/export for data slicer caches.
	* Hooks for data slicer UI.
	* Break GnmCommand out to allow commands in multiple files.

854 855
Morten:
	* Add search-for-number.
856
	* Fix format-as-currency action.
857 858
	* Honour --geometry even when not loading a file.
	* Fix increase/decrease precision for accounting formats.
859
	* Fix array editing criticals.  [#584746]
860 861
	* Fix style problems with operator.xls.  [#585178]
	* Fix NPER problems.
862
	* Implement new functions COT and ACOT.  [#585270]
863
	* Fix GCD.  [#585271]
864
	* Change x^y^z into x^(y^z) to indicate parsing.
865
	* Parse x^y^z as (x^y)^z from ODF files.  [#585277]
866
	* Fix text import problem.  [#135523]
867
	* Fix problem loading very old .gnumeric files.
868
	* Implement new-from-template.  [#303657]
869
	* Add Gudermannian function GD.
Morten Welinder's avatar
Morten Welinder committed
870
	* Fixed FIXED.  No, really.
871
	* Start introducing external references for function docs.
Morten Welinder's avatar
Morten Welinder committed
872
	* Implement new functions COTH and ACOTH.  [#586170]
873
	* Fix tsa crashes.  [#586191, #586427]
874
	* Fix IF problems with empties and arrays.  [#586218, #586312]
875
	* Fix problem with tooltip positions.  [#586590]
876

Morten Welinder's avatar
Morten Welinder committed
877
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
878 879
Gnumeric 1.9.8

880
Andreas:
Morten Welinder's avatar
Morten Welinder committed
881
	* Save and load text formatting of comments and of sheet object
882 883 884 885
	  labels [#580979][#580838]
	* Lots of improvements to the ODF exporter [#581937][#553508][# 582903]
	* Some improvements to the ODF importer [#581953]
	* Some improvements to the xlsx exporter [#569862][#581896]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
886
	* Write some character based formats to HTML files. [#582118]
887

Jody Goldberg's avatar
Jody Goldberg committed
888 889 890
Jody:
	* Closer to a turnkey win32 build.

891 892
Morten:
	* Optimize styles on load.
893
	* Prune fn-lookup caches in case someone is being silly.
Morten Welinder's avatar
Morten Welinder committed
894
	* Plug leak in HTML paste.
895
	* Respect the sheet size prefs for new blank workbooks.
896
	* Cache large ranges, possibly sorted.
897
	* Add progress display for OO import.
898
	* Improve ssindex' coverage.
899
	* Make it possible to have horizontal widgets too.  [#166487]
900
	* Fix sheet-object paste crash.  [#490479]
901
	* Fix critical in format dialog.  [#582890]
902
	* Turn WorkbookView into a more proper GObject.
903
	* Hide scrollbars as requested.  [#583005]
904
	* Fix date conventions in graphs.
905
	* Improve GUI for date/time axes.  [#574681]
906
	* Fix R1C1 issues.
907

908 909 910
Paul Fitzpatrick:
	* Extend ssconvert to also merge multiple sheets.  [#581616]

Morten Welinder's avatar
Morten Welinder committed
911
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
912 913
Gnumeric 1.9.7

914 915 916
Andreas:
	* Fix some divergence between character weight in the label properties
	  dialog and the label itself.