35 seconds to build graph for non-trivial workbook

Description

For non-trivial workbook (10+ worksheets, multiple rows and formulas referencing cross worksheets + named expressions) it takes hyperformula about 30-35 seconds to build dependency graph.

Steps to reproduce

1. Get xlsx workbook (not able to publicly share my sample due to NDA and it is timeconsuming to reproduce it. most value is in math model, not numbers...)
2. Translate xlsx into dictionary of array of arrays + load all named expressions. Use any library which is able to read xlsx format (XLSX from SheetsJS, ExcelJS, etc)
3. do buildFromSheets (with default options)
4. Measure time of buildFromSheets execution.

Demo

Here is profiling result: https://drive.google.com/file/d/1A9hGck4U8BdXs_dJ3_jllLH51qDVDSEr/view?usp=sharing

Your environment

Mac OS X, 2.5 GHz Quad-Core Intel Core i7, 16 GB 1600 MHz DDR3

• HyperFormula version: ^1.3.0
• Browser Name and version: server side environment. node --version v14.15.4
• Operating System: Mac OS X

Links

Start with the profiling result linked in the issue and trace the buildFromSheets execution path. Reproduce the reported delay with a workbook containing multiple worksheets, cross-sheet formulas, and named expressions, then compare measured build times after investigation; done means the graph build is materially faster for this workload.