QExport4XLSX numeric format and styles not applied correctly in UniGUI (Delphi 12)

[GNC]

Hello,

I am exporting a dataset using QExport4XLSX in a UniGUI application (Delphi 12).

Dataset contains:
- integer fields (PLU_NUMBER)
- double precision fields (quantities, prices, values)

Issues:

1. Numeric formatting is inconsistent:
   - 0 values appear without decimals
   - formatting like '0.000' is ignored in some cases

2. When using OnGetDataParams and setting:
   UseStyle := True;
   Style.NumericFormat := '0.000';

   → Excel file becomes corrupted or repaired on open

3. Style properties (Font, BackgroundColor, Border) are not applied at all

4. Column formatting in Excel remains "General"

At the same time:
- UniGridExcelExporter produces perfect layout but lacks correct decimal formatting
- QExport produces correct numeric format sometimes but breaks styles / layout

Question:
What is the correct way to:
- enforce numeric format (0.000 / 0.00)
- apply styles safely
- avoid Excel repair errors

Is there a known limitation or required configuration?

Thank you.

[Sherzod]

Hello, 

Which build and edition of uniGUI are you using? 

[GNC]

Hello,

I am using:

uniGUI Complete Professional
Version: 1.95.0.1610

Delphi: 12 (RAD Studio 12)

Exporter used: TUniGridExcelExporter

Let me know if you need additional details.

The issue is that numeric fields (double precision) are exported
without respecting DisplayFormat (e.g. 0.000, 0.00),
while layout and grouping are correct.

[Sherzod]

 

[GNC]

I'm sorry. I placed my Email in my account. Thank You.

 

[Sherzod]

On 3/20/2026 at 6:35 PM, GNC said:

Exporter used: TUniGridExcelExporter

We are working on improving the Excel export to preserve styles as much as possible.

[Moegamat Alexander]

looks good

[GNC]

Dear [Sherzod / UniGUI Team],

Thank you for your response and for sharing the screenshots.

The improvements you are working on look very promising, and it is good to know that Excel export formatting is being actively enhanced.

In our case, we observed that formatting (especially numeric formats and styles) is not fully preserved with the current UniGridExcelExporter. For our production reports, we have temporarily implemented an alternative approach to ensure precise formatting.

We will definitely keep an eye on upcoming updates, as improved native support in UniGUI would be very valuable for us.

Thank you again for your efforts and support.

Best regards,
George Ckakarov