ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: Punit on September 14, 2022, 05:13:08 pm

Title: Excel Values Display Wrong
Post by: Punit on September 14, 2022, 05:13:08 pm

Dear Team,
we bind our excel sheet using pqgrid but Some of the values display wrong. Please find the excel file from the URL.

Steps to Reproduce Issue
1.  Click On Balance Sheet Tab
2. Search (ii) Other Financial Assets.
3. In the original file you can see 1313.40 on the right side table and on the web wrong values display 0.00

URL: http://powergst.microvistatech.com/BalanceSheet.xlsx

Title: Re: Excel Values Display Wrong
Post by: paramvir on September 15, 2022, 04:33:18 pm

Dear Punit

It's caused by quite deep nesting of complex formulas, even Google sheets displays #REF! in that cell.  I would look further into it

Meanwhile If you using it as a read only spreadsheet, then you can use this code to remove formulas upon importing the excel file into a workbook and before importing into pqgrid, that way the value would be displayed correctly.

Code: [Select]

          pq.excel.eachCell(wb.sheets, function(cell){         
                cell.formula = null;
          })