Author Topic: Excel Values Display Wrong  (Read 425 times)

Punit

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 46
    • View Profile
Excel Values Display Wrong
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Excel Values Display Wrong
« Reply #1 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;
          })