Report columns with format show incorrect data
Reports have format function defined for a column in report definition, The results for that particular column are incorrect when exported to excel sheet.
Steps to Reproduce
- Configure format function for a column
- Export to excel
The user had a custom control and in this control he was converting integer into [hh:mm] format and passing it to RD column.
In Excel if the column has value of [xx:yy] format then it automatically converts it to [xx:yy:00]. User can see the format applied by excel using ctrl+1 .
So to overcome this, suggested user to change his custom control and send the values as [xx.yy] or [xx:yy hours] instead of [xx:yy] so that EXCEL doesn't consider it as Time field.
Published October 14, 2016 - Updated October 19, 2016