The Table formula in the LO is great, and so is interlinking figures from different tables. However, the stopper is that when you want to copy formula from one cell to another cell, it does not work. So, currently, you have to write the same formula, say summing each row at the end of the rows, or summing columns at the end of each of the columns, again and again. Or go to the formula bar and do copy paste there for each of the individual cells. Custom formula copy paste, like in Calc would be a great feature to work with tables, and enhance is utility multifold.
Works right in Win7x64 with:
LibreO 3.3.4, 3.5.5.1, 3.6.0.beta2
As Pedro have explained is needed to select the cell not the content of the cell. (Menu/Table/Select/Cell), the copy/paste.
Mark a single cell Do one of the following:
Click, then Shift-click the cell.
Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.
It does work (at least in the Windows OS)
If you select the cell that contains the formula and press Ctrl+C, then you just need to select the cells where you want to paste the formula, press Ctrl+V and the formula will be calculated for all rows/columns.
For Windows 7: It does NOT work! copy / paste works never. Copy / paste special (Formulas) worked ones than never again (...unformatted text?). Ctrl C / Ctrl V worked ones, but not the following times (only copies Number, not formula). Just downloaded 3.5.4.; no difference. Posted June 23, 2012
Here's how I copy-paste formula on Ubuntu 11.10 (using LO LibreOffice 3.4.4).
In the lefthand column, put in "1", then below, "2"
| 1 | _ |
| 2 | _ |
In the righthand column, top row, put in "=<a1><em>2" (type "=", then click the upper-left (A1) cell, then type "2") and hit enter. The table should look something like this:
| 1 | 2 |
| 2 | _ |
As @mariosv points out, there's a difference in Writer between selecting a cell and selecting the contents of a cell. We want to do the former.
Copy that cell (Ctrl-c) and then paste into B2. The formula should be copied over and the table should look like this:
| 1 | 2 |
| 2 | 4 |
Works fine for me under MS.
What you cant do is things like fill or relative references. I.e. copy a cell formula that references the cell to the right so that new instance references its cell to the right.
I use the copy paste manual tweak the formula alot for specs so that the math is correct.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-12 10:08:04 +0200
Seen: 687 times
Last updated: Jul 27 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
OK, it may be working under MS Windows. I could not make it work under GNU/Linux. I use Ubuntu 10.04, and LO 3.3.2. No Windows here, please!!!
mkyadava ( 2012-03-12 18:08:47 +0200 )edit