D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

[LUG] OO spreadsheet and dates

 
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)

this is 10 days of data save it as csv and Insert sheet from file

"Date","supplier","reference","vat_zero","vat_1","vat_2","vat_exempt","vat_paid","category"
"2010-08-01","Piran & Petroc","010810",28.34,0.00,0.00,0.00,0.00,"Deli"
"2010-08-01","Chaple Bakery","we010810",360.18,0.00,0.00,0.00,0.00,"Bread & Cakes"
"2010-08-01","Cornish Linen Services","193112",0.00,7.84,0.00,0.00,1.37,"Repairs & Maint"
"2010-08-01","Barclaycard","25448365",2.74,20.41,0.00,25.66,3.57,"Administration"
"2010-08-01","Barclaycard","25448365",0.00,-13.56,0.00,0.00,-2.37,"Top-up Commission"
"2010-08-01","Barclaycard","25448365",0.00,0.00,0.00,510.00,0.00,"top-ups"
"2010-08-02","Continental Fruits","4192",13.40,0.00,0.00,0.00,0.00,"Fruit & Veg"
"2010-08-03","Miles ","151573",49.20,0.00,0.00,0.00,0.00,"Deli"
"2010-08-03","Cornish Cottage Bakeries","121669",33.93,0.00,0.00,0.00,0.00,"Bread & Cakes"
"2010-08-03","Kerry Foods","809798",11.26,13.92,0.00,0.00,2.44,"Chilled Food"
"2010-08-03","Rodda & Son","213734",4.57,0.00,0.00,0.00,0.00,"Deli"
"2010-08-03","Higher Redwood Farm","0071",7.50,0.00,0.00,0.00,0.00,"Dairy"
"2010-08-03","Post Office","1559519",0.00,0.00,0.00,86.32,0.00,"Stamps"
"2010-08-04","Cornish Farmhouse","304236",13.39,142.44,0.00,0.00,24.93,"Ice Cream"
"2010-08-04","J C Hams","0004",60.31,0.00,0.00,0.00,0.00,"Deli"
"2010-08-04","Continental Fruits","4242",17.50,0.00,0.00,0.00,0.00,"Fruit & Veg"
"2010-08-04","Martins Cash & Carry","924826",151.15,488.06,7.99,0.00,85.81,"Split"
"2010-08-04","Martins Cash & Carry","924905",7.99,0.00,0.00,0.00,0.00,"Deli"
"2010-08-04","Martins Cash & Carry","924733",0.00,327.28,0.00,0.00,57.27,"Tobacco"
"2010-08-04","Higher Redwood Farm","0072",15.00,0.00,0.00,0.00,0.00,"Dairy"
"2010-08-04","Divine Earth Soap","0092",39.00,0.00,0.00,0.00,0.00,"Gifts"
"2010-08-05","Hawkridge Farmhouse","175141",33.35,0.00,0.00,0.00,0.00,"Deli"
"2010-08-05","Walkers","7681002",0.00,23.06,0.00,0.00,4.04,"Snacks & Drinks"
"2010-08-05","trevalan Organics","0057",2.25,0.00,0.00,0.00,0.00,"Fruit & Veg"
"2010-08-05","Bobbys","104-0284",9.76,29.35,0.00,0.00,5.14,"Snacks & Drinks"
"2010-08-05","Bodmin Moor Meats LTD","050810",60.52,0.00,0.00,0.00,0.00,"Deli"
"2010-08-05","Cornwall CC","CCES080978",0.00,112.75,0.00,0.00,19.73,"Waste disposal"
"2010-08-06","Continental Fruits","4303",40.74,0.00,0.00,0.00,0.00,"Fruit & Veg"
"2010-08-06","Robert Wiseman Dairies","51772307",103.22,0.00,0.00,0.00,0.00,"Dairy"
"2010-08-07","Chaple Bakery","we070810",342.52,0.00,0.00,0.00,0.00,"Bread & Cakes"
"2010-08-07","Rodda & Son","216748",4.20,0.00,0.00,0.00,0.00,"Deli"
"2010-08-07","Kerry Foods","809837",28.68,0.00,0.00,0.00,0.00,"Chilled Food"
"2010-08-09","Higher Redwood Farm","0076",15.00,0.00,0.00,0.00,0.00,"Dairy"
"2010-08-09","CPL","3125",0.00,0.00,44.71,0.00,2.24,"Fuel Sales"
"2010-08-09","Continental Fruits","4355",43.73,0.00,0.00,0.00,0.00,"Fruit & Veg"
"2010-08-09","Higher Redwood Farm","0075",7.50,0.00,0.00,0.00,0.00,"Dairy"
"2010-08-09","Mr P ALee","0015",27.05,0.00,0.00,0.00,0.00,"Grocery"
"2010-08-10","J C Hams","0024",50.99,0.00,0.00,0.00,0.00,"Deli"
"2010-08-10","W H S","we080810",470.13,22.86,0.00,0.00,4.00,"News & Mags"
"2010-08-10","W H S","DeliveryCharge",32.63,0.82,0.00,0.00,0.14,"Administration"
"2010-08-10","W H S","we310710",674.30,2.78,0.00,0.00,0.49,"News & Mags"
"2010-08-10","W H S","DeliveryCharge`",33.38,1.84,0.00,0.00,0.32,"Administration"
"2010-08-10","Piran & Petroc","100810",26.84,0.00,0.00,0.00,0.00,"Deli"
"2010-08-10","Rodda & Son","216793",76.00,0.00,0.00,0.00,0.00,"Deli"
"2010-08-10","Kerry Foods","809856",38.02,13.92,0.00,0.00,2.44,"Chilled Food"
"2010-08-10","Cornish Cottage Bakeries","121708",39.26,0.00,0.00,0.00,0.00,"Bread & Cakes"


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

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