Skip to main content
All CollectionsReport Sender
Report Sender ICU Locale Formats
Report Sender ICU Locale Formats

Enabling ICU Locale Formats with Report Sender

Updated over 2 weeks ago

Transitioning to ICU Formats

With Salesforce enforcing the transition to ICU Locale Formats in the Spring and Summer ‘25 release, Admins must ensure that their Org is ready for the switchover. Salesforce introduced ICU Locale Formats in the Winter ‘20 release to replace the legacy Java Development Kit (JDK) Formats. This change affects the format for dates, times, currencies, addresses, names, and numeric values according to international standards. It has been optional for several years but will be enforced in the Spring ‘25 release, with Admins having the ability to defer to Summer ‘25. You can read more details about these changes here. If you are unsure whether your Org uses JDK or ICU Formats, you can use this article to help you figure it out.

Main takeaways:

  1. To enable ICU formats, a minimum API version of 45.0 is required for Apex Classes, Apex Triggers, and Visualforce Pages.

  2. Orgs with any components below API version 45.0 will not have ICU formats enabled automatically, but they can still be enabled manually.

How this Affects Report Sender

Report Sender Works with ICU formats

CloudAnswers Report Sender already works with the ICU locale formats. We updated the compatibility years ago, ensuring that we were ahead of the curve for compliance and adhering to the most recent standard. When we made the change, Salesforce did not require updating all classes and pages, only those that handle locales. Therefore, we have a few classes and a Visualforce Page on an older API version, but those don't handle any locales. Salesforce won't enable ICU locales automatically if you have code with older API versions, but you can enable it manually. We are also planning to update all API versions in a future release.

The Deprecated Package, PowerPack, Does Not Support ICU Formats

If you still have our old package installed, Report Sender Plus, then that has been deprecated and should be uninstalled. If you're using anything in that package besides Report Sender, please let us know, and we can discuss a migration path. You can contact us directly at [email protected]. Note that this differs from having Report Sender installed with a Plus subscription. You are all set if you only see one Report Sender package in Setup > Installed Packages.

Changes to Sorting DateTime in Excel

Some ICU locales add an extra comma to DateTime fields. For example:

  • Under JDK formats: “1/1/2025 12:00 PM”

  • Under ICU formats: “1/1/2025, 12:00 PM” (note the comma after the date)

In cases like these, Excel may misinterpret a DateTime field as a text field when opening the file, which means sorting will sort alphanumerically instead of by date. Salesforce recommends searching and replacing the comma in that column so that Excel will format it as a date if you need to sort a DateTime column that includes one of the affected formats.

If you send a report with a DateTime field that will likely be used for sorting, you may want to send a message to your recipients about this or add a note in the email body of the report schedule.

The affected formats are:

  • English (United States) (en_US)

  • English (Canada) (en_CA)

  • English (Australia) (en_AU)

  • English (United Kingdom) (en_GB)

  • English (India) (en_IN)

What Actions Should You Take?

The main action you will have to take is to manually enable ICU formats since Salesforce will not do it automatically. Follow this article written by Salesforce on how to complete this step correctly.

Did this answer your question?