We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

lovecraft22's profile - activity

2021-04-21 11:07:26 +0200 marked best answer Calc - Find delta between a serie of points and a point

Dear all, imagine you have a serie of points with a certain (fixed) coordinate between them. I then have an additional point which might end up sitting between 2 coordinates of the above mentioned serie. What is the best way to find the delta between the serie and the point?

Here's an example:

Serie:
x y
0 2
1 4
2 5
3 7
4 9

Point:
x y
2.5 8

In this case the result should be the delta between 8 and the interpolated value of 2.5 from the serie between 2 and 3 hence: 8-6 = 2

Of course, I don't know a priori where the point would end up being and I cannot simply use a linear interpolation of the whole serie. What I would need is a linear interpolation of the interval of the seri (0-1, 1-2 ...) and the the delta between the point and this linear interpolation.

Thanks

2021-03-21 11:43:57 +0200 commented answer Calc - Find delta between a serie of points and a point

Thanks again. This works. I had tried several times by changing everything, columns to rows included, but did not manage

2021-03-20 15:19:58 +0200 commented answer Calc - Find delta between a serie of points and a point

Thanks again for your help. A couple of additional clarifications: 1. How do I adapt this to work with rows instead of c

2021-03-08 12:40:09 +0200 received badge  Notable Question (source)
2021-03-06 22:21:54 +0200 received badge  Supporter (source)
2021-03-06 22:21:48 +0200 commented answer Calc - Find delta between a serie of points and a point

Thanks! This does the trick.

2021-03-06 22:12:42 +0200 commented answer Calc - Find delta between a serie of points and a point

Thanks. I've never built a function myself but I would assume that this is not probable, right?

2021-03-06 22:12:09 +0200 commented question Calc - Find delta between a serie of points and a point

Thanks. This is for budgeting reasons. Imagine you have a budget for expenses of 10k in a year. You can assume that the

2021-03-06 22:03:14 +0200 received badge  Popular Question (source)
2021-03-06 08:01:49 +0200 asked a question Calc - Find delta between a serie of points and a point

