# Calc : function rand() side effect on cells values [closed]

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.