Product:Apryse WebViewer Spreadsheet Editor
Product Version:11.12.0
Please give a brief summary of your issue:
Excel formulas display as #NAME? in Apryse Spreadsheet Viewer while the same workbook renders correctly in Microsoft Excel.
Please describe your issue and provide steps to reproduce it:
We observed an issue where several formula cells display #NAME? in the Apryse Spreadsheet Viewer, while the same workbook renders correctly in Microsoft Excel.
The workbook contains multiple worksheets with formulas referencing other sheets (cross-sheet references using functions such as SUMIF, COUNTIF, etc.).
Example formulas:
=SUMIF(‘Market Rate’!$J:$J,$B6,‘Market Rate’!$S:$S)
=COUNTIF(Affordable!$J:$J,$B6)
Observed behavior:
-
Microsoft Excel evaluates and displays the values correctly.
-
Apryse Spreadsheet Viewer displays
#NAME?for several cells instead of calculated values.
Steps to reproduce:
-
Open the Apryse Spreadsheet Editor demo.
-
Upload the attached workbook.
-
Navigate to the
Summaryworksheet.(3rd worksheet) -
Observe that multiple cells display
#NAME?. -
Open the same workbook in Microsoft Excel.
-
Observe that the values are calculated and displayed correctly.
Please provide a link to a minimal sample where the issue is reproducible:
Expected behavior:
The spreadsheet viewer should evaluate and display the same calculated values as Microsoft Excel.
Actual behavior:
Several cells display #NAME? in Apryse Spreadsheet Viewer.
Additional notes:
-
The issue appears related to formula parsing/evaluation for cross-sheet references.
-
Workbook structure and formulas are intact.
-
The issue is consistently reproducible with the attached workbook.
sample file example .xlsx (85.4 KB)