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

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

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.8.1
    • Fix Version/s: 3.8.2
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
      None
    • gh.sprint.customfield.default.name:
      Sprint 1

      Description

      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)

        Activity

        Hide
        henrichen henrichen added a comment -

        Fixed. (Support ZSS-1126 would support ZSS-1127 automatically)

        Show
        henrichen henrichen added a comment - Fixed. (Support ZSS-1126 would support ZSS-1127 automatically)

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Agile