Ask Your Question

functions for linear and cubic spline interpolation in Calc?

asked 2016-04-12 12:07:54 +0100

Miguel Holman gravatar image

How can I make linear and cubic spline interpolations by using formulas? Libreoffice can draw interpolated lines using both of these interpolations if I make a graph, but how can I make the interpolation directly into a table?

So far I haven't been able to locate any plugins of funtions that can solve this.

Example, linear: x1=10, x2=20, y1=30, y2=50

CALCULATE: y for x=15

Example, spline: x1=10, x2=20, x3=30, y1=100, y2=400, y3=900

CALCULATE: y for x=13

There is a plugin for Microsoft Excel that does the trick here, but thats no good for Libreoffice.

Linear interpolation is used all over, and cubic spline is state of the art interpolation used in stuff as engineering an rocket science :)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-11-15 21:48:45 +0100

Hi, it is an old question, nevertheless, Why don't you try this one. also found here? Let me know how it was

kind regards

edit flag offensive delete link more

answered 2016-04-12 15:05:54 +0100

oweng gravatar image

There is no built-in function equivalent for LO. The AOO forum thread here offers an example of a spline using a macro, which is likely the method that needs to be considered.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-12 12:07:54 +0100

Seen: 3,735 times

Last updated: Nov 15 '18