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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Timed out
    • Icon: Low Low
    • None
    • 4.3.2, 4.3.7
    • None
    • Office Connector 2.1.10, Office Connector 2.1.12

      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.

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

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

                Created:
                Updated:
                Resolved: