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