Summary
The latest version of Report Sender works with ICU Locale formats. Still, there are some important things to consider, such as checking to see if you have our deprecated package installed and paying attention to changes in exported file behavior.
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 in this Salesforce help article. 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:
To enable ICU formats, a minimum API version of 45.0 is required for Apex Classes, Apex Triggers, and Visualforce Pages.
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. In the spring of 2025, when Salesforce started notifying people with any components below API version 45, we updated the rest of the components even though they don't affect locales.
The Deprecated Package, PowerPack, Does Not Support ICU Formats
If you still have our old package installed (it shows as Report Sender Plus in Setup > Installed Packages), it has been deprecated and should be uninstalled. All of the code has been moved to the Report Sender package, and now the Plus features are enabled with a feature switch that is enabled when you sign up for a subscription. If you're using anything in the deprecated 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?
Check if you have our deprecated package installed.
If you are using reports with Date/Time fields and the sending user is in one of the affected locales, consider notifying your recipients about the issue with sorting these fields.