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

Date format and display doesn't match

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.0.0
    • None
    • ZPOI
    • None

      Prepare a blank excel file and load it into spreadsheet

      case 1:
      1. set cell A1 edit text as 2013/12/24
      2. format the cell with format string m/d/yyyy
      3. expect result should display 24/12/2013 but was 2013/12/24

      case 2:
      1. download the attachment excel file which have 1 cell with value 2013/12/24 and format is yyyy/m/d
      2. open them by spreadsheet
      3. 2007 display correctly, but 2003 doesn't. It should be 2013/12/24 but was 12/24/2013

      The testing locale is zh_tw

        1. 2003.xls
          31 kB
        2. 2007.xlsx
          11 kB

            dennis dennis
            roliroli roliroli
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: