Spreadsheet Editor shows #VALUE! for valid Excel formulas

babu03022000 · February 23, 2026, 7:02am

Product:

Apryse Web SDK – Spreadsheet Editor

Product Version:

v11.11.0

Please give a brief summary of your issue (email subject):

#VALUE! error shown for valid Excel formulas in Spreadsheet Editor (v11.11.0)

Please describe your issue and provide steps to reproduce it:

We are using the Apryse Web SDK Spreadsheet Editor (v11.11.0) to display XLSX files in the browser.

When opening an Excel file that contains calculated/formula-based fields, some cells show #VALUE! in Apryse, while the same file displays correct numeric values when opened in Microsoft Excel.

For example, in our file, the “Loss / To Lease” column shows valid numbers in Excel, but displays #VALUE! in Apryse Spreadsheet Editor. This appears to be related to formula evaluation or unsupported Excel functions in Apryse.

Steps to reproduce:

Open the provided XLSX file in Microsoft Excel – values render correctly.
Open the same XLSX file in Apryse Web SDK Spreadsheet Editor (v11.11.0).
Observe that some formula-based cells (e.g., Loss / To Lease column) show #VALUE! instead of numeric values.

This impacts our reporting and print workflows, as users rely on these calculated fields being displayed correctly.

Please provide a link to a minimal sample where the issue is reproducible:

system · February 23, 2026, 7:02am

Hello, I’m AiRon, an automated tech support bot While you wait for one of our customer support representatives, I can help you with your question.

It seems that you are encountering issues with the Apryse Web SDK Spreadsheet Editor displaying #VALUE! errors for some formula-based cells. This can occur if the Spreadsheet Editor does not fully support certain Excel functions or if there are discrepancies in how formulas are evaluated.

Some things you can try:

Check if the specific Excel functions used in your formulas are supported by the Apryse Web SDK Spreadsheet Editor. Some complex or newer functions may not yet be implemented.

Verify if there are any dependencies or references in the formulas that might not be correctly interpreted by the Spreadsheet Editor.

Consider simplifying formulas or breaking them down into smaller parts to identify which specific function or operation is causing the issue.

Ensure that all necessary cell data and references are correctly loaded and accessible in the Spreadsheet Editor.

Here are some resources that might help you:

Functions Support in Apryse Spreadsheet Editor: Check for a list of supported Excel functions.

Spreadsheet Editor Troubleshooting Guide: Offers general troubleshooting advice for common issues.

Setting Up the Spreadsheet Editor: Ensure your environment is correctly configured.

Using the Spreadsheet Editor: Understand how to use the editor effectively.

Known Limitations of the Spreadsheet Editor: Find out about any current limitations that might affect your use case.

Hopefully, this helps you solve your problem while you wait for a human to get back to you.

darian.chen · February 23, 2026, 4:52pm

Hello Babu,

Thank you for contacting Apryse Forums.

I don’t see the provided Excel file. Could you try attaching it again?

Best Regards,

Darian

babu03022000 · February 23, 2026, 5:20pm

testfile.xlsx (940.7 KB)

this is the ref file which has issue

kaden.rettig · February 25, 2026, 10:44pm

HI Babu,

This is Kaden from the Apryse Support Team – I’ve reproduced the behavior you’ve described regarding the display of these IF Excel formulas internally, and as such, I have submitted a report to our Engineering team for further investigation. Our team will reach out here when more information is provided. If you have any further questions or issues regarding the PDFNet SDK or WebViewer, please don’t hesitate to ask.

Thank you,
Kaden Rettig
Technical Support Engineer
Apryse Support Team