Re: [libreoffice-users] Re: How to insert a field of a random integer in the range 5 to 20?

At 14:43 27/04/2014 +0200, Luuk Noname wrote:
> On 25-4-2014 22:37, Alf Noname wrote:
> > In LibreOffice Writer, how to insert a field of a random integer in 
> > the range 5 to 20? This random integer changes every time I open the document.
>
> In Word (2013) it is possible to insert two nested fields with the 
> following definition:
> { = ROUND({ TIME\@\"ss" \* MERGEFORMAT }/4+5;0) }
>
> The 'inner' field results in the seconds of the current time, this 
> is divided by 4, resulting in a number between 0 and 15, and finally 
> 5 is added. I was unable to reproduce this in LibreOffice... ;(
>
> Is anyone be able to do this?

Here's a start:
o In the first cell of a table, go to Insert | Fields > | Other... | Document.
o Under Type select Time.
o Under Select, select Time. (Note that "Time" in the earlier Fields 
menu is actually "Time (fixed) and not what you want.)
o Click Insert. (I don't think it matters what Format you select.)
o Put the cursor into another cell and press F2.
o Complete the formula in the Input Line: =((<A1>*100000-<A1>*100000 
round 0+0.5) round 2)*100 and click the green arrow.

I think that gives you an unpredictable two-digit number, but you'd 
better check the maths. The remainder of the calculation is left as 
an exercise for the reader!

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted