Excel Export: Negative values converted to positive

[ptatoChi]

Describe the bug

I've been trying to export a table that contains a fieldtype of number.

This is how it's displayed to the UI table

When i tried to export using ExcelExportService, I get this

I tried the CSV export, and i got it correctly.

Reproduction

Have a dataset that contains negative numbers, and set it to fieldtype.number

export using ExcelExportService

Expectation

No response

Environment Info

Angular 15
angular-slickgrid 5.6.3

Validations

• Follow our Code of Conduct
• Read the HOWTO - Step by Step.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion.
• The provided reproduction is a minimal reproducible example of the bug.

[ghiscoding]

trying out Example 14 which has negative numbers, it works as expected and unless you provide a repro, I can't help much. So as far as I see, it works correctly and there must be some issues with your code.

[ptatoChi]

I removed the exportWithFormatter from the excel options and it works now.. It's weird. In the UI, it was formatted correctly tho.
This will do for now on my end. Thanks @ghiscoding !

[ghiscoding]

I was able to reproduce, will do a bug fix shortly

[ghiscoding]

fixed in Angular-Slickgrid v5.6.4 and Slickgrid-Universal v2.6.4, you can also test it with the live demo Example 19

Also note this is the last version before the next upcoming Angular-Slickgrid v6 major version
Cheers and thanks for the feedback ⭐