First time here? Check out the FAQ!

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 |

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 :
Willing to learn the very basics of spreadsheets, i opened a new spreadsheet document, and starting using the 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 I would like to understand this behavior. Thanks. |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.