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+h...@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
