Ask Your Question

topo's profile - activity

2016-07-27 20:57:57 +0100 received badge  Famous Question (source)
2016-07-27 20:57:57 +0100 received badge  Notable Question (source)
2016-03-18 09:32:19 +0100 commented answer Calc : function rand() side effect on cells values

I could find this as the official documentation of LO Calc relative to mathematical functions, but it doesn't make any reference to volatile property that you mentioned :

Mathematical Functions - LibreOffice Help

I would be great to read somewhere a more complete definition of rand() function.

2016-03-18 09:27:27 +0100 received badge  Popular Question (source)
2016-03-17 14:10:43 +0100 received badge  Editor (source)
2016-03-17 13:45:38 +0100 commented answer Calc : function rand() side effect on cells values

Hallo karolus,

Danke schön for your quick answer ! :)

You put me on the right path, because i nearly thought it could be a bug, but thinking about it then thought i had missed something. Thanks for the replacement function, i will use it. Now i will be more carefull about how functions are defined (volatile or not for example).

2016-03-17 12:30:13 +0100 answered a question Calc : function rand() side effect on cells values

Say for example, if i have for the A4:C8 cells, entered the formula "=rand()", to randomize an array 3x5 of values, if i just set one cell elsewhere (E1 for example) on the spreadsheet with a value , it will affect all the values of the A4:C8 range of cells.

Say :

0.7208296846 0.9681026701 0.1170904948 0.4816458312 0.2473452087 0.2533566935 0.1701826189 0.4916606066 0.28557925 0.2569225257 0.6591033325 0.9558581608 0.9941591621 0.5651747689 0.6260274619

Become

0.9184627659 0.8902114319 0.3679129528 2 0.8269501603 0.7634500963 0.5624116682
0.217940301 0.4380287969 0.668961365
0.5994510901 0.7790492607 0.9111794242
0.6082804288 0.787962539 0.5868770138

2016-03-17 12:21:20 +0100 asked a question Calc : function rand() side effect on cells values

I'm novice to LibreOffice and just done a fresh install on my ArchLinux system. Here is the up-to-date version of LibreOffice i have :

Version: 5.0.5.2 Build ID: 5.0.5.2 Arch Linux build-1 Locale: en-US (en_US.UTF-8)

Willing to learn the very basics of spreadsheets, i opened a new spreadsheet document, and starting using the rand() function within cells formulas. For example, i set one cell with =rand() formula, and then copy down the formula to the cells below, and then to the cells at the next column to make an array of random values.

What is surprising, and i want to understand is, when i modify one cell on this spreadsheet, whatever the cell is, all cells containing random values (with =rand() formula), are modified.

I would like to understand this behavior.

Thanks.