ChangeLog-1999-07-09 148 KB
Newer Older
Morten Welinder's avatar
Morten Welinder committed
1
2
1999-05-03  Morten Welinder  <terra@diku.dk>

Morten Welinder's avatar
Morten Welinder committed
3
4
5
6
7
8
9
10
11
12
13
	* src/format.c (split_time): Fix leak.

	* src/parser.y (forget): Fix leak.

	* src/expr.c (do_expr_tree_ref): Delete.
	(expr_tree_ref): Just increase the ref-count.
	(do_expr_tree_unref): Properly decrease all the way.
	(expr_tree_new): Fix prototype.
	(value_release): Add "break".
	(value_cellrange): Make args const.  Don't use memcpy call.

Morten Welinder's avatar
Morten Welinder committed
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
	* src/parser.y (v_new): Fix type.
	(alloc_register): Ditto.
	(dump_tree): Fix reference to variable cell.

	* src/file.c (file_format_unregister_save): Fix leak.
	(file_format_unregister_open): Fix leak.

	* src/parser.y (forget): Fix leak.

	* src/eval.c (add_tree_deps): Use OPER_ANY_BINARY.
	(add_value_deps): Delete unused variable.
	(dependency_remove_cell): Fix leak.

	* src/sheet.c (sheet_destroy_styles): Leak fix.  Late night
 	coding?  :-)
	(sheet_shift_row): Ditto.

	* src/parser.y (alloc_clean): Ditto.
	(alloc_list_free): Ditto.

	* src/main.c (gnumeric_main): Get rid of memory leak debug code
 	(handled by other means now).

	* src/cell.c (cell_set_value): Remove "const".
	(cell_set_value_simple): Ditto.

40
41
42
43
44
45
46
47
48
49
50
1999-05-03  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-database.c: New file added for database
 	functions. Implemented DAVERAGE(), DCOUNT(), DGET(), DMAX(),
 	DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR(), and
 	DVARP().

	* src/func.c: Added registeration of database functions.

	* src/fn-stat.c, src/func.h: callback_function_stat made public.

51
52
53
54
55
56
1999-05-02  Michael Meeks  <michael@imaginator.com>

	* src/expr.h: Spelling fix 'substract' :-)

	* src/expr.c (expr_tree_new): Added for convenience.

Michael Meeks's avatar
Michael Meeks committed
57
58
59
60
61
62
63
1999-05-02  Michael Meeks  <michael@imaginator.com>

	* src/cell.c (cell_set_value): Created.
	(cell_set_value_simple): Created.

	* src/cell.h: Added headers

64
65
66
67
68
69
70
1999-05-01  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/corba-workbook.c, src/corba-sheet.c: New files implementing
	most of the new Gnumeric.idl interface.

	* src/Gnumeric.idl: Make it useful.

71
72
1999-04-30  Morten Welinder  <terra@diku.dk>