Calc - Find delta between a serie of points and a point Dear all, imagine you have a serie of points with a certain (fix

2020-10-09 11:47:27 +0200 marked best answer CALC: default date format

Dear all, my computer (Mac) language is English but I would like LO to show dates in Italian Format. Currently dates are shown as MM/DD/YY by default and I would like them to be DD/MM/YY instead. How can I do this?

Thanks!

2020-10-05 23:13:13 +0200 marked best answer Calc sheet takes forever to open and save

Dear all, I have a Calc sheet which takes a lot to open and especially to save (1'40").

My questions are:

  1. Any way to improve the saving time?
  2. Any way to check what is causing the slowdown? Some sort or activity monitor or something…
  3. What slows down calc the most: conditional formatting, formula, conditional formula (sumifs) done on entire columns

Thanks!

2020-08-09 20:28:47 +0200 marked best answer Conditional formatting based on week day

Dear all, is there any way to apply a conditional formatting based on the week day filled in the cell? I have cells with the following format: Sun 31/12/2015 I would like Sundays to have a different background color.

Working with CALC on a Mac

Thanks!

2020-03-02 16:13:26 +0200 received badge  Popular Question (source)
2020-02-08 16:51:46 +0200 marked best answer Calc file not inheriting locale settings

Dear all,

my LO locale setting is set to English UK.

If I create a new document and enter today's date, I get is this:

08/02/2020 which is exactly what I want

However, I have an old file where if I enter today's date anywhere, I get the American format: 02/08/2020

How is this possible? Is there a locale setting specific per file? Used to be ok until yesterday and this is driving me nuts.

Thanks

2020-02-08 16:51:46 +0200 received badge  Scholar (source)
2020-02-08 16:51:39 +0200 received badge  Commentator
2019-11-04 09:09:01 +0200 received badge  Famous Question (source)
2019-01-19 21:08:34 +0200 received badge  Popular Question (source)
2019-01-01 21:13:01 +0200 commented question Calc, password protected file is much slower than non protected file

https://bugs.documentfoundation.org/show_bug.cgi?id=122377

2018-12-30 09:04:39 +0200 commented question Calc, password protected file is much slower than non protected file

I wil, thanks

2018-12-29 23:21:08 +0200 received badge  Famous Question (source)
2018-12-29 23:19:49 +0200 asked a question Calc, password protected file is much slower than non protected file

Calc, password protected file is much slower than non protected file Dear all, I have a password protected calc file whi

2018-02-07 21:06:59 +0200 received badge  Famous Question (source)
2017-11-21 03:02:21 +0200 received badge  Notable Question (source)
2017-09-02 14:32:31 +0200 received badge  Famous Question (source)
2017-07-05 08:04:42 +0200 commented answer CALC: default date format

Thanks! Setting the locale to English UK solved my issue.

2017-07-05 08:01:08 +0200 received badge  Enthusiast
2017-07-05 02:04:42 +0200 received badge  Notable Question (source)
2017-07-05 00:32:18 +0200 received badge  Popular Question (source)
2017-07-04 22:57:23 +0200 asked a question CALC: default date format

CALC: default date format Dear all, my computer (Mac) language is English but I would like LO to show dates in Italian F

2017-06-03 22:24:13 +0200 received badge  Popular Question (source)
2017-06-03 16:13:30 +0200 answered a question Calc sheet takes forever to open and save

Hi, I have been able to identify the issue. Among others, in my file I have lots of sumifs such as: =IF($M$1>=J2;(IF(

2017-06-02 23:08:47 +0200 asked a question Calc sheet takes forever to open and save

Calc sheet takes forever to open and save Dear all, I have a Calc sheet which takes a lot to open and especially to save

2017-04-26 21:00:56 +0200 received badge  Taxonomist
2017-03-05 23:02:58 +0200 received badge  Notable Question (source)
2017-02-06 14:53:57 +0200 received badge  Popular Question (source)
2017-02-05 15:05:29 +0200 received badge  Notable Question (source)
2017-02-05 12:52:00 +0200 asked a question How to find out what is slowing down calc

Dear all, I have a big calc document and for some reason, in time, it got really slow. Is there any sort of "activity monitor" which would let me understand what is causing this?

Thanks!

2017-02-04 20:47:16 +0200 commented answer Calc - How to get cell coordinates as Sheet.A1

True, but in my case that will be just fine as I'm referencing this from a different sheet.

2017-02-04 20:12:51 +0200 commented answer Calc - How to get cell coordinates as Sheet.A1

Got it! =CELL("ADDRESS";Sheet2.A1) does exactly what I need! Thanks for your insight!

2017-02-04 19:53:05 +0200 commented answer Calc - How to get cell coordinates as Sheet.A1

Thanks! Works fine however it only works correctly if the cell where you fill the formula in is in the same sheet as cell A1, otherwise I get sheet2.sheet3.A1. Is there any way to fix it? (I'm not quite sure I understand how it works exactly)

2017-02-04 19:22:34 +0200 received badge  Popular Question (source)
2017-02-04 18:59:18 +0200 commented answer Calc - How to get cell coordinates as Sheet.A1

I don't want it to return the content of Sheet.A1 but I need it to return "Sheet.A1" instead. I need this to list different values and the cell where those values occur in 2 columns, such as

Sheet.A1 =Sheet.A1

Sheet.A2 =Sheet.A2

...

...

2017-02-04 18:58:49 +0200 answered a question Calc - How to get cell coordinates as Sheet.A1

I don't want it to return the content of Sheet.A1 but I need it to return "Sheet.A1" instead. I need this to list different values and the cell where those values occur in 2 columns, such as

Sheet.A1 =Sheet.A1

Sheet.A2 =Sheet.A2

...

...