Add missing "Fourier Analysis" function from Data Analysis Toolkit.
this issue was sponsored at https://freedomsponsors.org/issue/626/data-analysis-toolkit-fourier-analysis if anybody solves this in entirety so that it can be merged with libreoffice 4.5 release , then i will pay him an amount mentioned at this sponsoring url
here are some URLs for help how to do in MS Excel http://www.brainmapping.org/NITP/PNA/tests/ProblemSet3_files/FourierExcel.htm http://news.techgenie.com/technology/how-to-do-a-fast-fourier-transform-fft-in-microsoft-excel/ http://blogs.epfl.ch/pvdf/documents/The_Excel_FFT_Function_v1.1.pdf in Gnumeric: it is already in gnumeric, which has fourier() function
I care about getting this fixed, so I'm offering USD 15.00000000 via FreedomSponsors to the first person who fix it. Offer link: https://freedomsponsors.org/issue/626/data-analysis-toolkit-fourier-analysis You can also join me and throw in a few bucks there and we'll get it fixed faster :) If you fix this issue (see my acceptance criteria there) please use that site to request your payment.
Setting Assignee back to default. Please assign it back to yourself if you're still working on this issue
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/32d9f7a632e1df1b6d5ac32a88b2b88c042e91ff%5E%21 tdf#74664 : Adds FOURIER() formula It will be available in 6.3.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 "master": https://git.libreoffice.org/core/+/339c81e44b4d66307a43f8eb11c35220adf24fcb%5E%21 BIFF return class A for Array, tdf#74664 follow-up It will be available in 6.3.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.
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/fd7f542c1342bdcab35c5186b629d57467bf832c%5E%21 tdf#74664 : Compute the phase correctly using atan2 It will be available in 6.3.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.
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/d707a5e64ba53ddb7669cca725915527aa788a6b%5E%21 tdf#74664 : optimize the computation of twiddle factors. It will be available in 6.3.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.
Yet to add the UI (Fourier Analysis toolkit), so no status change.
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/3df43eb0f0a9c3c826eaa330a4099e0024f49f8d%5E%21 tdf#74664 : Unit test for FOURIER formula It will be available in 6.3.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.
(In reply to Dennis Francis from comment #9) > Yet to add the UI (Fourier Analysis toolkit), so no status change. Dennis, it will be work as formula for some cell range or only from different dialog?
(In reply to Roman Kuznetsov from comment #11) > (In reply to Dennis Francis from comment #9) > > Yet to add the UI (Fourier Analysis toolkit), so no status change. > > Dennis, it will be work as formula for some cell range or only from > different dialog? Currently an array formula(FOURIER()) is implemented, that takes data range and other parameters. The syntax is explained in the commit message : https://git.libreoffice.org/core/+/32d9f7a632e1df1b6d5ac32a88b2b88c042e91ff%5E%21 and also at https://dennisfrancis.wordpress.com/2019/02/19/discrete-fourier-transform-in-calc/ Ultimately the aim is to implement a dialog called Fourier Analysis from the menu "Data" > "Statistics" which is what the feature request wants. This dialog will make use of the FOURIER() formula to compute the results.
Added Fourier analysis tool (Data > Statistics > Fourier Analysis) as promised. https://gerrit.libreoffice.org/plugins/gitiles/core/+/1b9f0e99f3ab0deb8ee2291b34c5c2e6a31de2d1
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/88b52d4ecc908a817211a5beb908df378cbf5fae%5E%21 tdf#74664: FOURIER: add 5th optional parameter MinimumMagnitude It will be available in 6.3.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.