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: