https://bugs.documentfoundation.org/show_bug.cgi?id=100496
Winfried Donkers <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Summary|function AMORDEGRC - basis |function AMORDEGRC and
|2 result Err:502 |AMORLINC - basis 2 result
| |Err:502
--- Comment #3 from Winfried Donkers <[email protected]> ---
AMORLINC and AMORDEGR are Add-in functions from the Excel Analysis pack and as
such primarily complies with Excel.
Therefore these functions return an error with basis 2. There is no
technical/numerical need in the functions to reject basis 2; the functions work
fine with this constraint removed.
There are several 'solutions':
1-leave all as is, i.e. accept that the functions do not fully comply with
ODFF1.2 - but do change the help text;
2- make the functions compliant with ODFF1.2 and accept breaking the
inter-operability with Excel - and add a note to the help text;
3- rename the functions to AMORLINC_ADD and AMORDEGR_ADD and add new
ODFF1.2-compliant functions AMORLINC and AMORDEGR.
1 and 2 are not full solutions, so I tend to opt for 3.
@Eike: Given your expertise of both Calc and ODFF, what do you advise?
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
