# Reporting - decimal separator problem

**URL:** <https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158>\
**Category:** Ignition\
**Created:** [September 14, 2023, 1:52pm UTC](https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158 "2023-09-14T13:52:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Balazs\_Schaffer](https://avatars.discourse-cdn.com/v4/letter/b/b4bc9f/32.png) [@Balazs\_Schaffer](https://forum.inductiveautomation.com/u/Balazs_Schaffer)\
**Post date:** [September 14, 2023, 1:52pm UTC](https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158/1 "2023-09-14T13:52:58Z")

</div>

[error.zip](https://forum.inductiveautomation.com/uploads/short-url/7jsyCHHhavJHXQUM7G9NW1UsqP0.zip) (430.3 KB)

We use Ignition reporting. We have in our country comma for decimal separator.  
In designer we set the Number Format into #,##0.00 When we choose it, in the small dialog the locale-correct examples are shown (attached picture - dialog.png)  
After in opening the same project in the Preview in 2 machines we have 2 results. In 1 machine the Preview is correct with comma as dec. separator, in the other the Preview contains point as dec. separator (attached pictures - designer\_comma.png & designer\_point.png).  
On the web downloading pdf and XLSX (using [system.report.executeAndDistribute](https://docs.inductiveautomation.com/display/DOC81/system.report.executeAndDistribute) ) we always get point as decimal separator (attached ero\_tabla\_avg.xlsx and ero\_tabla\_avg.pdf). The biggest problem for us is the XLSX export as this way the number 156.66 is treated as String in XLSX and for example cannot be counted total, etc

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [September 14, 2023, 2:56pm UTC](https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158/2 "2023-09-14T14:56:57Z")

</div>

If you're getting different results in the Designer with the same report on two different machines, there's something in the machine settings (or the designer settings) for the locale that's different. That could be a setting in Ignition, it could be based on what setting the OS has now, or what setting the OS had when Java was first installed on that machine.

As for `system.report.executeAndDistribute()`, the report is always executed on the Gateway and the Gateway doesn't really have a concept of locales. And unfortunately, my brief research isn't turning up a way for the library we use to write the XSLX files to use different number formats (that may be part of the XSLX standard?).