Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Replace existing Writer table with Calc spreadsheet OLE object editable directly from Writer. Here's how to do it.

  1. select the whole table and copy it (Ctrl-C, right-click → Copy...)
  2. position the cursor below your table and select from menu Insert → Object → OLE Object → Create new → LibreOffice 3.x Spreadsheet
  3. select cell A1 and paste (Ctrl-V, right-click → Paste...)
  4. now you've got spreadsheet just like in Calc but within Writer, that you can edit later by double-clicking it and you can also use known method for auto-filling rows you asked
  5. you can now delete your original table and use newly created spreadsheet