73
74
75
76
77
78
	* src/*.h: Properly forward-declare structures.  Include
 	dependencies.  Change the occasional "void *" to its right
	type.

	* src/*.[cy]: Include more dependencies.

79
80
	* src/sheet.c (sheet_delete_row): Remove from workbook hash also.

81
82
1999-04-29  Morten Welinder  <terra@diku.dk>

83
84
85
86
87
	* src/expr.c (expr_tree_fixup_references): Implement.

	* src/sheet.c (sheet_delete_row, sheet_delete_col): Fixup
 	references.

88
89
90
91
92
93
94
95
96
97
98
99
100
101
	* src/expr.c (do_expr_tree_relocate): Remove strange and incorrect
 	refcount fiddling.

	* src/workbook.c (workbook_fixup_references,
 	workbook_invalidate_references): Fix cell walking.

	* src/expr.c (do_expr_decode_tree): rename binary_operation_names
	to operation_names and fill in the rest.

	* src/fn-misc.c (gnumeric_error): New function.

	* src/expr.c (value_str): Constify.
	(expr_tree_invalidate_references): Mostly implement.

Morten Welinder's avatar
Morten Welinder committed
102
103
104
	* src/fn-math.c (gnumeric_multinomial, gnumeric_product,
 	gnumeric_sumsq): Fix type.

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
	* src/expr.h (OPER_ANY_BINARY, OPER_ANY_UNARY): new convenience
 	macros.
	(struct _Sheet): declare forward reference so we can use the right
 	types.
	(CellRef, FunctionDefinition, expr_parse_string, expr_decode_tree,
 	eval_expr): use "struct _Sheet *".

	* src/workbook.c (workbook_do_destroy): Carefully clean workbook
 	before deleting sheets.  Do things in the standard way.  Get rid
 	of clipboard leak.
	(insert_cols_cmd): Fix name string.
	(workbook_detach_sheet): New parameter "force".  All callers
 	changed.
	(workbook_fixup_references, workbook_invalidate_references,
 	workbook_sheets): New functions.

	* src/sheet.c (sheet_verify_selection_simple): Mark strings for
 	translation.
	(sheet_insert_col): Fixup references to moved cells.
	(sheet_delete_col, sheet_delete_row): Invalidate references to
 	deleted cells.

	* src/sheet-autofill.c (fill_item_new): Fix copying of cell with
	error.

	* src/parser.y (yylex): "const" fixes.
	(gnumeric_expr_parser): New function (to fix memory corruption and
 	leaks).

	* src/fn-stat.c (i1mach): Make static.
	(gnumeric_var, gnumeric_varp, gnumeric_stdev, gnumeric_stdevp,
 	gnumeric_rank, gnumeric_trimmean, gnumeric_covar, gnumeric_correl,
 	gnumeric_mode, gnumeric_harmean, gnumeric_geomean, gnumeric_count,
 	gnumeric_counta, gnumeric_average, gnumeric_min, gnumeric_max,
 	gnumeric_skew, gnumeric_kurt, gnumeric_avedev, gnumeric_devsq,
 	gnumeric_pearson, gnumeric_rsq, gnumeric_median, gnumeric_large,
 	gnumeric_small, gnumeric_ztest): Fix type.

	* src/fn-math.c (gnumeric_fact, gnumeric_combin): Mark strings for
 	translation.
	(gnumeric_sum, gnumeric_trunc): Fix type.

	* src/fn-lookup.c (gnumeric_choose, gnumeric_column,
 	gnumeric_row): Fix type.

	* src/fn-misc.c (gnumeric_iserror): Fix type.

	* src/fn-sheet.c (gnumeric_selection): Fix type.

	* src/fn-string.c (gnumeric_concatenate): Fix type.

	* src/fn-logical.c (gnumeric_and, gnumeric_not, gnumeric_or,
 	gnumeric_if): Fix type.

	* src/fn-financial.c (gnumeric_npv): Fix type.

	* src/expr.c (expr_parse_string): Move in part to parser.y.
  	Delete global variables to communicate.
	(do_expr_tree_ref, do_expr_tree_unref, do_expr_decode_tree,
 	do_expr_tree_relocate): use OPER_ANY_BINARY and OPER_ANY_UNARY.
	(function_call_with_values): Mark strings for translation.
	(eval_expr, do_expr_decode_tree, expr_decode_tree): Fix type to
 	use "Sheet *" instead of "void *".
	(do_expr_decode_tree): Free sum.
	(expr_tree_invalidate_references, expr_tree_fixup_references): New
 	functions.  Not implemented yet.

	* src/cell.c (cell_set_formula): "const" fix.
	(cell_copy): Ref entered_string also if it exists.
	(cell_relocate): Unlink cell from workbook list of cells.

	* src/about.c (dialog_about): Add myself.  Update copyright.

178
179
1999-04-29  Jukka-Pekka Iivonen  <iivonen@iki.fi>

180
181
182
	* src/fn-{math,sheet,logical}.c, src/func.[ch]: Moved logical
 	functions into a new file.
	
183
184
	* src/fn-math.c: Added ROUNDDOWN(), ROUNDUP(), SUMX2MY2(),
 	SUMX2PY2(), and SUMXMY2().
185

186
	* src/fn-stat.c: Added PROB(). CONFIDENCE() should now work fully.
187
	
188
189
190
191
192
193
194
195
1999-04-28  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added COUNTA(), FINV(), and TINV().

	* src/fn-stat.c, src/fn-math.c: AVERAGE(), COUNT(), MAX(), and
	MIN() moved from fn-math.c to fn-stat.c.  They are in the
	statistical function group in Excel.
	
196
197
198
199
1999-04-27  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added BETADIST(), FDIST(), and TDIST().

200
201
202
203
204
205
1999-04-26  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/eval.c (intersects): Typo fix.  Sheet was being assigned
	instead of being tested for equality.  This got Michael to crash
	Gnumeric (as there was no test for can_remove)

jpekka's avatar
jpekka committed
206
207
208
209
1999-04-26  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added CHIDIST(), CHIINV(), and GAMMAINV().

210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
Sat Apr 24 14:39:32 1999  Morten Welinder  <terra@diku.dk>

	* src/sheet.c (sheet_selection_reset_only): Remove useless
 	initialisation.  Don't free individual selections here.

	(sheet_selections_free): Walk the list of selections and free each
 	one.

	(sheet_get_selection_name): Calculate buffer size based on the
 	size of an int.
	
	* src/fn-eng.c: Remove sqrtpi function -- it's already in fn-math.c

	* src/fn-math.c (gnumeric_sqrtpi): Add range check.

	* src/symbol.c (symbol_install): Add sanity check.

227
228
229
230
231
232
233
234
235
236
237
238
Fri Apr 23 17:52:44 1999  Morten Welinder  <terra@diku.dk>

	* src/sheet.c (sheet_destroy): Don't check that workbook is
	NULL because it cb_sheet_do_destroy will call it non-NULL.

	* src/workbook.c (cb_sheet_do_destroy): Don't NULL workbook
	member as it will be used.

	* src/format.c (render_number): Fix rounding up.

	* src/*.[chy]: add tons on "const"s.
	
jpekka's avatar
jpekka committed
239
240
241
242
243
244
1999-04-23  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added GAMMADIST() function.  It uses pgamma()
 	function written by Ross Ihaka.  Thanks to Morten for pointing
 	this piece of code.

245
246
247
248
249
250
251
252
253
254
255
256
257
258
1999-04-21  Morten Welinder  <terra@diku.dk>

	* src/workbook.c (workbook_do_destroy): Release the sheets and the
	hash table that held the references to the sheets. 

	* src/func.c: warning fix.
	
1999-04-21  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/widget-editable-label.c (el_button_press_event): Add type
	cast to kill warning.

	* src/format.c: Include ieeefp.h if required.

259
260
261
262
263
1999-04-19  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-string.c: Close parentheses in help_stubstitute function
	descritpion.   Thanks to Aldy Hernandez for pointing this out.

jpekka's avatar
jpekka committed
264
265
266
267
268
1999-04-19  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/dialog-goal-seek.c: Goal seek tool implemented.  Goal seek
 	should now find a solution for all linear problems (if there is
 	one).  A simple non-linear search algorithm also implemented.
jpekka's avatar
jpekka committed
269
270

	* src/workbook.c: Made 'Goal seek' menu entry visible.
jpekka's avatar
jpekka committed
271

jpekka's avatar
jpekka committed
272
273
	* src/fn-math.c: Added MULTINOMIAL(), PRODUCT(), SIGN(), SUMSQ(),
 	and SQRTPI().
jpekka's avatar
jpekka committed
274
	
275
276
277
278
279
1999-04-19  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/func.c (iterate_cellrange_callback): Eval the cell here if
	it has not yet been evaluated.

280
281
282
283
284
Sun Apr 18 17:59:09 EDT 1999 Gregory McLean <gregm@comstar.net>

	* gnumeric.spec.in: Updated and enhanced spec file. Tastes even
	better and is less filling to boot!

285
286
287
288
289
290
291
1999-04-17  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-object-container.c (make_container_item): New
	routine.  
	(sheet_object_container_land): Used to convert from the temporary
	widgets to the view provided by Bonobo.

Miguel de Icaza's avatar
Miguel de Icaza committed
292
293
1999-04-16  Miguel de Icaza  <miguel@nuclecu.unam.mx>

294
295
	* src/expr.c (value_array_resize): Fix typo bug I introduced. 

296
297
298
299
300
301
302
303
304
	* src/eval.c (cell_queue_recalc): When queuing for recalc, tag the
	cell, so that if we remove the cell from the recalc list we can
	quickly find out if we have to look for it on the list of pending
	recomputations. 
	(pick_next_cell_from_queue): Clear the cell's
	CELL_QUEUED_FOR_RECALC bit.
	(cell_unqueue_from_recalc): New routine to remove a cell queued
	for recomputation.

Miguel de Icaza's avatar
Miguel de Icaza committed
305
306
	* src/clipboard.c (new_node): Trim leading spaces.

jpekka's avatar
jpekka committed
307
308
1999-04-16  Jukka-Pekka Iivonen  <iivonen@iki.fi>

jpekka's avatar
jpekka committed
309
310
311
	* src/fn-math.c: Added EVEN, FACTDOUBLE, ODD, QUOTIENT, and
	RANDBETWEEN.
	
jpekka's avatar
jpekka committed
312
313
	* src/fn-stat.c: Added LOGINV, NORMINV, NORMSINV, RSQ, and ZTEST
 	functions.
jpekka's avatar
jpekka committed
314
	
Michael Meeks's avatar
Michael Meeks committed
315
1999-04-15  Michael Meeks  <michael@edenproject.org>
Michael Meeks's avatar
Michael Meeks committed
316

317
318
319
320
321
322
323
324
325
326
327
328
	* src/parser.y (value_dump): Added CellRange support

	* src/fn-lookup.c (gnumeric_offset): Implemented OFFSET.

	* src/expr.c (value_cellrange): Created.
	(eval_funcall): Major hack to allow auto-conversion
	of cell references to cell ranges on the fly.

	* src/expr.h: Added value_cellrange.

1999-04-15  Michael Meeks  <michael@edenproject.org>
	
Michael Meeks's avatar
Michael Meeks committed
329
330
	(gnumeric_choose): CHOOSE function implemented.

331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
1999-04-14  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet.c (sheet_destroy): No longer destroys the Bonobo
	objects here. 

	* src/sheet.h (Sheet): No longer keeps track of the ClientSites
	here. 
	
	* src/sheet-object.c (sheet_finish_object_creation): Invoke new
	class method to signal finalization of object creation.

	* src/sheet-object-container.c, src/sheet-object-container.h: New
	files that implement the Bonobo ClientSites
	(SheetObjectContainers).
	
	* src/Makefile.am (gnumeric_bonobo_SOURCES): Sources for Bonobo
	compilation. 

	* src/sheet-object.c (sheet_object_construct): Create the bounding
	box points here.  
	(sheet_set_mode_type): Fix from my previous reorganization:  Only
	stop editing mode if the mode is SHEET_MODE_SHEET.
	(sheet_button_press): Strategy change: now we accept
	sheet->current_object and we stop editing here the object.

	* src/sheet-object.h: points has been renamed to bbox_points.  
	
	* src/sheet-object-graphic.c (sheet_object_filled_realize):
	Simplified this routine.  Also, we now update the bounding box
	here.

362
363
1999-04-15  Michael Meeks  <michael@mejm2.dow.cam.ac.uk>

Michael Meeks's avatar
Michael Meeks committed
364
365
	* src/fn-lookup.c: Silly bug in types fixed.

Michael Meeks's avatar
Michael Meeks committed
366
	* src/expr.c (eval_funcall): Made cellrefs absolute.
Michael Meeks's avatar
Michael Meeks committed
367

368
369
	* src/cell.c (cell_set_text_simple): Fix for 1.234E-07

370
371
372
373
374
375
376
377
378
379
1999-04-13  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-object.c: Converted SheetObject to a Gtk+ object.
	Splitted the functionality of the SheetObject into classes:
	SheetObject abstract class;  SheetObjectGraphic for simple drawings;
	SheetObjectFilled for objects that have a fill attribute.

	* src/sheet-object-graphic.c: Implement the SheetObjectGraphic and
	SheetObjectFilled objects.

380
381
382
383
384
1999-04-13  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/xml-io.c (xml_probe): Do not crash if the file is a broken
	XML file.

385
386
387
388
389
390
1999-04-13  Zbigniew Chyla <cyba@t19.ds.pwr.wroc.pl>

	* src/workbook.c: using 'gnome_dialog_run_and_close' instead of
	'gnome_dialog_run' (which _may_ destroy dialog widget - we don't have to
	check for this case).
	
391
392
1999-04-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

393
394
395
396
	* src/corba-args.c (gnumeric_arg_parse): Intiialize Bonobo.

	* configure.in: add test for Bonobo.

397
398
399
400
401
402
403
404
405
406
407
408
409
410
	* src/clipboard.c (x_selection_to_cell_region): Fixed the
	computation of columns in the paste code.

1999-04-11  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (insert_object_cmd): Add sample bonobo support.
	Still lacking an object server selector.

	* src/sheet.c (sheet_insert_object): Add Bonobo support.

	* src/sheet-view.c (sheet_view_insert_object): Add basic Bonobo
	support.  I need to reuse the SheetObject stuff to add control
	points to the objects and to handle repositioning.

411
412
413
414
1999-04-12 Michael Meeks  <michael@imaginator.com>

	* TODO: Removed basic functions section, most are done.

Michael Meeks's avatar
Michael Meeks committed
415
416
417
418
419
420
421
422
423
424
425
426
1999-04-11 Michael Meeks  <michael@imaginator.com>

	* src/dialog-function-select.c (function_select_row):
	Check event is valid before using it, remove redundant
	total redraw.
	(category_select_row): Fix.
	(function_select_create): Removed redundant call to
	duplicated (create_description): Removed.
	
	* src/fn-lookup.c: Actualy change the lookup function
	tokens to the correct values.
	
427
428
429
430
431
432
433
434
435
1998-04-09 Zbigniew Chyla <cyba@t19.ds.pwr.wroc.pl>

	* src/workbook.c: Creating auto_expr menu every time it is popped
        up instead of using one object all the time (and referencing to
        invalid workbook from "activate" signal handler).

        * src/item-grid.c: (item_grid_popup_menu): Fixed memory leak
        (gnumeric_popup_menu used instead of gtk_menu_popup).

436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
1999-04-11 Michael Meeks  <michael@imaginator.com>

	* src/expr.c (eval_funccall): New array / 'area' tokens added,
	error strings simplified ( int type_mismatch added )
	(value_area_get_width, value_area_get_height): Implemented,
	(value_area_get_at_x_y): Implemented.
	(value_array_new, value_array_resize): Implemented.
	(value_release): Updated.
	(value_copy_to, value_array_copy_to): Updated, created.
	Added const to a scad of helper 'value_get' style functions.
	
	* src/expr.h: Value: Changed 'array' from GList to a
	structure.
	Added struct _Value for self reference.
	Added const to a scad of helper 'value_get' style functions.

	* src/func.c (function_iterate_do_value): Updated Array code.
	
	* src/eval.c (add_value_deps): Updated Array stuff.
	(add_value_deps): const added to Value *
	
	* src/dialog-function-wizard.c (function_type_input):
	Updated text for new tokens.

	* src/fn-sheet.c (gnumeric_selection): Update to new array code.
	
	* src/fn-lookup.c (columns, rows): Updated to clean new API.
	(vlookup, hlookup): Large clean.

	* src/parser.y (value_dump): Updated Array section.

	* docs/C/writing-functions.smgl: Added section explaining tokens,
	and new API.
	
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
1999-04-09 Michael Meeks  <michael@imaginator.com>

	* src/sheet.c (sheet_destroy): Move destruction of cell_hash to
	after destroy_styles.columns_and_rows that use it.
	NULL various pointers.
	(sheet_col_destroy): Added g_return_if_fail (ci)
	(sheet_duplicate_colrow): Merged into (sheet_row_new, sheet_col_new)
	and removed: nasty function.
	(sheet_destroy_columns_and_rows): Fix nasty bug using freed 'l'
	pointer ( freed by sheet_col_destroy / sheet_row_destroy ).
	NULL the pointers for safety.
	(sheet_col_destroy): NULL various pointers.

	* src/sheet.h (sheet_duplicate_colrow): Removed.
	
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
1999-04-08  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/dialog-solver.c, src/dialog-goal-seek.c, src/solver.h:
	Wrote dialogs for these tools. The tools are not implemented yet.

	* src/solver-lp.c:
	New file for linear programming methods created.

	* src/sheet.h:
	Added parameters for the Solver tool.

	* src/fn-stat.c (gnumeric_correl):
	Bug fixed.  If the covariance is zero the correlation coefficient
	should also be zero. Thanks for Vladimir for pointing this one out.
	
500
501
1999-04-07  Miguel de Icaza  <miguel@nuclecu.unam.mx>

502
503
504
	* src/xml-io.c (xmlGetCoordinates): Include fix from Richard Hult:
	Seemed to be a cut and paste error.

Morten Welinder's avatar
Morten Welinder committed
505
	* src/cell.c (cell_destroy): From Morten Welinder: destroy the
506
507
508
509
510
	cell->value only if it does exist.

	* src/file.c (dialog_query_load_file): Set the accepted value to
	false initially.  Thanks for Morten for pointing this one out.

Arturo Espinosa's avatar
Arturo Espinosa committed
511
512
513
514
515
1999-04-06  Zbigniew Chyla <cyba@piast.t19.ds.pwr.wroc.pl>

	* src/workbook.c (workbook_new): Use the translated version of the
	function to display
	
516
517
518
519
1999-04-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c: Enable the function wizard only if the --debug
	flag was passed.
Arturo Espinosa's avatar
Arturo Espinosa committed
520

521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
	* src/dialog-function-wizard.c, src/dialog-function-select.c:
	Adapt to the rest of Gnumeric coding style.

	Use a different way of creating the GUI and controlling the
	interactions. 
	
	* src/func.c, src/func.h (function_iterate_do_value): Use my
	indentation and coding style here.

	* src/dialog-cell-format.c (render_formated_version): Handle the
	case where the value might be NULL.

	* src/xml-io.c (createXmlSheet): New function.  Used in an initial
	pass over the XML file to load all of the Sheets defined there.
	(readXmlWorkbook): Now this does two passes at loading the sheet:
	the first pass creates the sheets, the second pass actually loads
	the contents.

539
540
541
542
543
544
545
546
547
548
549
1999-04-06 Michael Meeks  <michael@imaginator.com>

	* src/workbook.c (workbook_new): More sensible default
	size.

	* src/sheet.c (sheet_row_set_height): use sheet_row_new()
	instead of sheet_duplicate_colrow(), as we get duff span
	data otherwise ( not calling row_init_span )
	(sheet_col_set_width): Re-order, presumably fixing bug,
	and as for set_height.

550
551
552
553
554
555
556
557
1999-04-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/xml-io.c (createXmlSheet): New function.  Used in an initial
	pass over the XML file to load all of the Sheets defined there.
	(readXmlWorkbook): Now this does two passes at loading the sheet:
	the first pass creates the sheets, the second pass actually loads
	the contents.

558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
1999-04-06 Michael Meeks  <michael@imaginator.com>

	* src/func.c (tokenised_help_new): Improved algorithem.
	(functions_init): Made descriptions more verbose.

	* src/workbook.c (wizard_input): Cleaned to use local
	entry instead of specific wb->ea_input.
	
	* src/dialog-function-wizard.c (function_type_input):
	Update types, add recursive function button.
	(function_input): Created.
	(arg_data_list_new): Added wb to ARG_DATA, needed for
	function_input.
	Added default code for multi-arg functions.
	Deals with no-argument functions properly,
	Fix silly args=NULL g_free(args) bug.
	(dialog_function_wizard): Special 'no-arguments' quick
	case.

	* src/fn-math.c (gnumeric_rand): Added RAND function.

Morten Welinder's avatar
Morten Welinder committed
579
1999-04-05  Morten Welinder <terra@diku.dk>
580
581
582
583
584
585
586
587

	* src/cell.c (cell_set_rendered_text): Fix for circular
	references.  

1999-04-05  Miguel de Icaza  <miguel@nuclecu.unam.mx>
	
	* src/about.c (dialog_about): Do not make the about box modal.

Michael Meeks's avatar
Michael Meeks committed
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
1999-04-05 Michael Meeks  <michael@imaginator.com>

	* src/func.c (tokenised_help_new, tokenised_help_destroy),
	(tokenised_help_find_token): Implemented to assist searching
	for tokens.
	
	* src/func.h: Inserted TOKENISED_HELP struct, and prototypes.

1999-04-04 Michael Meeks  <michael@imaginator.com>

	* src/dialog_function_wizard.c: Created

	* src/workbook.c (workbook_setup_edit_area): Add Wizard
	button.

	* src/dialogs.h: Add dialog_function_wizard

	* src/func.c (functions_init): Added descriptions.
	Init categories array.
	(get_function_categories): Returns array of categories.
	(install_symbols): Add description argument.

	* src/func.h: Updated prototypes altered,
	add get_function_categories and struct FUNCTION_CATEGORY.

	* plugins/guile/plugin.c (init_plugin): Update install_symbols.

	* plugins/sample/plugin-sample.c (init_plugin): Ditto.

1999-04-03 Michael Meeks  <michael@imaginator.com>

	* src/sheet.c (sheet_cell_remove_from_hash): Now checks
	return value of g_hash_table_lookup_extended, before
	freeing a random pointer if its not there.

	* src/cellspan.c (cell_unregister_span): Check another
	pointer.

	* src/cell.c (cell_set_formula): Default error_msg !

628
629
630
631
632
633
634
635
636
637
638
1999-04-03 Michael Meeks  <michael@imaginator.com>

	* src/sheet.c (sheet_cell_remove_from_hash): Now checks
	return value of g_hash_table_lookup_extended, before
	freeing a random pointer if its not there.

	* src/cellspan.c (cell_unregister_span): Check another
	pointer.

	* src/cell.c (cell_set_formula): Default error_msg !

639
640
641
642
643
644
1999-04-02 Michael Meeks  <michael@imaginator.com>

	* src/fn-sheet.c (gnumeric_if): Fix to allow variable
	arguments, updated help & struct to comply, removed
	possible memory leak. ( Luke 17:3,4 )

645
646
647
648
1999-04-01 Michael Meeks  <michael@imaginator.com>

	* src/workbook.c (sheet_action_delete_sheet): Fix docs.

Morten Welinder's avatar
Morten Welinder committed
649
1999-03-31  Morten Welinder <terra@diku.dk>
650
651
652
653
654

	* src/fn-stat.c (phi): new internal function.
	(gnumeric_normdist): Implemented using phi instead of the built-in
	table. 

655
656
657
658
659
660
661
662
663
664
665
666
1999-03-31  Michael Meeks  <michael@imaginator.com>

	* src/dialog-cell-sort.c (dialog_cell_sort): Added multiple
	clause support, and cleaned UI.
	(add_clause, del_clause): Added.

1999-03-30  Michael Meeks  <michael@imaginator.com>

	* src/dialog-cell-sort.c (dialog_cell_sort): Fix possible
	problem with entire column selection. Need some function
	to determine largest used cell range.

667
668
669
670
671
672
673
674
675
676
677
678
1999-03-31  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/about.c (dialog_about): Fixed.  Patch from Takashi Matsuda

1999-03-30  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-financial.c (gnumeric_dollarfr): Use floor, not floorf,
	as I can not find documentation on this on my system. 

	* src/fn-math.c (gnumeric_ceiling): Use ceil, not ceilf.  I can
	not find documentation on this on my system

Morten Welinder's avatar
Morten Welinder committed
679
1998-11-12  Morten Welinder <terra@diku.dk>
680
681
682
683
	
	* src/fn-stat.c (gnumeric_variance): More precise method of
	computing the variance.

684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
1999-03-30  Michael Meeks  <michael@imaginator.com>

	* src/sheet.c (sheet_selection_first_range): This returns
	the co-ordinates of the first range, and a flag as to whether
	the selection is simply one range. This keeps things simple
	for sort.

	* src/utils.c (col_from_name): Created.

	* src/utils.h: Added prototype.

	* src/dialog-cell-sort.c: Created

	* src/workbook.c (workbook_menu_format): Added 'Sort'.
	(sort_cells_cmd): Created.

	* src/dialogs.h: Added dialog_cell_sort.
	
1999-03-30  Michael Meeks  <michael@imaginator.com>

	* src/fn-lookup.c (gnumeric_vlookup, gnumeric_hlookup):
	Removed check for same sheets in each cell reference, in
	intersheet references only a->sheet points to the other sheet.

	* src/func.c (function_iterate_do_value): Change CELLRANGE's
	sheet reference to cell_range.cell_a.sheet, since could be an
	inter-sheet reference. This fixes: Sum(Sheet1!A1:B3)

	* src/fn-eng.c: Cleaned function documentation.

	* docs/C/writing-functions.smgl: Updated for option function
	arguments.

	* src/fn-math.c (gnumeric_mod): Implemented.
	
Arturo Espinosa's avatar
0.20    
Arturo Espinosa committed
719
720
721
722
723
1999-03-30  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/expr.c (eval_expr): Fix from Ian Campbell for fixing the
	subtraction problem.

724
725
726
727
1999-03-28  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added large, median, pearson, and small. 
	
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
1999-03-28  Michael Meeks  <michael@imaginator.com>

	* src/parser.y (yylex): Added digits count to stop
	overflow of integers above 9 digits.

1999-03-27  Michael Meeks  <michael@imaginator.com>

        * src/sheet.c (fail_if_found): Renamed to
        (fail_if_not_selected): Added check for selection
        (sheet_is_region_empty): Renamed to
        (sheet_is_region_empty_or_selected): Better
        described new function.

        * src/item-cursor.c (item_cursor_target_region_ok):
        Uses sheet_is_region_empty_or_selected.

1999-03-27  Michael Meeks  <michael@imaginator.com>

        * src/expr.c (eval_funcall): Add vital 'break'
        statement :-)

1999-03-27  Michael Meeks  <michael@imaginator.com>

        * src/eval.c (cell_eval): Set default value of
        error_msg so cell doesn't get null text on
        g_return_val_if_fail (condition, NULL) ;

        * src/sheet.c (sheet_update_auto_expr):
        Internationalized ERROR string.

        * src/fn-lookup.c (gnumeric_column, gnumeric_columns)
        (gnumeric_row, gnumeric_rows): Hacked; best can do for
        now.

762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
1999-03-26  Michael Meeks  <michael@imaginator.com>

	* src/fn-eng.c (gnumeric_delta): Fix memory leak
	(gnumeric_gestep): Cleaned to better arg. model
	(bin/oct/dec/hex2...): Cleaned similarly

	* src/fn-stat.c (gnumeric_poisson): Cleaned

	* src/fn-string.c (string_and_optional_int): Removed.
	(gnumeric_left, gnumeric_right, gnumeric_find),
	(gnumeric_fixed, gnumeric_dollar, gnumeric_substitute):
	Updated to optional argument types.
	(gnumeric_clean): Moved from fn-misc.c

	* src/fn-misc.c (gnumeric_clean): Moved to fn-string.c

	* src/expr.c (cell_ref_make_absolute): Makes a CellRef
	absolute.
	(eval_funcall): Added range token 'r' for lookup
	functions, makes reference absolute so can be used
	downstream without trouble.

	* src/expr.h: Added range comments

	* src/fn-lookup.c: Created
	(lookup_simliar, gnumeric_vlookup):
	Implements VLOOKUP.
	(gnumeric_hlookup): Implements HLOOKUP.

791
792
793
794
795
796
797
1999-03-25  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-financial.c: dollarde, dollarfr, and npv added.

	* src/fn-stat.c: correl, covar, mode, negbinomdist, rank, and
 	trimmean added.

798
799
800
801
802
803
804
805
806
807
1999-03-25  Michael Meeks  <michael@imaginator.com>

	* src/expr.c (eval_funcall): Updated to add new optional argument
	token.

	* src/expr.h: Comments to explain above.

	* src/fn-eng.c (gnumeric_erf, gnumeric_delta): Drastic clean to use
	new optional token.

Arturo Espinosa's avatar
Arturo Espinosa committed
808
809
810
811
812
813
814
815
1999-03-23  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-math.c: ceiling added.

	* src/fn-stat.c: fisherinv, normsdist, and lognormdist added.

	* AUTHORS, src/about.c: added me.

816
817
818
819
Tue Mar 23 14:00:37 CET 1999 Daniel Veillard <Daniel.Veillard@w3.org>

	* src/xml-io.c : solved the problem of saving cells with < or &

820
821
822
823
824
825
826
827
1999-03-21  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: avedev, confidence, critbinom, devsq, fisher,
 	kurt, normdist, permut, skew, standardize, and weibull added.
	
	* src/fn-math.c, src/func.h: gnumeric_average and fact made public
 	(used in src/fn-stat.c).

828
829
830
831
832
1999-03-17  Vladimir Vuksan <vuksan@veus.hr>
 
 	* src/fn-financial.c: Added new functions gnumeric_ipmt,
	gnumeric_ppmt, gnumeric_duration.
 
Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
833
834
835
836
837
838
1999-03-18  Jukka-Pekka Iivonen  <iivonen@iki.fi>
 
 	* src/fn-math.c: combin added.
 
 	* src/fn-stat.c: binomdist, harmean, and hypgeomdist added.
 
Michael Meeks's avatar
Michael Meeks committed
839
840
841
842
843
1999-03-18  Michael Meeks  <michael@imaginator.com>

	* src/fn-eng.c (val_to_base): Minor fixes

1999-03-18  Sean Atkinson  <sca20@cam.ac.uk>
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
	
	* notes: typos

	* src/expr.c (value_string): cleaned to use g_strdup_printf

	* src/expr.h: typo

	* src/fn-string.c (gnumeric_mid): fixed
	internationalized various strings, typos
	(subs_string_new, subs_string_append_n, subs_string_free): added to
	speed gnumeric_substitute
	(gnumeric_concatenate, gnumeric_rept, gnumeric_find, gnumeric_fixed)
	(gnumeric_proper, gnumeric_replace, gnumeric_t, gnumeric_value)
	(gnumeric_substitute, gnumeric_dollar): implemented.

859
860
861
862
1999-03-16  Vladimir Vuksan <vuksan@veus.hr>

	* src/fn-financial.c: More financial functions: gnumeric_nominal,
	gnumeric_pv, gnumeric_fv, gnumeric_pmt.
863

864
865
1999-03-16  Miguel de Icaza  <miguel@nuclecu.unam.mx>
	
866
	* src/workbook.c: Change from active voice to passive voice in the
Morten Welinder's avatar
Morten Welinder committed
867
	help messages for "New".  Thanks to Morten for pointing this out. 2
868

869
870
1999-03-14  Miguel de Icaza  <miguel@nuclecu.unam.mx>

871
872
873
874
875
876
877
878
879
	* src/fn-math.c (callback_function_sum): Detects integer
	over/under flow. 

	* src/expr.c (eval_expr): Add integer overflow code for addition
	and substraction.

	* src/cell.c (cell_set_format): Call cell_render_value and
	cell_queue_redraw calls here.

880
881
882
	* src/expr.c (bigger_prec): When decoding left-to-right apply
	parentheses if the two priorities are equal.

883
884
885
886
887
1999-03-13  Richard Hult <rhult@hem2.passagen.se>

	* src/xml-io.c (xmlGetGnomeCanvasPoints): test against the value
	returned by xmlGetValue, not the GnomeCanvasPoints value. 

888
889
1999-03-13  Michael Meeks <michael@imaginator.com>

890
891
892
893
894
895
896
897
898
899
	* src/fn-eng.c (val_to_base, val_to_base_place),
	(bin/oct/dec/hex 2 bin/oct/dec/hex):
	Implemented - pending fixes to number storage.

1999-03-13  Michael Meeks <michael@imaginator.com>

	* src/fn-eng.c (gnumeric_delta, gnumeric_sqrtpi),
	(gnumeric_gestep): Implemented
	
	* src/fn-math.c (sqrt): Implemented.
900

901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
1999-03-13  Michael Meeks <michael@imaginator.com>

	* src/fn-eng.c: Created
	(gnumeric_erf, gnumeric_erfc, gnumeric_bessely)
	(gnumeric_besselj): Implemented
	(gnumeric_bin2dec): Moved from fn-math.c

	* src/fn-math.c (gnumeric_bin2dec): Moved to fn-eng

	* src/func.c (functions_init): Added eng_functions.

	* src/fn-stat.c: Cleaned functions help.

	* src/Makefile.am: Added fn-eng.c

916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
1999-03-11  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/clipboard.c (sheet_paste_selection): New routine.  Abstracts
	the paste operation.
	(clipboard_paste_region): Now it uses a clipboard with the active
	X selection instead of defaulting to "request clipboard from X"
	(this is only for inter-workbook copy-paste).

	* src/sheet.c (find_workbook_with_clipboard): Tries to find a
	workbook with clipboard information.  Probably the clipboard
	should be global to all Gnumeric.

	* src/render-ascii.c (cell_region_render_ascii): Free the
	information after we have used it, not before.

	* src/expr.c (eval_expr): Handle new-born recursive references. 

933
934
935
936
937
938
939
1999-03-11  Michael Meeks <michael@imaginator.com>

	* src/fn-math.c (gnumeric_power): Implemented.

	* src/fn-stat.c (gnumeric_poisson, gnumeric_gammaln):
	Implemented.

940
941
942
943
944
1999-03-11  Michael Meeks <michael@imaginator.com>

	* src/fn-stat.c (gnumeric_expondist, gnumeric_geomean):
	Implemented.

945
1999-03-10  Vladimir Vuksan <vuksan@veus.hr>
946
947
948
949
950
951
952
953
954

	* src/fn-financial.c: New file.

	(gnumeric_effect, gnumeric_sln, gnumeric_syd): New functions.

	* src/func.c (functions_init): Added financial functions.

	* src/func.h: Added extern.

Michael Meeks's avatar
Michael Meeks committed
955
956
957
958
959
960
961
962
963
1999-03-10  Michael Meeks <michael@imaginator.com>

	* src/fn-stat.c: Created.
	(gnumeric_stdev, gnumeric_stdevp, gnumeric_var, gnumeric_varp): Created

	* src/func.c (functions_init): added stat_functions

	* src/func.h: Added extern stat_functions.
	
964
965
1999-03-08  Miguel de Icaza  <miguel@nuclecu.unam.mx>

966
967
968
	* src/fn-misc.c (gnumeric_clean): Add check here: only loop until
	the end of the string.

969
970
971
	* src/sheet.c (sheet_cell_foreach_range): Revert the arguments if
	they are in a different order.

972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
1999-03-08  Takashi Matsuda <matsu@arch.comp.kyutech.ac.jp>

	* plugins: new text plugin. 	

	Add new plugin TXT for simple text inport/export
	tab separated text. multiple sheet in a workbook is separated by
	'\f' character.
	If first line of each sheet is not include tab, then that line is
	interpreted as sheet name.

	* src/gnumeric-sheet.c: Add new mean for hard-coded keyboard short
	cut CTRL-Return.  Because ItemEdit does not support XIM, I must
	click the entry whenever I want to input janapese character.  If
	user does not edit the cell, this key combination switchs a
	keyboard focus to entry .

	* Replace gdk_font_load() with gdk_fontset_load()
	src/style.c gdk_font_load() makes impossible to show international
	string.

	* src/clipboard.h 'copy by value' was not possible because of
	miss-definition of PASTE_* enume.

	* src/file.c: gnumeric_notice was called with wrong arguments.

Michael Meeks's avatar
Michael Meeks committed
997
998
999
1000
1999-03-07  Michael Meeks  <michael@imaginator.com>

	* src/cell.c (cell_set_format_from_style): Removed sluggish
	re-drawing code: unneccessary.
For faster browsing, not all history is shown. View entire blame