Combobox shows default or empty value after calculation.

  In Excel, you can delete contents of a cell with data validation. From a user perspective, this is a combobox with all selected options, and a blank item. To set an empty value, the web application requires an actual blank item. If the validated cell is blank...

Why am i getting “Inserting worksheet is disabled” message?

  SpreadsheetWEB wizard inserts a sheet called “PSW_Sheet” to every Excel file when it is opened for the first time. This operation is done after file loading is completed. If your workbook is protected (this can be a user enabled protection or...

Why does my SpreadsheetWEB application timeout?

  SpreadsheetWEB applications have a default time-out of 5 minutes. If there is no activity in the browser window for 5 minutes, SpreadsheetWEB will close the session and remove its data from the server. This means any unsaved data will be lost. It is possible to...

Sometimes it takes too long to load my application. Why?

  SpreadsheetWEB uses a caching algorithm to cache workbook calculations in the memory of the server, and it stays in the memory if that workbook is in use. If the application is not in use (after a 10 minutes timeout in Software-as-a-Service SaaS environments),...