[Libreoffice-bugs] [Bug 31939] New: FORMULA: command TODAY() not usable in automatic formula computing

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=31939

           Summary: FORMULA: command TODAY() not usable in automatic
                    formula computing
           Product: LibreOffice
           Version: LibO 3.3.0 Beta3
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: NEW
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: ad_debian at joonet.de


First I have tested it in German with "HEUTE()", then also with TODAY(). I have
uesd this command in a formula like this:

  =IF(D28>1;YEARFRAC(D28;TODAY();1);"")

If I open the file with this formula inside and add a date in the empty field
D28, then the formula field do not compute/show any value.

If I write instead:

  =IF(D28>1;YEARFRAC(D28;F$3;1);"")

and have set the formula "=TODAY()" into F3 then computing in field D28 is o.k.
(this can be used as workaround).

I have found this error in Beta 3. (I have not tested Beta 2).

Thanks for all your work!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.