Entering data: Entering numbers, text strings, date/time strings and error codes |
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. 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: |
|||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||
Boolean values |
true ( = 1 ) false ( = 0 ) |
||||||||||||||||||||||||||||
Error codes |
|
Error codes can be returned by formulas or can be entered 'as is'. |