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

Smart input cannot turn 1-Jan into a date format

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Invalid
    • Icon: Normal Normal
    • None
    • 3.8.1
    • None
    • None

      steps tor reproduce

      1. type 1-Jan in a cell

      actual result

      its cell format is still General

      expected result

      its cell format is Date.

      Debug info

      • In DateInputMask, there is such pattern d-mmm exists.

        — local:en_US ---------------------------------
        pattern :^[ \t]*([A-Z\p

        Unknown macro: {InLatin-1Supplement}

        ]

        Unknown macro: {3,9}

        )(?:[ \t][-/]?|[-/]?)[ \t]([0]?[1-9]|[12][0-9]|3[01])[ \t]*$
        format :d-mmm
        groupText:JUL 18
        ampm1MatchText:null

      • It converts Jan-1 into a date format

            Unassigned Unassigned
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: