asked 11 hours ago
Hello,
We recently updated to Flexmonster version 2.9.100 (from 2.8.10) and noticed a change in the behavior of Excel exports.
Previously, when exporting to Excel and setting the format of any measure to "None" for decimals, the exported file would reflect this setting by displaying zero decimals in Excel. However, in version 2.9.100, the exported file shows 1 decimal in Excel. If we select "0" decimals in the report format options, the export works correctly, displaying no decimals in Excel.
Is this the expected behavior? It seems unusual for the export to apply a different format in Excel than the one used in the pivot table.
Additionally, what is the difference between "None" and "0" decimals? Does "None" mean that no specific formatting is applied to decimals, allowing values to retain their original decimal places as they appear in the data source?
Thank you in advance.
⋅ 4 hours ago
Hello Javier,
Thank you for contacting us.
When exporting the report to Excel, measures will contain at least one decimal place in the output file if they don't have a number format with the explicitly defined decimalPlaces property.
To display the necessary measures as integers, set the decimalPlaces to 0 in the number format for these measures:
report: {
formats: [
{
name: "decimalFormat",
decimalPlaces: 0
}
],
slice: {
measures: [
{
uniqueName: "Price",
aggregation: "sum",
format: "decimalFormat"
},
],
// Other slice properties
},
// Other configs
}
Alternatively, all measures can be displayed as integers in the output file if you set the decimalPlaces to 0 in the default number format.
You are correct that the "none" value means that there is no specific format for decimal values, while 0 removes all decimal places explicitly. However, we agree that the behavior is inconsistent in the 2.8 and 2.9 versions of Flexmonster. Our team will research possible solutions. We will provide you with the results ETA May 26th. For now, we recommend setting the decimalPlaces to 0 explicitly.
You are welcome to contact us if other questions arise.
Kind regards,
Nadia
