On 20 Jun 2011 at 10:42, Tim Leonard wrote: Date sent: Mon, 20 Jun 2011 10:42:30 -0400 From: Tim Leonard <[email protected]> To: [email protected] Subject: [libreoffice-users] reproduce and isolate this spreadsheet copy/paste bug Send reply to: [email protected]
> The enclosed .xls file contains only a short column of dates, all from > 2011. If I copy them and paste them into a new spreadsheet, they are > inexplicably transformed into 2007 dates, and mostly changed by one day. > In the past, I recall that quattro, lotus, openoffice, and now libre would convert the number 0 to 12/30/1899, but I recalled that excell would do a different date. I thought it was 12/31/1899, but I just checked on a 2007 excell, and 0 shows up as the date 1/0/1900?? Never knew there was a January 0? If it is copying the numeric value, I could see it producing the off date, but if it copies it as a date, it could convert the value correctly? > If I type identical dates into a new file (even if it's .xls) and try > the same thing, it works correctly, so the problem is with this file, > not with the dates or the operations. > > Please confirm that you see the same behavior. If you can help isolate > the problem or suggest a workaround, I'd appreciate that, too. > > I'm running LibreOffice 3.3.1, OOO330m19 (Build:8), tag libreoffice-3.3.1.2 > > > -- > Unsubscribe instructions: E-mail to [email protected] > In case of problems unsubscribing, write to [email protected] > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10898843.776988 | EINSTEIN 6041819.840851 ROSETTA 3265227.160563 | ABC 6429989.946223 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
