Ask Your Question
1

If only LO Writer table could allow copy paste of formula? [closed]

asked 2012-03-12 10:08:04 +0100

mkyadava gravatar image

updated 2015-09-21 23:59:02 +0100

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-01 14:14:05.422520

Comments

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 gravatar imagemkyadava ( 2012-03-12 18:08:47 +0100 )edit

6 Answers

Sort by » oldest newest most voted
2

answered 2012-06-24 23:12:57 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

Works well under Kubuntu 14.04, LO 4.2.7.2 too. When saving to doc formulas are lost.

Adobe gravatar imageAdobe ( 2015-02-27 09:51:19 +0100 )edit
1

answered 2012-03-12 15:25:34 +0100

Pedro gravatar image

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.

edit flag offensive delete link more

Comments

1

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

mkyadava gravatar imagemkyadava ( 2012-03-12 18:09:28 +0100 )edit
0

answered 2015-09-21 22:42:56 +0100

mkyadava gravatar image

After long time, discovered the secret. Ofcourse I used LibreOffice 5.0.1. But looks like it should not matter. To copy & paste formula in LibreOffice Table, please follow this:

*1. Put the cursor in the cell containing the formula. Go to menu bar Table->Select->Cell).

*2. Then press Ctrl+C

3. Then select the target cell or group of cells, and press Ctrl+V.

You can also create a keyboard short cut for selecting the Cell and not its content. To do so, follow the instructions below:

  1. Open your document. Go to Tools->Customize. You shall get the "Customize" Dialog Box.
  2. Select the "Keyboard" tab, which should be the second tab in the top portion of the Dialog Box
  3. Choose your desired short cut keys (especially those which are not assigned)
  4. I, for example chose Alt+Shift+0 (Zero) key combination
  5. Having chosen, select the radio button modify to the right of it.
  6. Now come to the second portion of the Dialog Box i.e. "Functions"
  7. Select "Table" entry in the first column which is labelled "Category"
  8. Then, choose "Cell" entry in the second column which is labelled "Function"
  9. Now that's done. You should get "Alt+Shift+0" in the third column labelled "Keys"
  10. Press "OK" and exit the dialog box.
  11. Open a table, and put the cursor in a cell. (in any cell, empty or filled. Of course, I assume you have entered your formula in that cell)
  12. Press now "Alt+Shift+0" keys together
  13. And you shall see the entire cell selected
  14. Now Press Ctrl+C to copy the cell (but not its contents)
  15. Press Ctl+V in the desired cell or group of cells, your formula should now be copied, all at once.

The formula would be copied in the target cell(s). Hurra!!! Long live LibreOffice.

edit flag offensive delete link more
0

answered 2012-07-27 06:12:45 +0100

qubit gravatar image

updated 2012-07-27 19:49:14 +0100

Here's how I copy-paste formula on Ubuntu 11.10 (using LO LibreOffice 3.4.4).

  1. Open a new Writer document
  2. Create a blank 2x2 table
  3. In the lefthand column, put in "1", then below, "2"

    | 1 | _ |

    | 2 | _ |

  4. In the righthand column, top row, put in "=<a1&gt;<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.

  1. Click the B1 cell (2nd column, top cell), and drag down into the bottom (B2) cell. Both cells will be highlighted.
  2. Click in B2 and drag back into B1. Now just B1 will be highlighted.
  3. 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 |

edit flag offensive delete link more
0

answered 2012-06-23 16:54:42 +0100

barb gravatar image

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

edit flag offensive delete link more
0

answered 2012-06-25 03:10:59 +0100

vojo gravatar image

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.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-03-12 10:08:04 +0100

Seen: 4,512 times

Last updated: Sep 21 '15