Ivan Paganini wrote:
Hello fellow Open Office users!
I have a question: I can use autofill in a spreadsheet to fill with
integers. But I need to fill with floating points: to 0.06 to 0.2, say. When
I try to use the autofill, it just adds integers. How can this be done? I am
using open office 1.1.3 - debian. If it is impossible to do it in oo1, I can
change to oo2.
I dont understand what you need:
when you need random numbers, use function
=randbetween(6;20)/100
when you need linear series (n2=n1+x), then
enter two first number in serie, eg. 0,06 and 0,08 select these two
cells and drag from lower right corner (cursor changes to cross), cells
will be filled with numbers 0,1 0,12 0,14 etc as you drag (youll see
tooltip with last actual number)
when you need geometric series (n2=n1*x), use edit - fill - series
(this can be used also for linear series, but this above is faster)
ain
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
