https://bugs.documentfoundation.org/show_bug.cgi?id=148863
Bug ID: 148863
Summary: If a matrix created by RANDBETWEEN.NV function is
transposed, it will not be random number.
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If a matrix created by RANDBETWEEN.NV function is transposed, it will not be
random number.
Steps to Reproduce:
1.Cell A1: =TRANSPOSE(IF({0|0|0}=0;RANDBETWEEN.NV(1;100)))
2.Ctrl + Shift + Enter
3.
Actual Results:
Three same numbers line up at Cells A1:C1.
Expected Results:
Three random numbers are lined up at Cells A1:C1.
Reproducible: Always
User Profile Reset: No
Additional Info:
Example_1
Cell A1: {=IF({0|0|0}=0;RANDBETWEEN.NV(1;100))}
Three random numbers are lined up at Cells A1:A3.
This is the right result.
Example_2
Cell A1: {=TRANSPOSE(IF({0|0|0}=0;RANDBETWEEN(1;100)))}
or
Cell A1:
{=TRANSPOSE(IF({0|0|0}=0;com.sun.star.sheet.addin.Analysis.getRandbetween(1;100)))}
Three random numbers are lined up at Cells A1:C1.
This is the right result.
Version: 7.1.6.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Ubuntu package version: 1:7.1.6-0ubuntu0.21.04.1
Calc: threaded
Version: 7.3.1.3 (x86) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
