Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 30 Jan 2015 11:49:44 +0100How to 'drag-copy' a formula to the same row and modify (only) the row parameter (and vice versa)?https://ask.libreoffice.org/en/question/45524/how-to-drag-copy-a-formula-to-the-same-row-and-modify-only-the-row-parameter-and-vice-versa/Hello,
I've got another question. I'm pretty sure someone has asked this before, but I have no idea how to google this problem.
First off, I wanna define what I mean by 'drag-copy': If you select a cell and click on that little square at the bottom right corner of the black rectangle and drag it somewhere, it copies the value/formula of the cell, probably modifying the formula's cell references.
I know the `$` operator. What I sometimes wanna do, is to copy the formula from one cell to other cells in the same row and I want calc to modify the row parameter automatically (which it doesn't, because it's the same row; calc would only modify the column parameter).
Example: In A1 there is the formula `= A2 + 42`. Now I want to copy the value to the cells B1, C1, D1 and E1. The result will be for B1 `= B2 + 42`, for C2 `= C2 + 42` and so on.
If I have in A1 `= $A2 + 42`, the results will be like B1 `= $A2 + 42`.
But what I actually want, is B1 `= $A3 + 42`, C1 `= $A4 + 42` and so on.
Is there a way to achieve this? Pressing `CTRL` or `SHIFT` while copying doesn't seem to work. I've got the same question if you only want to change the column parameter when copying to the same column, but I assume it has the same solution.
I found a solution only for one situation: If you don't need to modify the cells formulas' after copying.
New example: In A1:A5 are some arbitrary values and I want the same values in A10:E10. Then I can use this formula in A10 `= TRANSPOSE(A1:A5)` and hit `CTRL + SHIFT + RETURN` to declare it as an array function. But this works only, if I don't want to - for example - change the formula in C10 after copying.
I am using Kubuntu 10.14 and LibreOffice Calc Version: 4.3.3.2.
Best RegardsHerbivore13Fri, 30 Jan 2015 11:49:44 +0100https://ask.libreoffice.org/en/question/45524/