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

 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: Any way to improve the saving time? Any way to check what is causing the slowdown? Some sort or activity monitor or something… 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 ... ...