1 2018-08-19 Morten Welinder <terra@gnome.org>
5 2018-08-09 Morten Welinder <terra@gnome.org>
9 2018-05-07 Morten Welinder <terra@gnome.org>
13 2018-04-29 Morten Welinder <terra@gnome.org>
17 2018-03-13 Morten Welinder <terra@gnome.org>
21 2017-12-28 Morten Welinder <terra@gnome.org>
25 2017-12-01 Morten Welinder <terra@gnome.org>
29 2017-11-18 Morten Welinder <terra@gnome.org>
33 2017-07-06 Morten Welinder <terra@gnome.org>
37 2017-03-20 Morten Welinder <terra@gnome.org>
41 2017-01-30 Morten Welinder <terra@gnome.org>
45 2016-08-20 Morten Welinder <terra@gnome.org>
49 2016-06-29 Morten Welinder <terra@gnome.org>
53 2016-06-17 Morten Welinder <terra@gnome.org>
57 2016-05-06 Morten Welinder <terra@gnome.org>
61 2016-03-22 Morten Welinder <terra@gnome.org>
65 2016-02-06 Morten Welinder <terra@gnome.org>
69 2015-12-28 Morten Welinder <terra@gnome.org>
73 2015-12-25 Morten Welinder <terra@gnome.org>
77 2015-09-20 Morten Welinder <terra@gnome.org>
81 2015-07-28 Morten Welinder <terra@gnome.org>
85 2015-04-16 Morten Welinder <terra@gnome.org>
89 2015-03-04 Morten Welinder <terra@gnome.org>
93 2015-02-04 Morten Welinder <terra@gnome.org>
97 2015-01-23 Morten Welinder <terra@gnome.org>
101 2015-01-09 Morten Welinder <terra@gnome.org>
103 * functions.c (gnumeric_address): Fix previous fix. The sheet we
104 compute is purely for the purpose of find the sheet size.
106 2015-01-03 Morten Welinder <terra@gnome.org>
108 * functions.c (gnumeric_address): Clear sheet_name when defaulting
111 2014-09-25 Morten Welinder <terra@gnome.org>
115 2014-06-09 Morten Welinder <terra@gnome.org>
119 2014-05-23 Morten Welinder <terra@gnome.org>
123 2014-04-30 Morten Welinder <terra@gnome.org>
127 2014-04-13 Morten Welinder <terra@gnome.org>
131 2014-03-24 Morten Welinder <terra@gnome.org>
133 * functions.c (clear_caches): Protect the pools from pruning while
136 2014-03-22 Morten Welinder <terra@gnome.org>
138 * functions.c (get_bisection_lookup_cache): Same thing as for
139 get_linear_lookup_cache.
141 2014-03-18 Morten Welinder <terra@gnome.org>
145 2014-03-03 Morten Welinder <terra@gnome.org>
149 2014-02-16 Morten Welinder <terra@gnome.org>
153 2014-02-11 Morten Welinder <terra@gnome.org>
157 2014-02-09 Morten Welinder <terra@gnome.org>
159 * functions.c (get_linear_lookup_cache): When creating a new
160 entry, don't actually insert it into the cache. Doing so here
161 means that (a) it can be pruned before we're done constructing it,
162 and (b) it can be accessed before it is ready.
163 (linear_lookup_cache_commit): Insert here instead in this new
165 These changes fix #723894.
167 2013-11-28 Morten Welinder <terra@gnome.org>
171 2013-10-21 Morten Welinder <terra@gnome.org>
173 * functions.c (hyperlink): scalar, not string type, arguments.
176 2013-10-07 Morten Welinder <terra@gnome.org>
180 2013-09-01 Morten Welinder <terra@gnome.org>
184 2013-08-27 Morten Welinder <terra@gnome.org>
188 2013-08-19 Morten Welinder <terra@gnome.org>
192 2013-07-10 Morten Welinder <terra@gnome.org>
196 2013-06-25 Morten Welinder <terra@gnome.org>
200 2013-04-26 Morten Welinder <terra@gnome.org>
204 2013-03-09 Morten Welinder <terra@gnome.org>
208 2012-12-18 Morten Welinder <terra@gnome.org>
212 2012-11-29 Morten Welinder <terra@gnome.org>
216 2012-11-16 Morten Welinder <terra@gnome.org>
220 2012-09-06 Morten Welinder <terra@gnome.org>
224 2012-07-26 Andreas J. Guelzow <aguelzow@pyrshep.ca>
226 * functions.c (help_transpose): add FLIP to SEEALSO
229 (lookup_functions): add FLIP
230 * plugin.xml.in: add FLIP
232 2012-07-15 Morten Welinder <terra@gnome.org>
236 2012-06-25 Morten Welinder <terra@gnome.org>
240 2012-04-21 Morten Welinder <terra@gnome.org>
244 2012-03-29 Morten Welinder <terra@gnome.org>
246 * functions.c (clear_caches): Add debug flag.
248 2012-03-18 Morten Welinder <terra@gnome.org>
250 * functions.c (gnumeric_vlookup, gnumeric_hlookup): Handle string
251 search with patterns. [#672319]
252 (wildcard_string_match): Return the index from the cache item.
253 That takes left-out cells into account.
255 2012-03-02 Morten Welinder <terra@gnome.org>
259 2011-11-27 Morten Welinder <terra@gnome.org>
263 2011-11-24 Morten Welinder <terra@gnome.org>
267 2011-07-31 Morten Welinder <terra@gnome.org>
271 2011-05-21 Morten Welinder <terra@gnome.org>
273 * functions.c (gnumeric_sheet): Simplify. Fixes #650761.
274 (gnumeric_sheets): Simplify. Fixes #650764.
276 2011-05-21 Morten Welinder <terra@gnome.org>
280 2011-05-12 Morten Welinder <terra@gnome.org>
282 * functions.c (gnumeric_address): Get sheet size from the right
283 sheet. Fixes #650003.
285 2011-03-24 Morten Welinder <terra@gnome.org>
289 2011-02-02 Morten Welinder <terra@gnome.org>
293 2010-11-25 Morten Welinder <terra@gnome.org>
297 2010-11-24 Andreas J. Guelzow <aguelzow@pyrshep.ca>
299 * plugins/fn-lookup/functions.c (help_vlookup): fix fn_note
300 (help_hlookup): fix description
302 2010-10-01 Morten Welinder <terra@gnome.org>
306 2010-09-04 Morten Welinder <terra@gnome.org>
310 2010-08-16 Morten Welinder <terra@gnome.org>
314 2010-07-30 Morten Welinder <terra@gnome.org>
318 2010-07-23 Andreas J. Guelzow <aguelzow@pyrshep.ca>
320 * plugins/fn-lookup/functions.c (help_sheet): fix description
322 2010-07-12 Andreas J. Guelzow <aguelzow@pyrshep.ca>
324 * functions.c (callback_function_array):
325 make sure we have values, since some functions such as COUNT
326 can't handle a matrix with NULL values.
328 2010-07-11 Andreas J. Guelzow <aguelzow@pyrshep.ca>
330 * plugin.xml.in: new function SORT
331 * functions.c (help_sort): new
333 (lookup_functions): add new function SORT
335 2010-07-11 Andreas J. Guelzow <aguelzow@pyrshep.ca>
337 * plugin.xml.in: new function ARRAY
338 * functions.c (help_array): new
339 (gnumeric_array): new
340 (callback_function_array): new
341 (lookup_functions): add new function ARRAY
343 2010-06-28 Morten Welinder <terra@gnome.org>
347 2010-06-16 Morten Welinder <terra@gnome.org>
351 2010-06-15 Andreas J. Guelzow <aguelzow@pyrshep.ca>
353 * functions.c: fix empty argument descriptions
355 2010-06-13 Morten Welinder <terra@gnome.org>
357 * functions.c (help_sheet, help_sheets): Remove help entries that
360 2010-05-30 Morten Welinder <terra@gnome.org>
364 2010-05-20 Morten Welinder <terra@gnome.org>
368 2010-05-07 Morten Welinder <terra@gnome.org>
372 2010-04-16 Morten Welinder <terra@gnome.org>
376 2010-04-16 Morten Welinder <terra@gnome.org>
378 * functions.c (gnumeric_index): Clean this up somewhat. Why is
379 this a vararg function?
381 2010-03-08 Morten Welinder <terra@gnome.org>
385 2010-02-13 Morten Welinder <terra@gnome.org>
389 2010-01-19 Morten Welinder <terra@gnome.org>
393 2009-12-15 Morten Welinder <terra@gnome.org>
397 2009-11-29 Morten Welinder <terra@gnome.org>
401 2009-11-01 Morten Welinder <terra@gnome.org>
405 2009-10-25 Andreas J. Guelzow <aguelzow@pyrshep.ca>
407 * functions.c (help_sheet): new
408 (gnumeric_sheet): new
409 (lookup_functions): add SHEET
410 * plugin.xml.in: add SHEET
412 2009-10-24 Andreas J. Guelzow <aguelzow@pyrshep.ca>
414 * functions.c (help_sheets): new
415 (gnumeric_sheets): new
416 (lookup_functions): add SHEETS
417 * plugin.xml.in: add SHEETS
419 2009-10-11 Morten Welinder <terra@gnome.org>
423 2009-09-20 Morten Welinder <terra@gnome.org>
427 2009-09-05 Morten Welinder <terra@gnome.org>
431 2009-08-30 Morten Welinder <terra@gnome.org>
435 2009-08-26 Andreas J. Guelzow <aguelzow@pyrshep.ca>
437 * functions.c (help_vlookup): fix formatting
438 (help_hlookup): ditto
440 2009-08-26 Morten Welinder <terra@gnome.org>
442 * functions.c (get_linear_lookup_cache,
443 get_bisection_lookup_cache): Take extra "vertical" argument and
444 separate caches for vertical and horizontal cases. All callers
445 changed. Fixes #593238.
447 2009-08-15 Morten Welinder <terra@gnome.org>
451 2009-08-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
453 * functions.c: remove argument names from GnmFuncDescriptor
455 2009-08-05 Andreas J. Guelzow <aguelzow@pyrshep.ca>
457 * functions.c (help_match): fix documentation [#317784]
459 2009-08-05 Andreas J. Guelzow <aguelzow@pyrshep.ca>
461 * functions.c (help_*): change to "new" documentation format
463 2009-06-20 Morten Welinder <terra@gnome.org>
467 2009-05-23 Morten Welinder <terra@gnome.org>
471 2009-05-08 Morten Welinder <terra@gnome.org>
473 * functions.c (get_linear_lookup_cache,
474 get_bisection_lookup_cache): Possible prune caches.
475 (prune_caches): New function.
477 2009-05-06 Morten Welinder <terra@gnome.org>
481 2009-04-25 Morten Welinder <terra@gnome.org>
485 2009-03-22 Morten Welinder <terra@gnome.org>
489 2009-02-22 Morten Welinder <terra@gnome.org>
493 2009-02-02 Morten Welinder <terra@gnome.org>
495 * functions.c (wildcard_string_match): New function.
496 (find_index_bisection): Call wildcard_string_match for the type=0
498 (gnumeric_match): For the type=0 string case, use
499 find_index_bisection if there are any wildcards.
501 2009-02-01 Morten Welinder <terra@gnome.org>
503 * functions.c (get_elem): Don't turn empties into 0.
505 2009-01-28 Morten Welinder <terra@gnome.org>
507 * functions.c (create_caches): Create caches for the bisection
509 (clear_caches): Destroy those.
510 (get_bisection_lookup_cache): New function.
511 (get_linear_lookup_cache): Change cache key to a GnmValue so we
512 can handle arrays too.
513 (find_bound_walk): Delete.
514 (find_index_linear): We no longer need the fallback code.
515 (find_index_bisection): Pre-load, pre-process, and cache the data.
517 2009-01-26 Morten Welinder <terra@gnome.org>
519 * functions.c (find_compare_type_valid): Floats should not match
521 (get_linear_lookup_cache): Create a separate cache for looking up
524 2009-01-24 Morten Welinder <terra@gnome.org>
526 * functions.c (find_index_linear): Eliminate "type" argument since
527 it is always zero. Simplify.
528 (get_linear_lookup_cache): Use pools for strings and floats so we
529 don't have to free individual cache members.
530 (get_linear_lookup_cache): Take new argument, "brand_new", so
531 caller doesn't have to use hash size hack. All callers fixed.
532 (find_index_linear_equal_float): Change to take needle as
533 GnmValue, so we can use find_compare_type_valid. Callers changed.
535 2008-11-03 Morten Welinder <terra@gnome.org>
537 * functions.c (gnumeric_lookup): Fix critical. (#559005)
539 2008-10-18 Jody Goldberg <jody@gnome.org>
543 2008-08-29 Jody Goldberg <jody@gnome.org>
547 2008-08-19 J.H.M. Dassen (Ray) <jdassen@debian.org>
549 * functions.c (gnumeric_indirect): Clarified boolean argument.
551 2008-07-01 Morten Welinder <terra@gnome.org>
553 * functions.c (find_bound_walk): When reversing direction, handle
554 singleton right. Fixes #540996.
556 2008-06-25 Jody Goldberg <jody@gnome.org>
560 2008-05-22 Morten Welinder <terra@gnome.org>
562 * functions.c (get_cache): Properly split caches for floats and
565 2008-05-17 Jean Brefort <jean.brefort@normalesup.org>
567 * functions.c: (gnumeric_index): correctly check first argument
570 2008-05-16 Morten Welinder <terra@gnome.org>
572 * functions.c (gnumeric_areas): Check the value type of the
573 calculation function result, not something weird with the call
574 itself. Fixes #533370.
576 2008-05-04 Jody Goldberg <jody@gnome.org>
580 2008-04-08 Morten Welinder <terra@gnome.org>
582 * functions.c (find_index_linear_equal_string): New function for a
583 common special case. Fixes #525875.
584 (go_plugin_init): Install signal to clear caches after recalcs.
585 (go_plugin_shutdown): Remove above signal.
587 2007-12-21 Jody Goldberg <jody@gnome.org>
591 2007-12-29 Jody Goldberg <jody@gnome.org>
593 * functions.c (help_column) : re-order the help text. The current
594 dump routine is too stupid to order things correctly for the
598 2007-12-03 Jody Goldberg <jody@gnome.org>
602 2007-11-20 Jody Goldberg <jody@gnome.org>
604 * functions.c (gnumeric_offset) : no need to translate the far corner
605 if there is no width/height specified. [#497294]
607 2007-11-19 Jody Goldberg <jody@gnome.org>
611 2007-11-04 Morten Welinder <terra@gnome.org>
615 2007-10-21 Morten Welinder <terra@gnome.org>
619 2007-09-04 Jody Goldberg <jody@gnome.org>
623 2007-08-31 Morten Welinder <terra@gnome.org>
625 * functions.c (gnumeric_column): Fix off-by-one.
627 2007-08-30 Jody Goldberg <jody@gnome.org>
629 * functions.c (gnumeric_column) : fix per Harlan Grove's testing that
630 row/column return vectors, not matricies.
631 * functions.c (gnumeric_row) : ditto. Move to the new help style
634 2007-08-27 Jody Goldberg <jody@gnome.org>
636 * functions.c (gnumeric_index) : actually return a
637 reference, some functions require it.
639 2007-07-24 Jody Goldberg <jody@gnome.org>
643 2007-05-03 Morten Welinder <terra@gnome.org>
647 2007-04-21 Morten Welinder <terra@gnome.org>
651 2007-03-04 Morten Welinder <terra@gnome.org>
655 2007-02-16 Morten Welinder <terra@gnome.org>
659 2006-12-17 Jody Goldberg <jody@gnome.org>
663 2006-12-04 Jody Goldberg <jody@gnome.org>
667 2006-11-20 Jody Goldberg <jody@gnome.org>
671 2006-11-19 Morten Welinder <terra@gnome.org>
675 2006-10-17 Jody Goldberg <jody@gnome.org>
679 2006-10-02 Jody Goldberg <jody@gnome.org>
683 2006-05-08 Jody Goldberg <jody@gnome.org>
687 2006-01-20 Jody Goldberg <jody@gnome.org>
689 * functions.c (gnumeric_areas) : handle new GNM_EXPR_OP_ARRAY
692 2006-01-20 Morten Welinder <terra@gnome.org>
694 * functions.c: Fix left-over uses of argument type B.
696 2005-12-08 Jody Goldberg <jody@gnome.org>
698 * functions.c (gnumeric_address) : Use the new gnm_expr_conv_quote.
699 (gnumeric_areas) : better error handling.
701 2005-11-30 Jody Goldberg <jody@gnome.org>
703 * functions.c (gnumeric_address) : rework to handle the special case
704 of relative refs in R1C1 mode actually being relative, where as in
705 A1 mode the col/row are treated as absolute.
707 2005-11-14 Jody Goldberg <jody@gnome.org>
711 2005-10-10 Jody Goldberg <jody@gnome.org>
715 2005-09-08 Jody Goldberg <jody@gnome.org>
719 2005-08-28 Morten Welinder <terra@gnome.org>
723 2005-08-28 Morten Welinder <terra@gnome.org>
727 2005-08-15 Morten Welinder <terra@gnome.org>
731 2005-06-13 Jody Goldberg <jody@gnome.org>
733 * functions.c (gnumeric_column) : rework to handle arrays locally.
734 As far as we know these are the only position dependent situations
736 (gnumeric_row) : ditto.
738 2005-06-13 Jody Goldberg <jody@gnome.org>
742 2005-06-07 Jody Goldberg <jody@gnome.org>
744 * functions.c (gnumeric_indirect) : handle R1C1
746 2005-05-10 Jody Goldberg <jody@gnome.org>
750 2005-02-09 Jody Goldberg <jody@gnome.org>
752 * functions.c (gnumeric_offset) : fix transposition of width and
755 2005-02-08 Jody Goldberg <jody@gnome.org>
759 2005-01-17 Jody Goldberg <jody@gnome.org>
763 2005-01-09 Jody Goldberg <jody@gnome.org>
765 http://bugzilla.gnome.org/show_bug.cgi?id=163040
766 * functions.c (gnumeric_match) : If type is not specified, default to
769 2004-12-09 Jody Goldberg <jody@gnome.org>
773 2004-11-28 Jody Goldberg <jody@gnome.org>
777 2004-11-07 Jody Goldberg <jody@gnome.org>
781 2004-10-31 Jody Goldberg <jody@gnome.org>
785 2004-10-05 Jody Goldberg <jody@gnome.org>
789 2004-09-08 Jody Goldberg <jody@gnome.org>
793 2004-08-29 Jody Goldberg <jody@gnome.org>
797 2004-08-19 Jon K Hellan <hellan@acm.org>
799 * functions.c: Xref INDIRECT->CELL
801 2004-07-19 Jody Goldberg <jody@gnome.org>
805 2004-03-28 Jody Goldberg <jody@gnome.org>
809 2003-12-23 Jody Goldberg <jody@gnome.org>
813 2003-11-26 Jody Goldberg <jody@gnome.org>
817 2003-10-08 Jody Goldberg <jody@gnome.org>
821 2003-10-05 Jody Goldberg <jody@gnome.org>
823 * functions.c : Have lookup/hlookup/vlookup/match use the new 'B' arg
824 type so that they can correctly handle empties.
825 (find_type_valid) : handle empty.
827 2003-09-15 Jody Goldberg <jody@gnome.org>
831 2003-09-10 Jody Goldberg <jody@gnome.org>
835 2003-08-21 Jody Goldberg <jody@gnome.org>
839 2003-06-23 Andreas J. Guelzow <aguelzow@taliesin.ca>
841 * functions.c: spelling fixes
843 2003-06-07 Jody Goldberg <jody@gnome.org>
847 2003-06-07 Jody Goldberg <jody@gnome.org>
851 2003-05-12 Morten Welinder <terra@gnome.org>
853 * functions.c (gnumeric_columnnumber): New function.
855 2003-05-11 Jody Goldberg <jody@gnome.org>
859 2003-01-28 Jody Goldberg <jody@gnome.org>
863 2002-12-31 Jody Goldberg <jody@gnome.org>
867 2002-12-22 Jody Goldberg <jody@gnome.org>
871 2002-12-22 Jody Goldberg <jody@gnome.org>
875 2002-11-15 Jody Goldberg <jody@gnome.org>
879 2002-11-01 Jody Goldberg <jody@gnome.org>
883 2002-10-27 Jody Goldberg <jody@gnome.org>
887 2002-10-16 Morten Welinder <terra@diku.dk>
889 * functions.c (gnumeric_column, gnumeric_row): Plug leaks.
891 2002-10-11 Jody Goldberg <jody@gnome.org>
893 * plugin.xml.in : add areas
894 * functions.c (gnumeric_areas) : new. A quick simple implementation
895 until the core can support more.
897 2002-10-10 Jody Goldberg <jody@gnome.org>
899 * functions.c (gnumeric_indirect) : always return a cell_range and use
900 the convenience routine gnm_expr_get_range. The core is now strong
901 enough to handle the intersection and dependencies properly.
903 2002-09-30 Jody Goldberg <jody@gnome.org>
907 2002-09-27 Jody Goldberg <jody@gnome.org>
909 * functions.c (gnumeric_index) : implement multi-region
911 2002-09-11 Jody Goldberg <jody@gnome.org>
913 * functions.c (gnumeric_address) : use sheet_name_quote and add upper
916 2002-08-30 Morten Welinder <terra@diku.dk>
918 * functions.c (gnumeric_address): Avoid copying string.
920 2002-08-25 Jody Goldberg <jody@gnome.org>
924 2002-08-12 Jody Goldberg <jody@gnome.org>
928 2002-07-22 Zbigniew Chyla <cyba@gnome.pl>
930 * plugin.xml.in: Set loader type to "Gnumeric_Builtin:module".
932 2002-07-28 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
934 * functions.c: Even more function description clean up.
936 2002-07-27 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
938 * functions.c: Function description clean up.
940 2002-07-21 Jody Goldberg <jody@gnome.org>
944 2002-06-22 Jody Goldberg <jody@gnome.org>
946 * functions.c (gnumeric_offset) : no need to special case 1x1 results.
947 but add some clipping for the 2nd
949 2002-05-29 Jody Goldberg <jody@gnome.org>
953 2002-05-21 Morten Welinder <terra@diku.dk>
955 * functions.c (gnumeric_column, gnumeric_row): Fix 82188.
957 2002-05-09 Andreas J. Guelzow <aguelzow@taliesin.ca>
959 * functions.c (find_index_bisection) : use value_area_get_x_y rather
960 than value_area_fetch_x_y
961 http://bugzilla.gnome.org/show_bug.cgi?id=80126
963 2002-05-03 Andreas J. Guelzow <aguelzow@taliesin.ca>
965 * functions.c : mark argument names for translation and adjust
966 them for use by the formula guru.