BetaRayBill wrote:… the list refreshes itself whenever I make any change within the document (like column width). I understood that it would refresh whenever I opened the document, but not when making changes in it while it was open.
No, lots of changes to the sheet can cause a recalculation.
OpenOffice Help wrote:[RAND] produces a new random number each time Calc recalculates.
BetaRayBill wrote:I do wonder if there is a way to make it not do that if I wanted.
That is explained in OpenOffice Help → Index → RAND, which says:
OpenOffice Help wrote:To generate random numbers which never recalculate, copy cells each containing =RAND(), and use Edit - Paste Special (with Paste All and Formulas not marked and Numbers marked).
To obtain a new selection of random values, put the
=RAND() function back in those cells. You can
record macros for those actions.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).