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

XMLWordPrintable

    • Type: Bug
    • Resolution: Timed out
    • Priority: Low
    • None
    • Affects Version/s: 4.3.2, 4.3.7
    • Component/s: None
    • Environment:

      Office Connector 2.1.10, Office Connector 2.1.12

    • 1
    • Severity 3 - Minor

      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

            Assignee:
            Unassigned
            Reporter:
            lachland (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: