02-19-2017, 09:59 AM | #821 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
02-19-2017, 11:00 AM | #822 | |
Join Date: Dec 2014
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
But funny enough my second PC has the exact same problem with the sheet and that does not even have a german kb layout. Everything was set to UK from the beginning. Maybe Excel has it's own regional settings somewhere, I need to check this. [EDIT] Indeed Excel has it's own settings and for some reason those were set to really weird values. I don't know how I never noticed that! I set it to the correct values and most of the problems with the sheet are gone. I tested the RC10 and could use it quite nicely. Now we still need to figure out why the macros throw errors after RC 10 (need to confirm later which update it was exactly that broke the macros) Last edited by loofou; 02-19-2017 at 11:08 AM. |
|
02-19-2017, 11:14 AM | #823 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
I've done some significant updates in the macros since RC10, almost completely rewriting them. If you let me know what the specific error is and when it's coming up I may be able to figure something out.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
02-19-2017, 01:13 PM | #824 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Version 2.0 Release Candidate 17
-A couple minor bug fixes -Added a rudimentary Regional Setting detection to the Office 2007 version. --This checks the Regional Settings for Excel itself the first time the file is opened and if you are not using custom settings which set a . as the decimal separator and , as the thousand separator it offers a dialog to set these for you (this means even if you are using Windows Default Settings, and Windows Default Settings use these, you'll still get the dialog; AFAIK there is no way for me to check the Windows Default Settings to suppress the dialog). --This dialog only shows up the first time you open the file and only if it detects you are not using the compatible settings. "First time" resets if you use Save As to save the file; the next time you open it after Saving As will be treated as the first time. You can download the spreadsheet here: Excel 2000 (RC17) http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (5.1 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (~2.5 MB) Excel 2007 (RC16) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (~6.3 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (~6.2 MB) OpenOffice 3.3.0 (RC9) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (~2.1 MB) http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (~1.9 MB)
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 02-19-2017 at 06:16 PM. |
02-19-2017, 01:48 PM | #825 | |
Join Date: Dec 2014
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
I hope it helps in finding the errors: https://www.dropbox.com/s/c85b673hs5...video.mp4?dl=0 |
|
02-19-2017, 02:37 PM | #826 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
I just uploaded another version of v2.0RC17. This one, I hope, will fix the issue where the Save Sheets aren't showing any ships in them. This should also fix some of the issues you had with the Load Next Ship button, since that relies on loading the next visible ship in line from the target Save Sheet as well as the issue with the Save Ships portion of the Output sheet.
If not can I get you to Save the sheet and upload it again so I can suss out more errors?
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
02-19-2017, 03:16 PM | #827 |
Join Date: Dec 2014
|
Re: GURPS Spaceships Design Spreadsheet
Yes, the ship lists seem to work now (but the filters are not, or I am using them wrong, I don't know). Systems popup is still empty and some of the error messages still appear. The HTML output column is also still broken and clicking the Design Table macro button brings me to the Unofficial Ships list.
I also resaved the file: https://www.dropbox.com/s/hloc490hw3...Copy.xlsm?dl=0 We are getting there :) |
02-19-2017, 04:04 PM | #828 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Yes we are. The most frustrating part of this is that these aren't generating issues in Office 2000 or 2007, but I can see the errors frozen in the version of the sheet you save so long as I don't recalculate the sheet. As soon as I let it recalculate the errors clear, which makes it difficult to do more than a fix or two at a time because I need to get past one error to see if there's another. So I just uploaded another fix for the Save Sheets which will hopefully get those and the output sheet working correctly now.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
02-19-2017, 08:49 PM | #829 | |
Join Date: Dec 2016
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
|
|
02-19-2017, 11:31 PM | #830 | ||
Join Date: Dec 2014
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
Btw: Thank you for your hard work on this :) [EDIT] There is still the Sheet Size Error 1004 (when using the Zoom or Resolution buttons in the Design Table). Popups for the Ship Systems are empty on start, but as soon as you load a ship and reset, they work fine. Output seems also to be fixed. Only minor stuff remains :) Latest resave: https://www.dropbox.com/s/i7vu6sm6cl...0220.xlsm?dl=0 Last edited by loofou; 02-20-2017 at 12:57 PM. |
||
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|