Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )

Advanced DNS Management
New ZoneEdit. New Managment.


Sign Up Now
Reply to this topicStart new topic
> Rand.between In Open Office
post Dec 15 2003, 03:37 PM
Post #1

Whats this Lie-nix Thing?

Group: Members
Posts: 1
Joined: 15-December 03
Member No.: 1,968

I'm new to Open Office, and am trying to get worksheets from Excel to work. The rand() formula works fine in open office, but I can't get the rand.between() function to work. It will give me a single random number within the range I specify, but will not update or recalculate teh cell when I recalculate the whoel spreadhseet, while the rand() function behaves normally. I suppose I can just multiply rand() by the number of interest and round, but I'd have to go back and change a lot of spreadsheets to do so. Ideas?
Go to the top of the page
+Quote Post
post Dec 15 2003, 07:35 PM
Post #2

Its GNU/

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151

I can verify the behavior in openoffice 1.1.0 ... I don't see any way to fix it (on recalculate cells - F9).

It will recalculate on recalc whole worksheet (Shift-Ctrl-F9) but not on recalculate cell (F9).

Johnny Hughes
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


RSS Lo-Fi Version Time is now: 22nd March 2018 - 04:24 PM