Description: FOURIER function returns the same results as the input data if the size of input is 1x2. It is appropriate for the case Polar=FALSE. But the result should be changed into polar form if the fourth argument Polar is TRUE. Steps to Reproduce: 1.Open s spreadsheet. 2.Input 0 to A1, 1 to B1, and select A2. 3.Open function wizard and choose FOURIER function. 4.Input A1:B1, 1, 0, 1, 0 to the argument forms, press OK. Actual Results: 0, 1 are displayed at A2, B2. Expected Results: 1, 1.5707963267949 should displayed at A2, B2. They are the absolute value and the argument of the result 0+i. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: StartModule [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no
Dennis: one for you since it concerns Fourier part?
Confirmed. Thanks for the bug report !
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/e324a6cea23fe19ec8a67f368c31e1567928a5af%5E%21 tdf#126012: Take care of polar and min-magnitude flags... It will be available in 6.4.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.
Fixed in master. Pending approval for 6.3 @ https://gerrit.libreoffice.org/#/c/74441/
Dennis Francis committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/08c39a9d96dafcb6f04b0b73e82603dfb49acc21%5E%21 tdf#126012: Take care of polar and min-magnitude flags... It will be available in 6.3.0.1. 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.