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
	* Fix import of LibreOffice created xlsx files using shared formulas. 
	  [#642850]
10 11
	* Fix crash on resaving LibreOffice created xlsx files with unauthored 
	  comments. [#642850]
12
	* Trigger configurable text importer on paste of tabs. [#395631]
13

14 15 16
Jean:
	* Fix cursor position inside a cell edited in a zoomed sheet. [#641709]

17 18
Morten:
	* Import wide sc files.  [#641581]
19
	* Fix problem with single-cell names and 'r'-type arguments.  [#613273]
20
	* Plug leaks.
21
	* Fix potential crash on quick exit.
22
	* Fix stf import problem diagnosed by Andreas.  [#642477]
23
	* Restore toolbar positioning code.
24

Morten Welinder's avatar
Morten Welinder committed
25
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
26 27
Gnumeric 1.10.13

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

Jean:
45
	* Only disable the formula bar when a chart sheet is selected. [#636031]
46
	* Make sheet objects invisible outline from .xls files persistent. [#637393]
47
	* Fixed arrows and line object position when zoomed. [#637453]
48 49
	* Fixed series lines color export to .xls. [#637658]
	* Fixed sheet objects position on zoomed sheets. [#637739]
50
	* Override edition-canceled property for GnmExprEntry. [#639287]
51

52 53
Morten:
	* Fix array intersection problem with IF.  [#633433]
54
	* Make sure columns are wide enough for dates in csv import.
Morten Welinder's avatar
Morten Welinder committed
55
	* Plug a few leaks.
56
	* Fix number-match issue regarding fraction.
Morten Welinder's avatar
Morten Welinder committed
57
	* Fix problems with pivot reading from xls.  [#638776]
58
	* Allow version-agnostic template files.  [#630247]
59

Morten Welinder's avatar
Morten Welinder committed
60
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
61 62
Gnumeric 1.10.12

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

78 79 80
Hans de Goede:
	* Fix import of dib format images in XLS. [#553098]

81 82
Jean:
	* Fixed maximum for col/row number in sheet resize dialog. [#631702]
83
	* Eliminate glade usage.  [#631717]
84
	* Fixed crash in print setup. [#634149]
85
	* Fixed image bounds in zoomed sheets.
86

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

99 100
Sameer Morar:
	* Add key combinations to move sheets. [#634139]
101 102
	* Modify quit dialog to be able to discard multiple files without 
	saving.  [#527133]	
103

Morten Welinder's avatar
Morten Welinder committed
104
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
105 106
Gnumeric 1.10.11

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

120
Jean:
121
	* Export/import tick label rotation angle. [#629675]
122
	* Read and write cell comments from/to OpenXML. [#630627]
123
	* New contextual menu item: copy a graph to a new graph sheet.
124

J.H.M. Dassen (Ray)'s avatar
J.H.M. Dassen (Ray) committed
125 126 127 128 129
J.H.M. Dassen (Ray):
	* Revised ssconvert man page.
	* Fix several potential and actual problems highlighted by
	  LLVM/clang static analysis.

130 131
Morten:
	* Fix date entry problem.  [#630177]
132 133
	* Fix problem with inter-process empty-value paste.  [#629302]
	* Fix problem with inter-process object paste.  [#629302]
134
	* Allow user-defined templates.  [#630247]
135
	* Improve test suite.
136

Morten Welinder's avatar
Morten Welinder committed
137
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
138 139
Gnumeric 1.10.10

140
Andreas:
141
	* Significantly improve chart export and import to/from ODF.
142
	* Improve handling of corrupted ODF files.
143
	* Fix percentage style import from ODF. [#627517]
144
	* Fix INTERPOLATION documentation. [#627461]
145 146
	* Provide progress info in ODF export.
	* Improve warnings dialog in ODF import.
147
	* Fix button sensitivity in sort dialog.
148

149 150
Jean:
	* Fix some interpolation and periodogram issues.
151
	* Fixed graph scalar data editor behavior. [#628721]
152

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

Morten Welinder's avatar
Morten Welinder committed
165
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
166 167
Gnumeric 1.10.9

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

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

202 203
Morten:
	* Survive malformed xml files.
204
	* Fix win32 random problem.  [#533779]
205
	* Fix IMPOWER problem.  [#627014]
Morten Welinder's avatar
Morten Welinder committed
206
	* Avoid criticals in ODS import.
207
	* Fix problem with collect cache.  [#627079]
208

Morten Welinder's avatar
Morten Welinder committed
209
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
210 211
Gnumeric 1.10.8

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

272 273
Jean:
	* Fix strong/weak cursor display. [#623241]
274 275
	* Fix regression in ms_excel_chart_read. [#623960]
	* Fix a regression in chart series evaluation. [#624263]
276
	* Fix crash in cell_calc_span. [#624274]
277
	* Install a self-consistent headers list.
278
	* Fixed borders display in cell format dialog.
279

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

Morten Welinder's avatar
Morten Welinder committed
291
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
292 293
Gnumeric 1.10.7

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

305
Jean:
306
	* Fixed autofilter (and other) combo positions. [#621817]
307

308 309
Morten:
	* Improve function syntax tooltips.
310
	* Fix excessive memory use problem with xlsx.  [#622365]
311
	* Make BackSpace work as Delete on pane.  [#622599]
Morten Welinder's avatar
Morten Welinder committed
312
	* Improve handling of MS-style HTML in clipboard.  [#617801]
313

Morten Welinder's avatar
Morten Welinder committed
314
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
315 316
Gnumeric 1.10.6

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

340 341
Jean:
	* Do not ungrab a not grabbed item. [#620369]
342
	* Always update the right series entry. [#620719]
343
	* Fixed multi-line item edit selection. [#621235]
344

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

Morten Welinder's avatar
Morten Welinder committed
366
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
367 368
Gnumeric 1.10.5

369 370 371
Andreas:
	* Add Wilcoxon-Mann-Whitney test tool.

Morten Welinder's avatar
Morten Welinder committed
372 373
Morten:
	* Fix stf crash.  [#619283]
374
	* Persist solver model type.
375
	* Add non-linear solver.  [#614865]
Morten Welinder's avatar
Morten Welinder committed
376
	* Feed the gtk+ deprecation monster.  [#572240]
377
	* Fix win32/paradox problem.  [#619942]
Morten Welinder's avatar
Morten Welinder committed
378

379 380 381
Sameer Morar:
	* Improve page setup dialog. [#619421]

Morten Welinder's avatar
Morten Welinder committed
382
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
383 384
Gnumeric 1.10.4

385 386
Andreas:
	* Include version number in HTML export.
387

388
Jean:
389
	* Fixed autofill issues. [#618687]
390 391 392

Morten:
	* Linear regression test suite.
393
	* Fix TABLE problem.  [#618829]
394 395
	* Handle "Jan 2010" and "January 2010" better.
	* Fix date parsing problems for invalid years.
396

397 398 399
Sameer Morar:
 	* Fix sheet order dialog layout. [#619056]

Morten Welinder's avatar
Morten Welinder committed
400
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
401 402
Gnumeric 1.10.3

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

417
Jean:
418
	* Implement graph only sheets. [#158170]
419
	* Fix chart title import when excel automagically uses the unique
Morten Welinder's avatar
Morten Welinder committed
420
	  series label. [#616262]
421
	* Allow multiple and block selection for graph vector data.
Morten Welinder's avatar
Morten Welinder committed
422
	  [#494685,#616068]
423
	 * Use the "combo-activate" signal where appropriate? [#583175]
424

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

Morten Welinder's avatar
Morten Welinder committed
441
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
442 443
Gnumeric 1.10.2

444 445 446
Alexander Kahl & Sven Mantei:
	* Some documentation updates

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

462 463 464
Jean:
	* Print pattern backgrounds. [#615365]

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

Morten Welinder's avatar
Morten Welinder committed
480
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
481 482
Gnumeric 1.10.1

483 484
Andreas:
	* Fix storing of error-literals in ODF. [#610175]
485
	* Don't export filter combos to ODF. [#610399]
486
	* Apply filter on ODF import. [#610399]
487 488
	* Fix display of autocomplete suggestions. [#610537]
	* Fix formatting of multirow cells in LaTeX export. [#611633]
489
	* Protect exported LaTeX files from babel shorthands.
490

491
Jean:
Morten Welinder's avatar
Morten Welinder committed
492
	* Fix a crash in excelplugin. [#610012]
493
	* Fix cursor appearance. [#611076]
494

495 496
Morten:
	* Turn off -Wstrict-prototypes for the stable series.
497 498
	* Fix ODF read problem.  [#610178]
	* Fix rendering problem with iterated evaluation.
499
	* Fix solver undo problem.  [#611406]
500
	* Fix graph label problem.  [#611362]
501
	* Fix GLPK solver issue.  [#611407]
Morten Welinder's avatar
Morten Welinder committed
502
	* Fix ssindex crash.  [#611842]
503
	* Fix ODF export of intersection.  [#611824]
504
	* Fix cell comment critical.
505

Morten Welinder's avatar
Morten Welinder committed
506
--------------------------------------------------------------------------
507
Gnumeric 1.10.0
Morten Welinder's avatar
Morten Welinder committed
508

509 510
Andreas:
	* Fix ODF contour/surface plot confusion. [#607631]
511 512
	* Include compatibility info in the gnumeric manual.
	* Fix confidence interval in simulation output. [#607970]
513

514 515
Morten:
	* Fix TRIMMEAN border case.  [#607562]
Morten Welinder's avatar
Morten Welinder committed
516
	* Fix TDIST border case.  [#607008]
517
	* Fix problem with hpaned for tabs/scrollbar.  [#607794]
Morten Welinder's avatar
Morten Welinder committed
518

Morten Welinder's avatar
Morten Welinder committed
519 520 521
Peter Jaeckel:
	* Support for XLL files.  [#597849]

Morten Welinder's avatar
Morten Welinder committed
522
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
523 524
Gnumeric 1.9.18

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

560
Jean:
561
	* Fix import export of line type in scatter plots. [#605043]
562
	* Force sharing of first series in line plots when requested. [#605330]
563
	* Fixed mouse cursor for object resizing in RTL mode. [#605514]
564

565 566
Jody:
	* Fix use of ExprEntry from glade on win32.
567
	* More win32 build fixes (xslt for libgda & poppler).
568
	* Fix pango test harness.
569
	* Fix use of Tab in ExprEntry for gurus.
570
	* Adapt to latest gtk-2.19.3 GSEAL.
571

572 573 574
Morten:
	* Fix GCD border case.  [#606870]

Morten Welinder's avatar
Morten Welinder committed
575
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
576 577
Gnumeric 1.9.17

578
Andreas:
579
	* Update EURO and EUROCONVERT with currencies added in 2007 to 2009.
580
	* Export hyperlinks to ODF. [#603533]
581 582
	* Make EUROCONVERT Excel compatible [#603755]
	* Update modification times. [#603099]
583
	* Add RANK.AVG (rank function returning average rank for ties)
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
584
	* Added Sign Test to statistical analysis tools
585

586 587 588
Gabriel Kerneis:
	* Implement --one-file-per-sheet in ssconvert [#604549]

589 590
Jean:
	* Fixed problem with row headers. [#603862]
591
	* Fixed pane origin when zoomed. [#604373]
592
	* Make the cell comment red triangle visible in RTL mode. [#604580]
593

Morten Welinder's avatar
Morten Welinder committed
594 595
Morten:
	* Elminate use of "float".
596
	* Fix selection problem.  [#601107]
Morten Welinder's avatar
Morten Welinder committed
597
	* Automate solver testing.
598
	* Fix SUMIF problems.  [#603671] [#604214]
599
	* Fix DATEDIF problem across bogus 1900-02-29.  [#599461]
600
	* Fix graph editor crash.  [#604223]
Morten Welinder's avatar
Morten Welinder committed
601
	* Fix goal seek problems.
602
	* Fix ODS import crash.  [#604615]
Morten Welinder's avatar
Morten Welinder committed
603

Morten Welinder's avatar
Morten Welinder committed
604
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
605 606
Gnumeric 1.9.16

607 608
Andreas:
	* Clarify distinction between Document and View Properties.
609 610
	* Sort the translated labels in the preference dialog.
	* Turn view properties dialog into instant-apply dialog.
611
	* Temporarily remember the sort setups. [#100541]
612
	* Work around GTK bug #601922.
613
	* Add ADTEST (Anderson-Darling Test for Normality).
614 615 616 617
	* 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).
618

619
Jean:
Jean Bréfort's avatar
Jean Bréfort committed
620
	* Fix cursor and cell edition on dark backgrounds. [#600656]
621
	* Fix multiple error message boxes in graph guru. [#152517]
Jean Bréfort's avatar
Jean Bréfort committed
622 623
	* Invert selected text in a cell when editing. [#122176]
	* Allow selection when the click occur after the last character. [#388342]
624
	* Fixed selecting text in a cell. [#337521]
Morten Welinder's avatar
Morten Welinder committed
625

626 627 628 629
Jody:
	* turnkey win32 build on 32bit host.
	* update desktop file to follow new guidelines.

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

Morten Welinder's avatar
Morten Welinder committed
645
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
646 647
Gnumeric 1.9.15

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

662 663 664
Jean:
	* Fixed graph size issues. [#599887]

665 666 667
Jody:
	* First steps towards a turnkey win32 build.

668 669
Morten:
	* Fix sheet-resize vs. merges issue.  [#582030]
670 671 672
	* 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]
673
	* Add xls export of list widgets.  [Part of #597035]
674 675
	* Add xls export of combo widgets.  [Part of #597035]
	* Add xls export of button widgets.  [Part of #597035]
676 677 678
	* Make it possible for arrows to have arrow heads in both ends.
	* Implement round arrow heads.
	* Fix xls import and export of line styles.
679
	* Save and read new arrow attributes in xml format.
680
	* Fix Excel-to-Gnumeric paste problem.  [#381732, #388531].
681
	* Fix Alt-Enter problems.  [#597295]
682
	* Make DATE work for pre-1900 dates.  [#599365]
683
	* Add lpsolve output format.
Morten Welinder's avatar
Morten Welinder committed
684
	* Plug solver leaks.
685
	* Some solver cleanups.
686
	* Fix reading of solver constraints.
687

688 689 690
Yaacov Zamir:
       * Hebrew Calendar functions.  [#153738]

Morten Welinder's avatar
Morten Welinder committed
691
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
692 693
Gnumeric 1.9.14

694 695
Albert Gräf:
        * Add button sheet object.
696
        * Add radiobutton sheet object.  [#595670]
697

698 699
Andreas:
	* Add more ODF elements on ODF read. [#595750]
700 701 702 703
	* 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]
704
	* Fix histogram tool.
705

706 707
Jean:
	* Make plugins GUI labels translatable. [#159806]
708
	* Fix more canvas issues.
709
	* Enable image filling in shapes.
710

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

Morten Welinder's avatar
Morten Welinder committed
729
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
730 731
Gnumeric 1.9.13

732
Jean:
733 734
	* 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
735
	* Fix access to GocWidget in sheet widgets. [#595627 and #595648]
736

737 738
Morten:
	* Fixes text export GUI issue.  [#594155]
739
	* Fix minor status line issue.  [#594469]
Morten Welinder's avatar
Morten Welinder committed
740
	* Fix print crash for sheet object.  [#594862]
741
	* Limit memory usage for rendered values.
742
	* Fix auto-format.
743
	* Fix API installation problem.  [#595317]
744
	* Put zoom action on vertical toolbars too.  [#590889]
745

Morten Welinder's avatar
Morten Welinder committed
746
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
747 748
Gnumeric 1.9.12

Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
749 750
Andreas:
	* Add CHOLESKY.
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
751
	* Fix ODF background colour export. [#593816]
752
	* Handle super/subscript in html export. [#593851]
753
	* Fix crash on unknown chart type. [#594041]
Morten Welinder's avatar
Morten Welinder committed
754
	* Handle ODF import/export of surface plots originally created in
755
	  XL [#594041]
Morten Welinder's avatar
Morten Welinder committed
756
	* Remember text import configuration for export. [#142395]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
757

758 759 760
Jean:
	* Don't use simple GOData when importing xls files. [#594068]

761 762
Morten:
	* Fix menu sensitivity problem.  [#593624]
763
	* Simplify GnmColor.
Morten Welinder's avatar
Morten Welinder committed
764
	* Fix grab problem.  [Debian #544975]
765
	* Simplify GnmFont.
766

Morten Welinder's avatar
Morten Welinder committed
767
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
768 769
Gnumeric 1.9.11

Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
770
Andreas:
771
	* Add AVERAGEIF, MUNIT, RRI, SEARCHB, REPLACEB, COMBINA, ARABIC.
772
	* Improve import of ODF functions
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
773

774 775 776
Jean:
	* Use GocCanvas instead of FooCanvas.

Morten Welinder's avatar
Morten Welinder committed
777 778
Morten:
	* Add GAMMA.
Morten Welinder's avatar
Morten Welinder committed
779
	* Fix Insert-Date+Time.  [#592545]
780 781
	* Fix problem with VLOOKUP and HLOOKUP when both are used on the
	  same data range.  [#593238]
Morten Welinder's avatar
Morten Welinder committed
782

Morten Welinder's avatar
Morten Welinder committed
783
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
784 785
Gnumeric 1.9.10

786
Andreas:
787 788 789 790 791 792
	* 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]
793
	* Fix import of currency symbols from ODF.
794
	* Improve import of elapsed time from ODF.
795
	* Import some conditional cell formats from ODF.
796
	* Fix "not-between" conditional styles. [#586818]
797
	* Show existence of conditional styles in format dialog.
798
	* Add an initialy hidden long format toolbar.
799
	* Fix std error for intercept in non-affine case of LINEST. [#550933]
800
	* Fix loading of charts from MS generated ODF files. [#588107]
801
	* Add some sheet object support to ODF export.
802
	* Export basic charts to ODF.
803
	* Fix format labels in configurable text importer. [#590257]
804
	* Add warning for missing plugins needed by tools. [#590175]
805
	* Fix percentage histogram . [#590375]
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
806
	* Fix non-label 2-factor ANOVA with replication.
807
	* Fix various minor bugs.
808
	* Convert old help texts to new format.
809

810 811 812
Jody:
	* Fix col/row resize. [#588297]

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

Morten Welinder's avatar
Morten Welinder committed
829
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
830 831
Gnumeric 1.9.9

832
Almer S. Tigelaar:
Morten Welinder's avatar
Morten Welinder committed
833
        * Fix scrolling via mouse wheels [#533051]
834

835
Andreas:
836 837 838 839
	* Export some data formats to ODF.
	* Fix comment export to ODF.
	* Remove distinction between label and filled rectangle.
	* Add superscipt and subscript buttons. [#583327]
840
	* Improve ODF import.
841 842 843 844 845 846 847 848 849 850 851 852
	* 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.
853

854 855 856 857 858 859 860
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.

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

Morten Welinder's avatar
Morten Welinder committed
884
--------------------------------------------------------------------------
Morten Welinder's avatar
Morten Welinder committed
885 886
Gnumeric 1.9.8

887
Andreas:
Morten Welinder's avatar
Morten Welinder committed
888
	* Save and load text formatting of comments and of sheet object
889 890 891 892
	  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
893
	* Write some character based formats to HTML files. [#582118]
894

Jody Goldberg's avatar
Jody Goldberg committed
895 896 897
Jody:
	* Closer to a turnkey win32 build.

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