Illuminati-R-Us

A Cozy Living Room of an Internet Board

Skip to content

That was Weird

Post about your cool new gadgets and toys. Ask other users for help with techy problems.
Post a reply

That was Weird

Postby Мастер » Sun May 03, 2015 5:21 pm

Copying a column with a bunch of dates in it, from one place to another, in LibreOffice, the free-ware replacement for Microsoft Excel.

Within the same spreadsheet, no problem, everything works just fine.

Copying from one spreadsheet to another, all the dates advance by four years and one day.

:shock:

Once I realised it was a reliable pattern, and not just a random scrambling, it was easy enough to fix. But, WTF?
They call me Mr Celsius!
User avatar
Мастер
Moderator
Moderator
Злой Мудак
Mauerspecht
 
Posts: 23937
Joined: Tue Aug 02, 2005 2:56 pm
Location: Far from Damascus
Top

Re: That was Weird

Postby Lance » Sun May 03, 2015 6:02 pm

That's pretty bizarre!

Four years and a day; 365.25 times 4. So 4 years plus a leap day.

Interesting...
No trees were killed in the posting of this message.
However, a large number of electrons were terribly inconvenienced.

==========================================

Build a man a fire and he will be warm for a few hours.
Set a man on fire and he will be warm for the rest of his life.
User avatar
Lance
Administrator
Administrator
Cheeseburger Swilling Lard-Ass who needs to put down the remote and get off the couch.
 
Posts: 91434
Joined: Thu May 12, 2005 5:51 pm
Location: Oswego, IL
Top

Re: That was Weird

Postby Мастер » Mon May 04, 2015 12:06 am

Lance wrote:That's pretty bizarre!

Four years and a day; 365.25 times 4. So 4 years plus a leap day.

Interesting...


Well, four years including the leap day, plus another day.
They call me Mr Celsius!
User avatar
Мастер
Moderator
Moderator
Злой Мудак
Mauerspecht
 
Posts: 23937
Joined: Tue Aug 02, 2005 2:56 pm
Location: Far from Damascus
Top

Re: That was Weird

Postby Lance » Mon May 04, 2015 1:23 am

Мастер wrote:Well, four years including the leap day, plus another day.

So 1,462 days then.

I haven't a clue.

I am probably over thinking it.
No trees were killed in the posting of this message.
However, a large number of electrons were terribly inconvenienced.

==========================================

Build a man a fire and he will be warm for a few hours.
Set a man on fire and he will be warm for the rest of his life.
User avatar
Lance
Administrator
Administrator
Cheeseburger Swilling Lard-Ass who needs to put down the remote and get off the couch.
 
Posts: 91434
Joined: Thu May 12, 2005 5:51 pm
Location: Oswego, IL
Top
Post a reply

Return to Computers and Gadgets

Who is online

Users browsing this forum: No registered users and 2 guests

Powered by phpBB® Forum Software © phpBB Group