Excel export number formatting issue

Stimulsoft Reports.JS discussion
Post Reply
bbialas
Posts: 1
Joined: Mon Jan 05, 2026 10:20 am

Excel export number formatting issue

Post by bbialas »

Hello Stimulsoft Team,

I'm currently working on a Stimulsoft package version update, and I encountered a problem with the Excel Export feature.

I update stimulsoft-reports-js package from version 2024.3.4 to 2026.1.1 (I know, big update :roll: ).

Problem description
One of my cells contains a value -50377.34
This is my text formatting setup:
.
text-formatting.png
text-formatting.png (113.9 KiB) Viewed 118 times
.
.
In the old package version, my excel export file contains a cell with the correct value -50377.34 and proper formatting:
.
old-excel-formatting.png
old-excel-formatting.png (46.84 KiB) Viewed 118 times
In the new package version, the same setup, I get different value exported to the excel file which is -5037734.
Dot decimal sign is removed and excel formats the call in a wrong way.
.
Interesting fact:
When I set "Decimal Digits" option in the designer to 1, then the value exported to the excel file is -50377.34 and the Excel formatting option is set to 1 correctly.
.
excel-test-formatting.png
excel-test-formatting.png (147.75 KiB) Viewed 118 times
When I set "Decimal Digits" option in the designer to 0, it cuts out the dot decimal symbol completely... :cry:
.
The expected behaviour:
I need to get full value exported to the excel file which is -50377.34 and excel should contain cell formatting for decimal places set to 0 (that was the old package version behaviour).

Please let me know if you need more details.
Thank you in advance!
Max Shamanov
Posts: 1075
Joined: Tue Sep 07, 2021 10:11 am

Re: Excel export number formatting issue

Post by Max Shamanov »

Hello,

We need some additional time to investigate the issue, we will let you know about the result as soon as possible.

Thank you.
Post Reply