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:
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.
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
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.
Pending review https://gerrit.libreoffice.org/c/core/+/141744 for 7-4
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.
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.