Export to excel issue still exists after applying HFix-31103
SummaryWhen using a custom control format control in a Report Definition to display the differences between two dates the results are shown correctly in the report viewer, but when performing an "export to excel" operation the results are not shown correctly. Export to excel is not picking up the format from the custom control.
Steps to Reproduce
- Create a Report Definition with pxElapsedTime as a column.
- Apply control to convert pxElapsedTime to days, minutes, and hrs format.
- Run Report and export it to excel.
- The format of pxElapsed column is not changed as per the control.
Root CauseAn issue in the custom application code or rules. When using a Date column in the Report Definition with custom control. Since the original property is Date column, the (number) returned by custom control is also getting converted to Date while exporting to excel.
ResolutionPerform the following local-change:
Changed the original column from date to number and access the date value via below API in the custom control. ClipboardProperty date = tools.getActive().getParentPage().getProperty("FieldName")
Published February 17, 2017 - Updated March 1, 2017