Spreadsheet data types

[wojciechczerniak]

⚠️ WIP

Description

There are four data types recognized by spreadsheet software [4]:

• Logical (aka Boolean): TRUE and FALSE
• Number: integer, float but also percentage, date, time and duration (which is tricky [1])
• Label (aka String)
• Array
• Error

4.1 General

• 4.2 Text (String)
• 4.3 Number
  • 4.3.1 General
  • 4.3.2 Time
  • 4.3.3 Date
  • 4.3.4 DateTime
  • 4.3.5 Percentage
  • 4.3.6 Currency
  • 4.3.7 Logical (Number)
• 4.4 Complex Number
• 4.5 Logical (Boolean)
• 4.6 Error
• 4.7 Empty Cell
• 4.8 Reference
• 4.9 ReferenceList
• 4.10 Array
• 4.11 Pseudotypes
  • 4.11.1 General
  • 4.11.2 Scalar
  • 4.11.3 DateParam
  • 4.11.4 TimeParam
  • 4.11.5 Integer
  • 4.11.6 TextOrNumber
  • 4.11.7 Basis
  • 4.11.8 Criterion
  • 4.11.9 Database
  • 4.11.10 Field
  • 4.11.11 Criteria
  • 4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence)
  • 4.11.13 Any

References:
[1] https://stackoverflow.com/questions/17715841/how-to-read-the-correct-time-duration-values-from-google-spreadsheet
[2] http://www.hep.by/gnu/gnumeric/sect-data-types.shtml
[3] https://help.gnome.org/users/gnumeric/stable/quick-data.html.en
[4] https://support.office.com/en-us/article/TYPE-function-45B4E688-4BC3-48B3-A105-FFA892995899
[5] https://help.gnome.org/users/gnumeric/stable/sect-configuration-localization.html.en
[6] https://support.office.com/en-us/article/Data-types-in-Data-Models-E2388F62-6122-4E2B-BCAD-053E3DA9BA90
[7] https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Infix_Operator_MINUS
[8] https://www.ablebits.com/office-addins-blog/2014/12/10/excel-not-equal-to-greater-than-less-than/

[wojciechczerniak]

This issue is no longer needed. Most of the types are implemented and the remaining Array #131 and Complex Number #281 have their own detailed issues.