[Libreoffice] [REVIEW][3-4] date change regression fdo#44385

Noel Grandin noel at peralex.com
Fri Jan 20 03:42:10 PST 2012



On 2012-01-20 13:32, Noel Power wrote:
> [*] table of behaviour in vba, pre the bug being introduced and post 
> patch
>
>                                mso    old behaviour  present
>                             --------------------------------
> date + num                    Date      Date          Date
> date - num                    Date      Double        Date
> date * num                    Double    Double        Double
> date / num                    Double    Double        Double
> date + date                   Date      Double        Double [1]
> date - date                   Double    Double        Double
> date * date                   Double    Double        Double
>
> [1] the date + date is clearly wrong (fixing that would address '3.' 
> above. )
>

The MSO behaviour mostly makes sense to me - using plus or minus on a 
date value returns a date value, using times or divide on a date value 
returns a double.


Disclaimer: http://www.peralex.com/disclaimer.html




More information about the LibreOffice mailing list