I have LibreOffice Calc file which has 2 sheets.
I wanted to reference Sheet1 from Sheet2, so I wrote function =Sheet1.A1
in Sheet2 cell A1.
How do I apply this to all cells on Sheet2? (Sheet2.B5 = Sheet1.B5, ...)
I select all cells, but I have no idea what formula to write: =Sheet1.????
Edit:
Some clarification:
Reason I want to do this is that Sheet1 will have varying number of rows. So when I add new rows to Sheet1, then Sheet2 should just deal with it, without requiring me to apply same formula to new rows (which I sometimes forget to do).
That is why all cells in column should have this reference by default, not only subset of them.