ChangeLog-2000-02-23 158 KB
Newer Older
1 2 3 4 5
1999-05-16  Michael Meeks  <michael@imaginator.com>

	* CHANGES: Added to ease burdern of creating accurate descriptions
	between versions.

6 7 8 9 10 11 12
1999-05-15  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* samples/statfuns.xls: Added a new file.  It can be used for
 	regression testing.  It is in Excel format so it tests the Excel
 	plugin's functionality in the same time too.


13 14 15 16 17 18 19 20 21 22 23 24 25 26
1999-05-15  Michael Meeks  <michael@imaginator.com>

	* src/file.c (file_format_register_save): Changed to append
	new types; works round bug in selection.

	* src/expr.c (eval_cell_value): Fix sillyness of top left
	corner stuff.

	* src/expr.h: Added const to value_dump

	* src/parser.y (value_dump): Fixed array problem.
	Added const to parameter.

	
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
1999-05-15  Michael Meeks  <michael@imaginator.com>

	* src/parser.c (value_dump): Updated Arrays, to use Value *

	* src/func.c (function_iterate_do_value): same.

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

	* src/eval.c (add_value_deps): same.

	* src/expr.c (value_get_as_string): Major re-work of ARRAY
	conversion.
	(value_array_set): Fix rather embarassing bug in assertions.
	(eval_cell_value): Return top left corner of array, seems to be
	what excel does.
	(value_release, value_array_set, value_array_new),
	(value_array_copy_to, value_array_resize):
	Updated value->v.array to Value *'s saves much hassle !

46 47 48 49 50 51 52 53 54 55 56 57
1999-05-14  Michael Meeks  <michael@imaginator.com>

	* src/expr.c (value_area_get_width, value_area_get_height): 
	Clip to sheet bounds if CELLRANGE: Massive speedup on some
	lookups.

	* src/expr.h: Added value_zero

	* src/func.c (constants_init): Added a 'value_zero' constant
	to kill leak in out-of-range / NULL cell cases in value_get_at_x_y
	

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
58 59 60 61
1999-05-14  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-math.c: Added LCM().
	
Kjartan Maraas's avatar
Kjartan Maraas committed
62 63 64 65 66
1999-05-13  Kjartan Maraas  <kmaraas@online.no>

	* src/Gnumeric.idl: s/#include <gnome-object.idl>/
	  #include <GnomeObject.idl>, to make it compile.
	  
67 68 69 70 71
1999-05-13  Michael Meeks  <michael@imaginator.com>

	* src/Gnumeric-impl.c: Fixes killing this file by
	mistake.

