Advanced

Spreadsheet annoyance no. 3: quotes have priority

Posted by Bob_Mesibov on · Post a comment
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

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments

No comments yet. Be the first.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post