[Jfreereport-developers] [JIRA] Created: (PRD-3801) Formula conversion between number and text is not reversible - text cannot be parsed as number anymore.

[Pentaho J. N. (do-not-reply) <ji...@pe...>]

Formula conversion between number and text is not reversible - text cannot be parsed as number anymore.
-------------------------------------------------------------------------------------------------------

                 Key: PRD-3801
                 URL: http://jira.pentaho.com/browse/PRD-3801
             Project: Pentaho Reporting and Pentaho Report Designer
          Issue Type: Bug
          Components: LibFormula/OpenFormula
    Affects Versions: 3.6.0
            Reporter: Thomas Morgner
            Assignee: Triage
            Priority: Blocker
             Fix For: 4.0.0 GA (5.0 GA Suite Release)


=DATEVALUE("" & (NOW() - 1)) fails, as 

NOW() - 1 is evaluated as number, then converted as text, and then passed into DateValue.

In 3.9

=DATEVALUE(NOW() - 1) fails too, as DATEVALUE's parameter is declared as TextType instead of AnyType.


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira