2008/10/7 Martin Fulgueiras <[EMAIL PROTECTED]> > Hi there, > > Today working with spreadsheets i found what seems to be a big problem. For > some strange reason everytime I right clicked on a tab at the bottom in > order to copy it into another, new, spreadsheet (new book I mean), the info > on the dates changed the year from 2008 to 2004. Strangely sometimes it also > changed the month. The weird thing is that it didn't do it constantly, but > to some entries and couldn't figure out why. (this on the last production > version for windows I don't remember the chipset, but is a pentium m or > celeron d) > > This problem doesn't happen when you copy and paste the spreadsheet into > the same book. >
I believe this problem has to do with different 'start dates' in Mac and Windows. I had the same isuue a few years ago when switching an Excel worksheet from a Windows environment to my Mac. !!! load a xls file into Calc > Select all or part of a sheet> Copy > Paste in new Calc file result: all dates are 4 years and 1 day younger (18/apr/06 becomes 17/apr/02) cause: known issue between Windows and Mac versions of Excel (1904 instead of 1900). see in Help (Calc) under Date, Start see also http://compoundthinking.com/blog/index.php/2006/01/20/excel-date-wierdness/ http://user.services.openoffice.org/en/forum/viewtopic.php?f=49&t=3250 > > I use version 3.0 beta for my macbook > I use the last beta version for a windows dual core in one office > I use version 2.something (the last production one before beta) in a... > mmhh actually I don't know if it is a pentium m or celeron D chipset but can > find out if you need it. > > Me > HTH -- Guy using dutch OOo Aqua 3.0.0 RC3 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 RC3 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches
