Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi :)
Sorry for the lack of replies so far!!  The best documentation is on our wiki at
as well as being available for purchase from various online stores and
even as properly published guides.
Regards from
Tom :)

On 26 January 2014 19:02, Dominique Michel <> wrote:

This is my first message to that list, and I am a newbie with calc.

What I want to do is to extrapolate a sheet from an existing sheet, and
later do some calculation on the new sheet. The existing sheet is a
simple x/y graph with x on the A1, some values in A2 to An, and the
other rows, the value of x in the first cell, and the value of y for
the value corresponding to A2 to An in the following cells. This
give a chart with one x/y curve for each cell between A2 to An. This
work fine. The sheet look like:

x    -20     -10     0      10       20
0      0       0     0       0        0
1                                    0.1
2                           0.2
3                  0.23
4            0.34                    0.15
5      0.4                  0.3

The new sheet will represent the values of x at A2 to An, that for
different values of y. In other words, the first sheet is y=f(x) for
different and constant n, the new sheet will be x=f(n) for different
and constant y.

n     0.1     0.2     0.3     0.4     0.5
20      1
10              2
0                       5

First I must have a way to search for the nearest 2 values of y in the
table, and from them do a calculation to extrapolate the value of x for
y. It must also know the value of n.

It is 2 cases, if the value of y = y_new sheet, no calculation is
needed, is the value of y != y_new sheet, I must make a simple
calculation to determine the value of x from the 2 nearest values of y.
(I have enough points, so I can assume it is a straight line between
the 2 values).

What I cannot figure out, is how to go trough the existing sheet with a
formula that will find the 2 nearest values of y and apply a function
on these values, or output directly the value if an exact match is
found. And from that build a new sheet.

Another issue is the original data comes from a csv file, that is
synchronized to the original sheet. The csv file is generated by
engauge, and between 2 runs, the numbers of rows and columns in that
file will change. That imply the new sheet must also be able to be
synchronized with the old one, and that even if the numbers of rows and
columns are changing. Is it possible to do that?

Can you explain me how to do this, or provide me a link to some
documentation describing a similar issue?


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.