05-09-2021, 08:10 PM | #991 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Older versions of Excel had some memory issues with doing this with large sheets (which this is). So what you can do is delete all of the sheets from the older spreadsheet except for the Saved Ships Sheet before opening it (I recommend saving it to a new file at this point, closing it, then reopening it). Once you've opened both spreadsheets you will need a Saved Ships sheet with enough room to import all of the ships; you can either create a new Saved Ships sheet or delete all of the ships from within the Official or Unofficial Ships sheets. Once you have that, you can click the Import Saved Ships button in the Saved Ships sheet, and it will ask you which file you're importing from, which Saved Ships sheet in that file you're importing from, and which Saved Ships sheet in the current spreadsheet you're importing to. Let me think on that.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|
05-10-2021, 09:06 AM | #992 | |
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Dalton “Happy Mother Ocean Day!” Spence
|
|
06-12-2021, 03:53 PM | #993 |
Join Date: Dec 2016
|
Re: GURPS Spaceships Design Spreadsheet
RC 33 bug report:
Fabricator, Robofac and nanofactories have the same output. The exact same |
06-13-2021, 11:06 PM | #994 |
On Notice
Join Date: Aug 2004
Location: Sumter, SC
|
Re: GURPS Spaceships Design Spreadsheet
How well do these work with LibreOffice?
__________________
Help make a digital reference for GURPS by coming to the GURPS wiki and provide some information and links (such as to various Fanmade 4e Bestiaries) . Please, provide more then just a title and a page number. |
09-27-2021, 07:05 PM | #995 |
Join Date: Mar 2021
|
Re: GURPS Spaceships Design Spreadsheet
So I've tried to use the thing with Google Sheets and
First of all, it hogs all my computing power up. I have to wait sometimes minutes for a single dropdown list. But second, and more annoyingly, is that I can't input a SM because I keep getting a data validation error |
09-27-2021, 08:48 PM | #996 |
Join Date: May 2020
Location: Winnipeg, Canada
|
Re: GURPS Spaceships Design Spreadsheet
I haven't had much luck with the OpenOffice version of the spreadsheet in LibreOffice on my Macbook. In many cases multiple lines of text are jumbled together on a single line. Haven't tried it in LibreOffice on a Windows PC, so the issue might be limited to my own system.
Last edited by sparcipx; 09-27-2021 at 08:48 PM. Reason: Typo |
09-28-2021, 04:59 AM | #997 |
Join Date: Jun 2007
Location: USA, Arizona, Mesa
|
Re: GURPS Spaceships Design Spreadsheet
|
09-28-2021, 08:29 AM | #998 | |
Join Date: Mar 2021
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
So can we get a google sheets version? |
|
09-28-2021, 08:37 AM | #999 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Not likely. The sheet was written exclusively in Excel. The fact that I got it to work in an older version of OpenOffice was almost a miracle. I have no desire to try to get it working with Google Sheets.
I haven't even looked at the OpenOffice versions in a long time, but there were some serious issues which I remember identifying with the newer versions of OpenOffice/LibreOffice and started to address in the Excel Macros. If I had ever ported it back over to OpenOffice/LibreOffice again it would have run much better in newer versions of those suites. Unfortunately, the amount of work that would have taken got to be more and more as time went on and I never got around to doing another port. My best advice is to try to get your hands on an older version of OpenOffice, specifically v3.2 which is what I developed the port for. It worked on OpenOffice v3.4.x and LibreOffice v4, but was slow. On newer versions than those I believe it had some serious issues with the Macros that caused it to be very slow.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
09-28-2021, 12:39 PM | #1000 | |
Join Date: May 2020
Location: Winnipeg, Canada
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
|
|
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|