Description: A random string generator should be implemented in LibreOffice that would generate a random string out of the following inputs: length, and which character sets to include (uppercase, lowercase, numbers, hexadecimal, special characters). This would generate a random string 16 characters long with a choice of one of the possible combinations of numbers, letters and special characters if someone picked the specific input option. Steps to Reproduce: 1.Select a range of cells 2.Click a button in the Insert menu to generate a random string 3.Select a set of character sets in a pop-up box and specify the length of the random string to be generated. 4.The selected range has random strings inserted. Actual Results: Enhancement Expected Results: Enhancement Reproducible: Always User Profile Reset: No Additional Info: Enhancement
Created attachment 173634 [details] Implementation Example
The file's input is as follows: length 11 characters, character set selection of numbers, uppercase letters, lowercase letters. A simple formula for generating the example is =CONCAT(INT(RAND()*10), CHAR(48+RAND()*10), INT(RAND()*10),CHAR(65+RAND()*26),INT(RAND()*1000),CHAR(97+RAND()*26),INT(RAND()*1000)).
*** Bug 143407 has been marked as a duplicate of this bug. ***
Sounds like the job for an extension or macro
You resolved the (unclear) use case yourself with comment 2. Calc functions provide everything to generate a random string. Besides, if there is no general use case such a feature would indeed better realized per extension.