The Automatic data type converts data entered in a cell to the most appropriate data type. Similar to the default behavior of traditional spreadsheets, Automatic is the default data type for cells in Spreadsheet.com.
Automatic maps data (like "1/1/2020") to its corresponding data type (a date). Automatic is useful if you have a column with different types of data in it. As Automatic is more than just a catch-all data type, it recognizes your data and attempts to map it to the best data type for you. If you'd prefer, you can also set or change the data type of any cell, column, or range of cells to something other than Automatic.
Automatic Maps New Data to the Matching Data Type
New cells and columns default to the Automatic data type, unless the Automatic data type has detected and mapped a different data type for that cell. For instance, in the example below, entering data that looks like an email address or date causes the Automatic data type to change that cell's data type to Email and Date. Automatic can also map to Number, Currency, and URL.
When Automatic maps cells to new data types, Spreadsheet.com does not change the data type of other cells in that row and column.
Similarly, if you copy a range of data into Spreadsheet.com, Automatic may recognize the data in each cell and map to each cell's corresponding data type.
Check out all of Spreadsheet.com's data types in our Introductions to Data Types article.