Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

Problem

When referring a string column in a formula, and the value of the string column is composed of numbers, starting with a '0', the value is interpreted as a number.


Consider following configuration

...
col.domainref = Domain Reference
col.domainref.type = string
...
col.genref = MRM Reference
col.genref.type = string
col.genref.formula =  {domainref}


When the content of domainref is for instance 010, the value of the genref column will be 10.  The string value 010 is interpreted as a number 10.  The column genref will therefore contain the string 10.

 

Workaround

Provide a hint to the formula parser that the dependent column value should not be interpreted as a number as follows

...
col.domainref = Domain Reference
col.domainref.type = string
...
col.genref = MRM Reference
col.genref.type = string
col.genref.formula =  "" + {domainref}