Bug 140554 - FIXED Function Wizard needs an update
Summary: FIXED Function Wizard needs an update
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Eike Rathke
URL:
Whiteboard: target:7.5.0 target:7.4.3
Keywords:
Depends on:
Blocks: Function-Wizard
  Show dependency treegraph
 
Reported: 2021-02-20 12:35 UTC by Jürgen Kirsten
Modified: 2022-10-24 20:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jürgen Kirsten 2021-02-20 12:35:36 UTC
Description:
The function wizard of the FIXED function should be revised.

1.) The description should be adapted to the one in the help. The hint that the result is a text is missing. The following text should be used:
Returns a number as text with a specified number of decimal places and optional thousands separators. 

2.) The option "Decimals" is optional and should therefore not be displayed in bold. The note (required) should be replaced with the note.
Optional – default = 2

3.) In the description of the option, the possibility of rounding to the left of the decimal point with negative values should also be described. So like this:
Decimal places. The number of fixed decimal places that are to be displayed. Negative values round the number to the left.

See also my bug in the documentation part:
https://bugs.documentfoundation.org/show_bug.cgi?id=140553


Actual Results:
 

Expected Results:
 


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Xisco Faulí 2022-05-03 12:09:58 UTC
Dear  Roman Kuznetsov,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assign it back to yourself if you're still working on this.
Comment 2 Jürgen Kirsten 2022-10-22 11:26:49 UTC
The update of the function wizard has not yet been completed in the latest LO version.

Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-GB (de_DE); UI: en-GB
Calc: threaded
Comment 3 Commit Notification 2022-10-24 16:14:09 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/633db8a099e3041bc10fb1709311bd6055ab61a2

Resolves: tdf#140554 Function Wizard, FIXED() second parameter is optional

It will be available in 7.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 4 Eike Rathke 2022-10-24 16:14:58 UTC
Pending review https://gerrit.libreoffice.org/c/core/+/141744 for 7-4
Comment 5 Commit Notification 2022-10-24 18:28:49 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/6d4e290bfd38664eebb1a394563e89a845a85078

Related: tdf#140554 Function Wizard, FIXED() second parameter default is 2

It will be available in 7.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Commit Notification 2022-10-24 20:15:48 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-7-4":

https://git.libreoffice.org/core/commit/9d0f9c199b8875d2d185c1848d4d5cfaff7cf260

Resolves: tdf#140554 Function Wizard, FIXED() second parameter is optional

It will be available in 7.4.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.