Re: GURPS Spaceships Design Spreadsheet
 

A couple of bugs I've noticed recently:

1. Ever since I added a "Saved Ships" sheet for my own ships, whenever I use a top row button to get to another sheet I end up there. I have to use the sheet tabs to get the one I want.
2. I tried to add a "Vehicle Dock" as a "Smaller System" and got a recursion error message. The "Vehicle Dock" name ended up in the sub-system name cell but without showing any stats, joining with a following small "Vehicle Dock" or adding to the hull section's auxiliary vehicle space.

Re: GURPS Spaceships Design Spreadsheet
 

All of them? Or just the Save Sheets buttons? I'm not even sure how it's possible for all of them to stop working. The only ones that change target destination are the Design Table and Save Sheet buttons, the other buttons are set up to target specific tables.


This one I figured out where the error lies and I'm re-uploading RC17 with this error fixed.

Re: GURPS Spaceships Design Spreadsheet
 

Unfortunately I don't have the foggiest idea what's causing this error. I've made a few changes that may help with this, but it may not, as I'm just guessing right now.

Note that these are supposed to be blank until you input a ship SM & TL, because without knowing the SM & TL of the ship it's impossible to know what systems are available and which must be filtered. Do Ship System drop-down menus stay blank even after you set ship SM & TL? If they do can you set SM & TL and then save me a copy of the sheet?

Re: GURPS Spaceships Design Spreadsheet
 

Using the latest version, with Excel 2007, the cell (BB23, Design Table) in which one is supposed to manually enter a ship length claims it's protected. EDIT: I was trying to enter the number in the wrong cell. Ignore this bug.


Also, and this has never worked for me, the 'Electro-Mechanical Computers' option doesn't change the complexity of the Control Room computer. Note that 'Advanced Computer' (the Transhuman Space option) does.

Re: GURPS Spaceships Design Spreadsheet
 

Only the top row "Design Table" button redirects to the "Saved Ships 1" sheet, but it does this from any sheet except the "Design Table" one. Also, there is no "Saved Ships 1" button on any but the saved ship sheets.
And yet ...
Was that not enough to raise the RC number? ;)

Re: GURPS Spaceships Design Spreadsheet
 

Well, according to the microsoft documentation this has something to do with resizing cells with text inside. Their recommended fix/workaround is to set font size of the cell to 2 and back to the original font size after the resize.

If I would put workarounds like that into production code, my boss would kill me xD

From reading the documentation I don't really get why they throw this error in the first place. It feels more like a warning if anything. I mean if I want to resize a cell to a size where the text does not fit in anymore, I should be able to do that?

Latest resave if needed: https://www.dropbox.com/s/qgo2w8clkw...0221.xlsm?dl=0

Re: GURPS Spaceships Design Spreadsheet
 

I don't know how that could happen. It literally shouldn't happen at all.

That is normal. I'm just running out of room for buttons. However, if you want you can grab the tab at the bottom of the sheet and reorder the Saved Ships sheet tabs and the left-most two should appear on buttons on all other sheets.



Since I went back- and-forth with several small fixes I just updated RC17 rather than updating the RC number.

The thing is, the zoom function doesn't change cell sizes at all (except the 75%, which may force the resolution to bump up from the lowest, since there's an issue with 75% zoom and the 800px res). What is getting resized is the checkboxes across the top section of the sheet, and I can force the 1004 error to pop up there - but only if I am trying to resize a checkbox on a sheet that is not currently active, which shouldn't be happening since the resolution only changes the column width and checkbox widths in the active sheet.


In fact, you can do that. Excel doesn't have a problem with you making cells so small that text doesn't fit. Like I said, I'm not sure why exactly it's pitching this error, especially for you but not for me.

Re: GURPS Spaceships Design Spreadsheet
 

Well, if I'm the only person with this error - and actually it does not seem to prevent anything from happening - and the rest of the sheet works fine, then don't sweat it! You already did quite a lot to make the sheet work better on newer Excel versions.

Maybe if I have some time on the weekend, I'll go into the macros and do some brute force debugging to find out which line is causing the issue.

Re: GURPS Spaceships Design Spreadsheet
 

Well it does, and still is. Not a big problem; that top row of buttons isn't really needed since the sheet tabs can be used. (Maybe a drop-down list control would work instead.)

Some "Auxiliary Craft" Questions:

1. What is the purpose of the "Auxiliary Craft" sheet, and how do I use it? I tried to load a cargo lighter I designed there from my "Saved Ships 1" sheet, but nothing showed up on the ships list for that sheet.
2. I noticed that a non-superscience ship can't have TL^ auxiliary craft. Is that filter really necessary? Shouldn't size be the only qualifying factor?

Re: GURPS Spaceships Design Spreadsheet
 

Sorry for the long delay.
Just want to say that so far, it has worked like a charm! thanks! Everything works!

Edit: I take it back... I spoke too soon, I have to mark the "Don't filter system by SM"... And the automatic calculations doesn't seem to take effect once I choose a system