GitLab

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

	* src/fn-math.c: Added ROUNDDOWN() and ROUNDUP().

	* src/fn-stat.c: Added PROB().

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

	* src/fn-math.c: Added SUMX2MY2(), SUMX2PY2(), and SUMXMY2().

	* src/fn-stat.c: CONFIDENCE() should now work fully.

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.

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.

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

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

MOD function, updated function writing docs, fix to function number
parser so doesn't overflow.

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.

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).

1999-03-17  Vladimir Vuksan <vuksan@veus.hr>

        * src/fn-financial.c: Added new functions gnumeric_ipmt,
        gnumeric_ppmt, gnumeric_duration.

1999-03-18  Jukka-Pekka Iivonen  <iivonen@iki.fi>

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

        * src/fn-stat.c: binomdist, harmean, and hypgeomdist added.

1999-03-18  Jukka-Pekka Iivonen  <iivonen@iki.fi>

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

 	* src/fn-stat.c: binomdist, harmean, and hypgeomdist added.

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

	* 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.

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


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

	* 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

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

	* 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.

* Completed fr.po translation and fixed a few typos in fn-math.c

* POTFILES.in, fr.po: Updated.
* src/fn-math.c: Misc. corrections (typos, changed some help texts, ...)

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

	* src/cell.c (cell_modified): Cells from the clipboard do not have
	a Sheet parameter attached.

	* src/sheet.c (sheet_cell_add): Check the computed style:  if the
	computed style includes a format, then turn on the cell flag for
	format is set to avoid the auto guess of cell content.
	(sheet_style_compute): Now can return the flags of the style that
	were not part of the default style.

	* src/file.c (dialog_query_load_file, workbook_save_as): Put the
	window close to the mouse.

	* src/workbook.c (sheet_check_dirty, workbook_close): Do not
	cancel without warning the user if the workbook has changed.
	(workbook_new, workbook_can_close, workbook_window_destroy,
	quit_cmd, close_cmd): Reorganized the code to suit the new code to
	prevent inadvertent quits.

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

	* src/cell.c (cell_modified): New function, used to tag a modified
	cell in a sheet.

	* src/fn-math.c (gnumeric_average): Display error on division by
	zero.  Make the code not depend on the types returned by
	gnumeric_sum and gnumeric_count.
	(callback_function_sum): Keep sum as integers as long as
	possible instead of using floating point all the time.

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

	* src/fn-math.c (callback_function_sum): Do not try to be smart
	about string content.  Let the smartiness to other layers.
	(gnumeric_average): Handle division by zero on average routine.

	* src/number-match.c (create_option_list): Small bug fix:  First
	translate, then move the pointer ahead.

	* src/cell.c (str_trim_spaces): Trim space routine was removing
	everything after the first space instead of removing only the
	trailing space.
	(cell_draw): Free the original string, not the modified copy.

	* src/sheet.c (sheet_set_text): Test if the format has been
	manually set by the user before trying to do format matching.

	* src/cell.h: New flag: CELL_FORMAT_SET, used if the user has
	manually specified a format. FIXME: This information should be
	saved and loaded.

	* src/cell.c (cell_set_format): Set the CELL_FORMAT_SET flag

1998-09-29  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/xml-io.c: Changed the formatting of it to be like the rest
	of Gnumeric.

	* src/fn-math.c, src/fn-date.c: Simplify routines to use
	value_float and value_int.

	* src/expr.c (value_float, value_int): New utility functions to
	create values of type integer and float.

	* src/sheet.c (sheet_set_text): Use the matching engine on entered text

	* src/cell.c (cell_set_text_simple): New function.  Does not queue
	cell computations nor queue any redraws
	(cell_content_changed): New function: Queues recomputations for
	cells that depend on the contents of the argument.
	(cell_set_format_simple): New routine, like cell_set_format but
	does not render the value nor queues a redraw.

	* src/xml-io.c: Use workbook_recalc_all instead of workbook_recalc

	* src/fn-math.c (gnumeric_log10, gnumeric_log, gnumeric_log2):
	Range check fix was wrong.  The valid range does not include
	zero.  Thanks to Morten Welinder for noticing this.
	(gnumeric_cosh): Call cosh, not cos.
	Reordered this file to have the help always before the function
	that defines it.
	(callback_function_or): Bug fix: any non-zero value is considered
	to be TRUE.
	(gnumeric_fact): Use exp (lgamma (n+1)) to compute large
	factorials (this only applies to factorials over 40).

	* src/about.c (dialog_about): Stop using gnome_dialog_set_modal.

1998-09-21  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-math.c: Changed the way we tag the function definitions
	before its too late.

	* src/item-cursor.c (item_cursor_point): Made the thresholds for
	the cursor a little better.

	* src/dialog-cell-format.c: Small changes to the color
	configuration code.

	* src/expr.c (do_expr_decode_tree): When decoding a tree, include

1998-09-21  Adrian Likins <adrian@gimp.org>

        *src/fn-math.c: first stab at fleshing out the help
	        blurbs here.
-adrian

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

	* src/sheet-view.c (sheet_view_row_size_changed,
	sheet_view_col_size_changed): If there is a selection of columns
	or rows, change the sizes of all of the columns.

	* src/sheet.c (sheet_row_get_distance, sheet_col_get_distance):
	optimized to be O(n) instead of O(n^2) using
	(col_row_distance): new routine to compute distances.

	* src/sheet-view.c (sheet_view_redraw_cell_region): Add the
	scrolling offset to the x and y positions to draw properly

	* src/xml-io.c (readXmlSheet): Call sheet_set_zoom_factor to
	initialize the ->pixels field.

Ok, the new display engine is now in place.

The design bug with the exposures has now been fixed.

Now, back to more mundane tasks.

Miguel.

Today it probably does not compile, but I have to leave now.

This is basically the framework for getting computations working.

My current approach is to register areas of interest for a cell.
This is not perfect, but good enough:

	The idea is to walk the expression tree and look for
	cell references (cell references or ranges) and register
	those areas of "interest" for a cell.

	When a new text is entered into a cell, the "regions" of
	interest list is checked and if a match is found, then
	the cells on that region of interest are queued for
	recomputation.

Of course, I do not know yet how to handle the recursive references.

One option is to keep a counter (that starts at zero) during
recomputation, ie something like:

eval_cell (Cell *cell)
{
	cell->use_count++;
	if (cell->use_count > threshold)
		return "Cycle too depth";
	...
	on value lookup:
		eval_cell (cell);
	...
	cell->use_count--;
}