Our blazing fast Grid component built with pure JavaScript


Post by ws85 »

Hi all,

Apologies if this has already been answered in the forums or addressed in the documentation, I've tried scouring both with no success:

Using the Bryntum Grid Excel Export example:
https://bryntum.com/examples/grid/exporttoexcel/

When I use..:

format: {
        locale: "en-US",
        template: "$9,999",
        currency: "USD",
        significant: 5,
    },

..for an aggregate field type, then attempt to export the grid data, I get this Excel error when I open the generated .xlsx file:

Image
(Image doesn't automatically load on my browser, if it's the same for you: right-click > 'Open image in new tab')

Here's the full Grid config:

const grid = new Grid({

appendTo: 'container',

features: {
    excelExporter: true
},

columns: [
    {
        type: "aggregate",
        text: "Price",
        field: "price",
        flex: 1,
        format: {
            locale: "en-US",
            template: "$9,999",
            currency: "USD",
            significant: 5,
        },
        sum: true,
    },
],

data: [
    {
        id: 1,
        price: 1,
    },
    {
        id: 2,
        price: 1,
    },
],

tbar: [
    {
        type: 'button',
        text: 'Export (default settings)',
        ref: 'excelExportBtn1',
        onAction: () => grid.features.excelExporter.export()
    },
]
});

If you remove the..

template: "$9,999",
currency: "USD",

..properties from the 'format' config item, then it works fine, but of course there's no currency prefix. Note: After selecting 'Yes' when the Excel error/info modal is displayed, the currency is displayed correctly, but we'd rather not have that error pop-up if possible.

Is this more of a zipcelx issue?

Thank you.


Post by tasnim »

Reproduced The bug, We'll investigate it, Here is the ticket : https://github.com/bryntum/support/issues/4474

Thank you for your report,
Tasnim


Post by ws85 »

Thank you, Tasnim.


Post Reply