Bug 129057 - Mismatch between Calc's Function Wizard and Help files for Duration function
Summary: Mismatch between Calc's Function Wizard and Help files for Duration function
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
6.2.7.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:6.5.0 target:6.4.0.1
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-27 12:22 UTC by Steve Fanning (Retired)
Modified: 2020-01-23 11:38 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 Steve Fanning (Retired) 2019-11-27 12:22:52 UTC 
Description:
In Calc's Function Wizard, the user is requested to enter the following parameters: Settlement, Maturity, Coupon, Yield, Frequency and Basis.

In the Help files, the following different set of parameters is described for the function: Rate, PV and FV.

Also pressing the Help button with the Duration function displayed on the Function Wizard invokes the wrong Help page. The information for DURATION_ADD is displayed.

Steps to Reproduce:
1.Open Function Wizard, select Financial category and select Duration function.
2.Inspect list of parameters in Function Wizard.
3.Press Help button on Function Wizard.
4.Note that Help button links to DURATION_ADD function rather than DURATION function.
5.At top of Help file, search for "Duration function" and select Duration function link.
5.Inspect list of parameters in Help page.

Actual Results:
Different parameters listed in Help and Function Wizard.
Help button targets wrong Help.

Expected Results:
Same parameters listed in Help and Function Wizard.
Help button targets correct Help.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Roman Kuznetsov 2019-11-27 14:17:25 UTC 
Olivier, I think it's your theme
Comment 2 Olivier Hallot 2019-11-27 18:29:16 UTC 
in Help 6.3

The DURATION function maps to DURATION_ADD, and the help pages opens correctly with a info box explaining the _ADD suffix.

The MDURATION function maps to MDURATION and right Help page

The PDURATION function is actually the (old) DURATION function, which has been renamed in the past.

The fix is to rename DURATION to PDURATION, DURATION_ADD to DURATION in the Help.
Comment 3 Commit Notification 2019-11-27 19:08:08 UTC 
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/2e263815cad73dd9b350cb4f679bc69c551e89ab

tdf#129057 Correct DURATION and PDURATION Help
Comment 4 Commit Notification 2019-11-27 19:08:23 UTC 
Olivier Hallot committed a patch related to this issue.
It has been pushed to "libreoffice-6-4":

https://git.libreoffice.org/help/commit/07a573b651b1378ba70f8a06b2bbfdc163a96da5

tdf#129057 Correct DURATION and PDURATION Help
Comment 5 Xisco Faulí 2020-01-20 14:27:53 UTC 
A polite ping to Olivier Hallot:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ?
Otherwise, Could you please explain what's missing?
Thanks