- edited description
Strings interpreted as numeric value in Inserted Columns in Grid Widget
Description
If an inserted column in a Grid Widget shows a string/text that is comming from a function =DBRW or =XY1 (reference to another column), the string is interpreted and formatted as a number. As a consequence, all points in the string are converted into a comma.
To Reproduce
For example, the function =DBRW("DB_ISTAR","}ElementAttributes_iStAR_Projekte",A1,"PZ_NL") in an inserted column refers to a String-attribute and should return “BNA.21.00.00.00”. However, the presented text is “BNA,21,00,00,00”. => All points in the string are converted to a comma.
The same applies when referring to another column with text in it, such as =XY1, all points in the string (from source column XY1) are converted into a comma, which is not the expected behaviour.
Expected behavior
If a string is presented in an inserted column, it shall NOT be modified by any number formatting. In particular, points (“.”) must not be changed into comma (“,”) within the string.
Screenshots
See attached PNG file.
Additional context
Customer: Deutsche Bahn
Apliqo UX, Version 2023.05 FP1, Grid Widget, Inserted column
Comments (2)
-
reporter -
- changed status to open
Dear Daniel, thank you for bringing this to our attention, we will reproduce the issue and get back to you.
- Log in to comment