Entering data: Entering numbers, text strings, date/time strings and error codes

GS-Calc recognizes and uses the following basic data/cell types:

TypeExamplesComments
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
Min. positive value: 2.2250738585072014eľ308
Precision: up to 15 digits

Text strings abc
abc def
123

Use the Edit > Convert commands to convert numbers to text strings, and vice versa.

When editing a cell you can force GS-Calc to treat the entered data as a text label by pressing and holding down the SHIFT key before pressing ENTER.

GS-Calc automatically converts text strings to numbers in formulas that require numeric arguments, however such text strings must represent unformatted numbers with a period (.) as a decimal separator. For example:
="1.5" + 1
is a valid formula but
="1,500.00" + 1
will return the #NUM! error.

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 (one year, 2 months, 3 days, 10 hours 30 minutes, 60 seconds, 0 miliseconds)
P2M4D
-P120D
PT23H34M

Date/time/period values can be specified either as date/time 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 of that value represents days and the fractional part represents the time of the day. The value 1.0 represents December 31, 1899. Negative numbers represent dates prior to December 30, 1899.

A generic date/time string is a string that conforms to the www.w3.org specification for date/time/period data types.

For more information about using date/time/period strings as an alternative for serial numbers please see the Formula Composer window and the included samples.

Note:To maintain maximum portability, you should date serial numbers as currently most of other spreadsheet applications use that method of date/time encoding.

Arrays

A four-element 2x2 arrays:

{1, 2; "abc", "def"}

{1.00e+10; 2.00e+10; #N/A!; true}

Array elements can be unformatted numbers, text strings, Boolean values or error codes.

Generic (system-independent) GS-Calc settings activated with the Settings > Locales > Generic command require commas to separate columns (,) and semicolons (;) to separate rows.
If you choose to use the system regional settings and if your system requires commas to be used as decimal separators, use semicolons (;) to separate columns and backslashes (\) to separate rows.

Boolean values true ( = 1 )
false ( = 0 )
 
Error codes
#DIV/0!Division by 0
#NAME?An invalid name was found in the specified formula
#NULL!The returned result is an empty intersection or an empty array
#N/A!No data/result available
#NUM!Invalid number, overflow or underflow
#REF!Invalid cell/range reference:
(+) a column or row number out of range,
(+) an array (result) exceeding worksheet dimensions,
(+) a non-existing worksheet or workbook,
(+) an inaccessible file/workbook
#VALUE!Invalid argument type or too long text string
#IMPL!The specified function is not yet implemented but the name is reserved for future use
#SYNTAX!Syntax error: incorrect number of arguments, missing parenthesis etc.
Error codes can be returned by formulas or can be entered 'as is'.