asked 12 hours ago
I am using ExcelJS library with Flexmonster to export my Pivot Table to Excel. I noticed that when I set the decimalPlaces value in format options and export the report the actual value is exported with a numberFormat applied. I wanted the values to be exported with the remaining numbers truncated and not be present in my exported excel. I tried doing this through customizeCellFunction where I forcefully truncated the values using the toFixed method but that had a weird issue where it didn't work for numbers less than 1000. Please help me fix this.
⋅ 12 hours ago
I can understand that the FormatObject is present only for changing the number format and not change the actual value but atleast modifying the values through customizeCell should be consistent for all values
