Re: [LUG] OO spreadsheet and dates

[Henry Bremridge <henry.bremridge@xxxxxxxxx>]

On Sat, Nov 13, 2010 at 11:30:29AM +0000, kevin wrote:
> help on a Bug in OO spreadsheet
> 
> Can any of the Dc luggers please test this data for me in OO spreadsheet
> its just a csv file with dates and currency amounts.
> The date is in yyyy/mm/dd format (for Mysql)
> 
 
> If I use "Insert sheet from File" and select this csv file the Date,
> when shown in OO spread sheet moves forward 2 days Ie it starts on  the
> 3rd day not the 1st?  This happens on three separate Machines with
> versions 2 to 3 Open Office
> 
> Please advise if you get the right or wrong dates in the Date column 

Right dates

OpenOffice.org 3.2.1 
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Debian package 1:3.2.1-7

Imported two ways

1)  Open File, csv (under the spreadsheet sub-menu)
2)  Insert file as csv (under the spreadsheet sub-menu)


-- 
Henry
Photocopies or faxes of my signature are not binding. 
This email has been signed with an electronic signature in accordance with 
subsection 7(3) of the Electronic Communications Act 2000.
Digital Key Signature: GPG RSA 0xFB447AA1 
Sat Nov 13 11:56:51 GMT 2010

Attachment: signature.asc
Description: Digital signature

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq