Bug 102365 - Help text for function AMORDEGRC and AMORLINC - basis 2
Summary: Help text for function AMORDEGRC and AMORLINC - basis 2
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium minor
Assignee: Rafael Lima
URL:
Whiteboard: target:7.2.0
Keywords:
Depends on: 100496
Blocks:
  Show dependency tree / graph
 
Reported: 2016-09-22 16:52 UTC by raal
Modified: 2021-04-26 22:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2016-09-22 16:52:39 UTC 
User-Agent:       Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:48.0) Gecko/20100101 Firefox/48.0
Build Identifier: 

Follow-up of the bug 100496 : After the bug will be closed, we should mention that function is incompatible with Excel for basis 2. See comment 4 of the bug 100496.

Reproducible: Always







Reset User Profile?No
Comment 1 Rafael Lima 2021-03-24 19:35:17 UTC 
Just as an update to this bug report, I tested using Basis 2 in LO 7.1.1.2 and it worked (did not return an error).

=AMORDEGRC(10000;DATE(2012;3;1);DATE(2012;12;31);1500;1;0,3;2)

Please, confirm if this bug is still valid, otherwise we can close it.
Comment 2 Rafael Lima 2021-03-24 19:39:39 UTC 
Actually, I misunderstood when I first read it. Actually Basis 2 works on LO, but when exported to MS Excel it doesn't work.

I'll add a note to the Help page to highlight this issue.
Comment 3 Commit Notification 2021-03-24 22:46:15 UTC 
Rafael Lima committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/91287a050719f9c151327cc629cd4630cf61e804

tdf#102365 Add note to AMORDEGRC and AMORLINC about MS incompatibility with Basis 2