Ask Your Question

possible fill down date bug in calc [closed]

asked 2013-06-30 13:34:20 +0100

mikeymike gravatar image

updated 2015-11-03 01:44:23 +0100

Alex Kemp gravatar image

I nearly got caught out by this one. If it is a bug, it's due to expected behaviour rather than "this program can't do maths".

I was using fill down to create a list of dates a month apart, but as I used 30 as the day number, the fill down function skipped February. In Excel 2007 SP3, it didn't skip February, instead it put the highest valid day number for February for that year.

Tested in LO 3.5 on win64.

Steps to reproduce:

Enter 30/12/12 in the first box, and 30/1/13 in the box beneath that, then select both cells and use fill down.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-03 01:44:34.713565

1 Answer

Sort by » oldest newest most voted

answered 2013-06-30 13:41:32 +0100

m.a.riosv gravatar image

There is bug about this with resolved status, but I think you need a version 3.6 or up.

Autofill - Date - Months' wrong if day of month exceeds max. days of month

edit flag offensive delete link more



At least 3.6.7, 4.0.4 or 4.1.0

erAck gravatar imageerAck ( 2013-07-01 16:12:18 +0100 )edit

Question Tools

1 follower


Asked: 2013-06-30 13:34:20 +0100

Seen: 118 times

Last updated: Jun 30 '13