Hi Jacob,
We tested the same reproducible file using the latest experimental WebViewer build. The original issue where the SpreadsheetEditor continuously loaded and threw the getcellrange null error in the console no longer occurs. The file now loads successfully in the experimental build.
However, we still observe that formulas using named ranges are not evaluated and display #NAME? in columns E–G, while the same file works correctly in Microsoft Excel. As mentioned earlier, we understand that named ranges are currently not supported and that a feature request has been raised.
Since our users frequently upload Excel files generated from financial and accounting systems that rely on named ranges for calculations and summaries, this behavior can lead to incorrect values being displayed in the viewer. For this reason, support for named ranges would be important for our workflow.
We have also observed a related behavior in another support thread where formulas display #NAME? instead of evaluated values:
We would appreciate if this feature could be considered in future releases.
Thank you for the assistance.