1 2015-02-04 Morten Welinder <terra@gnome.org>
5 2015-01-23 Morten Welinder <terra@gnome.org>
9 2014-09-25 Morten Welinder <terra@gnome.org>
13 2014-06-09 Morten Welinder <terra@gnome.org>
17 2014-05-23 Morten Welinder <terra@gnome.org>
21 2014-04-30 Morten Welinder <terra@gnome.org>
25 2014-04-13 Morten Welinder <terra@gnome.org>
29 2014-03-18 Morten Welinder <terra@gnome.org>
33 2014-03-03 Morten Welinder <terra@gnome.org>
37 2014-02-16 Morten Welinder <terra@gnome.org>
41 2014-02-11 Morten Welinder <terra@gnome.org>
45 2013-11-28 Morten Welinder <terra@gnome.org>
49 2013-10-07 Morten Welinder <terra@gnome.org>
53 2013-09-01 Morten Welinder <terra@gnome.org>
57 2013-08-27 Morten Welinder <terra@gnome.org>
61 2013-08-19 Morten Welinder <terra@gnome.org>
65 2013-07-10 Morten Welinder <terra@gnome.org>
69 2013-06-25 Morten Welinder <terra@gnome.org>
73 2013-04-26 Morten Welinder <terra@gnome.org>
77 2013-03-09 Morten Welinder <terra@gnome.org>
81 2012-12-18 Morten Welinder <terra@gnome.org>
85 2012-11-29 Morten Welinder <terra@gnome.org>
89 2012-11-16 Morten Welinder <terra@gnome.org>
93 2012-09-06 Morten Welinder <terra@gnome.org>
97 2012-07-15 Morten Welinder <terra@gnome.org>
101 2012-06-25 Morten Welinder <terra@gnome.org>
105 2012-06-21 Andreas J. Guelzow <aguelzow@pyrshep.ca>
107 * functions.c (help_duration): clarify and add examples
108 (help_mduration): correct description and add examples
109 (help_g_duration): add example
111 2012-04-21 Morten Welinder <terra@gnome.org>
115 2012-03-02 Morten Welinder <terra@gnome.org>
119 2011-11-27 Morten Welinder <terra@gnome.org>
123 2011-11-24 Morten Welinder <terra@gnome.org>
127 2011-07-31 Morten Welinder <terra@gnome.org>
131 2011-05-21 Morten Welinder <terra@gnome.org>
135 2011-03-24 Morten Welinder <terra@gnome.org>
139 2011-02-02 Morten Welinder <terra@gnome.org>
143 2011-01-08 Andreas J. Guelzow <aguelzow@pyrshep.ca>
145 * functions.c (help_mduration): Typo. #639142
147 2011-01-08 Andreas J. Guelzow <aguelzow@pyrshep.ca>
149 * functions.c (help_dollarfr): Typo. #638992
151 2011-01-07 Morten Welinder <terra@gnome.org>
153 * functions.c (help_accrintm): Typo. #631504.
155 2010-12-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
157 * functions.c (help_euro): add EEK (Estonia)
159 (euro_local_rounding): add EEK
161 2010-11-25 Morten Welinder <terra@gnome.org>
165 2010-10-03 Andreas J. Guelzow <aguelzow@pyrshep.ca>
167 * functions.c (help_amordegrc): add more information
169 2010-10-01 Morten Welinder <terra@gnome.org>
173 2010-09-04 Morten Welinder <terra@gnome.org>
177 2010-08-16 Morten Welinder <terra@gnome.org>
181 2010-07-30 Morten Welinder <terra@gnome.org>
185 2010-07-28 Andreas J. Guelzow <aguelzow@pyrshep.ca>
187 * functions.c (help_cumipmt): fix argument description
188 (help_cumprinc): fix argument description
190 2010-07-23 Andreas J. Guelzow <aguelzow@pyrshep.ca>
192 * functions.c (help_vdb): fix description
194 2010-06-28 Morten Welinder <terra@gnome.org>
198 2010-06-16 Morten Welinder <terra@gnome.org>
202 2010-06-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
204 * functions.c: remove inconsistent periods, etc.
206 2010-06-11 Morten Welinder <terra@gnome.org>
208 * functions.c (gnumeric_fvschedule): Ignore blanks. (This is the
209 same as treating as zero.)
211 2010-06-09 Andreas J. Guelzow <aguelzow@pyrshep.ca>
213 * functions.c (gnumeric_accrint): add @{calc_method} and
216 2010-05-30 Morten Welinder <terra@gnome.org>
220 2010-05-20 Morten Welinder <terra@gnome.org>
224 2010-05-07 Morten Welinder <terra@gnome.org>
228 2010-05-05 Andreas J. Guelzow <aguelzow@pyrshep.ca>
230 * functions.c (gnumeric_accrint): make @{par} optional
231 (help_accrint): update
232 (financial_functions): update
234 2010-04-16 Morten Welinder <terra@gnome.org>
238 2010-03-08 Morten Welinder <terra@gnome.org>
242 2010-02-13 Morten Welinder <terra@gnome.org>
246 2010-01-19 Morten Welinder <terra@gnome.org>
250 2010-01-04 Andreas J. Guelzow <aguelzow@pyrshep.ca>
252 * functions.c (help_npv): there does not seem to be
255 2010-01-02 Andreas J. Guelzow <aguelzow@pyrshep.ca>
257 * functions.c (help_euroconvert): fix spelling
259 2009-12-15 Morten Welinder <terra@gnome.org>
263 2009-12-03 Andreas J. Guelzow <aguelzow@pyrshep.ca>
265 * functions.c (one_euro): change LUX to LUF
266 (euro_local_rounding): new
267 (help_euroconvert): add 2 optional arguments
268 (gnumeric_euroconvert): handle optional arguments
269 (financial_functions): add 2 optional arguments to
272 2009-12-03 Andreas J. Guelzow <aguelzow@pyrshep.ca>
274 * functions.c (help_euro): add currencies added to
275 the euro in 2007 to 2009
278 2009-11-29 Morten Welinder <terra@gnome.org>
282 2009-11-01 Morten Welinder <terra@gnome.org>
286 2009-10-11 Morten Welinder <terra@gnome.org>
290 2009-09-20 Morten Welinder <terra@gnome.org>
294 2009-09-05 Morten Welinder <terra@gnome.org>
298 2009-08-30 Morten Welinder <terra@gnome.org>
302 2009-08-25 Andreas J. Guelzow <aguelzow@pyrshep.ca>
304 * plugin.xml.in: add rri
305 * functions.c (help_rri): new
307 (financial_functions): add RRI
309 2009-08-24 Andreas J. Guelzow <aguelzow@pyrshep.ca>
311 * functions.c (help_g_duration): add ODF note
313 2009-08-15 Morten Welinder <terra@gnome.org>
317 2009-08-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
319 * functions.c: remove argument names from GnmFuncDescriptor
321 2009-08-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
323 * functions.c: skip "calculate(s)" and "return(s)" in NAME records
325 2009-08-14 Andreas J. Guelzow <aguelzow@pyrshep.ca>
327 * functions.c (help_ddb): fix name record
330 2009-08-14 Morten Welinder <terra@gnome.org>
332 * functions.c: Convert to new doc format.
334 2009-06-20 Morten Welinder <terra@gnome.org>
338 2009-06-09 Morten Welinder <terra@gnome.org>
340 * functions.c (gnumeric_nper): Negative rates make sense down to,
341 but not including -100%. Fixes bug reported at
342 http://www.oasis-open.org/committees/download.php/32469/OpenDocument-formula-20090508.odt
343 on page 184. Hint: there are better places to report problems.
345 2009-05-23 Morten Welinder <terra@gnome.org>
349 2009-05-06 Morten Welinder <terra@gnome.org>
353 2009-04-25 Morten Welinder <terra@gnome.org>
357 2009-03-28 Morten Welinder <terra@gnome.org>
359 * functions.c (gnm_range_xirr): Try -1 too.
361 2009-03-22 Morten Welinder <terra@gnome.org>
365 2009-02-22 Morten Welinder <terra@gnome.org>
369 2008-10-18 Jody Goldberg <jody@gnome.org>
373 2008-10-07 Morten Welinder <terra@gnome.org>
375 * functions.c (gnumeric_xirr): Booleans should cause an error.
377 2008-10-03 Morten Welinder <terra@gnome.org>
379 * functions.c (gnumeric_xirr): Use float_range_function2d to
380 handle pairing. Fixes #554732.
382 2008-08-29 Jody Goldberg <jody@gnome.org>
386 2008-07-02 Morten Welinder <terra@gnome.org>
388 * functions.c (gnumeric_ddb): Use a sane formula for this. Fix
389 piles of corner cases. Fixes #541158.
391 2008-06-29 Morten Welinder <terra@gnome.org>
393 * functions.c: Fix problems with invalid dates. [#540690]
395 2008-06-25 Jody Goldberg <jody@gnome.org>
399 2008-05-04 Jody Goldberg <jody@gnome.org>
403 2008-01-10 Morten Welinder <terra@gnome.org>
405 * functions.c: Add proper argument description to NPV. [#506160]
407 2007-12-21 Jody Goldberg <jody@gnome.org>
411 2007-12-03 Jody Goldberg <jody@gnome.org>
415 2007-11-19 Jody Goldberg <jody@gnome.org>
419 2007-11-04 Morten Welinder <terra@gnome.org>
423 2007-10-21 Morten Welinder <terra@gnome.org>
427 2007-09-04 Jody Goldberg <jody@gnome.org>
431 2007-07-24 Jody Goldberg <jody@gnome.org>
435 2007-05-03 Morten Welinder <terra@gnome.org>
439 2007-04-21 Morten Welinder <terra@gnome.org>
443 2007-03-04 Morten Welinder <terra@gnome.org>
447 2007-02-16 Morten Welinder <terra@gnome.org>
451 2006-12-17 Jody Goldberg <jody@gnome.org>
455 2006-12-04 Jody Goldberg <jody@gnome.org>
459 2006-11-20 Jody Goldberg <jody@gnome.org>
463 2006-11-20 Morten Welinder <terra@gnome.org>
465 * functions.c (gnumeric_rate): Fix typo.
467 2006-11-19 Morten Welinder <terra@gnome.org>
471 2006-10-24 Jody Goldberg <jody@gnome.org>
473 * functions.c (gnumeric_accrint) : if par is ommited use 1000 (XL
474 compatibility). Still more work needed.
475 (value_get_paytype) : Be more accomodating with values. Anything
478 2006-10-24 Morten Welinder <terra@gnome.org>
480 * functions.c (calculate_ipmt): New function replacing and fixing
481 calculate_interest_part.
482 (gnumeric_ipmt, gnumeric_ppmt): Use calculate_ipmt.
484 2006-10-17 Jody Goldberg <jody@gnome.org>
488 2006-10-02 Jody Goldberg <jody@gnome.org>
492 2006-05-08 Jody Goldberg <jody@gnome.org>
496 2006-03-17 Morten Welinder <terra@gnome.org>
498 * functions.c (gnumeric_effect, gnumeric_nominal): Improve for
500 (gnumeric_dollarde, gnumeric_dollarfr): Fix for negative amounts.
501 Improve Excel compatibility.
503 2006-03-06 Morten Welinder <terra@gnome.org>
505 * functions.c (gnumeric_xnpv): Fix handling of bools and strings.
506 (gnumeric_xirr): Fix handling of strings. [#333620]
507 (gnumeric_xirr): Handle failing Newton search. [#333631]
509 2006-01-27 Morten Welinder <terra@gnome.org>
511 * functions.c (value_get_basis): New function to properly handle
512 basis fields. All basis-taking functions changed.
513 (value_get_freq): New function to properly handle frequency
514 fields. All frequency-taking functions changed.
515 (value_get_paytype): New function to properly handle front-or-back
518 2006-01-09 Morten Welinder <terra@gnome.org>
520 * functions.c (func_coup): Simplify using
521 value_get_as_checked_bool.
523 2005-11-14 Jody Goldberg <jody@gnome.org>
527 2005-11-07 Morten Welinder <terra@gnome.org>
529 * functions.c (price): Special-case n==1 as per HP's calculator
530 manuals. Seems to agree with Excel's undocumented behaviour.
531 (Discovered by Philippe Lelong.) Avoid potentially expensive
534 2005-10-10 Jody Goldberg <jody@gnome.org>
538 2005-09-08 Jody Goldberg <jody@gnome.org>
542 2005-08-28 Morten Welinder <terra@gnome.org>
546 2005-08-28 Morten Welinder <terra@gnome.org>
550 2005-08-15 Morten Welinder <terra@gnome.org>
554 2005-06-28 Morten Welinder <terra@gnome.org>
556 * functions.c (gnumeric_npv): Use a range function.
558 2005-06-27 Morten Welinder <terra@gnome.org>
560 * functions.c (gnumeric_irr): If all else fails, try to Newton
561 seek from left edge of interval.
562 (irr_npv, irr_npv_df): Don't be smart. Fixes Debian #315625.
564 2005-06-13 Jody Goldberg <jody@gnome.org>
568 2005-05-10 Jody Goldberg <jody@gnome.org>
572 2005-02-08 Jody Goldberg <jody@gnome.org>
576 2005-01-17 Jody Goldberg <jody@gnome.org>
580 2004-12-09 Jody Goldberg <jody@gnome.org>
584 2004-11-28 Jody Goldberg <jody@gnome.org>
588 2004-11-07 Jody Goldberg <jody@gnome.org>
592 2004-10-31 Jody Goldberg <jody@gnome.org>
596 2004-10-05 Jody Goldberg <jody@gnome.org>
600 2004-09-08 Jody Goldberg <jody@gnome.org>
604 2004-08-29 Jody Goldberg <jody@gnome.org>
608 2004-08-25 Jody Goldberg <jody@gnome.org>
610 * functions.c (gnumeric_accrint) : fix error checking
612 2004-07-19 Jody Goldberg <jody@gnome.org>
616 2004-04-12 Morten Welinder <terra@gnome.org>
618 * functions.c (calculate_fvifa, calculate_pvif,
619 calculate_interest_part, price, gnumeric_effect, gnumeric_nominal,
620 gnumeric_mirr, irr_npv, irr_npv_df, callback_function_npv,
621 gnumeric_xnpv, xirr_npv): Improve precision for small rates using
622 new pow1p and pow1pm1.
623 (gnumeric_nper, gnumeric_g_duration): Use log1pgnum.
625 2004-03-28 Jody Goldberg <jody@gnome.org>
629 2004-01-23 Andreas J. Guelzow <aguelzow@taliesin.ca>
631 * functions.c: fix argument names for RATE.
633 2004-01-08 Jody Goldberg <jody@gnome.org>
635 * functions.c (gnumeric_euroconvert) : slight cleanup. Nothing major.
637 2003-12-23 Jody Goldberg <jody@gnome.org>
641 2003-11-26 Jody Goldberg <jody@gnome.org>
645 2003-10-08 Jody Goldberg <jody@gnome.org>
649 2003-09-15 Jody Goldberg <jody@gnome.org>
653 2003-09-10 Jody Goldberg <jody@gnome.org>
657 2003-08-21 Jody Goldberg <jody@gnome.org>
661 2003-07-28 Jody Goldberg <jody@gnome.org>
663 * functions.c : fix docs for mduration to use 'if basis is invald' to
664 make life easier for translators when more day counts land.
666 2003-07-16 Jody Goldberg <jody@gnome.org>
668 * functions.c : document amorlinc & amordegrc
669 fix arguments for duration.
671 2003-07-14 Jody Goldberg <jody@gnome.org>
674 s/begining/beginning/
676 2003-07-14 Jody Goldberg <jody@gnome.org>
678 * plugin.xml.in : add missing decl for g_duration
680 2003-07-05 Jody Goldberg <jody@gnome.org>
682 * functions.c : s/sequrity/security/
683 s/depriciation/depreciation/
684 Remove the duplication of the arg decriptors for SLN
686 2003-07-01 Jody Goldberg <jody@gnome.org>
688 * sc-fin.c : ditch sc's daycount routines
690 2003-07-01 Morten Welinder <terra@gnome.org>
692 * functions.c (gnumeric_oddlprice, gnumeric_oddlyield): Dump OO's
693 implementation and roll our own. (Our date stuff is better.)
694 (gnumeric_yielddisc): Dump OO's and use yearfrac.
696 2003-06-29 Morten Welinder <terra@gnome.org>
698 * functions.c (func_coup): Use is_valid_basis and is_valid_freq.
699 (gnumeric_duration, gnumeric_mduration): Ditto, thus fixing for
702 2003-06-28 Jody Goldberg <jody@gnome.org>
704 * functions.c : update the status for oddfyield
706 2003-06-27 Morten Welinder <terra@gnome.org>
708 * functions.c (calc_oddfprice): New function, extracted from
709 gnumeric_oddfprice and fixed.
710 (gnumeric_oddfprice): Use calc_oddfprice.
711 (gnumeric_oddfyield): Implement.
713 * sc-fin.c (get_yielddisc): Beat some sense into this.
715 2003-06-23 Andreas J. Guelzow <aguelzow@taliesin.ca>
717 * functions.c: spelling fixes
718 * plugin.xml.in: use `Finance'
720 2003-06-12 Jody Goldberg <jody@gnome.org>
722 * functions.c : docs fixes as per
723 http://bugzilla.gnome.org/show_bug.cgi?id=115028
725 2003-06-07 Jody Goldberg <jody@gnome.org>
729 2003-06-07 Jody Goldberg <jody@gnome.org>
733 2003-05-11 Jody Goldberg <jody@gnome.org>
737 2003-01-28 Jody Goldberg <jody@gnome.org>
741 2002-12-31 Jody Goldberg <jody@gnome.org>
745 2002-12-22 Jody Goldberg <jody@gnome.org>
749 2002-12-22 Jody Goldberg <jody@gnome.org>
753 2002-12-03 Morten Welinder <terra@diku.dk>
755 * functions.c (gnumeric_nper): Last two args are optional.
757 2002-12-02 Morten Welinder <terra@diku.dk>
759 * functions.c (gnumeric_ispmt): Handle non-integer period numbers.
761 (gnumeric_ipmt): Ditto.
762 (gnumeric_nper): Handle rate=0 special case.
764 2002-12-01 Morten Welinder <terra@diku.dk>
766 * functions.c (gnumeric_ipmt): Base on calculate_interest_part.
767 (gnumeric_ppmt): Ditto.
768 (calculate_principal): Replaced by...
769 (calculate_interest_part): ...this new function which does not
770 have a rate=0 singularity.
772 2002-11-24 Morten Welinder <terra@diku.dk>
774 * functions.c (calculate_fvifa): Handle rate==0 here.
775 (gnumeric_pv): Remove special case.
777 2002-11-15 Jody Goldberg <jody@gnome.org>
781 2002-11-04 Morten Welinder <terra@diku.dk>
783 * functions.c: Adapt to new autoformat specs.
785 2002-11-01 Jody Goldberg <jody@gnome.org>
789 2002-10-27 Jody Goldberg <jody@gnome.org>
793 2002-10-15 Jody Goldberg <jody@gnome.org>
795 * functions.c : convert all of the dates to 'f' rather than '?'
796 because implicit conversions are handle in the marshaller.
799 2002-10-14 Morten Welinder <terra@diku.dk>
801 * functions.c (gnumeric_dollarde): Use floorgnum, not floor.
802 (gnumeric_dollarfr): Ditto.
804 2002-09-30 Jody Goldberg <jody@gnome.org>
808 2002-08-25 Jody Goldberg <jody@gnome.org>
812 2002-08-16 Jon K Hellan <hellan@acm.org>
814 * functions.c (coupnum): Make static.
816 2002-08-12 Jody Goldberg <jody@gnome.org>
820 2002-08-10 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
822 * functions.c: Implemented EUROCONVERT(). Rounding is not yet
825 2002-08-10 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
827 * sc-fin.c (get_vdb): Fixed, hopefully.
829 2002-08-07 Morten Welinder <terra@diku.dk>
831 * sc-fin.c (ScInterVDB): Remove a few unused variables.
833 2002-07-22 Zbigniew Chyla <cyba@gnome.pl>
835 * plugin.xml.in: Set loader type to "Gnumeric_Builtin:module".
837 2002-07-27 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
839 * functions.c: Much more function description clean up.
841 2002-07-26 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
843 * functions.c: Some function description clean up.
845 2002-07-22 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
847 * sc-fin.c (ScGetGDA, ScInterVDB, get_vdb): Imported from the OO
848 with some clean up. The original code is quite a nightmare,
849 however, still a few identifiers are in German (Sprechen Sie
852 * functions.c (gnumeric_vdb): Implemented.
854 2002-07-21 Jody Goldberg <jody@gnome.org>
858 2002-07-16 Morten Welinder <terra@diku.dk>
860 * functions.c (gnumeric_dollarde): Use gpow10.
861 (gnumeric_dollarfr): Ditto.
863 2002-07-16 Morten Welinder <terra@diku.dk>
865 * functions.c (gnumeric_yield): Use existing root finding
868 2002-07-16 Morten Welinder <terra@diku.dk>
870 * sc-fin.c: Use powgnum, not pow.
872 2002-07-13 Jody Goldberg <jody@gnome.org>
874 * functions.c (gnumeric_price) : silence some warnings.
876 2002-07-07 Jody Goldberg <jody@gnome.org>
878 * sc-fin.c (GetDiffParam) : avoid compiler warnings.
879 * functions.c (gnumeric_amordegrc) : ditto.
881 2002-07-07 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
883 * functions.c (gnumeric_yield): Fixed.
885 2002-07-07 Jon K Hellan <hellan@acm.org>
887 * functions.c (annual_year_basis, days_monthly_basis, coupnum):
888 Replaced deprecated g_date_xxx with g_data_get_xxx.
890 2002-07-07 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
892 * functions (gnumeric_cumprinc, gnumeric_cumipmt, gnumeric_mduration):
895 * sc-fin.c (GetRmz,GetZw,Duration,get_cumprinc,get_cumipmt,
896 get_mduration): Added.
898 2002-07-07 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
900 * functions.c (gnumeric_duration): Renamed DURATION() as
901 G_DURATION(). Wrote a new DURATION() that is XL compatible.
903 * sc-fin.c (get_duration): Added.
905 2002-07-06 Jukka Pekka <jiivonen@hutcs.cs.hut.fi>
907 * functions.c (gnumeric_amordegrc, gnumeric_amorlinc,
908 gnumeric_oddlprice, gnumeric_oddlyield, gnumeric_yieldmat,
909 gnumeric_yielddisc): Implemented. Thanks for OO, read the comment
912 * sc-fin.[ch], Makefile.am: Added new file.
914 2002-06-14 Jody Goldberg <jody@gnome.org>
916 * functions.c (gnumeric_euro) : add drachma.
918 2002-05-29 Jody Goldberg <jody@gnome.org>
922 2002-05-03 Morten Welinder <terra@diku.dk>
924 * functions.c (gnumeric_xirr): Put sane limits on the goal search.