GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by DaltonS

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.

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

Originally Posted by DaltonS

Also, there is no "Saved Ships 1" button on any but the saved ship sheets.

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.

Originally Posted by DaltonS

Was that not enough to raise the RC number? ;)

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

Originally Posted by loofou

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

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.

Originally Posted by loofou

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?

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.