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.