Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 21 Sep 2017 10:29:15 +0200Two parameters functions: slope, intercept, etc. do not work with indirect(address()) as one parameterhttps://ask.libreoffice.org/en/question/131818/two-parameters-functions-slope-intercept-etc-do-not-work-with-indirectaddress-as-one-parameter/Hi,
I have a strange problem with libreoffice calc latest version 5.4.1.2 under ubuntu 16.04 64 bit (build 5.4.1~rc2-0ubuntu0.16.04.1~lo0).
I would like to use some functions that take two range parameters as input (slope, intercept, rsq, etc.).
These functions work well if the parameters range are defined as usual:
`SLOPE(absolute_range1,absolute_range2), INTERCEPT(absolute_range1,absolute_range2)` where absolute_rangeX is like this `$A$10:$A$100.`
However, I would like to able to change the range on which the functions work. For this purpose I use ADDRESS and MATCH function:
`H1=ADDRESS(MATCH(value_to_search, range_where_to_search,1)+ROW(cell)-1,COLUMN(cell),1)` and I correctly get the cell address, let say `$C$10`.
After, by using `H2=INDIRECT(H1 &":$C$100")` I can obtain the required range and I able to use it in functions that take one parameter as `SUM(H2), SUMPRODUCT(H2)`.
Unfortunately, it does not work with `SLOPE(H2,$A$10:$A$100), INTERCEPT(H2,$A$10:$A$100)` and `SUMPRODUCT(H2,$A$10:$A$100)` too.
So is there any intrinsic limit about using `INDIRECT(ADDRESS())` together with functions that take two range as parameters?
Thank you
P.S.
For curiosity, I tried also with the same version of libreoffice on windows and with excel 2016 and both do not work.erotavlasThu, 21 Sep 2017 10:29:15 +0200https://ask.libreoffice.org/en/question/131818/