Official ICE Forums

Systems & Settings => Rolemaster => Rolemaster Software => Topic started by: netbat on April 07, 2013, 10:57:06 AM

Title: Open Office conversion of JDales excel charsheet
Post by: netbat on April 07, 2013, 10:57:06 AM

As the subject says, has anyone done this conversion? My spreadsheet programing skills are very rusty and I don't have the time to do it myself.

Title: Re: Open Office conversion of JDales excel charsheet
Post by: Grinnen Baeritt on April 08, 2013, 03:14:28 AM

Have you tried just opening it with Open Office, and saving it in open office format? it's quite clever and will convert most stuff.

Title: Re: Open Office conversion of JDales excel charsheet
Post by: netbat on April 08, 2013, 10:36:39 PM

yes I did, most of the macros break. I could probably use it as a basic charsheet, but all the support for leveling up and a lot of the choices are broken.

Title: Re: Open Office conversion of JDales excel charsheet
Post by: arakish on April 12, 2013, 09:33:04 AM

Or, try using Quattro Pro X6.  I have found that it imports Excel 2007 or before sheets rather well.  Then save it as QPW file.  Reopen the QPW file, then save as an ODS file.  It has worked for me for files other than the charsheet.  Let me hunt down the files when I get home over the weekend.  I no longer have home internet service since even the cheapest ISP where I live wants a minimum of $120 a month.  Then add all the FCC fees, charges, and taxes, and that $120 becomes about $230 a month.

If I can't find them, I'll do what I said above and upload the results.

rmfr

Title: Re: Open Office conversion of JDales excel charsheet
Post by: arakish on April 12, 2013, 09:40:03 AM

Is this the sheet you are asking about?

http://www.ironcrown.com/ICEforums/index.php?action=tpmod;dl=item78 (http://www.ironcrown.com/ICEforums/index.php?action=tpmod;dl=item78)

It is the only one I found by JDale.

rmfr

Title: Re: Open Office conversion of JDales excel charsheet
Post by: jdale on April 12, 2013, 11:33:57 AM

That's it, or it's also on http://www.madreporite.com/rpg/rm.htm (http://www.madreporite.com/rpg/rm.htm)

I'm afraid I used a lot of VB and ActiveX components so it wouldn't surprise me if it doesn't convert well. The formulas on the sheet should probably be ok, but the dialog boxes and related functionality (e.g. for adding training packages) may be more challenging.

Title: Re: Open Office conversion of JDales excel charsheet
Post by: arakish on April 17, 2013, 09:47:43 AM

Have you tried looking at the OOo ODT and ODS by allenmaher?

http://www.ironcrown.com/ICEforums/index.php?action=tpmod;dl=item558 (http://www.ironcrown.com/ICEforums/index.php?action=tpmod;dl=item558)

rmfr

Title: Re: Open Office conversion of JDales excel charsheet
Post by: arakish on April 17, 2013, 09:49:04 AM

Quote from: jdale on April 12, 2013, 11:33:57 AM

I'm afraid I used a lot of VB and ActiveX components so it wouldn't surprise me if it doesn't convert well. The formulas on the sheet should probably be ok, but the dialog boxes and related functionality (e.g. for adding training packages) may be more challenging.

And I did try the method I mentioned.  It did not work.  Sorry, netbat.  However, see post directly above.

rmfr

Title: Re: Open Office conversion of JDales excel charsheet
Post by: netbat on April 19, 2013, 06:55:07 PM

Thanks, I will take a look and see if it will be easier to convert it to RMSS or try to convert jdales to OO or use one of the other sheets. Jdales sheet is the one I have used most and like the best, but having moved to Macs only in the house I might have to give it up.