Spreadsheet annoyance no. 3: quotes have priority

Posted by Bob_Mesibov on Jan 20, 2021 2:46 AM EDT
BASHing data; By Bob Mesibov
Mail this story
Print this story

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

  Nav
» Read more about: Story Type: Tutorial

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.