Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at

Status Future consideration
Workspace Planning Analytics
Created by Guest
Created on Feb 13, 2024

Apply number format when editing a cell in PAW

We are using the german number format ("." as thousand separator and "," as decimal separator) in PAW. The format works fine for non-selected cells, but after a doubleklick into a cell the cell value is displayed with the default format (point as decimal separator). This can lead to incorrect inputs:

1. Write a decimal value for example 100.5 (100,5 in german format) into one cell

2. Double klick this cell, mark the content with ctrl+a and copy it with ctrl+c

3. Klick another cell once and paste via ctrl+v

4. The second cell now shows the value 1005, so it was multiplied by 10

All cells mentioned are at leaf level and there are no cube rules involved.

To prevent this error, the only solution is to ask users to never copy cell values when in "editing mode". This of course cannot be ensured and stays a potential source of errors.

IBM does not classify this as a bug, but for users of PAW the behaviour is highly confusing and can lead to incorrect inputs very fast.

The solution we propose is to make the number format apply to the cell values when a cell is edited. This would not be a big change, but would totally resolve the problem. Maybe a flag in the tm1s.cfg could activate and deactivate the custom formats, so that existing systems are not changed.

Needed By Month
  • Admin
    Stuart King
    Feb 28, 2024

    I've updated the status to future consideration (I thought a bit more about this and changed my mind). We are now tracking a work item that will make the unformatted value be displayed with language specific decimal delimiter (e.g in German it will show a comma). This will be a client side change only (no change in TM1 required).

    1 reply
  • Admin
    Stuart King
    Feb 20, 2024

    I've declined this enhancement request. Unformatted values in TM1 are always displayed with the period as the decimal separator. In this case the formatted value should be used. There is an incorrect assumption that double clicking into the cell is putting the cell in 'Edit mode'. The cell value can be changed without double clicking into the cell. Double clicking in the cell shows the unformatted value. Without formatting we cannot apply a localization to determine if the period or comma should be displayed as the decimal separator.

    1 reply