Fourier transform - transform data to DFT and reconstruct it with IDFT in Libre Calc

I want to transform data to DFT and reconstruct it with IDFT
So basically I’m trying to do something like in this Excel tutorial:

There’s a =fourier() function in Calc, but It’s kinda different from what’s on Excel. Can anyone explain how to use it?
I also want to extend the IDFT’ed function outside data spectrum

Given that it appeared as resolution of tdf#74664, which explicitly asked for "Fourier Analysis" function from Data Analysis Toolkit, it’s unexpected and should be a bug - but you never explained what specifically is “kinda different”.

Some documentation is, as expected, in the help: FOURIER function, Fourier Analysis.

Inputs seems kinda different. Excel has these “Component” index input and “N” number of observations. Calc has everything merged into one function and it is missing some components I mentioned. I just don’t know what should I input into =fourier() function to make the results similar to one in tutorial
Example file with finished calculations would be helpful

The video that you linked to in your question has this pinned at the top of the comments:

The DFT and IDFT are part of NumXL. NumXL is an Excel Add-in for time series analysis. Once NumXL is installed on your system, it will add scores of functions (e.g. DFT) to Excel. To download a 30-day free trial, visit our main website.

So the DFT/IDFT functions are not part of Excel, and even not part of its “Analysis ToolPack” that is a separate download for Excel from MS; but some third party tool.

Hope someone helps you getting some sort of formula to get the needed results; but actually, “I want results like in a tutorial for a closed-source third-party add-on” is a bad question; more appropriate would be “I need this math formula be implemented as Calc formula”.