72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
1999-05-13  Michael Meeks  <michael@imaginator.com>

	* src/expr.h: Updated all prototypes.

	* *.c: 
	s/\<value_float *(/value_new_float (/g
	s/\<value_int *(/value_new_int (/g
	s/\<value_str *(/value_new_string (/g
	s/\<value_string *(/value_get_as_string (/g
	s/\<value_cellrange *(/value_new_cellrange (/g
	s/\<value_get_as_double *(/value_get_as_float (/g
	s/\<value_get_bool *(/value_get_as_bool (/g

	* src/expr.c: Moved all pertainant Value functions to the
	same place to aid possible splitting.

Michael Meeks's avatar
Michael Meeks committed
88 89 90 91 92 93 94 95 96 97 98 99 100 101
1999-05-13  Michael Meeks  <michael@imaginator.com>

	* src/expr.c (value_area_get_at_x_y): Added warning
	in safety case.

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

	* src/func.h: Updated critera_test_fun_t: returns int,
	should really be gboolean ?

	* src/expr.h: Added prototype & indentation beautified.

	* src/expr.c (value_array_set): Helper function added.

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
102 103 104 105
1999-05-13  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-math.c: Added GCD().

106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
1999-05-12  Michael Meeks  <michael@imaginator.com>

	* src/workbook.c (workbook_setup_edit_area): Added dependancy
	debugging button for --debug=10 and fixed memory leak.
	(deps_output): Dumps dependency data to stdout.

	* src/gnumeric-util.c (range_contains): Re-order compares
	to catch single cell ranges more quickly.

	* src/eval.c (intersects): Change order of sheet / range check
	for speed.
	(search_cell_deps): Added comment.

	* src/eval.h: Cosmetic typo. fix shet -> sheet

121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141
1999-05-12  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-database.c: Database functions accept now string
 	criterias too.  In addition, the parsing of criterias and the test
 	functions are now public (src/fn-math.c uses these for now on).

	* src/func.h: Added type definitions and function prototypes for
 	internal functions that parse and test criterias.
	
	* src/fn-math.c: Added LN().  Changed LOG() to take an optional
 	second parameter.  LOG() returns the logarithm in base 10 if the
 	optional argument is not given, otherwise it returns the logarithm
 	in the given base.

	* src/fn-math.c: Added COUNTIF() and SUMIF().
	
	* src/fn-eng.c: Added IMLOG10() and IMLOG2().
	
	* src/fn-eng.c (complex_ln): Fixed a bug.  Imaginary coefficient
	was calculated incorrectly.

142 143 144 145 146 147
1999-05-11  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-eng.c: Added CONVERT().  All translations should work.
  	Also get_real_and_imaginary() fixed (complex numbers should now
 	work completely).

Michael Meeks's avatar
Michael Meeks committed
148 149 150 151 152 153
1999-05-10  Michael Meeks  <michael@imaginator.com>

	* src/sheet.h: Added workbook_focus_sheet.

	* src/workbook.c (workbook_focus_sheet): Added.

154 155 156 157 158 159
1999-05-10  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-eng.c: Added IMARGUMENT(), IMCONJUGATE(), IMCOS(),
 	IMDIV(), IMEXP(), IMLN(), IMPOWER(), IMPRODUCT(), IMSIN(),
 	IMSQRT(), IMSUB(), and IMSUM().

160 161 162 163 164 165
1999-05-08  Michael Meeks  <michael@imaginator.com>

	* web/index.html: Fix sillyness in references.

	* web/gnumeric-0.25: Remove HTML tags...

166 167
1999-05-08  Michael Meeks  <michael@imaginator.com>

168 169 170 171
	* src/Makefile.am (gnumeric_LDADD): Added libole2 library.

	* configure.in (XML_CFLAGS): Updated to add excel/libole2

172 173 174 175 176 177 178 179
	* src/sheet.h: Commented sheet_cell_get vs. _fetch.

	* src/expr.c (do_expr_tree_unref, value_string, value_release),
	(eval_cell_value, do_expr_tree_invalidate_references): 
	Clean: Added 'default' cases with warnings.
	(value_get_as_double, value_get_as_int, value_get_bool): Changed
	to safer / faster switch statement from if.

180 181 182 183 184 185 186 187 188
1999-05-07  Michael Meeks  <michael@imaginator.com>

	* src/corba-workbook.c (corba_sheet): Add CORBA_Environment
	parameter, needed for Object_dupicate...
	(Workbook_sheet_new, Workbook_sheet_lookup),
	(Workbook_sheet_current): Updated corba_sheet's args.

	* src/fn-lookup.c: Fixed choose help.

189 190 191 192 193
1999-05-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/corba-workbook.c (corba_sheet): Duplicate the object before
	returning to ORBit.

194 195 196 197 198 199 200 201 202
1999-05-07  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-eng.c: Added COMPLEX(), IMABS(), IMAGINARY(), IMREAL().
  	Also added an internal function get_real_and_imaginary() which
 	still needs to be improved.
	
	* src/fn-math.c: Added MROUND() and ROMAN().  ROMAN() currently
 	supports only type 0 (classic).

203 204 205 206 207 208
1999-05-07  Heath Martin  <martinh@pegasus.cc.ucf.edu>

	* src/expr.c (expr_tree_invalidate_references): Add extra argument
 	for the sheet we are changing.  All callers changed.
	(expr_tree_fixup_references): Ditto.

Morten Welinder's avatar
Morten Welinder committed
209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233
1999-05-06  Morten Welinder  <terra@diku.dk>

	* src/eval.c (cell_queue_recalc): Don't re-queue cell.
	(cell_queue_recalc_list): Don't re-queue cells.  (Because it is
 	wasteful and because unqueue then won't work right.)

	* src/fn-lookup.c (gnumeric_column): Fix leak.
	(gnumeric_row): Fix leak.
	(gnumeric_choose): Fix leak.
	(lookup_similar): Fix leaks.

	* src/xml-io.c (xml_probe): Fix leak.
	(xmlGetValue): Fix *HUGE* leak.
	(readXmlStyle): Fix leaks.
	(readXmlSheet): Fix leaks.
	(createXmlSheet): Fix leak.
	(readXmlCell): Move the freeze, just in case.

	* src/fn-lookup.c (gnumeric_choose): Remove (incorrect) arg check.

	* src/cell.c (cell_copy): Properly handle render_color member.
  	Clear the CELL_QUEUED_FOR_RECALC flag.
	(cell_destroy): Add code to make it painfully clear when members
 	of freed cells are accessed.

234 235
1999-05-06  Michael Meeks  <michael@imaginator.com>

Michael Meeks's avatar
Michael Meeks committed
236 237 238 239 240 241 242 243 244 245 246 247
	* src/cell.h: Added deep freeze prototypes.

	* src/cell.c (cell_deep_freeze_redraws): Added
	(cell_deep_thaw_redraws): Added,
	(cell_queue_redraw): Updated to use deep_freeze
	effectively ignore redraw requests.

	* src/xml-io.c (readXmlCell): Added deep freeze/thaw
	redraws for clean and easy speedup.

1999-05-06  Michael Meeks  <michael@imaginator.com>
	
248 249 250 251
	* src/workbook.c: Moved 'Sort' to the tools menu.

	* HACKING: Pedantic clean.

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
252 253
1999-05-06  Jukka-Pekka Iivonen  <iivonen@iki.fi>

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
254 255 256 257
	* src/fn-date.c: Added EDATE().

1999-05-06  Jukka-Pekka Iivonen  <iivonen@iki.fi>
	
Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
258 259
	* src/fn-date.c: Added DATEVALUE().
	
260 261 262 263 264
1999-05-05  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-database.c (parse_criteria): If a condition contains
	just a number, it is an equality condition.
	
265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281
1999-05-05  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* configure.in: Laptop does not have resources.  Make guile
	optional until at least.

	* src: Now we only support two modes: Gnumeric and
	Gnumeric-Bonobo.  The later includes all of the CORBA support,
	there is no longer a non-Bonobo CORBA version.

	* src/corba-workbook.c, src/corba-sheet.c, src/workbook-factory.c:
	New files that support the Gnumeric CORBA interfaces.

1999-05-02  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/corba-workbook.c (WorkbookFactory_init): Add workbook
	factory servant initialization.

282 283 284 285 286 287 288 289 290 291 292 293 294
1999-05-04  Morten Welinder  <terra@diku.dk>

	* src/eval.c (dependency_remove_cell): Remove unused assignment.
	(cell_queue_recalc_list): Mark queued cells as being so.

	* src/fn-math.c (gnumeric_combin): Clean up.
	(combin): Handle large numbers carefully.

	* src/utils.c (january_1900): Fix argument list.

	* src/fn-stat.c (gnumeric_var): Remove unused variable.
	(gnumeric_varp): Ditto.

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
295 296 297 298 299 300 301 302 303
1999-05-04  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-math: Added ROUND().
	
	* src/fn-information: Added new file for information functions.
	New function COUNTBLANK() implemented.

	* src/Makefile.am, src/func.[ch]: Added `fn-information.c'.
	
Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
304 305 306 307 308 309 310
1999-05-04  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-database.c: Added DCOUNTA().

	* src/fn-stat.c: Added argument count checks for VAR() and VARP().
	Added STEYX().

Morten Welinder's avatar
Morten Welinder committed
311 312
1999-05-03  Morten Welinder  <terra@diku.dk>

Morten Welinder's avatar
Morten Welinder committed
313 314 315 316 317 318 319 320 321 322 323
	* 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
324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349
	* 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.

350 351 352 353 354 355 356 357 358 359 360
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.

361 362 363 364 365 366
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
367 368 369 370 371 372 373
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

374 375 376 377 378 379 380
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.

381 382
1999-04-30  Morten Welinder  <terra@diku.dk>

383 384 385 386 387 388
	* src/*.h: Properly forward-declare structures.  Include
 	dependencies.  Change the occasional "void *" to its right
	type.

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

389 390
	* src/sheet.c (sheet_delete_row): Remove from workbook hash also.

391 392
1999-04-29  Morten Welinder  <terra@diku.dk>

393 394 395 396 397
	* src/expr.c (expr_tree_fixup_references): Implement.

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

398 399 400 401 402 403 404 405 406 407 408 409 410 411
	* 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
412 413 414
	* src/fn-math.c (gnumeric_multinomial, gnumeric_product,
 	gnumeric_sumsq): Fix type.

415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 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 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487
	* 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.

488 489
1999-04-29  Jukka-Pekka Iivonen  <iivonen@iki.fi>

490 491 492
	* src/fn-{math,sheet,logical}.c, src/func.[ch]: Moved logical
 	functions into a new file.
	
493 494
	* src/fn-math.c: Added ROUNDDOWN(), ROUNDUP(), SUMX2MY2(),
 	SUMX2PY2(), and SUMXMY2().
495

496
	* src/fn-stat.c: Added PROB(). CONFIDENCE() should now work fully.
497
	
498 499 500 501 502 503 504 505
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.
	
506 507 508 509
1999-04-27  Jukka-Pekka Iivonen  <iivonen@iki.fi>

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

510 511 512 513 514 515
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
516 517 518 519
1999-04-26  Jukka-Pekka Iivonen  <iivonen@iki.fi>

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

520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536
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.

537 538 539 540 541 542 543 544 545 546 547 548
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
549 550 551 552 553 554
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.

555 556 557 558 559 560 561 562 563 564 565 566 567 568
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.

569 570 571 572 573
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
574 575 576 577 578
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
579 580

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

jpekka's avatar
jpekka committed
582 583
	* src/fn-math.c: Added MULTINOMIAL(), PRODUCT(), SIGN(), SUMSQ(),
 	and SQRTPI().
jpekka's avatar
jpekka committed
584
	
585 586 587 588 589
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.

590 591 592 593 594
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!

595 596 597 598 599 600 601
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
602 603
1999-04-16  Miguel de Icaza  <miguel@nuclecu.unam.mx>

604 605
	* src/expr.c (value_array_resize): Fix typo bug I introduced. 

606 607 608 609 610 611 612 613 614
	* 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
615 616
	* src/clipboard.c (new_node): Trim leading spaces.

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

jpekka's avatar
jpekka committed
619 620 621
	* src/fn-math.c: Added EVEN, FACTDOUBLE, ODD, QUOTIENT, and
	RANDBETWEEN.
	
jpekka's avatar
jpekka committed
622 623
	* src/fn-stat.c: Added LOGINV, NORMINV, NORMSINV, RSQ, and ZTEST
 	functions.
jpekka's avatar
jpekka committed
624
	
Michael Meeks's avatar
Michael Meeks committed
625
1999-04-15  Michael Meeks  <michael@edenproject.org>
Michael Meeks's avatar
Michael Meeks committed
626

627 628 629 630 631 632 633 634 635 636 637 638
	* 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
639 640
	(gnumeric_choose): CHOOSE function implemented.

641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671
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.

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

674 675
	* src/fn-lookup.c: Silly bug in types fixed.

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

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

680 681 682 683 684 685 686 687 688 689
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.

690 691 692 693 694
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.

695 696 697 698 699 700
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).
	
701 702
1999-04-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

703 704 705 706
	* src/corba-args.c (gnumeric_arg_parse): Intiialize Bonobo.

	* configure.in: add test for Bonobo.

707 708 709 710 711 712 713 714 715 716 717 718 719 720
	* 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.

721 722 723 724
1999-04-12 Michael Meeks  <michael@imaginator.com>

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

Michael Meeks's avatar
Michael Meeks committed
725 726 727 728 729 730 731 732 733 734 735 736
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.
	
737 738 739 740 741 742 743 744 745
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).

746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779
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.
	
780 781 782 783 784 785 786 787 788 789 790 791 792 793 794
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.
	
795 796 797 798 799 800 801 802 803 804 805 806 807 808 809
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.
	
810 811
1999-04-07  Miguel de Icaza  <miguel@nuclecu.unam.mx>

812 813 814
	* 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
815
	* src/cell.c (cell_destroy): From Morten Welinder: destroy the
816 817 818 819 820
	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.

821 822 823 824 825
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
	
826 827 828 829
1999-04-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c: Enable the function wizard only if the --debug
	flag was passed.
830

831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848
	* 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.

849 850 851 852 853 854 855 856 857 858 859
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.

860 861 862 863 864 865 866 867
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.

868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888
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
889
1999-04-05  Morten Welinder <terra@diku.dk>
890 891 892 893 894 895 896 897

	* 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
898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937
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 !

938 939 940 941 942 943 944 945 946 947 948
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 !

949 950 951 952 953 954
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 )

955 956 957 958
1999-04-01 Michael Meeks  <michael@imaginator.com>

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

Morten Welinder's avatar
Morten Welinder committed
959
1999-03-31  Morten Welinder <terra@diku.dk>
960 961 962 963 964

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

965 966 967 968 969 970 971 972 973 974 975 976
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.

977 978 979 980 981 982 983 984 985 986 987 988
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
989
1998-11-12  Morten Welinder <terra@diku.dk>
990 991 992 993
	
	* src/fn-stat.c (gnumeric_variance): More precise method of
	computing the variance.

994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028
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
Arturo Espinosa committed
1029 1030 1031 1032 1033
1999-03-30  Miguel de Icaza  <miguel@nuclecu.unam.mx>

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

1034 1035 1036 1037
1999-03-28  Jukka-Pekka Iivonen  <iivonen@iki.fi>

	* src/fn-stat.c: Added large, median, pearson, and small. 
	
1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071
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.

1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100
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.

1101 1102 1103 1104 1105 1106 1107
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.

1108 1109 1110 1111 1112 1113 1114 1115 1116 1117
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.

1118 1119 1120 1121 1122 1123 1124 1125
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.

1126 1127 1128 1129
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 &

1130 1131 1132 1133 1134 1135 1136 1137
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).

1138 1139 1140 1141 1142
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
1143 1144 1145 1146 1147 1148
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
1149 1150 1151 1152 1153
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>
1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168
	
	* 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.

1169 1170 1171 1172
1999-03-16  Vladimir Vuksan <vuksan@veus.hr>

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

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

1179 1180
1999-03-14  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1181 1182 1183 1184 1185 1186 1187 1188 1189
	* 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.

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

1193 1194 1195 1196 1197
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. 

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

1200 1201 1202 1203 1204 1205 1206 1207 1208 1209
	* 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.
1210

1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225
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

1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242
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. 

1243 1244 1245 1246 1247 1248 1249
1999-03-11  Michael Meeks <michael@imaginator.com>

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

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

1250 1251 1252 1253 1254
1999-03-11  Michael Meeks <michael@imaginator.com>

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

1255
1999-03-10  Vladimir Vuksan <vuksan@veus.hr>
1256 1257 1258 1259 1260 1261 1262 1263 1264

	* 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
1265 1266 1267 1268 1269 1270 1271 1272 1273
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.
	
1274 1275
1999-03-08  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1276 1277 1278
	* src/fn-misc.c (gnumeric_clean): Add check here: only loop until
	the end of the string.

1279 1280 1281
	* src/sheet.c (sheet_cell_foreach_range): Revert the arguments if
	they are in a different order.

1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306
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
1307 1308 1309 1310 1311
1999-03-07  Michael Meeks  <michael@imaginator.com>

	* src/cell.c (cell_set_format_from_style): Removed sluggish
	re-drawing code: unneccessary.

1312 1313 1314 1315
1999-03-05  Michael Meeks  <michael@imaginator.com>

	* src/cell.c (cell_set_color_from_style): Implemented.

Michael Meeks's avatar
Michael Meeks committed
1316 1317 1318 1319 1320 1321
1999-03-03  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-formula.c (parse_data_new): Trap null pointers
	on entry, ( coming from biff_get_text ).
	(ms_excel_parse_formula): Removed nasty static buffers.
	
1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339
1999-02-23  Bruno Unna  <bruno@iac.com.mx>

	* src/dialog-cell-format.c (create_background_radio): Activated
	the patterned background control (although in my machine the
	boxes are all black) and added a radio button to let the
	user do nothing with backgrounds (analogous to the one in
	foreground section).

	* src/dialog-cell-format.c (apply_coloring_format): Now this
	functions takes into account the changes in create_background_radio,
	that is, if the user decides not to change the background,
	the background will not be changed. Also, assigned default
	values to some variables, just to avoid an annoying warning.

	* src/dialog-cell-format.c (create_coloring_page): If there
	are different backgrounds in the range, select by default
	the "no change" radio button for the background.

1340 1341 1342 1343 1344 1345 1346 1347 1348 1349
1999-02-23  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/cell.c (cell_draw): If the cell has a render_color (provided
	by the format specification), use that for the foreground.

1999-02-22  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/file.c (workbook_save_as): Append the extension of the
	default format if no colon is specified

1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361
1999-02-22  Tim Mooney  <mooney@dogbert.cc.ndsu.nodak.edu>

	* plugins/guile/plugin.c (func_scm_apply): Initialization of
	structure is done in the function body, rather thatn when it is
	declared.  This is necessary because struct initializer must be
	determinable at compile time, and those aren't. 

	* src/expr.c (eval_expr): Add at least one statement to the
	default: handler in the case. 

	* src/fn-math.c: provide a break for default handlers.
	* src/item-edit.c (entry_event): ditto
Arturo Espinosa's avatar
Arturo Espinosa committed
1362
	* src/sheet-autofill.c (fill_item_destroy): ditto.
1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373
	
	* src/dialog-cell-format.c (create_number_format_page): Initialize
	in the body, like above.
	
1999-02-22  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* plugins/guile/plugin.c (func_scm_apply): Initialize the
	cell_ref.sheet to NULL.

1999-02-22  Miguel de Icaza  <miguel@nuclecu.unam.mx>
	
1374 1375
	* src/sheet.c (sheet_cell_remove_internal): Queue recalcs for
	cells that depend on cells that are being destroyed.
1376 1377
	(clear_cell_content): Added a call to workbook_recalc 
	(sheet_clear_region_content): same.
1378

1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397
1999-02-21  Michael Meeks <michael@imaginator.com>

	* plugins/excel/ms-formula.c FORMULA_PTG_EXP: Fixed several bugs.

	* plugins/excel/ms-excel.c (ms_excel_set_cell_font, biff_font_data_get_style_font):
	Body of the former moved to the latter, loop invariant code removed for
	big speedup.
	(ms_excel_set_cell_xf): Burdern of border color stuff moved to
	(ms_excel_palette_get): New routine to cache and create
	StyleColor records as needed.
	(ms_excel_sheet_insert): Fixed so no NULL pointers can escape
	into cell_set_text.
	(ms_excelReadWorkbook): Removed BIFF Usage chart, its slow.
	(biff_nasty_font_check_function): Sorts out font sillyness.
	(biff_xf_data_new): Added cached style_format pointer
	(biff_xf_data_destroy): unref style_format if allocated.

	* src/cell.c (cell_set_format_from_style): Implemented.
	
1398 1399
1999-02-19  Raja R Harinath  <harinath@cs.umn.edu>

1400 1401 1402
	* doc/C/Makefile.am (install-data-local): Use $(mkinstalldirs) not
	$(topsrcdir)/mkinstalldirs. 

1403 1404 1405 1406 1407
	* src/Makefile.am: Use $(GNOME_CONFIG) instead of `gnome-config'
	to run the gnome-config script.
	(BUILT_SOURCES): Swap with GNUMERIC_CORBA_GENERATED to be 
	conceptually clean.

1408 1409
1999-02-19  Miguel de Icaza  <miguel@nuclecu.unam.mx>

Miguel de Icaza's avatar
Miguel de Icaza committed
1410 1411
	* src/fn-misc.c (gnumeric_min): Implement ISERROR.

1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432
	* src/clipboard.c (paste_cell): Do not render the value if the
	result is an error.

	* src/cell.c (cell_copy): Do not copy the value of a cell when the
	value is NULL (due to the cell having an error).

	* src/expr.c (eval_expr): Evaluate binary operations in parts to
	keep the correct error message on an operation if possible.
	(eval_expr): Propagate errors.

	* src/item-edit.c (item_edit_draw): Sync the before-cursor and
	after-cursor Y-display text cordinate.

	* src/expr.c (eval_funcall): Add type checking for the simple
	functions. 

	* doc/C/Makefile.am (install-data-local): use topsrcdir here (fix
	from Ian Campbell <ijc25@cam.ac.uk>

	* src/fn-math.c (gnumeric_not): Implement NOT.

1433 1434 1435 1436 1437
	* src/number-match.c (format_create_regexp): Allow upper case
	format codes.

	* src/format.c: ditto.

Michael Meeks's avatar
Michael Meeks committed
1438 1439 1440 1441 1442
1999-02-18  Michael Meeks <michael@imaginator.com>

	* plugins/excel/ms-formula.c (ms_excel_parse_formula):
	case FORMULA_PTG_ATTR: Added 'Optimised SUM' functionality,
	Generaly made output less verbose.
1443 1444 1445 1446 1447 1448 1449
	
	* plugins/excel/ms-excel.c: BIFF_DBCELL, ignore it, its
	not interesting.
	(ms_excel_set_cell_xf, biff_format_data_lookup,
	biff_format_data_destroy, ms_excel_workbook_new,
	ms_excel_workbook_destroy): Implemented formatting.
	
1450 1451 1452 1453 1454 1455
1999-02-17  Michael Meeks <michael@imaginator.com>

	* plugins/excel/ms-excel.c (biff_get_rk): moved RK number
	extraction into function.
	Added MULRK support: the lost numbers arrive !

1456 1457
1999-02-17  Miguel de Icaza  <miguel@nuclecu.unam.mx>

Arturo Espinosa's avatar
Arturo Espinosa committed
1458 1459
	* src/fn-math.c (gnumeric_trunc): Implement TRUNC.

1460 1461 1462 1463 1464 1465 1466
	* src/func.c (function_iterate_argument_values): Do not evaluate a
	subexpression if the previous expression failed due to an error.
	Basically: add a check to the eval return value.   

	I took this oportunity to check all the source and this was the
	only buggy spot.

1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480
1999-02-16  Michael Meeks  <sca20@cam.ac.uk>

	* plugins/excel/ms-excel.c: Fixed many bugs in my
	understanding of hash table functions.
	Added rudimentary NAME stuff.
	made error lookup global.
	Fixed up Header / Footer functionality.
	(ms_excel_sheet_new, ms_excel_sheet_insert,
	ms_excel_read_sheet): Added 'blank' field to excel_sheets,

	* plugins/excel/ms-formula.c: Added puzzling
	PTG_NAME stuff, this is really wierd.
	PTG_ERR added.
	
1481 1482 1483 1484 1485 1486 1487 1488 1489
1999-02-16  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (change_auto_expr_menu): OOps I got too excited
	here using my helper routine: Now we do not destroy this helpful
	menu. 

	* src/widget-editable-label.c (editable_label_set_text): Bug fix:
	sometimes this code is invoked with its argument being el->text. 

1490 1491 1492 1493 1494 1495 1496
1999-02-15  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (workbook_new): Make a local copy of the toolbar,
	as we use this to update the radio buttons. 
	(workbook_do_destroy): Free the toolbar.
	(workbook_feedback_set): Use the per-workbook toolbar here.

1497
1999-02-14  Michael Meeks  <sca20@cam.ac.uk>
1498 1499 1500 1501 1502 1503 1504

	* plugins/excel/ms-formula.c: Inserted a whole scad
	of math functions into translation table.
	(parse_list_to_equation): g_strdupped return values.
	FORMULA_PTG_STR: Updated old and broken code.
	* src/about.c (dialog_about): Added Sean.

1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520
1999-02-13  Bruno Unna  <bruno@iac.com.mx>

	* src/dialog-cell-format.c (create_foreground_radio): Added a
	radio button to let the users 'no change' the text colour, useful
	when there is a range selected with differently colored cells
	and it is desired to change the background of them without
	touching the foreground.

	* src/dialog-cell-format.c (create_coloring_page): When there
	are different foreground colours in the selected cells, the
	default selection is 'no change'.

	* src/dialog-cell-format.c (apply_coloring_format): If there
	is no need to make changes to the foreground color of the
	cells, avoid doing them.

1521 1522 1523 1524 1525 1526 1527 1528
1999-02-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/item-cursor.c (item_cursor_target_region_ok): Warn the user
	if he overwrites something accidentally by dropping cells in the
	target location.

	* src/sheet.c (sheet_is_region_empty): New function.

1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541
1999-02-12  Michael Meeks  <sca20@cam.ac.uk>

	* plugins/excel/ms-excel.c (biff_get_global_string): 
	Drasticly simplified, accelerated and in-lined out.
	(biff_get_text): Fixed using unicode spec, various
	updates to calls to it, fixing offsets.
	Removed lots of debug output to speedup
	
1999-02-10  Sean Atkinson  <sca20@cam.ac.uk>

	* src/fn-math.c (callback_function_sum): enhanced warning for
	unknown value->type.

1542 1543 1544 1545
1999-02-12  Frederic Devernay  <devernay@istar.fr>

	* plugins/perl/perl.c: Handle the #define dirty in perl-thread.

1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556
1999-02-12  Bruno Unna  <bruno@iac.com.mx>

	* src/cell.c (cell_draw): Now the function draws the cell
	using the cell background color setting. Although it does
	the job, I guess there must be a better way to do it. Thanks
	to Michael for the hint.

	* src/item-grid.c (item_grid_draw_cell): Commented out the lines
	involved with patterns display in the cell, for that code is
	not ready yet.

1557
	* src/dialog-cell-format.c (create_coloring_page): Reactivated
1558 1559
	the background selection panel of the coloring page.

1560
	* src/dialog-cell-format.c (create_background_radio): Commented out
1561 1562
	the addition of the pattern selection for a cell.

1563 1564
1999-02-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1565 1566 1567 1568
	* src/workbook.c (workbook_detach_sheet): Be less forgiving as to
	removing sheets with pending references.
	
	(sheet_action_delete_sheet): Add a test for
1569 1570 1571
	dependencies when removing a sheet
	(workbook_can_detach_sheet): New function.

1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586
	* src/cell.c (cell_relocate): When relocating a cell with a
	formula, always mark it as changed.  We were doing that before
	only for the case where the location had changed, but we use
	cell_relocate in other cases as well.

	* src/fn-string.c (gnumeric_lower, gnumeric_upper): These
	functions were wrong.  They were never incrementing the pointer
	and they were releasing the wrong pointer.

	* src/clipboard.c (paste_cell): When pasting a cell, mark the
	contents as modified.

	* src/file.c (file_saver_is_default_format): Make sure the saver
	is always set.

1587 1588 1589 1590 1591 1592
1999-02-10  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-excel.c (ms_excel_read_cell): BOOLERR booleans
	hard-translated to 1, 0: not a good solution to problems with TRUE.
	* src/fn-string.c (gnumeric_upper, gnumeric_lower): Add increment
	
1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605
1999-02-09  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/parser.y: Apparently string concatenation operator in Excel
	has the lower priority.

	* src/workbook.c (workbook_detach_sheet): New function used to
	detach a sheet from a workbook.
	(sheet_menu_label_run): New routine.  Invoked on button-3 on the
	sheet label.

	* src/gnumeric-util.c (gnumeric_auto_kill_popup_menu_on_hide): New
	routine to deallocate menus when they go to unshown state

1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629
1999-02-09  Michael Meeks  <michael@imaginator.com>
	
	* plugins/excel/ms-excel.c (ms_excel_sheet_new,
	ms_excel_workbook_attach, biff_boundsheet_data_new):
	Major sheet allocation re-organisation, hash boundsheet data.
	(ms_excel_sheet_set_version, ms_excel_sheet_set_index,
	ms_excel_workbook_get_sheet): re-hashed API
	* plugins/excel/ms-formula.c: PTG_MISSARG implemented

1999-02-08  Sean Atkinson  <sca20@cam.ac.uk>

	* plugins/excel/ms-excel-biff.h, ms-excel.c:
	added BIFF_EXTERNCOUNT
	* plugins/excel/ms-excel.c (ms_excel_read_sheet): 
	stubbed BIFF_EXTERNSHEET, stubbed SUPBOOK
	(biff_get_externsheet_name): implemented inter-sheet references
	* plugins/excel/ms-formula.ch: added FORMULA_PTG_CONCAT
	(ms_excel_parse_formula): implemented FORMULA_PTG_REF_3D

1999-02-07  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-formula.c (ms_excel_parse_formula):
	FORMULA_PTG_ATTR stubs: can ignore most of AttrSpace.
	
1630 1631 1632 1633 1634 1635 1636 1637
1999-02-08  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/cell.c (cell_draw): Make the clip region one pixel bigger to
	account for the offset.
	(cell_draw): Do not add one to text_base.

	* src/item-edit.c (item_edit_draw): Take into account the margin_b.

1638 1639 1640 1641 1642 1643 1644 1645 1646
1999-02-07  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-formula.c: Fixed memory leaks
	* plugins/excel/ms-excel.c: Fixed several memory leaks

1999-02-07  Sean Atkinson  <sca20@cam.ac.uk>

	* plugins/excel/ms-formula.ch: added FORMULA_PTG_NUM

1647 1648 1649 1650 1651
1999-02-07  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/cell.c (cell_set_text_simple): Allow a single "=" to
	represent a string.

1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666
1999-02-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/gnumeric-util.c (gnumeric_notice): Now we take a Workbook
	argument to bind the dialog boxes properly to the main window.  We
	use gnome_messagebox now to report errors.  We now take a type
	parameter for the message box type.

	* plugins/ff-csv/csv-io.c: Use gnumeric_error

	* src/workbook.c (wb_input_finished): Call sheet_set_current_value
	instead of the cancel pending input routine.

	* Moved src/csv-io.[ch] to the plugins/ff-csv directory and
	converted them to 
	
1667 1668 1669 1670 1671
1999-02-06  Vincent Renardias <vincent@ldsol.com>

	* src/csv-io.h src/csv-io.c: Added code to load
	csv files.

1672 1673
1999-02-06  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1674 1675 1676 1677 1678 1679 1680
	* src/file.c (fill_save_menu): Creates an option menu with the
	file format to save on.
	(workbook_save_as): Use the saver selected by the user.
	(saver_activate): Keep track of the current file save format, set
	as default.
	gnumeric_file_savers, gnumeric_file_openers: made static. 

1681 1682 1683
	* src/sheet.c (sheet_destroy_styles): Release the proper style, I
	was releasing a different structure.

1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698
1999-02-06  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-formula.c: Cut out lots of debug in working
	cases

	* plugins/excel/ms-excel.c: Implemented a hash table for fast
	font lookups, removed and simplified dead font code.

	* plugins/excel/ms-excel.c (ms_excel_set_font): Bold if boldness
	greater or equal to threshold, not just equal.
	
	* plugins/excel/ms-excel.c (ms_excel_read_cell): Added support
	for BIFF_STRING records, and re-organised switch statement. Added
	BIFF_BOOLERR support.

1699 1700 1701 1702
1999-02-06  Changwoo Ryu  <cwryu@adam.kaist.ac.kr>

	* gnumeric.desktop: Added Korean translations.

Michael Meeks's avatar
Michael Meeks committed
1703 1704 1705 1706 1707
1999-02-04  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-excel.ch: Major overhaul of how XF styles
	are looked up, sparation of Cell / style XF records. Hash
	table implemented for lage speedup and code simplification.
1708

1709 1710 1711 1712
1999-02-04  Michael Meeks  <michael@imaginator.com>

	* plugins/excel/ms-biff.h: Added a biff_getdouble function for
	G_BIG_ENDIAN machines, since I don't have one... [begs forgiveness]
1713

1714 1715 1716 1717 1718 1719 1720 1721 1722 1723
1999-02-03  Sean Atkinson  <sca20@cam.ac.uk>

	* plugins/excel/ms-formula.c (ms_excel_parse_formula):
	FORMULA_PTG_INT and FORMULA_PTG_BOOL added

	* plugins/excel/ms-formula.c:
	Implemented remaining binary operators and unary operators +,-,%
	interpolated operator precedences.
	formula_func_data[] : added AND, OR, V/H LOOKUP functions
	
1724 1725 1726 1727 1728 1729
1999-02-03  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (workbook_configure_minimized_pixmap): Provide an
	icon.  Note that I could not get this to work on fvwm2 though.  I
	will wait for other people to try it.

1730 1731 1732 1733 1734 1735 1736
1999-02-01  Jaka Mocnik  <jaka.mocnik@kiss.uni-lj.si>

	* src/widget-editable-label.c (el_realize): new function.
	set the font for text_item here to match the widget's style.
	(editable_label_set_text): don't bother to set the font when
	creating the text_item, as the style is not set properly yet.
	
1737 1738 1739 1740
1999-01-27  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-misc.c: Added documentation for the functions in this file.

1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753
1999-01-26  Bruno Unna  <bruno@iac.com.mx>

	* src/dialog-cell-format.c (create_coloring_page): Now, the
	method to find out whether a cell has been colored or not
	is to compare the RGB values to zero.
	Commented out the attachment of background_radio_list
	because the functionality is not ready yet.

	* src/dialog-cell-format.c (apply_coloring_format): Added support
	for background solid coloring. Howver, changes to the style of
	the cells in this regard have no effect in the display. The reason
	for this is unknown to me as of now.

1754 1755 1756 1757 1758
1999-01-25  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-autofill.c (sheet_autofill_dir): Add a call to
	sheet_cell_remove before calling cell_destroy.

1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774
1999-01-23  Bruno Unna  <bruno@iac.com.mx>

	* src/dialog-cell-format.c: Reactivated the 'Coloring' page
	in struct array cell_format_pages.

	* src/dialog-cell-format.c (create_coloring_page): Lots of
	changes, practically a full rewrite. One problem is that cells
	are thrown into this world with the flag STYLE_FORE_COLOR of
	their style set, which causes a lack of synchronization with
	what is expressed in the global variable foreground_radio_list.

	* src/dialog-cell-format.c (apply_coloring_format): By the moment
	being, deactivated the call of function cell_set_pattern, along
	with the STYLE_PATTERN bit flag of style->valid_flags. I will
	concentrate in fg/bg coloring of the cell.

1775 1776
1999-01-19  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1777 1778 1779 1780 1781 1782 1783
	* src/widget-editable-label.c 	(el_init): Set the scroll region
	to something very big.  This fixes the label-sliding problem.
	Thanks to Federico for his quick debugging eye.
	
	(el_button_press_event): WOW.  I am amazed.  I now gtk grab add
	and if I receive a widget->window different than the canvas, I
	drop the grab and stop editing.
1784

1785 1786 1787 1788 1789
1999-01-19  Francisco Bustamante  <pancho@nuclecu.unam.mx>

	* src/workbook.c (workbook_delete_event)  Return TRUE when the
	workbook should not be destroyed. (i.e. the user presses cancel)

1790 1791 1792 1793 1794 1795
1999-01-19  Jeff Garzik  <jgarzik@pobox.com>

	* src/dialog-cell-format.c, src/gnumeric-util.c,
	  src/sheet-view.c, src/workbook.c:
	Renamed deprecated Gtk+ functions.

1796 1797 1798 1799 1800 1801 1802 1803
1999-01-18  Bruno Unna  <bruno@iac.com.mx>

	* src/dialog-cell-format.c: Now the terminator element of the
	cell_format_pages has three null elements (as stated in the struct
	definition), instead of two. Fixed up some comments. Started
	to pursue the bug that causes that when adding the "Coloring"
	tab the program generates a Gdk-ERROR. Modifications not commited.

1804 1805 1806 1807 1808 1809 1810 1811 1812 1813
1999-01-17  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/gnumeric-sheet.c (gnumeric_sheet_can_move_cursor): Do not
	enable item editing if sheet is not in edit mode.

1999-01-13  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/gnumeric-sheet.c (gnumeric_sheet_key_mode_sheet): Mark sheet
	as being edited.

Arturo Espinosa's avatar
Arturo Espinosa committed
1814 1815 1816 1817 1818
1999-01-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/file.c (dialog_query_load_file): Set the window modal.
	(workbook_save_as): ditto.

1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849
1999-01-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/format.c (format_value): Use 0.0########## instead.  Looks saner.

1999-01-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (change_auto_expr_menu): Use the event->button
	field to get the popup menu to behave correctly.
	(workbook_setup_auto_calc): Put the information display inside a
	GtkFrame. 

	* src/item-bar.c (set_cursor): This routine can be invoked before
	we are realized.

	* src/workbook.c (sheet_label_button_press): We need to do the
	page flipping ourselves, as the GtkNotebook wont take events if
	they are not for a window it knows about.

	* src/widget-editable-label.c (el_button_press_event): Forward
	events to parent.

	* src/parser.y: New non-terminal "cellref".  Make this
	non-terminal include CELLREF and SHEETREF!CELLREF constructions. 

	* src/expr.c: Changed the whole module according to the dropping
	of VALUE_CELLREF.

	* src/expr.h: VALUE_CELLREF did not make much sense.  Better add
	to the ExprTree union a CellRef field specifically for OPER_VAR
	nodes.

1850 1851
1999-01-10  Michael Meeks <michael@imaginator.com>

1852
	* plugins/excel/ms-excel.c (ms_excelReadWorkbook): Only believe the
1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
	first BOF with regard to BIFF version number, other BOFs seem to lie.

1999-01-10  Nick Lamb <njl98r@ecs.soton.ac.uk>

	* plugins/excel/ms-excel.h: Added global string table to EXCEL_WORKBOOK

	* plugins/excel/ms-excel.c (ms_excel_workbook_new): Setup new fields,
	(ms_excel_read_cell): case BIFF_STRING_REF,
	(biff_get_global_string): Retrieves a global string from the EXCEL_WORKBOOK table.
	(ms_excel_read_cell): case BIFF_STRING_REF,
	(ms_excelReadWorkbook): case BIFF_STRINGS reads the global table.

1999-01-10  Michael Meeks <michael@imaginator.com>

	* plugins/excel/ms-excel.c: Rehash of border code to use neater centralised
	enumerations / types.
	(get_style_color_from_idx): Implemented.
	
	* src/style.h: Major expansion of 'StyleBorderType', massive simplification
	of StyleBorder to use directional [ StyleSide ] arrays instead of lots of
	unique member names.

	* src/style.c (border_equal, border_hash, style_border_new,
	style_border_new_plain): Major overhaul and shrink to fit new structure.

	* src/xml-io.c: Updated BorderTypes array to give textual names to
	the new border types, also created an array of text names for StyleSides.
	
	* src/xml-io.c (readXmlStyleBorder,writeXmlStyleBorder): Use new
	arrays and struct.

	* src/cell.c, src/cell.h: Added cell_set_border.
	
1999-01-10  Thomas Meeks  <meekte95@christs-hospital.org.uk>

 	* plugins/excel/ms-excel.c (ms_excel_read_cell): 
 	added header and footer Biff code.
 	* plugins/excel/ms-excel-biff.h: the defines. 
	
1892 1893 1894 1895 1896
1999-01-10  Changwoo Ryu  <cwryu@adam.kaist.ac.kr>

	* src/workbook.c (cb_sheet_check_dirty): Use g_strdup_printf
	instead of g_strconcat.  More easy to translate the string.

1897 1898
1999-01-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

1899 1900 1901 1902 1903
	* src/workbook.c (wb_input_finished): Use
	sheet_accept_pending_input instead of sheet_set_current_value.
	(workbook_setup_auto_calc): Stick the information display inside
	the status bar.

1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934
	* src/eval.c (add_value_deps): Reorganization.  Hanlde
	VALUE_CELLREF here and make OPER_VAR and OPER_CONSTANT call
	add_value_deps. 

	* src/expr.c (do_expr_tree_relocate, expr_tree_relocate): New
	routine that returns an ExprTree relocated.
	(value_copy_to): Handle the VALUE_CELLREF type.

	* src/expr.h: define VALUE_CELLREF

	* src/parser.y (yylex): Type fix.
	When creating values of type VALUE_CELLREF, set this value. 

1999-01-09  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet.c (sheet_move_column): Update to new cell_relocate
	semantics.
	(sheet_shift_row): ditto.
	(sheet_insert_row): ditto.
	(sheet_delete_row): ditto.
	(sheet_shift_col): ditto.

	* src/clipboard.c: Update to new cell_relocate semantics.
	Remove the old GTK compatibility code.

	* src/cell.c (cell_relocate): We do not need to reference this
	formula. 
	This routine now takes delta-x and delta-y values for the
	relocation, instead of absolute cordinates.  To implement the
	proper semantics of cell movement that other spreadsheets implement

1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945
1999-01-09  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* src/gnumeric-sheet.c (gnumeric_sheet_key_mode_sheet): Return the
	result of gtk_widget_event() if we get to the switch's default
	case.
	(gnumeric_sheet_key): Return FALSE in the default case, since we
	did nothing there.

	* src/workbook.c (open_cmd): If the file-open dialog was
	cancelled, it will return NULL.  Take this into account.

1946 1947 1948 1949 1950
1999-01-08  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (workbook_setup_status_area): We do not use the
	progress bar feature currently.

1951 1952 1953 1954
1999-01-07  Nat Friedman  <nat@nat.org>

	* src/workbook.c: Added hints to the rest of the custom menu items.
	
1955 1956 1957 1958 1959 1960 1961 1962 1963
1999-01-07  Nat Friedman  <nat@nat.org>

	* src/workbook.c (workbook_new): Install the menu hints.
	(workbook_setup_status_area): Create the GnomeAppBar.

	Added hints to most of the custom menu items.

	* src/sheet.h: Added the appbar field to the Workbook structure.

1964 1965 1966 1967 1968
1999-01-07  Nat Friedman  <nat@nat.org>

	* src/workbook.c: Use GNOMEUIINFO_MENU_ABOUT_ITEM and the new
 	GNOMEUIINFO_MENU trees.

1969 1970 1971 1972 1973
1999-01-07  Nat Friedman  <nat@nat.org>

	* src/workbook.c: Pass the menu item description to
 	GNOMEUIINFO_MENU_NEW_ITEM.

1974 1975 1976 1977 1978
1999-01-06  Nat Friedman  <nat@nat.org>

	* src/workbook.c: Use the standard GNOMEUIINFO macros from
 	gnome-app-helper.h.

1979 1980 1981 1982
1999-01-06  Nat Friedman  <nat@nat.org>

	* src/workbook.c: Use the gnome-uidefs.h macros for the
 	accelerators.
1983
	
1984

1985 1986 1987 1988 1989 1990 1991 1992
1999-01-04  Havoc Pennington  <hp@pobox.com>

	* src/fn-date.c (gnumeric_date): Allocate the GDate on the stack,
	saves some small amount of time. Check user-provided
	month/day/year for validity before using it.
	(gnumeric_today): Allocate GDate on the stack.
	(gnumeric_now): Ditto.

Miguel de Icaza's avatar
Miguel de Icaza committed
1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
1999-01-04  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet.c (sheet_rename): New routine.

	* src/workbook.c (workbook_attach_sheet): Use a EditableLabel for
	the notebook tab.
	(workbook_rename_sheet): New routine.

	* src/widget-editable-label.c:  New widget.  This is a label that
	can be edited if you double click on it.  This uses the same trick
	of the gnome-icon-item to provide the editing facilities.

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

	* src/workbook.c (workbook_setup_status_area): Use the style font,
	not "fixed".
	(workbook_setup_status_area): One hack down.  Use GTK_ANCHOR_NW to
	achieve the same effect I had with my previous hack.

	* src/dialog-cell-comment.c (dialog_cell_comment): New file.
	Implements the cell comment dialog box.

	* src/cell.c (cell_relocate): Only call cell_comment_reposition is
	there is a cell comment bound to this cell.

	* src/format.c (format_value): No format means "General" format as
	well.
	If the value has decimal numbers use "0.00##########" for the
	formatting instead of 0.00.
	

2024 2025 2026 2027 2028
1998-01-03  Jeff Garzik  <jgarzik@pobox.com>

	* src/number-match.c, src/plugin-manager.c, src/sheet.c:
	Warning fixes.

2029 2030
1999-01-03  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2031 2032 2033 2034 2035
	* src/expr.c (do_expr_decode_tree): Add termination NULL to the OPER_NEG
	operation. 
	
	* (eval_expr): Add support for non-local cells here.  I am
	impressed how simple this was.
2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050

	* src/parser.y: Add rules for cell references outside of the
	current sheet.

	* src/main.c: New option --debug.  Turns on the zoom in/zoom out
	buttons on the main sheet.

	* src/workbook.c: Include the zoom in/zoom out buttons conditionally.

	* src/xml-io.c (xmlGetCoordinates): Load using double numbers the
	information. 

	* src/parser.y (yylex): Allow strings to be specified with "'"
	characters. 

2051 2052 2053 2054 2055 2056
1999-01-01  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/item-grid.c (item_grid_button_1): When starting a selection
	of cells during a formula edit, insert the currently clicked cell
	name. 

2057 2058 2059 2060 2061 2062
1998-12-30  Jeff Garzik  <jgarzik@pobox.com>

	* plugins/perl/perl.c, src/cell.c, src/expr.c, src/plugin.c,
	  src/sheet-autofill.c, src/sheet.c, src/workbook.c:
	s/g_copy_strings/g_strconcat/

2063 2064
1998-12-28  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079
	* plugins/excel/boot.c: New file, this holds the probing and load
	wrapper code for Gnumeric to use as well as the initial format
	registering code. 

	* src/xml-io.c (xml_probe): New routine, used to probe if a file
	is a Gnumeric-xml file.

	* src/file.c (file_format_register_open,
	file_format_unregister_open, file_format_register_save,
	file_format_unregister_save): New routines used to register and
	unregister file formats in Gnumeric.

	* src/main.c (main): Boot xml and excel formats, since they now
	need to register themselves with the file.c code 

2080 2081 2082 2083 2084 2085 2086 2087 2088
	* src/cell.h: cell->entered_text is back, now only used for typo
	correction.  Maybe I will use it for saving. 

	* src/fn-string.c (gnumeric_right): Use value_str.
	(gnumeric_char): same
	(gnumeric_left): same

	* src/expr.c (value_str): New function.

2089 2090 2091 2092 2093 2094 2095 2096 2097
	* src/xml-io.c (writeXmlCell): Use cell_get_content instead of
	cell_get_text.

	* src/cell.c (cell_get_content): New function.

1998-12-17  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c: fix bug introduced yesterday.

2098 2099 2100 2101 2102 2103 2104
1998-12-17  Tuomas Kuosmanen  <tigert@fun112.koivukyla.hoas.fi>

	* gnumeric.desktop: Added gnumeric program icon
	* Makefile.am: added the stuff to install the icon - 
	could someone check that I did it correctly?
	* gnome-gnumeric.png: the icon itself

2105 2106 2107 2108 2109 2110 2111
1998-12-16  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c: Use GNOME stock icons for the stuff that hsa
	icons on Gnome Stock.

	* gnumeric.keys.in: New file that defines the mime-type for Gnumeric

2112 2113
1998-12-16  Federico Mena Quintero  <federico@nuclecu.unam.mx>

2114 2115 2116 2117 2118 2119 2120 2121 2122
	* src/workbook.c (workbook_setup_status_area): Do not set_usize()
	on the info item.

	* src/sheet-view.c (new_canvas_bar): Set the width or height to -1
	in set_usize().

	* src/gnumeric-sheet.c (gnumeric_sheet_new): Do not set_usize() on
	the sheet.

2123 2124 2125 2126 2127
	* src/item-bar.c: Updated for the new canvas item API.
	* src/item-cursor.c: Likewise.
	* src/item-edit.c: Likewise.
	* src/item-grid.c: Likewise.

2128 2129 2130 2131 2132 2133
1998-12-15  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (workbook_new): Use the new gnomeapp api.

	* src/gnumeric-sheet.c: Use the new canvas.
	
2134 2135 2136 2137 2138
1998-12-14  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* src/gnumeric-sheet.c (gnumeric_sheet_new): Use
	gtk_widget_set_usize() instead of gnome_canvas_set_size().
	* src/pattern-selector.c (pattern_selector_new): Likewise.
2139
	* src/sheet-view.c (new_canvas_bar): Likewise.
2140

2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153
1998-12-13  Sebastian Wilhelmi  <wilhelmi@ira.uka.de>

	* src/fn-date.c (gnumeric_year_month_day, gnumeric_now,
	gnumeric_today,gnumeric_date): 
	* src/workbook.c (insert_current_date_cmd): 
	* src/number-match.c (compute_value): Changed to use the glib
	GDate type instead of the lib_date functions. Fixed off by-one
	error for some date functions (e.g. =today ()) was one day to
	early).

	* src/utils.c, src/utils.h (g_date_serilal, g_date_serial_new):
	New functions for handling the gnumeric serial of a date.

2154 2155 2156 2157 2158
1998-12-03  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/item-cursor.c (item_cursor_set_bounds_visibly): Update the
	cursor position as well.

2159 2160 2161 2162 2163 2164 2165 2166
1998-12-10  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-excel.c (ms_excel_read_cell): Fixed serious bug
	in IEE floating point number reading from RK records.

	* plugins/excel/ms-formula.c (ms_excel_parse_formula): Implemented
	string expressions in formulae, MS stores numbers like this !

2167 2168 2169 2170 2171
1998-12-10  Owen Taylor  <otaylor@redhat.com>

	* src/workbook.c (filenames_dropped): Make toplevel
	windows drop targets for files.

2172 2173 2174 2175 2176
1998-12-09  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.c: Indented correctly, implemented writes
	of all file lengths.

2177 2178 2179 2180 2181 2182
1998-12-08  Jaka Mocnik  <jaka.mocnik@kiss.uni-lj.si>

	* src/dialog-paste-special.c (dialog_paste_special): changed
	gnome_dialog_run_modal() to gtk_window_set_modal() and
	gnome_dialog_run().

2183 2184 2185 2186 2187
1998-12-06  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.c: Much trivial bug fixing, API fixups,
	testing and stabilizing.

2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198
1998-12-05  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.c: Major work on creation of readable
	macros for accessing obscure fields, removing magic numbers from
	main code.
	(ms_ole_create): Created to create new OLE files.

	* plugins/excel/ms-excel-biff.h: Update comments, and re-arrange.
	
	* plugins/excel/ms-biff.h: Commenting fixes

2199 2200 2201 2202 2203
1998-12-04  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* configure.in (ALL_LINGUAS): Added Japanese translation courtesy
	of Mitsuru Oka <moka@globe.to>.  Also updated the .desktop file.

2204 2205
1998-12-02  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2206 2207 2208 2209 2210 2211 2212
	* src/gnumeric-sheet.c (gnumeric_sheet_set_top_row,
	gnumeric_sheet_set_top_col): New functions to set the sheet top
	column and row respectively.

	(gnumeric_sheet_bar_set_top_row, gnumeric_sheet_bar_set_top_col):
	Renamed from their old names to reflect their actual action.

2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224
	* src/item-cursor.c (item_cursor_autofill_event): Do not pass
	negative numbers to item_grid_find_col and item_grid_find_row. 

	* src/item-grid.c (item_grid_find_row, item_grid_find_col): Check
	for possitive numbers. I think the right fix is to accept negative
	numbers and find the column even if the number is negative instead
	of this ugly restriction.

1998-11-30  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet.c (cellref_name): Add more space.

2225 2226 2227 2228 2229
1998-12-02  Sebastian Wilhelmi  <wilhelmi@ira.uka.de>

	* src/Makefile.am: make Gnumeric-impl.c dependend on Gnumeric.h to
	make it compile the idl-file before compiling Gnumeric-impl.c

2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240
1998-11-28  Michael Meeks    <mejm2@cam.ac.uk>

	* plugins/excel/ms-formula.c(ms_excel_parse_formula): Fixed serious
	memory leaks on return values from cellref_name

	* plugins/excel/ms-formula.c(getRefV7): Now sets CellRef->sheet properly
	(getRefV8): same.

	* plugins/excel/ms-ole.c: Several minor changes, moving seperate
	structures back into the raw datastream with macros.
	
2241 2242
1998-11-28  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2243 2244 2245 2246 2247 2248
	* src/gnumeric-util.c (gnumeric_notice): Do not use
	gnome_dialog_run_modal. 

	* src/dialog-goto-cell.c (dialog_goto_cell): Do not use
	gnome_dialog_run_modal 

2249 2250 2251 2252 2253 2254
	* src/sheet.c (sheet_mark_clean): New routine to mark a sheet as
	not modified.

	* src/workbook.c (workbook_mark_clean): New routine to mark a
	workbook as not modified.

2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267
1998-11-13  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-autofill.c (autofill_cell): Simplify by using
	cell_set_formula_tree 

	* src/expr.c (expr_parse_string): Take a sheet argument
	(expr_decode_tree): Same
	
	* sheet.c (cellref_name): Now takes a sheet argument and decodes the
	cellref depending on the sheet.
	
	* cell.c (CellRef): Now they include the sheet location.
	
2268 2269 2270 2271 2272
1998-11-28  Michael Meeks    <mejm2@cam.ac.uk>

	* plugins/excel/ms-ole.c, plugins/excel/ms-ole.h: Total re-write
	of internal interfaces, code streamlined, '?' operators expunged.

Miguel de Icaza's avatar
Miguel de Icaza committed
2273 2274
1998-11-27  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287
	* src/item-grid.c (item_grid_realize): Oops.  This was not a bug.
	gc was actually initialized as being item_grid->grid_gc, it was
	just not obvious.

	* src/main.c (gnumeric_main): Fix the prototype.

	* src/dialog-goto-cell.c (dialog_goto_cell): Revert const from gtk-clist.

	* src/dialog-cell-format.c (create_number_format_page): Revert
	const from gtk-clist.

	* src/dialog-goto-cell.c (dialog_goto_cell): Revert const from gtk-clist.

Miguel de Icaza's avatar
Miguel de Icaza committed
2288 2289 2290 2291 2292 2293 2294 2295 2296 2297
	* src/Gnumeric-impl.c: Empty stubs for now.
	
	* src/Makefile.am (GNUMERIC_CORBA_SOURCES): Add rules for
	compiling the CORBA support.

	* plugins/python/Makefile.am (LIBTOOL): This one needs xlibtool
	instead of our modified libtool.

	* plugins/sample/Makefile.am (GNUMERIC_SRC_DIR): Simplified Makefile.am

2298 2299 2300 2301 2302
1998-11-25  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/item-grid.c (item_grid_realize): Removed bogus calls to
	invalid gc.

2303 2304 2305 2306
1998-11-24  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* src/item-grid.c (item_grid_unrealize): Unref all the item_grid's GCs.

2307 2308
1998-11-23  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2309 2310 2311
	* src/dialog-goto-cell.c (dialog_goto_cell): Set the policy on the
	scrolled window.

2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323
	* src/sheet.h: formula_cell_list *ONLY* exists in the Workbook,
	not on the Sheet.

	* src/sheet.c (sheet_cell_formula_link,	sheet_cell_formula_unlink): 
	Keep the formula on the Workbook, not on the Sheet.  Thanks to
	Havoc for reporting these bugs.
	
	* src/cell.c (cell_set_formula): Use cell_set_rendered_text to
	propery set the error messages.
	(cell_get_text): If value is NULL, use the rendered version of the
	text instead of re-rendering it.

2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336
	* src/dialog-cell-format.c (create_number_format_page): Put the
	clist inside a scrolled window for the new CList api.
	
	* src/dialog-define-names.c (dialog_define_names): ditto.
	
	* src/dialog-goto-cell.c (dialog_goto_cell): ditto
	

1998-11-23 Marin Purgar <pmc@iskon.hr>

	* src/dialog-cell-format.c: Style general was applied to more
	than one cell in various cases.

2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348
1998-11-18  Bruno Unna       <bruno@iac.com.mx>
	* src/style.c: added the default italic font as helvetica-oblique.

	* src/style.h: added declaration for new global variable
	  gnumeric_default_bold_font

	* src/gnumeric-util.c: enhanced the robusteness of the function 
	  font_get_italic_name. But it's not at a 100%, though.

	* plugins/excel/ms-excel.c: slight modification to the error 
	  tracking mechanism (font stuff in ms_excel_set_cell_font).

2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363
1998-11-15  Michael Meeks    <mejm2@cam.ac.uk>

	* plugins/excel/ms-ole.c(ms_ole_directory*): Created new directory
	API for ole files, such that the excel dependant stuff is now moved
	out of ms-ole.c into ms-excel.c

	* plugins/excel/ms-excel.c(find_workbook): Nicer routine using the
	directory API to find its file

	* plugins/excel/ms-ole.c(ms_ole_stream_open): Renamed from ~_new

	* plugins/excel/ms-ole.c: Re-organisation, code clean, many cases
	added throughout to make NULL pointers less harmful, and allow
	for turning into a library soon.

Michael Meeks's avatar
Michael Meeks committed
2364 2365 2366 2367 2368
1998-11-14  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-excel.c(ms_excel_set_cell_font): Fixed buffer
	overflow bug, and secured sprintf.

2369 2370 2371 2372 2373 2374 2375 2376 2377
1998-11-12  Bruno Unna       <bruno@iac.com.mx>

	* plugins/excel/ms-excel.c: added support for fount size.

	* plugins/excel/ms-excel.c: included ctype.h.

	* plugins/excel/ms-excel.c: initial hacks on font name importing,
	  from windoze to X.

2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391
1998-11-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/parser.y: 

	* src/workbook.c (workbook_new): Use case-insenstive routines when
	creating the hash table.
	(workbook_sheet_get_free_name): Find an unused name for a sheet. 
	(workbook_sheet_lookup): Looks up a sheet by name in a Workbook.
	(insert_sheet_cmd): New command to insert a sheet into a workbook.

	* src/utils.c (gnumeric_strcase_hash, gnumeric_strcase_equal):
	Routines used for strings hash tables that are not case
	sensitive. 

Morten Welinder's avatar
Morten Welinder committed
2392
1998-11-12  Morten Welinder <terra@diku.dk>
2393 2394 2395 2396 2397

	* test-parser.c: Fix to compile with the new API

	* parser.y: Make the code more maintainable.

2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415
1998-11-12  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.c, plugins/excel/ms-ole.h: Massive changes
	renamed many functions to conform to a sensible naming convention.
	Cleaned the interface, and structure names.

	* plugins/excel/ms-excel-biff.h: Split from ms-biff.h removing all
	the excel specifics so that the biff & ole stuff can be turned into
	a library sometime.

	* src/workbook.c(workbook_read): Updated to new structure names.

	* plugins/excel/ms-excel.c: Added list of array formulae, as yet
	unused, possibly unneccesary.

	* plugins/excel/ms-formula.c: Added support for slightly different
	array formula BIFF layout.

2416 2417 2418 2419 2420 2421 2422 2423
1998-11-11  Bruno Unna       <bruno@iac.com.mx>

	* src/gnumeric-util.c: Added function font_get_italic_name, 
	analogous to font_get_bold_name.

	* plugins/excel/ms-excel.c: added enhanced support for styles 
	(bold & italic). Included gnumeric-util.h.

Miguel de Icaza's avatar
Miguel de Icaza committed
2424 2425 2426 2427 2428 2429
1998-11-11  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/gnumeric-util.c (font_get_italic_name): Missing function.

	* src/parser.y: Use '^'.

Mark Probst's avatar
Mark Probst committed
2430 2431 2432 2433
1998-11-11  Mark Probst  <schani@obiwan.unix.cslab.tuwien.ac.at>

	* plugins/guile: Added guile plug-in.

2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462
1998-11-11  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-biff.h, plugins/excel/ms-excel.c: Removed fatal
	bug, and accelerated code by testing for DV in MULBLANK case.

	* plugins/excel/ms-excel.c(ms_excel_set_cell_xf): Out by one indexes
	causing serious attribute offset grief in fonts.

	* Rememberance_Day:
	They went with songs to the battle, they were young,
	Straight of limb, true of eye, steady and aglow.
	They were staunch to the end against odds uncounted,
	They fell with their faces to the foe.

	They shall grow not old, as we that are left grow old,
	Age shall not weary them, nor the years condemn.
	At the going down of the sun, and in the morning,
	We will remember them.

	Lest we forget.

1998-11-10  Bruno Unna       <bruno@iac.com.mx>

	* plugins/excel/ms-excel.c(ms_excel_set_font): Started implementing
	font styles properly.
	
	* src/gnumeric-util.c(font_get_bold_name, font_get_italic_name): Hacked
	both so they allow testing of new font code.

2463 2464 2465 2466 2467
1998-11-10  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.c(create_link_array): Truly
	brainless one suprised it took so long to surface.

2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493
1998-11-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-view.c (sheet_view_comment_get_points): Scale properly
	the points to be in window cordinates.

	* src/sheet.c (sheet_col_set_width): Move comments on column
	change. 

	* src/cell.c (cell_copy): Duplicated cells get col, row and sheet
	values set to NULL.

1998-11-05  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-misc.c: Add ctype.h

	* src/sheet-view.c (sheet_view_comment_get_points): New utility
	routine used.
	(sheet_view_comment_relocate): New function used to relocate a
	comment canvas item in a cell to its new location.

	* src/cell.c (cell_relocate): Move the comments with the cell.
	(cell_realize, cell_unrealize, cell_comment_realize,
	cell_comment_unrealize): New functions used to create and destroy
	view-specific cell components (the comments are canvas objects
	that need to be created on a per-view basis).
	
2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504
1998-11-10  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-ole.h: Added unsigned to WORD, LONG
	types.

	* plugins/excel/ms-formula.c(getRefV7, getRefV8): Fixed 
	bug in relative column retrieval.

	* plugins/excel/ms-formula.c(ms_excel_parse_formula):
	Squashed silly op-code bug, and got simple op-codes working.
	
2505 2506 2507 2508 2509 2510
1998-11-09  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-formula.c: Re-designed the translation
	code, abstracted, and implemented AVERAGE, MIN & MAX using
	StarOffice 4.0 to deduce the standard function numbers.

2511 2512 2513 2514 2515 2516 2517 2518 2519 2520
1998-11-08  Michael Meeks    <michael@imaginator.com>

	* plugins/excel/ms-formula.c: Major top to bottom changes
	basic hacked RPN to Infix parsing started in a rather nasty
	fashion. Much more work needed only 1 ( the SUM ) function
	supported.

	* src/cell.c (cell_split_text): Fixed string length malloc
	bug, out by 1 trashing stack.

2521 2522 2523 2524 2525 2526 2527 2528
1998-11-08  Michael Meeks    <michael@imaginator.com>

	* src/workbook.c, src/sheet.h, src/main.c (workbook_read):
	Added generic routine to read a file

	* plugins/excel/ms-excel.c: Major code overhaul, multiple bug
	fixes, BLANK, MULBLANK implemented & tested
	
2529 2530 2531 2532 2533 2534 2535 2536 2537 2538
1998-11-02  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/cell.c, src/workbook.c, src/sheet-view.c: Finish cell
	comment display routines.  Now we only need the dialog box to
	insert/edit a cell comment.

1998-10-30  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/cell.c (cell_set_comment): new implementation.

2539 2540
1998-10-28  Miguel de Icaza  <miguel@nuclecu.unam.mx>

2541 2542 2543 2544 2545
	* src/fn-date.c (gnumeric_date): Fix longstanding off by one
	error.
	(gnumeric_today): ditto
	(gnumeric_now): ditto.

2546 2547 2548 2549 2550 2551 2552
	* Prepare for 0.4 release.
	
	* configure.in: Add test for new GTK+ selection code. 

	* src/clipboard.c: Make it work with both APIs: the old and the
	new one.  

2553 2554 2555 2556 2557
1998-10-28  Daniel Veillard <Daniel.Veillard@w3.org>

	* src/xml-io.c: now the basic I/O functions should be clean
	  removed all direct references to node->content.

2558 2559
1998-10-28  Miguel de Icaza  <miguel@nuclecu.unam.mx>

Miguel de Icaza's avatar
Miguel de Icaza committed
2560 2561 2562
	* src/gnumeric-sheet.c (gnumeric_sheet_key_mode_sheet): Added
	keypad support. 

2563 2564
	* src/parser.y (dump_tree): Updated to use the new symbol table.

Miguel de Icaza's avatar
Miguel de Icaza committed
2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585
1998-10-27  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/parser.c (dump_tree): Use extra argument.

	* src/expr.c (function_call_with_values): Use the extra argument
	to symbol_lookup

	* src/func.c (constants_init): Use the extra argument to symbol_install.

	* src/main.c (main): Invoke global_symbol_init.

	* src/symbol.h: Symbol routines now take an extra argument; the
	symboltable they work on.  Now the code can have multiple symbol
	tables (this is required for the cell range name bindings in a
	per-sheet fashion.

1998-10-25  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet.c (sheet_set_zoom_factor): Zoom factor should be
	applied to to the default styles.

2586 2587 2588 2589 2590 2591 2592 2593
1998-10-27  Daniel Veillard <Daniel.Veillard@w3.org>

	* src/xml-io.c: adapted code to the new XML tree format, however
	  to compile you need to update your libxml from the CVS tree too.
	  Not a definite solution I'm thinking about a more general API
	  for XML tree values encoding/decoding. I modified the endoding
	  format but backward compatibility should be maintained.

2594 2595 2596 2597 2598
1998-10-23  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* src/workbook.c: Made the menus consistent with the (unwritten!)
	UI Guidelines document.

2599 2600 2601 2602
1998-10-18  Tom Dyas  <tdyas@vger.rutgers.edu>

	* src/clipboard.c: Update to new GTK selection API.

2603 2604 2605 2606 2607
1998-10-14  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-string.c (gnumeric_right): New file.  Implements
	left/right string functions. 

2608 2609 2610 2611
1998-10-13  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/item-grid.h: Add some missing variables. 

2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636
1998-10-13  Jakub Jelinek  <jj@ultra.penguin.cz>

<