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

thank you for reply!
but .... maybe i'm not explain good.. or i'm bad question.. i wish to generate automatic from a1 to 
a1000 with 128bit key this is possible, lenth 8 or 12...it's possible?
see example link: http://randomkeygen.com/



________________________________
 Da: Brian Barker <b.m.barker@btinternet.com>
A: users@global.libreoffice.org 
Inviato: Lunedì 7 Maggio 2012 22:29
Oggetto: 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
-- 
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