Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Issue with Text area control after installing HFix-54081

SA-92047

Summary



Post applying HFix-54081, in the exported Excel, the text area column values do not display in a single line. Hence, the user is unable to perform any calculation on the Excel file.
  • Before applying the hotfix, the details display as a single row in the exported Excel even when the details are entered in multiple rows. 


     
  • After applying the hotfix, formatting does not occur and multiple rows display in the generated Excel. Hence, user is unable to perform any operation on the Excel cell.


Error Messages



Not Applicable


Steps to Reproduce

  1. Source the report definition column with a text area property.
  2. Enter the values in multiple line format.
  3. Export the file to Excel. The values in the Excel display in the format entered by the user.


Root Cause



This behavior is working as expected.
The hotfix changes are meant to retain the format entered. Hence, in this case, since the user entered multiline values, the Excel file displays the values as they are entered.



Resolution



Apply HFix-56995 to revert the changes made in HFix-54081.

Alternatively, perform the following local-change to avoid the Timestamp from being appended:
  1. Navigate to the Date column (where the issue is observed).
  2. Click the Function button (fx) beside the column source Text box. 
  3. Apply 'The day portion of [Date Value]' function.
  4. Provide the column source in the Function Input.



    The report displays as below,


     
  5. Apply the changes  only for those columns where timestamp is not required. For the columns with timestamp, the correct values are retrieved and the changes are not required.

Published April 11, 2020 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us