1. Overview
GS-Calc recognizes and uses the following basic data/cell types:
| Type | Examples | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Numbers |
123 -123 123.09 1.23e+02 |
The actual decimal and thousand separators depend on your system regional settings and the current Settings > Locales menu selection.
Max positive value: 1.7976931348623158e+308 |
||||||||||||||||||
| Text strings |
abc abc def 123 |
Use the Edit > Convert commands to convert numbers to text strings, and vice versa. To force GS-Calc to treat entered data as a text label, press and hold SHIFT before pressing ENTER. GS-Calc automatically converts text strings to numbers in formulas requiring numeric arguments, but only if they represent unformatted numbers using a period (.) as the decimal separator.
Example: |
||||||||||||||||||
| Date/Time strings Period strings |
Date/Time: 2006-01-31 2006-01-31T13:10:55 2006-01-31T13:10:55.123 2006-01-31T23:30:00+02:00 13:10:00 13:10:55.123 13:10:55-00:30 Periods: P1Y2M3DT10H30M60S.000 P2M4D -P120D PT23H34M |
Date/time/period values can be specified either as serial numbers or as generic date/time/period strings. A date/time serial number is a floating point value representing a date between January 1, 100 and December 31, 9999. The integer part represents days; the fractional part represents time of day.
1.0 represents December 31, 1899. A generic date/time string must conform to the www.w3.org specification. For more information, see the Formula Composer window and included samples. Note: To maintain maximum portability, you should use date serial numbers. |
||||||||||||||||||
| Arrays |
A four element 2x2 array: {1, 2; "abc", "def"} {1.00e+10; 2.00e+10; #N/A!; true} |
Array elements may be unformatted numbers, text strings, Boolean values, or error codes.
With Settings > Locales > Generic:
With system regional settings using comma as decimal separator: |
||||||||||||||||||
| Boolean values |
true (= 1) false (= 0) |
|||||||||||||||||||
| Error codes |
|
Error codes may be returned by formulas or entered directly. |