Yes and No. Yes, you can add a column to all other sheets, but it has its limits. LibreOffice is built so that its columns grow as needed, so when you clone a column to other worksheets the number of rows cloned will be the max number possible in those other sheets.
For example, say column A has 200 rows of data, and 500 rows currently in memory (i.e. you have scrolled down 500 rows in that session). When you clone the column over, 500 will be the max number of linked cells. Basically, Sheet1.A = Sheet2.A, but as far as Sheet 2 is concerned, Sheet1.A is 500 cells long. The first 500 cells of each will be identical, changing dynamically whenever Sheet1.A is changed, but only for the first 500 cells. LibreOffice (and excel too I think) simply don't have the functionality to symbolically set Sheeet1.A = Sheet2.A for all A.
So if your data is growing continuously, then there is no way to do this for all occurrences, other than just just repeating the cloning process when max is reached. You can help yourself out by scrolling down in libreoffice before cloning (i.e if you have 200 rows of data, scrolling down 2000 rows will buy you more time.)
If having a max is acceptable, following these steps is the quickest way to clone to all sheets:
- Right click the column header that you want to copy. Select "copy".
- At the bottom of the screen,
ctrl+click the sheets you want to copy to. If you want to copy to all sheets, right click any of them and click "select all" (if you do this, be sure to
ctrl+click the sheet you are copying from to deselect it, otherwise you'll get bad data.)
- Now, in any of the selected tabs, right click the header of the destination column (Note that this will erase all current data in that column. Insert new column if this is not acceptable) and select "paste special".
- In the pop-up, check the boxes "Paste All" under Selection and "Link" under Options.
- Finally, hit "OK" to finish.
This is the best way that I have found, given that full symbolic linking is not supported. Hope this helps.