https://bugs.documentfoundation.org/show_bug.cgi?id=159936
Bug ID: 159936
Summary: calc function problem
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
=CONCATENATE(MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1))
The above function is written to output 12 characters, but it may output 11 or
10 characters.
It seems that it doesn't work if "\" is included in the character candidates in
cell A1.
Steps to Reproduce:
1.A1 Cell ->
0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!"#$%&'()*+,-./:;<=>?@[\]^_`{|}~
2.A3 cell ->
=CONCATENATE(MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1),MID($A$1,(RANDBETWEEN(1,LENB($A$1))),1))
3.
Actual Results:
Xo)<|yD#TVM
Expected Results:
fR3GNZ"8;MiU
Reproducible: Always
User Profile Reset: Yes
Additional Info:
It seems that it doesn't work if the "\" character is included.
--
You are receiving this mail because:
You are the assignee for the bug.
