View Single Post
Old 02-19-2017, 09:59 AM   #821
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by loofou View Post
About the , and . issue: My windows is set up to UK settings, but my keyboard uses the German layout. I had problems in the past with the decimal points being commas, so I set my region to UK with decimal dots. It might still be related, though, I'll investigate further on another machine with complete native UK settings for everything and see if this changes anything.
In the sheet you uploaded I see multiple places where a text string conversion of a number which should be outputting a "0" is outputting a ",0" which makes me seriously suspect regional setting issues. Most of those text strings are set up to output numbers as text in the "#,##0" format, so with a regional separator of a comma it's going to interpret that comma as the decimal separator and output ",0"
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
I shall pull the pin from this healing grenade and...
Kaboom-baya.
ericbsmith is online now   Reply With Quote