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 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.