Published at LXer:

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...

Read More...