Summary
We did tests on the frontend with our streaming formulas and we were able to confirm that having multiple streaming cells can lead to performance issues on the frontend i.e. unresponsive / glitchy user interface. This can also possibly result to the updating of values slower than the expected rate.
Why This Matters
Our users are expected to work on large spreadsheets containing more than 50,000 streaming cells (potentially more for some users)
Having the capability to determine which cells are viewed by the users will open the possibilities for us to optimize the streaming values. We can make changes to our add-in wherein only the cells being viewed by the users are automatically updated instead of everything.
Proposed Change/s
- Add capability to determine which cells are being viewed by the user
Benefits
Having this capability will prevent the scenario wherein the frontend will be not as responsive when dealing with multiple streaming values