Re: [libreoffice-users] how add new alphabetic and numeric for generate in CALC?

At 19:19 07/05/2012 +0100, Manuel Songokuh wrote:
> i wanted to add new alphabetic + numeric for create generate like 
> key 128bit or 64bit or 32bit in a cell from CALC libreoffice 
> 3.5?  also can uo and down ( abc and ABC, mix: AbC)?
>
> example: cell is A1: df6rEI9f753lr3xldgjm2we0d or

You want to create a random alphanumeric string?

These may help you in your quest:
 =INT(RAND()*10) will create a single random digit as a number.
 =CHAR(48+RAND()*10) will create a random digit as text.
 =CHAR(65+RAND()*26) will create a random capital letter.
 =CHAR(97+RAND()*26) will create a random lower-case letter.

Alternatively, you could make a list of the sixty-two characters; 
suppose these are in A1 to A62.  Then
 =INDIRECT("A"&INT(1+RAND()*62)) will create a single random 
character from the set.

This may give you a start; I trust it helps.

Brian Barker


--
For unsubscribe instructions e-mail to: users+help@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