Go Back  Bike Forums > Bike Forums > Bicycle Mechanics
Reload this Page >

Using Spocalc with OpenOffice??

Notices
Bicycle Mechanics Broken bottom bracket? Tacoed wheel? If you're having problems with your bicycle, or just need help fixing a flat, drop in here for the latest on bicycle mechanics & bicycle maintenance.

Using Spocalc with OpenOffice??

Old 04-30-10, 09:08 AM
  #1  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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.
ClarkinHawaii is offline  
Old 04-30-10, 09:32 AM
  #2  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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
ClarkinHawaii is offline  
Old 04-30-10, 09:45 AM
  #3  
Old fart
 
JohnDThompson's Avatar
 
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).
JohnDThompson is offline  
Old 04-30-10, 10:29 AM
  #4  
Cat 6
 
Ex Pres's Avatar
 
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








Ex Pres is offline  
Old 04-30-10, 11:09 AM
  #5  
AEO
Senior Member
 
AEO's Avatar
 
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.
__________________
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
AEO is offline  
Old 04-30-10, 11:52 AM
  #6  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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 . . .
ClarkinHawaii is offline  
Old 04-30-10, 01:48 PM
  #7  
Senior Member
 
SweetLou's Avatar
 
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.

Last edited by SweetLou; 04-30-10 at 02:20 PM.
SweetLou is offline  
Old 04-30-10, 07:36 PM
  #8  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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
Hi--Just started looking at Sherman's. Thanks for the tip!
ClarkinHawaii is offline  
Old 04-30-10, 08:42 PM
  #9  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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.
ClarkinHawaii is offline  
Old 04-30-10, 10:21 PM
  #10  
Senior Member
 
SweetLou's Avatar
 
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.
SweetLou is offline  
Old 04-30-10, 11:23 PM
  #11  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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!
ClarkinHawaii is offline  
Old 04-30-10, 11:42 PM
  #12  
Senior Member
 
mrrabbit's Avatar
 
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-)
__________________
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
mrrabbit is offline  
Old 05-01-10, 10:34 AM
  #13  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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. . .
ClarkinHawaii is offline  
Old 05-03-10, 04:02 PM
  #14  
Senior Member
Thread Starter
 
ClarkinHawaii's Avatar
 
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
Originally Posted by SweetLou
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.
after resolving my own computer's "issues", I got the Sherman 2.1 to work. Thanks!
ClarkinHawaii is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
rck
Fifty Plus (50+)
2
05-29-12 09:09 AM
slipknot0129
Electronics, Lighting, & Gadgets
1
02-17-10 07:45 PM
cantdrv55
Northern California
3
12-12-09 11:29 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.