Re: [libreoffice-users] reproduce and isolate this spreadsheet copy/paste bug

On 20 Jun 2011 at 10:42, Tim Leonard wrote:

Date sent:              Mon, 20 Jun 2011 10:42:30 -0400
From:                   Tim Leonard <aries-da@verizon.net>
To:                     users@global.libreoffice.org
Subject:                [libreoffice-users] reproduce and isolate this 
spreadsheet copy/paste bug
Send reply to:          users@global.libreoffice.org

> 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 users+help@global.libreoffice.org
> In case of problems unsubscribing, write to postmaster@documentfoundation.org
> 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:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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