Using Spocalc with OpenOffice??
#1
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Using Spocalc with OpenOffice??
I google and read that spocalc works fine with open office--but I can't get the macros to work. I realize that I can just enter the dimensions to the worksheet manually, but I have pissed away so much time trying to get the macros to work that now I am really curious what is wrong . . .
If somebody has been successful, please help! Thanks.
Yes, I enabled the macros.
If somebody has been successful, please help! Thanks.
Yes, I enabled the macros.
#2
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I took a screenshot showing the error message, but this site is currently not allowing image from my computer. Of course my computer does not allow me to just copy and paste the error message--for unknown reasons the right-click shows no options. Did you ever get the impression it's all one big conspiracy to drive you CRAZY
#3
Old fart
Join Date: Nov 2004
Location: Appleton WI
Posts: 24,936
Bikes: Several, mostly not name brands.
Mentioned: 153 Post(s)
Tagged: 0 Thread(s)
Quoted: 3571 Post(s)
Liked 3,367 Times
in
1,916 Posts
I have found that gnumeric works better for SpoCalc. Otherwise, you might try the OxygenOffice fork of the OpenOffice.org project, which claim to support VBA macros (I haven't tested it myself).
#4
Cat 6
Join Date: Dec 2007
Location: Mountain Brook, AL
Posts: 7,519
Mentioned: 27 Post(s)
Tagged: 0 Thread(s)
Quoted: 500 Post(s)
Liked 183 Times
in
118 Posts
I've never had the macros work on OO as well, but I haven't tried since a much earlier version. I figure it takes me all of 5-10 seconds to just enter the dimensions myself.
__________________
72 Frejus (for sale), Holdsworth Record (for sale), special CNC & Gitane Interclub / 74 Italvega NR (for sale) / c80 French / 82 Raleigh Intl MkII f&f (for sale)/ 83 Trek 620 (for sale)/ 84 Bruce Gordon Chinook (for sale)/ 85 Ron Cooper / 87 Centurion IM MV (for sale) / 03 Casati Dardo / 08 BF IRO / 09 Dogma FPX / 09 Giant TCX0 / 10 Vassago Fisticuff
72 Frejus (for sale), Holdsworth Record (for sale), special CNC & Gitane Interclub / 74 Italvega NR (for sale) / c80 French / 82 Raleigh Intl MkII f&f (for sale)/ 83 Trek 620 (for sale)/ 84 Bruce Gordon Chinook (for sale)/ 85 Ron Cooper / 87 Centurion IM MV (for sale) / 03 Casati Dardo / 08 BF IRO / 09 Dogma FPX / 09 Giant TCX0 / 10 Vassago Fisticuff
#5
Senior Member
Join Date: Jun 2007
Location: A Coffin Called Earth. or Toronto, ON
Posts: 12,258
Bikes: Bianchi, Miyata, Dahon, Rossin
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 5 Times
in
5 Posts
I could never get the macros to work in both MS office and OO.
but it's not so hard to just copy and paste values over to the calculator sheet.
the calculator works fine with macros disabled.
but it's not so hard to just copy and paste values over to the calculator sheet.
the calculator works fine with macros disabled.
__________________
Food for thought: if you aren't dead by 2050, you and your entire family will be within a few years from starvation. Now that is a cruel gift to leave for your offspring. ;)
https://sanfrancisco.ibtimes.com/arti...ger-photos.htm
Food for thought: if you aren't dead by 2050, you and your entire family will be within a few years from starvation. Now that is a cruel gift to leave for your offspring. ;)
https://sanfrancisco.ibtimes.com/arti...ger-photos.htm
#6
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Yeah, Thanks, Guys. I'm happy to hear that it doesn't work for ANYBODY! What was blowing my mind was that somebody reported it worked just great with open office--therefore I assumed I was doing something wrong and couldn't figure out what . . .
As long as all this talent is gathered in one place--does anybody have any idea why this friggin site will allow you to post images from your computer sometimes, but not always?? If this keeps up, I'm gonna demand my $$ back . . . Oh, wait . . .
As long as all this talent is gathered in one place--does anybody have any idea why this friggin site will allow you to post images from your computer sometimes, but not always?? If this keeps up, I'm gonna demand my $$ back . . . Oh, wait . . .
#7
Senior Member
Join Date: Jul 2007
Posts: 2,114
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
Same here with spocalc.xls, but I did find a version called spocalc.sxc that does work in OpenOffice. I don't recall where I found it, though.
Edit: I found it. It is at Mike Sherman's site. https://home.earthlink.net/~mike.sherman/bike.html
For some reason, I only get the version for 2.1 to work, the version for 3 has the buttons, but they don't seem to do anything for me, yet.
Edit: I found it. It is at Mike Sherman's site. https://home.earthlink.net/~mike.sherman/bike.html
For some reason, I only get the version for 2.1 to work, the version for 3 has the buttons, but they don't seem to do anything for me, yet.
Last edited by SweetLou; 04-30-10 at 02:20 PM.
#9
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
For some reason I have the program in "read only" mode, which means I cannot enter stuff manually even.
But using the macro buttons, after I have made my selections, isn't there an "execute" button somewhere I'm supposed to hit? The stuff on the calculations page doesn't change just because I make some selections.
But using the macro buttons, after I have made my selections, isn't there an "execute" button somewhere I'm supposed to hit? The stuff on the calculations page doesn't change just because I make some selections.
#10
Senior Member
Join Date: Jul 2007
Posts: 2,114
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
No execute button. As soon as you hit one of the buttons it should change on the calculations page. I had to set the security to medium for macros for it to work. Before I did that, I just got a warning about macros. After I changed the setting, OO.org asked if I wanted to run the macros. Then it worked fine.
#11
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
It's been a long time since I futzed around with computers. Working with bikes can be frustrating, but computers take it to a whole different level!
#12
Senior Member
Join Date: Dec 2007
Location: San Jose, California
Posts: 3,504
Bikes: 2001 Tommasini Sintesi w/ Campagnolo Daytona 10 Speed
Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 145 Post(s)
Likes: 0
Liked 35 Times
in
30 Posts
Created my own spreadsheet without macros...
...and works fine in Excel or Open Office...
https://www.mrrabbit.net/wheelsbyflemingapplications.php
Give it a try...it's about 2/3's way down...
=8-)
...and works fine in Excel or Open Office...
https://www.mrrabbit.net/wheelsbyflemingapplications.php
Give it a try...it's about 2/3's way down...
=8-)
__________________
5000+ wheels built since 1984...
Disclaimer:
1. I do not claim to be an expert in bicycle mechanics despite my experience.
2. I like anyone will comment in other areas.
3. I do not own the preexisting concepts of DISH and ERD.
4. I will provide information as I always have to others that I believe will help them protect themselves from unscrupulous mechanics.
5. My all time favorite book is:
Kahane, Howard. Logic and Contemporary Rhetoric: The Use of Reason in Everyday Life
5000+ wheels built since 1984...
Disclaimer:
1. I do not claim to be an expert in bicycle mechanics despite my experience.
2. I like anyone will comment in other areas.
3. I do not own the preexisting concepts of DISH and ERD.
4. I will provide information as I always have to others that I believe will help them protect themselves from unscrupulous mechanics.
5. My all time favorite book is:
Kahane, Howard. Logic and Contemporary Rhetoric: The Use of Reason in Everyday Life
#13
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Thanks, Guys, I'll try some more ideas incl MrRabbit's later on today and report my glowing success story. . .
#14
Senior Member
Thread Starter
Join Date: Jan 2010
Location: Wahiawa. Oahu
Posts: 1,701
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Same here with spocalc.xls, but I did find a version called spocalc.sxc that does work in OpenOffice. I don't recall where I found it, though.
Edit: I found it. It is at Mike Sherman's site. https://home.earthlink.net/~mike.sherman/bike.html
For some reason, I only get the version for 2.1 to work, the version for 3 has the buttons, but they don't seem to do anything for me, yet.
Edit: I found it. It is at Mike Sherman's site. https://home.earthlink.net/~mike.sherman/bike.html
For some reason, I only get the version for 2.1 to work, the version for 3 has the buttons, but they don't seem to do anything for me, yet.
Thread
Thread Starter
Forum
Replies
Last Post
slipknot0129
Electronics, Lighting, & Gadgets
1
02-17-10 07:45 PM