What is the difference between Public and Private SpreadsheetWEB Cloud Licenses?
SpreadsheetWEB is a server software which can transform Microsoft Excel spreadsheets into web applications by ‘reading’ the spreadsheet content and translating its features for web consumption. The underlying workbook is kept on a server machine where the SpreadsheetWEB software must be installed.
SpreadsheetWEB can be used as a cloud solution by signing up and paying a monthly fee. Pagos hosts a public cloud where all users can publish their web applications. However, this is a shared environment and to ensure that all of our users have a secure and stable experience, some features are disabled. Pagos also offers SpreadsheetWEB on a ‘private cloud’. This means that Pagos dedicates a virtual server to the client’s use and no other application or client will be sharing this server. All installation, configuration, and server maintenance tasks are handled by Pagos. The pricing includes licensing and server maintenance costs. Private cloud approach offers several benefits like flexible web application configurations, custom branding, and superior performance.
As with any server software, load speed of your applications will vary based on several factors such as your internet connection, network overhead, the number of active users, and server capacity. One of the most important factors is the time it takes to load the workbook onto server memory. Bigger workbooks with more data and formulas take longer to load. Because SpreadsheetWEB public cloud is shared by other cloud users, workbooks are loaded when they are needed. But in private cloud accounts, we have ability to preload and cache these workbooks on server memory. So when a request comes, it uses a cached instance. As a result, application loading times in private cloud is faster than public cloud.
You can customize the SpreadsheetWEB control panel to replace the logos and contact links with your own. Private cloud license will also give you the ability to configure the stylesheets (CSS) of your web applications to further customize their looks.
All web applications hosted on SpreadsheetWEB public cloud have their URL include our domain (www1.spreadsheetweb.com/…). With a private cloud license, you’re not tied to our default domain and can change the URL to any other domain you own.
Although SpreadsheetWEB doesn’t natively support VBA macros, there are other built-in methods like the User-Defined Functions (UDF) (put link to EDF page) and custom UI applications (put link to custom UI page). Due to security restrictions, these functionalities are not allowed on the public cloud. A private cloud license is your key to custom UI applications and your only way to implement any macros or similar functionality into a web application.
Private cloud packages allow you to customize user roles, access rights, and create custom user fields. User roles can be configured to give users access to certain pages, or even specific buttons in the control panel.
Being the system administrator of your own server means you can also track its status live. Administration interface in SpreadsheetWEB control panel displays node status, hardware usage and application activity.
SpreadsheetWEB private cloud also supports Single-Sign-On (SSO) integration. This will help you to integrate SpreadsheetWEB applications with you internal systems where authenticated users can access permitted applications on your private cloud server without having to re-enter user credentials.