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

Values do not localize on downloading Excel

SA-76838

Summary

Values do not localize on downloading Excel through scheduled reports.


Error Messages



Not Applicable


Steps to Reproduce

  1. Set the operator locale to fr_FR
  2. Create field values for the values in the local storage
  3. Create a control with name DisplayLocalisedText and property value as localize property value
  4. Change the column value to DisplayLocalisedText in the datatableeditorreport
  5. Run the report. The localized value of the data displays
  6. Click Export to Excel. The values localize
  7. Schedule the report. The values do not localize


Root Cause



Scheduled reports cannot localize the values, by default.

Resolution



Perform the following local-change:
  1. Add a step to the pyExecuteTask(Pega-ScheduledTask-Reporting) activity to invoke the UpdateLocaleSettings activity with the value of required timezone for the "useTimeZone" parameter and a value of 'fr_FR' for the 'useLocale' parameter
  2. Use the 'Default scalar property display' control instead of 'DisplayLocalizedText'




 

Published April 12, 2019 - Updated December 2, 2021

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