When I send dashboard result as xlsx format and i open it, one column format corrupts and shows -1 as value of integer values (the entire column data type is varchar).
I surrounded the values with parenthesis and problem solved but I don't know how to show the original values.
Before adding parenthesis
After adding parenthesis
Post "Diagnostic Info" from Admin > Troubleshooting.
Looks like Excel has set column formatting incorrectly, but I cannot tell if the problem comes from Metabase or Excel auto-formatting.
The problem comes from Metabase because no other columns are corrupt,
and I tried to solve the problem by assigning a hard code value like '1234' but after doing this , still -1 is the cell content and sharps are shown.
@tooraj Post "Diagnostic Info" from Admin > Troubleshooting.