markling, the reason why one does not get the "..." as anticipated from the first formula has to do with how Excel handles:
=WEEKDAY(,2) which equals 6. Both OpenOffice.org and LibreOffice keep compatibility with this result. Microsoft disclaims this issue at http://office.microsoft.com/en-us/excel-help/about-dates-and-date- systems-HP005200674.aspx?CTT=5&origin=HP005209336 noting: "Because the rules that govern the way that any calculation program interprets dates are complex, you should be as specific as possible about dates whenever you enter them. This will produce the highest level of accuracy in your date calculations." Despite this, this issue really is not a bug and requires more discussion, which should be done on an appropriate mailing list or forum. If you have a Microsoft support contract you can leverage, feel free to bring this to the attention of Microsoft and post the results to this bug. Otherwise, feel free to post to one or both of the following Microsoft forums and post a link of it to this bug: http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads http://answers.microsoft.com/en-us/office/forum/excel?page=1 apt-cache policy openoffice.org-writer openoffice.org-writer: Installed: 1:3.2.1-7ubuntu1.1 Candidate: 1:3.2.1-7ubuntu1.1 Version table: *** 1:3.2.1-7ubuntu1.1 0 500 http://us.archive.ubuntu.com/ubuntu/ maverick-updates/main i386 Packages 500 http://security.ubuntu.com/ubuntu/ maverick-security/main i386 Packages 100 /var/lib/dpkg/status 1:3.2.1-7ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ maverick/main i386 Packages apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu2~maverick1 Candidate: 1:3.3.2-1ubuntu2~maverick1 Version table: *** 1:3.3.2-1ubuntu2~maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status Microsoft Office Excel 2003 (11.5612.5606) apt-cache policy wine1.3 wine1.3: Installed: 1.3.18-0ubuntu1 Candidate: 1.3.18-0ubuntu1 Version table: *** 1.3.18-0ubuntu1 0 500 http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: openoffice.org (Ubuntu) Status: Expired => Opinion ** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Changed in: libreoffice (Ubuntu) Status: New => Opinion ** Also affects: gnumeric (Ubuntu) Importance: Undecided Status: New ** Changed in: gnumeric (Ubuntu) Status: New => Opinion ** Summary changed: - Calc - Nested IF malfunction when used with WEEKDAY function + Nested IF malfunction when used with WEEKDAY function -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/654161 Title: Nested IF malfunction when used with WEEKDAY function -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
