[BUG] - [Numeric Value (decimalk) in dictionary causes Excel erros]

[Guz-TsTech]

Description

Using a dictionary to store key values to use SaveAsTemplateAsync causes errors when opening the file in Excel

Expected Behavior

No error when the file is opened

Actual Behavior

There's error when the file is opened.

Workarounds

Using String to export decimal value "works" but Excel process these values as string.

Environment (please fill the following information):

• MiniExcel Version: 1.42.0
• .NET Version: net8.0
• OS: macOS French (decimal separator in , not .)

[Guz-TsTech]

I got it working modifying source code as follow :

MiniExcel.Core / OpenXml / templates / OpenXmlTemplate.Impl.cs

Line 747 : if (/*!isDictOrTable && */TypeHelper.IsNumericType(type))

Removing test to detect if we process Dict or Table resolve the issue. The value is processed as numeric and everything is good.

I tried to push a pull request but I don't have the rights.

Regards.

Guillaume