Re: [libreoffice-users] Create a list of ascending numbers with repeats

2013-04-23 Thread Steve Edmonds
LO seems to extend the series with 5 x 1s, 5 x 2s and then 10 x 3s, 10 x 4s, etc. Possibly a bug and should be 5 x 3s, 5 x 4s, etc. I have found a couple of other cases where the series does not extend well. 123 was very good at extending series. I found Calligra gets it right. Steve On

Re: [libreoffice-users] Create a list of ascending numbers with repeats

2013-04-18 Thread Brian Barker
At 14:16 18/04/2013 +0300, Raz Noname wrote: Can't figure out how to create a list of: 1,1,1,1,1,2,2,2,2,2... the drag-down menu makes the list as follows: 1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3 o Type 1 into your first five cells. o In the sixth cell, type =, click on the first cell (top of