1 2017-03-20 Morten Welinder <terra@gnome.org>
5 2017-01-30 Morten Welinder <terra@gnome.org>
9 2016-08-20 Morten Welinder <terra@gnome.org>
13 2016-06-29 Morten Welinder <terra@gnome.org>
17 2016-06-17 Morten Welinder <terra@gnome.org>
21 2016-05-06 Morten Welinder <terra@gnome.org>
25 2016-03-22 Morten Welinder <terra@gnome.org>
29 2016-02-06 Morten Welinder <terra@gnome.org>
33 2015-12-28 Morten Welinder <terra@gnome.org>
37 2015-12-25 Morten Welinder <terra@gnome.org>
41 2015-09-20 Morten Welinder <terra@gnome.org>
45 2015-07-28 Morten Welinder <terra@gnome.org>
49 2015-04-16 Morten Welinder <terra@gnome.org>
53 2015-03-04 Morten Welinder <terra@gnome.org>
57 2015-02-04 Morten Welinder <terra@gnome.org>
61 2015-01-23 Morten Welinder <terra@gnome.org>
65 2015-01-09 Morten Welinder <terra@gnome.org>
67 * functions.c (gnumeric_address): Fix previous fix. The sheet we
68 compute is purely for the purpose of find the sheet size.
70 2015-01-03 Morten Welinder <terra@gnome.org>
72 * functions.c (gnumeric_address): Clear sheet_name when defaulting
75 2014-09-25 Morten Welinder <terra@gnome.org>
79 2014-06-09 Morten Welinder <terra@gnome.org>
83 2014-05-23 Morten Welinder <terra@gnome.org>
87 2014-04-30 Morten Welinder <terra@gnome.org>
91 2014-04-13 Morten Welinder <terra@gnome.org>
95 2014-03-24 Morten Welinder <terra@gnome.org>
97 * functions.c (clear_caches): Protect the pools from pruning while
100 2014-03-22 Morten Welinder <terra@gnome.org>
102 * functions.c (get_bisection_lookup_cache): Same thing as for
103 get_linear_lookup_cache.
105 2014-03-18 Morten Welinder <terra@gnome.org>
109 2014-03-03 Morten Welinder <terra@gnome.org>
113 2014-02-16 Morten Welinder <terra@gnome.org>
117 2014-02-11 Morten Welinder <terra@gnome.org>
121 2014-02-09 Morten Welinder <terra@gnome.org>
123 * functions.c (get_linear_lookup_cache): When creating a new
124 entry, don't actually insert it into the cache. Doing so here
125 means that (a) it can be pruned before we're done constructing it,
126 and (b) it can be accessed before it is ready.
127 (linear_lookup_cache_commit): Insert here instead in this new
129 These changes fix #723894.
131 2013-11-28 Morten Welinder <terra@gnome.org>
135 2013-10-21 Morten Welinder <terra@gnome.org>
137 * functions.c (hyperlink): scalar, not string type, arguments.
140 2013-10-07 Morten Welinder <terra@gnome.org>
144 2013-09-01 Morten Welinder <terra@gnome.org>
148 2013-08-27 Morten Welinder <terra@gnome.org>
152 2013-08-19 Morten Welinder <terra@gnome.org>
156 2013-07-10 Morten Welinder <terra@gnome.org>
160 2013-06-25 Morten Welinder <terra@gnome.org>
164 2013-04-26 Morten Welinder <terra@gnome.org>
168 2013-03-09 Morten Welinder <terra@gnome.org>
172 2012-12-18 Morten Welinder <terra@gnome.org>
176 2012-11-29 Morten Welinder <terra@gnome.org>
180 2012-11-16 Morten Welinder <terra@gnome.org>
184 2012-09-06 Morten Welinder <terra@gnome.org>
188 2012-07-26 Andreas J. Guelzow <aguelzow@pyrshep.ca>
190 * functions.c (help_transpose): add FLIP to SEEALSO
193 (lookup_functions): add FLIP
194 * plugin.xml.in: add FLIP
196 2012-07-15 Morten Welinder <terra@gnome.org>
200 2012-06-25 Morten Welinder <terra@gnome.org>
204 2012-04-21 Morten Welinder <terra@gnome.org>
208 2012-03-29 Morten Welinder <terra@gnome.org>
210 * functions.c (clear_caches): Add debug flag.
212 2012-03-18 Morten Welinder <terra@gnome.org>
214 * functions.c (gnumeric_vlookup, gnumeric_hlookup): Handle string
215 search with patterns. [#672319]
216 (wildcard_string_match): Return the index from the cache item.
217 That takes left-out cells into account.
219 2012-03-02 Morten Welinder <terra@gnome.org>
223 2011-11-27 Morten Welinder <terra@gnome.org>
227 2011-11-24 Morten Welinder <terra@gnome.org>
231 2011-07-31 Morten Welinder <terra@gnome.org>
235 2011-05-21 Morten Welinder <terra@gnome.org>
237 * functions.c (gnumeric_sheet): Simplify. Fixes #650761.
238 (gnumeric_sheets): Simplify. Fixes #650764.
240 2011-05-21 Morten Welinder <terra@gnome.org>
244 2011-05-12 Morten Welinder <terra@gnome.org>
246 * functions.c (gnumeric_address): Get sheet size from the right
247 sheet. Fixes #650003.
249 2011-03-24 Morten Welinder <terra@gnome.org>
253 2011-02-02 Morten Welinder <terra@gnome.org>
257 2010-11-25 Morten Welinder <terra@gnome.org>
261 2010-11-24 Andreas J. Guelzow <aguelzow@pyrshep.ca>
263 * plugins/fn-lookup/functions.c (help_vlookup): fix fn_note
264 (help_hlookup): fix description
266 2010-10-01 Morten Welinder <terra@gnome.org>
270 2010-09-04 Morten Welinder <terra@gnome.org>
274 2010-08-16 Morten Welinder <terra@gnome.org>
278 2010-07-30 Morten Welinder <terra@gnome.org>
282 2010-07-23 Andreas J. Guelzow <aguelzow@pyrshep.ca>
284 * plugins/fn-lookup/functions.c (help_sheet): fix description
286 2010-07-12 Andreas J. Guelzow <aguelzow@pyrshep.ca>
288 * functions.c (callback_function_array):
289 make sure we have values, since some functions such as COUNT
290 can't handle a matrix with NULL values.
292 2010-07-11 Andreas J. Guelzow <aguelzow@pyrshep.ca>
294 * plugin.xml.in: new function SORT
295 * functions.c (help_sort): new
297 (lookup_functions): add new function SORT
299 2010-07-11 Andreas J. Guelzow <aguelzow@pyrshep.ca>
301 * plugin.xml.in: new function ARRAY
302 * functions.c (help_array): new
303 (gnumeric_array): new
304 (callback_function_array): new
305 (lookup_functions): add new function ARRAY
307 2010-06-28 Morten Welinder <terra@gnome.org>
311 2010-06-16 Morten Welinder <terra@gnome.org>
315 2010-06-15 Andreas J. Guelzow <aguelzow@pyrshep.ca>
317 * functions.c: fix empty argument descriptions
319 2010-06-13 Morten Welinder <terra@gnome.org>
321 * functions.c (help_sheet, help_sheets): Remove help entries that
324 2010-05-30 Morten Welinder <terra@gnome.org>
328 2010-05-20 Morten Welinder <terra@gnome.org>
332 2010-05-07 Morten Welinder <terra@gnome.org>
336 2010-04-16 Morten Welinder <terra@gnome.org>
340 2010-04-16 Morten Welinder <terra@gnome.org>
342 * functions.c (gnumeric_index): Clean this up somewhat. Why is
343 this a vararg function?
345 2010-03-08 Morten Welinder <terra@gnome.org>
349 2010-02-13 Morten Welinder <terra@gnome.org>
353 2010-01-19 Morten Welinder <terra@gnome.org>
357 2009-12-15 Morten Welinder <terra@gnome.org>
361 2009-11-29 Morten Welinder <terra@gnome.org>
365 2009-11-01 Morten Welinder <terra@gnome.org>
369 2009-10-25 Andreas J. Guelzow <aguelzow@pyrshep.ca>
371 * functions.c (help_sheet): new
372 (gnumeric_sheet): new
373 (lookup_functions): add SHEET
374 * plugin.xml.in: add SHEET
376 2009-10-24 Andreas J. Guelzow <aguelzow@pyrshep.ca>
378 * functions.c (help_sheets): new
379 (gnumeric_sheets): new
380 (lookup_functions): add SHEETS
381 * plugin.xml.in: add SHEETS
383 2009-10-11 Morten Welinder <terra@gnome.org>
387 2009-09-20 Morten Welinder <terra@gnome.org>
391 2009-09-05 Morten Welinder <terra@gnome.org>
395 2009-08-30 Morten Welinder <terra@gnome.org>
399 2009-08-26 Andreas J. Guelzow <aguelzow@pyrshep.ca>
401 * functions.c (help_vlookup): fix formatting
402 (help_hlookup): ditto
404 2009-08-26 Morten Welinder <terra@gnome.org>
406 * functions.c (get_linear_lookup_cache,
407 get_bisection_lookup_cache): Take extra "vertical" argument and
408 separate caches for vertical and horizontal cases. All callers
409 changed. Fixes #593238.
411 2009-08-15 Morten Welinder <terra@gnome.org>
415 2009-08-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
417 * functions.c: remove argument names from GnmFuncDescriptor
419 2009-08-05 Andreas J. Guelzow <aguelzow@pyrshep.ca>
421 * functions.c (help_match): fix documentation [#317784]
423 2009-08-05 Andreas J. Guelzow <aguelzow@pyrshep.ca>
425 * functions.c (help_*): change to "new" documentation format
427 2009-06-20 Morten Welinder <terra@gnome.org>
431 2009-05-23 Morten Welinder <terra@gnome.org>
435 2009-05-08 Morten Welinder <terra@gnome.org>
437 * functions.c (get_linear_lookup_cache,
438 get_bisection_lookup_cache): Possible prune caches.
439 (prune_caches): New function.
441 2009-05-06 Morten Welinder <terra@gnome.org>
445 2009-04-25 Morten Welinder <terra@gnome.org>
449 2009-03-22 Morten Welinder <terra@gnome.org>
453 2009-02-22 Morten Welinder <terra@gnome.org>
457 2009-02-02 Morten Welinder <terra@gnome.org>
459 * functions.c (wildcard_string_match): New function.
460 (find_index_bisection): Call wildcard_string_match for the type=0
462 (gnumeric_match): For the type=0 string case, use
463 find_index_bisection if there are any wildcards.
465 2009-02-01 Morten Welinder <terra@gnome.org>
467 * functions.c (get_elem): Don't turn empties into 0.
469 2009-01-28 Morten Welinder <terra@gnome.org>
471 * functions.c (create_caches): Create caches for the bisection
473 (clear_caches): Destroy those.
474 (get_bisection_lookup_cache): New function.
475 (get_linear_lookup_cache): Change cache key to a GnmValue so we
476 can handle arrays too.
477 (find_bound_walk): Delete.
478 (find_index_linear): We no longer need the fallback code.
479 (find_index_bisection): Pre-load, pre-process, and cache the data.
481 2009-01-26 Morten Welinder <terra@gnome.org>
483 * functions.c (find_compare_type_valid): Floats should not match
485 (get_linear_lookup_cache): Create a separate cache for looking up
488 2009-01-24 Morten Welinder <terra@gnome.org>
490 * functions.c (find_index_linear): Eliminate "type" argument since
491 it is always zero. Simplify.
492 (get_linear_lookup_cache): Use pools for strings and floats so we
493 don't have to free individual cache members.
494 (get_linear_lookup_cache): Take new argument, "brand_new", so
495 caller doesn't have to use hash size hack. All callers fixed.
496 (find_index_linear_equal_float): Change to take needle as
497 GnmValue, so we can use find_compare_type_valid. Callers changed.
499 2008-11-03 Morten Welinder <terra@gnome.org>
501 * functions.c (gnumeric_lookup): Fix critical. (#559005)
503 2008-10-18 Jody Goldberg <jody@gnome.org>
507 2008-08-29 Jody Goldberg <jody@gnome.org>
511 2008-08-19 J.H.M. Dassen (Ray) <jdassen@debian.org>
513 * functions.c (gnumeric_indirect): Clarified boolean argument.
515 2008-07-01 Morten Welinder <terra@gnome.org>
517 * functions.c (find_bound_walk): When reversing direction, handle
518 singleton right. Fixes #540996.
520 2008-06-25 Jody Goldberg <jody@gnome.org>
524 2008-05-22 Morten Welinder <terra@gnome.org>
526 * functions.c (get_cache): Properly split caches for floats and
529 2008-05-17 Jean Brefort <jean.brefort@normalesup.org>
531 * functions.c: (gnumeric_index): correctly check first argument
534 2008-05-16 Morten Welinder <terra@gnome.org>
536 * functions.c (gnumeric_areas): Check the value type of the
537 calculation function result, not something weird with the call
538 itself. Fixes #533370.
540 2008-05-04 Jody Goldberg <jody@gnome.org>
544 2008-04-08 Morten Welinder <terra@gnome.org>
546 * functions.c (find_index_linear_equal_string): New function for a
547 common special case. Fixes #525875.
548 (go_plugin_init): Install signal to clear caches after recalcs.
549 (go_plugin_shutdown): Remove above signal.
551 2007-12-21 Jody Goldberg <jody@gnome.org>
555 2007-12-29 Jody Goldberg <jody@gnome.org>
557 * functions.c (help_column) : re-order the help text. The current
558 dump routine is too stupid to order things correctly for the
562 2007-12-03 Jody Goldberg <jody@gnome.org>
566 2007-11-20 Jody Goldberg <jody@gnome.org>
568 * functions.c (gnumeric_offset) : no need to translate the far corner
569 if there is no width/height specified. [#497294]
571 2007-11-19 Jody Goldberg <jody@gnome.org>
575 2007-11-04 Morten Welinder <terra@gnome.org>
579 2007-10-21 Morten Welinder <terra@gnome.org>
583 2007-09-04 Jody Goldberg <jody@gnome.org>
587 2007-08-31 Morten Welinder <terra@gnome.org>
589 * functions.c (gnumeric_column): Fix off-by-one.
591 2007-08-30 Jody Goldberg <jody@gnome.org>
593 * functions.c (gnumeric_column) : fix per Harlan Grove's testing that
594 row/column return vectors, not matricies.
595 * functions.c (gnumeric_row) : ditto. Move to the new help style
598 2007-08-27 Jody Goldberg <jody@gnome.org>
600 * functions.c (gnumeric_index) : actually return a
601 reference, some functions require it.
603 2007-07-24 Jody Goldberg <jody@gnome.org>
607 2007-05-03 Morten Welinder <terra@gnome.org>
611 2007-04-21 Morten Welinder <terra@gnome.org>
615 2007-03-04 Morten Welinder <terra@gnome.org>
619 2007-02-16 Morten Welinder <terra@gnome.org>
623 2006-12-17 Jody Goldberg <jody@gnome.org>
627 2006-12-04 Jody Goldberg <jody@gnome.org>
631 2006-11-20 Jody Goldberg <jody@gnome.org>
635 2006-11-19 Morten Welinder <terra@gnome.org>
639 2006-10-17 Jody Goldberg <jody@gnome.org>
643 2006-10-02 Jody Goldberg <jody@gnome.org>
647 2006-05-08 Jody Goldberg <jody@gnome.org>
651 2006-01-20 Jody Goldberg <jody@gnome.org>
653 * functions.c (gnumeric_areas) : handle new GNM_EXPR_OP_ARRAY
656 2006-01-20 Morten Welinder <terra@gnome.org>
658 * functions.c: Fix left-over uses of argument type B.
660 2005-12-08 Jody Goldberg <jody@gnome.org>
662 * functions.c (gnumeric_address) : Use the new gnm_expr_conv_quote.
663 (gnumeric_areas) : better error handling.
665 2005-11-30 Jody Goldberg <jody@gnome.org>
667 * functions.c (gnumeric_address) : rework to handle the special case
668 of relative refs in R1C1 mode actually being relative, where as in
669 A1 mode the col/row are treated as absolute.
671 2005-11-14 Jody Goldberg <jody@gnome.org>
675 2005-10-10 Jody Goldberg <jody@gnome.org>
679 2005-09-08 Jody Goldberg <jody@gnome.org>
683 2005-08-28 Morten Welinder <terra@gnome.org>
687 2005-08-28 Morten Welinder <terra@gnome.org>
691 2005-08-15 Morten Welinder <terra@gnome.org>
695 2005-06-13 Jody Goldberg <jody@gnome.org>
697 * functions.c (gnumeric_column) : rework to handle arrays locally.
698 As far as we know these are the only position dependent situations
700 (gnumeric_row) : ditto.
702 2005-06-13 Jody Goldberg <jody@gnome.org>
706 2005-06-07 Jody Goldberg <jody@gnome.org>
708 * functions.c (gnumeric_indirect) : handle R1C1
710 2005-05-10 Jody Goldberg <jody@gnome.org>
714 2005-02-09 Jody Goldberg <jody@gnome.org>
716 * functions.c (gnumeric_offset) : fix transposition of width and
719 2005-02-08 Jody Goldberg <jody@gnome.org>
723 2005-01-17 Jody Goldberg <jody@gnome.org>
727 2005-01-09 Jody Goldberg <jody@gnome.org>
729 http://bugzilla.gnome.org/show_bug.cgi?id=163040
730 * functions.c (gnumeric_match) : If type is not specified, default to
733 2004-12-09 Jody Goldberg <jody@gnome.org>
737 2004-11-28 Jody Goldberg <jody@gnome.org>
741 2004-11-07 Jody Goldberg <jody@gnome.org>
745 2004-10-31 Jody Goldberg <jody@gnome.org>
749 2004-10-05 Jody Goldberg <jody@gnome.org>
753 2004-09-08 Jody Goldberg <jody@gnome.org>
757 2004-08-29 Jody Goldberg <jody@gnome.org>
761 2004-08-19 Jon K Hellan <hellan@acm.org>
763 * functions.c: Xref INDIRECT->CELL
765 2004-07-19 Jody Goldberg <jody@gnome.org>
769 2004-03-28 Jody Goldberg <jody@gnome.org>
773 2003-12-23 Jody Goldberg <jody@gnome.org>
777 2003-11-26 Jody Goldberg <jody@gnome.org>
781 2003-10-08 Jody Goldberg <jody@gnome.org>
785 2003-10-05 Jody Goldberg <jody@gnome.org>
787 * functions.c : Have lookup/hlookup/vlookup/match use the new 'B' arg
788 type so that they can correctly handle empties.
789 (find_type_valid) : handle empty.
791 2003-09-15 Jody Goldberg <jody@gnome.org>
795 2003-09-10 Jody Goldberg <jody@gnome.org>
799 2003-08-21 Jody Goldberg <jody@gnome.org>
803 2003-06-23 Andreas J. Guelzow <aguelzow@taliesin.ca>
805 * functions.c: spelling fixes
807 2003-06-07 Jody Goldberg <jody@gnome.org>
811 2003-06-07 Jody Goldberg <jody@gnome.org>
815 2003-05-12 Morten Welinder <terra@gnome.org>
817 * functions.c (gnumeric_columnnumber): New function.
819 2003-05-11 Jody Goldberg <jody@gnome.org>
823 2003-01-28 Jody Goldberg <jody@gnome.org>
827 2002-12-31 Jody Goldberg <jody@gnome.org>
831 2002-12-22 Jody Goldberg <jody@gnome.org>
835 2002-12-22 Jody Goldberg <jody@gnome.org>
839 2002-11-15 Jody Goldberg <jody@gnome.org>
843 2002-11-01 Jody Goldberg <jody@gnome.org>
847 2002-10-27 Jody Goldberg <jody@gnome.org>
851 2002-10-16 Morten Welinder <terra@diku.dk>
853 * functions.c (gnumeric_column, gnumeric_row): Plug leaks.
855 2002-10-11 Jody Goldberg <jody@gnome.org>
857 * plugin.xml.in : add areas
858 * functions.c (gnumeric_areas) : new. A quick simple implementation
859 until the core can support more.
861 2002-10-10 Jody Goldberg <jody@gnome.org>
863 * functions.c (gnumeric_indirect) : always return a cell_range and use
864 the convenience routine gnm_expr_get_range. The core is now strong
865 enough to handle the intersection and dependencies properly.
867 2002-09-30 Jody Goldberg <jody@gnome.org>
871 2002-09-27 Jody Goldberg <jody@gnome.org>
873 * functions.c (gnumeric_index) : implement multi-region
875 2002-09-11 Jody Goldberg <jody@gnome.org>
877 * functions.c (gnumeric_address) : use sheet_name_quote and add upper
880 2002-08-30 Morten Welinder <terra@diku.dk>
882 * functions.c (gnumeric_address): Avoid copying string.
884 2002-08-25 Jody Goldberg <jody@gnome.org>
888 2002-08-12 Jody Goldberg <jody@gnome.org>
892 2002-07-22 Zbigniew Chyla <cyba@gnome.pl>
894 * plugin.xml.in: Set loader type to "Gnumeric_Builtin:module".
896 2002-07-28 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
898 * functions.c: Even more function description clean up.
900 2002-07-27 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
902 * functions.c: Function description clean up.
904 2002-07-21 Jody Goldberg <jody@gnome.org>
908 2002-06-22 Jody Goldberg <jody@gnome.org>
910 * functions.c (gnumeric_offset) : no need to special case 1x1 results.
911 but add some clipping for the 2nd
913 2002-05-29 Jody Goldberg <jody@gnome.org>
917 2002-05-21 Morten Welinder <terra@diku.dk>
919 * functions.c (gnumeric_column, gnumeric_row): Fix 82188.
921 2002-05-09 Andreas J. Guelzow <aguelzow@taliesin.ca>
923 * functions.c (find_index_bisection) : use value_area_get_x_y rather
924 than value_area_fetch_x_y
925 http://bugzilla.gnome.org/show_bug.cgi?id=80126
927 2002-05-03 Andreas J. Guelzow <aguelzow@taliesin.ca>
929 * functions.c : mark argument names for translation and adjust
930 them for use by the formula guru.