Getting creative with = RANDBETWEEN

Discuss the spreadsheet application

Getting creative with = RANDBETWEEN

Postby Brevardo » Sat Jul 20, 2019 1:45 pm

I have the formula = Randbetween (0,30) in a cell. However. The only way i can get it to generate a new result is by copying the formula and pasting it to another cell. Is there a better way to keep the formula in the original cell and find another way to execute it so i can get a different result while staying in the same cell? Ideally, i would like to create some kind of virtual button to the spreadsheet in which everytime i select it, it will run the =RANDBETWEEN formula and generate a nee number/ result. Any suggestions are greatly appreciated. Thanks
Open Office 3.1
Posts: 15
Joined: Sat Jul 20, 2019 12:58 pm

Re: Getting creative with = RANDBETWEEN

Postby FJCC » Sat Jul 20, 2019 2:49 pm

The key combination CTRL + Shift + F9 causes a Hard Recalculate which will give you a new number.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 7449
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Getting creative with = RANDBETWEEN

Postby F3K Total » Sat Jul 20, 2019 3:03 pm

If you like to use a button, you can force this behaviour by adjusting the buttons properties on it's Genaral TAB
  • Action -> Open document/web page
  • URL -> .uno:CalculateHard
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Posts: 948
Joined: Fri Dec 16, 2011 8:20 pm

Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests