|
Post by reeftrigger on Jul 19, 2010 13:11:48 GMT -5
Having just bought the Colonial Battlefleet rules yesterday, you could consider me somewhat inexperienced with this stuff. I loaded up the Colonial Shipyard in OpenOffice (Open source excel basically) and the clear and save buttons don't work. I am aware that there are some problems with this and win 7, and I want to be able to save my class designs. Is there any good workaround to be able to fix this?
|
|
kashre
Lieutenant Commander
Posts: 110
|
Post by kashre on Jul 19, 2010 13:16:15 GMT -5
I had the same problem... so I just save each design as it's own spreadsheet.
|
|
|
Post by reeftrigger on Jul 19, 2010 14:08:18 GMT -5
How does that work with printing? Does it still show up in the same format as the datacards in the book?
|
|
|
Post by kenh01 on Jul 19, 2010 16:31:27 GMT -5
Hi guys,
The problem is that the buttons are actually Macros which in excel are done in Visual Basic for Aplications. These are NOT compatable with open office which uses another language for their macros. As I do my programing in VB and don't know the open office version, the spreadsheet macros will only work in Excel
Sorry
Ken
|
|
|
Post by reeftrigger on Jul 19, 2010 16:36:51 GMT -5
Blaaa. Are there any plans for a standalone application for colonial shipyard? I don't really want to pay Microsoft for office 2010, and I'm no pirate. I could see making an app being pretty easy considering that all the relationships between the different parameters are already laid out in the spreadsheet. Then you could get it to export to a database contained in a .txt file, and solve all the worlds problems.
|
|
|
Post by TheDreadnought on Jul 19, 2010 17:58:12 GMT -5
Just save the Colonial Shipyard app each time with the specific design. Throw them into a designs folder with the the file re-named to the design it contains. Then you can open it back up and re-edit it anytime.
|
|
|
Post by kenh01 on Jul 20, 2010 7:53:09 GMT -5
All the save ship button is doing is copying the data line at A101 to the saved class sheet and doing a sort! If you want to do this yourself its not that hard. You should do a paste as/values so you don't copy the formula to the class sheet
The Clear button is more complex as it is resetting the dropdown boxes as well as blanking the plain imput cells, so be carfull you don't delete a formula or dropdown.
Ken
|
|
|
Post by Cougar_DK on Jul 27, 2010 6:24:14 GMT -5
We use the Novell Edition version 3.1.0 here at work and that version has NO problems converting the Excel sheet to Open Office.....
Maybe I could save it in OO format and some of you could test it out?
Cheers Mark
|
|
|
Post by kenh01 on Jul 27, 2010 10:01:53 GMT -5
Mark
I would love to know if that works. Have you tested the save class, edit class and clear sheet buttons? That is what causes the problems as they are macros, all the rest is just formulas which openoffice handles fine (in most cases)
Ken
ps - emailing a spreadsheet with a macro will usually strip the macro from the spreadsheet! virus programs think it is a virus.
|
|
|
Post by Cougar_DK on Jul 28, 2010 1:16:33 GMT -5
It looks like it work in OO3.2 when saved from a Novell 3.1. I can save, edit and clear.
And zipping/raring the file up should remove the macro risk.
|
|
|
Post by Cougar_DK on Jul 28, 2010 1:18:52 GMT -5
But not trying to step any toes here.... So please advice what would you like us to do 'TheDreadnought'?
|
|
|
Post by TheDreadnought on Jul 28, 2010 10:37:14 GMT -5
Ken - What do you think? Should we just replace the shipyard file in the dowloads? Or add an "Open Office Compatible" version?
Cougar - Were you working with the Shipyard v2.0?
|
|
|
Post by kenh01 on Jul 28, 2010 11:48:41 GMT -5
First, test the email as I have found that most virus scan pgms will strip the macros even if you zip the file. If it still works (or even if it doesn't, you can always have him get the file to you the same way I do Harry) I like the 2 versions, Excel and OO.
Ken
|
|
|
Post by reeftrigger on Jul 28, 2010 17:51:50 GMT -5
It would be really great if you guys to get this to work! I feel like I need to go and make a bunch of ships now lol.
|
|
|
Post by Cougar_DK on Jul 29, 2010 6:07:54 GMT -5
Cougar - Were you working with the Shipyard v2.0? Yes its the version 2.0. And if i were you I would make both available. You should try the OO variant and see that its like YOU want it. I will gladly help converting the 2.x files to OO when you have made changes to your Excel files
|
|
|
Post by Cougar_DK on Jul 29, 2010 6:09:00 GMT -5
And I have access to my private FTP, so I could always put it there for you!
Its up to you, just glad I can help!
|
|
|
Post by reeftrigger on Aug 5, 2010 0:01:37 GMT -5
I'm using OO 3.1 and I think I found a solution to *some* of the problem. it looks like this setting would fix it... Tools->Options->Load/Save->VBA Properties Default one of the boxes is unticked. Tick it. For me that made the save and clear buttons function as intended, though the Edit still doesn't work. BTW how is the edit supposed to work?
|
|
|
Post by kenh01 on Aug 5, 2010 7:31:17 GMT -5
Hey reeftrigger
The save and clear buttons are recorded macros attached to a hotspot and are doing only 'normal' excel functions. On the other hand, the Edit button is a VBA program that asks for the number of a previously saved ship and reloads it into the editor. The first could be made usable in OO the way you said, but the Edit macro uses non-excel functionality that your method is unable to handle.
Ken
|
|
|
Post by Cougar_DK on Aug 6, 2010 12:42:35 GMT -5
I have a full OO version of the version 2 working. The property for the edit button was the real problem, easy solved by a manual edit so it calls the macro. Every buttons work now
|
|
|
Post by pixelgeek on Oct 1, 2010 14:50:46 GMT -5
Is there somewhere that we can download the OO version of the file?
|
|