I have a Writer-document consisting of many pages of tables. To make it easier to reference to this document, I want to have a column that numbers each row (1, 2, 3... 499, 500). Is there any function that does this easy, like the function that can "auto-fill" rows and columns in Calc?
In the cell of first row: 1
In the cell of second row: push [F2] introduce: =< A1 > + 1
Select the above cell and copy down. (select the cell not the content).
Replace existing Writer table with Calc spreadsheet OLE object editable directly from Writer. Here's how to do it.
first answer does not work....formulas in tables are fixed references...moreover, you need to copy the actual forumula....copying the cell copies the contents but not the forumula
I ran into this same desire/problem yesterday (3.5.2 on XP). ended up having to manually copy formula and edit the formula to pick up the right cell references.
Better off to use calc and copy and paste...though formatting brings new challenges.
per Raev's comment....that does NOT work for me on 3.5.2, Copying the cell works fine but the formula in the new cell is the old formula....so if done 100 times, then 100 cells all with the same exact formula (<A1>+1) so all the same.....not the desired <A2>+1...<A3>+1....etc
vojo ( 2012-05-21 05:34:27 +0200 )editEasy Make your Table, Choose the row you want numbered. Select that entire row (highlight it) Got to the tool bar at the top and choose Format -> Bullets and Numbering. Play around with that, it works Perfectly! Awesome
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-05-17 10:55:58 +0200
Seen: 748 times
Last updated: Aug 10 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
