In an lot of scientific fields, we need to do interpolation of data. That is, if you have a set of x_i and y_i, you want to know the values y'_i at abscissas x'_i. Currently, there is no interpolation function in calc, though. I would greatly appreciate one. The basic functionality would be to have a linear interpolation. Other type of interpolation include staircase and cubic spline. All these interpolations could be done by simply evaluating the function, or also by using an averaging between two consecutive x'_i. Such a function exists in another spreadsheet software called gnumeric, so it is possible to take some inspiration from it (with a critical look, though).
Hi Frederic, Some fuctions available in Statistical Category: Forecast Forecast.linear as closest functions from Interpolation Forecast.Ets.Add Forecast.Ets.Mult Forecast.Ets.Pi.Add Forecast.Ets.Pi.Mult Forecast.Ets.Stat.Add Forecast.Ets.Stat.Mult Forecast.Ets.Saesonality for the same forecast charts as in Excel 2016. Diagrams: Trend lines Extensions : Improved trend lines(CorelPolyGUI) where you can find Spline outline. Interpolation. See also Data > Statistics Jacques
Frederic: what do you think about Jacques's comment?
Sorry for the late answer. What Jacques proposed is NOT linear interpolation. Forecast.linear is based on a linear regression. Forecast.Ets.xx is based on Exponential smoothing.
It would be better to have an extension with all the myriad interpolation models. This thread has a macro solution for cubic spline: https://forum.openoffice.org/en/forum/viewtopic.php?t=4574 Frederic: consider creating such an extension as a university project and submitting it to https://extensions.libreoffice.org/
(In reply to Buovjaga from comment #4) > [...] > Frederic: consider creating such an extension as a university project and > submitting it to https://extensions.libreoffice.org/ I think that developing an extension is the best way: easy prototyping, you can choose the programming language (Basic, Python, Java,...), easy to extend. And when the extension is mature enough it is possible to bundle it with LO if there is a consensus for that. As you read French, have a look on this discussion: https://forum.openoffice.org/fr/forum/viewtopic.php?f=4&t=24156 What do you think ? Set status to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF
It is not clear to me what information I should provide now.
(In reply to Frederic Parrenin from comment #6) > It is not clear to me what information I should provide now. Jean-Baptiste just wanted to know that you are OK, if we close this report and you implement this functionality as an extension.
Maybe it is better to let this bug open if other people want to comment. On my side, I will not have time to implement this extension in the coming months.
Even if the bug report is closed one can add comment, and it is possible to reopen it if someone is interested in developing something. Closing as WontFix. Best regards. JBF