[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Funny this... If I just open a new file (csv) it imports ok If I try to add a sheet to an existing file ( My Vat template) the dates are shifted forward two days. So I have something wrong with the Template file This template is 7 years old, time to create a new one I think. Thanks for this I would have spent hours working it out. On Sat, 2010-11-13 at 11:57 +0000, Henry Bremridge wrote: > 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) > > Regards Kevin Lucas Minions Post Master(Sub) Ten Years in the Making! www.minionsbandb.co.uk www.tearooms.minionsbandb.co.uk Po House, Minions, Liskeard Cornwall PL14 5LE 01579363386 -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq