Downstream bug may be found at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/127505
OOo bug may be found at: http://qa.openoffice.org/issues/show_bug.cgi?id=74069
1) lsb_release -rd Description: Ubuntu 11.04 Release: 11.04
2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.3-1ubuntu2 Candidate: 1:3.3.3-1ubuntu2 Version table: *** 1:3.3.3-1ubuntu2 0 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 1:3.3.2-1ubuntu4 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
3) What is expected to happen is when one types in a cell either:
=YEARFRAC(DATE(1958,3,1),DATE(1996,1,1),1) =YEARFRAC(DATE(1958,3,1),DATE(1995,12,31),1)
one gets two different results.
4) What happens instead is they are identical:
37.8356164384 37.8356164384
Downstream bug may be found at: /bugs.launchpad .net/ubuntu/ +source/ libreoffice/ +bug/127505
https:/
OOo bug may be found at: qa.openoffice. org/issues/ show_bug. cgi?id= 74069
http://
1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc dpkg/status 3.3.2-1ubuntu5 0 us.archive. ubuntu. com/ubuntu/ natty-updates/main i386 Packages 3.3.2-1ubuntu4 0 us.archive. ubuntu. com/ubuntu/ natty/main i386 Packages
libreoffice-calc:
Installed: 1:3.3.3-1ubuntu2
Candidate: 1:3.3.3-1ubuntu2
Version table:
*** 1:3.3.3-1ubuntu2 0
100 /var/lib/
1:
500 http://
1:
500 http://
3) What is expected to happen is when one types in a cell either:
=YEARFRAC( DATE(1958, 3,1),DATE( 1996,1, 1),1) DATE(1958, 3,1),DATE( 1995,12, 31),1)
=YEARFRAC(
one gets two different results.
4) What happens instead is they are identical:
37.8356164384
37.8356164384