Page 1 of 1

[Solved] Numbering days in a table

Posted: Thu Jun 20, 2013 8:14 am
by JackK
Hi, All!
I've got a table in Writer: the header contain working days in a week: Mon. Tue. Wed. Thu. Fri. I'd like to autonumerate days in a month.

Example (July 2013): when I put 1 into variable x cells should be populated as:

Code: Select all

Mon. Tue. Wed.  Thu.  Fri.
x    x+1  x+2   x+3   x+4
x+7  x+8  x+9   x+10  x+11
x+14 x+15 x+16  x+17  x+18
x+21 x+22 x+23  x+24  x+25
x+28 x+29 x+30
How may I do this?

OO Version: 3.2.1

Re: Numbering days in a table

Posted: Thu Jun 20, 2013 11:53 am
by acknak
Just the way you wrote it:

Create a variable; call it "x" or anything you want. Insert > Fields > Other > Variables > Type: Set variable

In your table cells, Insert > Fields > Other > Variables > Type: Insert Formula, Formula: x, x+1, x+2, ...

If you change the value of x (double-click on the "set variable" field), all the formulas will update automatically.

Re: Numbering days in a table

Posted: Thu Jun 20, 2013 12:13 pm
by JackK
Thank you for reply.
I added a variable start. Then in a cell I wanted to add a formula start+1 but after click on "Insert" (propably; I have polish version) nothing is happen :roll:
---------
It works :)
---------
But when I changed start the cell does not change :?
---------
It works :) Thanks again.