Re: [libreoffice-users] Odd behavior using DATE() function in calc

2013-05-03 Thread Andrew Douglas Pitonyak
On 05/02/2013 09:52 PM, vsharris wrote: I have a spreadsheet with three columns: year, month, day. In the 4th column I use the DATE() function to create a date from these columns. It works fine if there are valid data, but if the month and day column are empty, the results are surprising. For

Re: [libreoffice-users] Odd behavior using DATE() function in calc

2013-05-02 Thread Brian Barker
At 18:52 02/05/2013 -0700, V. S. Harris wrote: I have a spreadsheet with three columns: year, month, day. In the 4th column I use the DATE() function to create a date from these columns. It works fine if there are valid data, but if the month and day column are empty, the results are surprisin