Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1126

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

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.8.2
    • 3.8.1
    • 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)

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

              Created:
              Updated:
              Resolved: