Advanced

On dates and stuffed non-dates

Posted by eldersnake on · Post a comment
The Linux Rain; By Bob Mesibov 		Mail this story
Print this story

Nothing gives my wife the Screaming Meemies like dates in spreadsheets. Unless she formats the target cell in advance as text, the spreadsheet will turn a perfectly innocent, non-date string like 23/2/6 into '23-Feb-2006'. When she types 6420-11-3, according to both LibreOffice Calc and Gnumeric, she really meant 3 November 6420. And nothing she can do will persuade the spreadsheet to re-format '23-Feb-2006' as 23/2/6. Once a date, always a date. Our house regularly echoes with "I HATE spreadsheets!". But there are workarounds...

Full Story

  Nav
» Read more about: Story Type: Editorial, Tutorial; Groups: GNU, Linux, OpenOffice.org

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

« Return to the newswire homepage

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