Prefix with name of container and to avoid Excel errors.
Description
Given a numerical value longer than 15 digits (such as generated unique identifiers) MS excel will auto convert these to scientific notation.
Example : 4750528335817263 becomes 4.75E+15
This breaks post-processing where we rely on complete numbers.
Acceptable solution
Prefix with container type like: MOS3211546750212116083
Issue
Prefix with name of container and to avoid Excel errors.
Description
Given a numerical value longer than 15 digits (such as generated unique identifiers) MS excel will auto convert these to scientific notation. Example : 4750528335817263 becomes 4.75E+15 This breaks post-processing where we rely on complete numbers.
Acceptable solution
Prefix with container type like: MOS3211546750212116083