Ask Your Question
0

Calc: How can I use the randomizer with Windows 8.1?

asked 2018-05-12 07:41:23 +0200

JoJoBB gravatar image

updated 2018-05-12 22:09:35 +0200

LibreTraining gravatar image

I recently downloaded LibraOffice Calculator spreadsheet into my computer. It involves a game show I've created and it has a randomizer, but for some reason it does not work. A couple of people I have talked to told me it's either F9 or Control, Shift and F9, but they do not work on my WIndows 8,1. I also have a Dell computer....Is there anything else I can do?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-05-12 09:15:59 +0200

Jim K gravatar image

updated 2018-05-12 09:17:17 +0200

Go to Data -> Calculate -> Recalculate. The hotkey for this is F9 on my machine.

If that does not work, start with a new spreadsheet. Enter =RAND() and see if recalculating changes the value.

Documentation: https://help.libreoffice.org/Calc/Rec...

edit flag offensive delete link more

Comments

F9 only shows as the Search on my computer. Do I have push another button or buttons before F9?

JoJoBB gravatar imageJoJoBB ( 2018-05-14 08:09:59 +0200 )edit

What key combination does it say next to Data -> Calculate -> Recalculate? Alternatively, search for function Recalculateunder Tools -> Customize -> Keyboard to see if it is set to a key.

Jim K gravatar imageJim K ( 2018-05-14 18:29:50 +0200 )edit

It says F9 and it says F9 involving the function Recalculate.....but it still does not work. Everytime I bring up the file and push F9, the Search function comes up.

JoJoBB gravatar imageJoJoBB ( 2018-05-15 02:04:17 +0200 )edit

Perhaps you need to reset the profile, or you have a keyboarding solution set up on your operating system to type in a different language, or something like AutoHotkey is interfering.

Jim K gravatar imageJim K ( 2018-05-15 14:49:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-12 07:41:23 +0200

Seen: 39 times

Last updated: May 12 '18