Legacy Platform documentation
Other Features
Explore 17 practical guides for Other Features in SpreadsheetWeb Legacy Platform, with setup instructions, examples, troubleshooting guidance, and related…
Start here
Core Other Features guides
AnalyticsAnalytics tab is a web analytics interface allowing administrators to monitor traffic and changes made to the applications published on SpreadsheetWEB.Current RestrictionsCurrently following features are not supported: Macros and VBA codeWhile SpreadsheetWEB doesn’t support macros, it can still execute workbooks containing…Formulas with Limited SupportThis page contains a list of formulas with limited support in SpreadsheetWEB, and also suggests possible workarounds and alternatives.My AccountClick your user name on the right hand side of the Control Panel menu and click My Account. Here, you can edit your account details.Supported Excel FormulasSpreadsheetWEB supports almost all common Microsoft Excel functions. The table here lists all currently supported Excel formulas.
Other Features
Custom Worksheet Formulas
DBOpen and DBGetDBOpen and DBGet are custom SpreadsheetWEB functions used for database calls. While DBOpen establishes a connection between the application and the…SpreadsheetWEBAttachmentYou can use this function for SpreadsheetWEB attachment to return the status of an attachment field in your workbook as "uploaded" or "empty".SpreadsheetWEBConnectionStringSpreadsheetWEBConnectionString is a custom function used for getting an encrypted connection string for the application's parent site.SpreadsheetWEBCounterThis function will give the number of times a new entry was created in the database for the given application for counting the number of records.SpreadsheetWEBdataThe SpreadsheetWEBdata function can retrieve data from another web application using the URL of the application from which you want to retrieve data.SpreadsheetWEBFileSpreadsheetWEBfile function creates a hyperlink in the web application. When the user clicks on the hyperlink, the web application will download the file.SpreadsheetWEBImageThe SpreadsheetWEBimage function can be used to download the image and render it into the cell that has this equation by resizing the image.SpreadsheetWEBimageLinkSpreadsheetWEBimageLink (cell reference) takes the relative or absolute address of the images which can be located on the internet or intranet.SpreadsheetWebRecordInfoThe SpreadsheetWEBRecordInfo formula allows user to pull in data about the current record into their spreadsheet for reference.SpreadsheetWEBStatusIndexYou can use this function to retrieve the SpreadsheetWEB status index in the form of an ID number for the active record and use this data in your workbook.SpreadsheetWEBUserInfoThis function displays SpreadsheetWEB user info such as email or role, as they were set during account creation, or from the My Account page.SpreadsheetWEBUserRoleThis function can retrieve the SpreadsheetWEB user role into a cell in your workbook and you can use this feature to in your workbook logic.