value() supports date format like 2015-09-05

XMLWordPrintable

    • Type: New Feature
    • Resolution: Fixed
    • Priority: Normal
    • 3.8.2
    • Affects Version/s: 3.8.1
    • Component/s: None
    • Security Level: Jimmy
    • None
    • Sprint 1

      steps to reproduce

      1. enter =value("2015-09-05")

      actual result

      #VALUE

      expected result

      a number, 42252

      debug information

      • the same formula is evaluated to a number in Excel 2011 (US), Excel 2007 (ZH)

            Assignee:
            henrichen
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: