LXer: Spreadsheet annoyance no. 3: quotes have priority
by LXer from LinuxQuestions.org on (#5D2C6)
Published at LXer:
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.
Read More...
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.
Read More...