Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-28216

Text function addes extra characters to cell when using "m" for format string

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Low
    • Resolution: Timed out
    • 4.3.2, 4.3.7
    • None
    • None
    • Office Connector 2.1.10, Office Connector 2.1.12

    Description

      When using a text function to convert a value to months, the office connector renders incorrectly.

      Expected:

      Actual:

      The cell which says "December 31" should say 12.

      The function used below is: =TEXT(A3,"m"), where A3 is an empty cell, and therefore represents the date 1899-12-30.

      Attachments

        1. inconf.png
          inconf.png
          8 kB
        2. inexcel.png
          inexcel.png
          6 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ldally lachland
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: