Export Excel when the Cell value is < 1 then its convert to Text

[gopigupta]

Hi Guys,

I need help on the  Export excel issue. when we have the cell value is < 1 i.e., (0.5, 0.8 etc..) then its converts as Text even if it is 'float' datatype.
Please note that, we are currently using Pro V8.2.1

If this is a bug, please fix it.
If it's not a bug, is there a workaround?

  gridApi.exportData({
        url: _baseURL + "Assignment/exportData",
        format: 'xlsx',
        nopqdata: true,
        render: true,
        filename: "WFP_EmployeeAssignmentsView_ " + moment().format('DD-MMM-YYYY') + '.xlsx'
    });


obj.width = 70;
            obj.align = "right";           
            obj.summary = { type: "all" };
            obj.dataType = "float";
            obj.format = "##,###.00";
            obj.title = (obj.title).replace(" ", "<br> ");
            obj.nodrop = true;
            obj.nodrag = true;
            obj.menuInHide = true;
            obj.render = function (ui) {               
                if (parseFloat(ui.cellData) === 0 && (ui.rowData.DataType === "F" || ui.rowData.DataType === "A")) {
                    return "";
                }
            };

[paramvir]

This issue has already been fixed in v8.3.0