TM1: Web Sheet display format issue in TM1 Contributor / Planner

When porting an Excel spread sheet into TM1 Contributor/ Planner, the format of string and number will display differently from in the Excel.  This is due to the string measurement algorithm that TM1 uses when it converts an Excel spreadsheet into web format.  Within the web.config file look for the following section.

The StringMeasurement parameter is set to 3 by default.  Changing it to 0 (legacy mode) may help a bit but may not completely resolve the issue.  Regardless of which mode is chosen, the column width needs to be adjusted in order to get an expected display format.

Here are the comparisons between the new mode (‘3’) and legacy mode (‘0’) in Contributor / Planner for a string and number:

Normal display within Excel

Web Display 1


New Mode (mode 3)

Web Display 2


Legacy Mode (mode 0)

Web Display 3

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content