Spreadsheet annoyance no. 3: quotes have priority
Spreadsheets confuse non-dates with dates, and automatically interpret certain number strings with 2 colons as [h]:mm:ss. Grrr. I've now found another example of spreadsheets doing unexpected things with plain-text data. By default, spreadsheet programs see quotes (") as string delimiters. If there's a quote at the start of a data item but none at the end, the results are... interesting.
|
|
Full Story |
This topic does not have any threads posted yet!
You cannot post until you login.