Arc corrupts element format attribute
Created by: lotsaram
Describe the bug In Arc the number format in the "Format" column of the dimension/hierarchy editor just displays the actual number format and omits the prefixed and suffixed technical strings that are stored in the ElementAttributes cube. As a feature this is good except if the format is edited in Arc in which case the string saved back into the attributes cube contains only the number format without the technical prefix (& suffix if a "built-in" format). This will break the number formatting in Architect & TM1Web and numbers display as unformatted.
To Reproduce Steps to reproduce the behavior:
- Go to Attribute Editor in Architect. Set a number format. e.g. built-in format for thousand separator with brackets for negative
- Open the same dimension in Arc and change a number format e.g. add or remove a decimal place
- Open the same dimension again in Architect Attribute Editor. The value saved in the attributes cube now has the "b:" prefix removed as well as the trailing "CO|2|Y"
- This results in the element's values being interpreted as not formatted in Architect and TM1Web.
- There is the same result for "custom" number formats which have "c:" prefix before the number format string (but no trailing technical characters after the number format string). If the "c:" is removed by Arc the values don't display correctly in the TM1 native UIs.
Expected behavior Arc should store the technical "b:" or "c:" prefix and not invalidate the number format in native TM1 UIs
Desktop (please complete the following information):
- TM1 Version: 11.4
- Browser: Chrome
- Arc Version: 1.3.1