by Lupp » Fri Feb 15, 2019 11:50 am
It's the same thing: Use relative addressing which is default anyway.
If your current cell ist D31 e.g, the cell "one row above and one column right of" is E30. Use this address to reference it. A formula containing this reference copied and then pasted elswhere or "filled" elsewhere dragging the fill handle or using the respective menu sequence will adapt automatically as you expect.
Copying the reference E30 (above example) from cell D31 to cell D32 will show it as E31. Pasting the same faormula into cell AZ111 will result in a reference to BA110, which is "one above, one right of" again.
If you want to NOT GET such an adaption you need to use ABSOLUTE addressing with the help of the $-character.
You should actually read the above linked tutorial!
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München