Product documentation
App Designer
Build application interfaces with pages, controls, formulas, and events that turn spreadsheet logic into guided workflows.
Start here
Core App Designer guides
Add Controls with Quick AddUse Ctrl+Space in Layout & Controls to add a SpreadsheetWeb control quickly, choose its destination, and bind it to a compatible workbook named range.ApplicationConfigure your SpreadsheetWeb application, update its workbook, and manage access, database, backgrounds, analytics, SEO metadata, and social sharing.Application BackgroundsChoose application background artwork, colors, or uploaded images in SpreadsheetWeb Designer, with semantic accents, animation options, and theme previews.Build an Application with the Design LibraryBrowse ready-made flows, pages, and components in SpreadsheetWeb Designer, preview responsive layouts, and import a design before connecting your workbook.Connect a Design to Your WorkbookConnect imported designs to workbook inputs and results, review labels and navigation, and resume guided setup from Page overview in SpreadsheetWeb Designer.Creating an ApplicationCreate a SpreadsheetWeb application from an Excel workbook or Google Sheets file, add tags, select an application type, and start designing.Custom ActionsThe Custom Actions allow defining custom actions with custom action hooks with custom code that will be executed with calculations.DatabaseIn SpreadsheetWEB, designer applications can store input and output fields when you define them in the database designer.ElementsSelect workbook cells, ranges, charts, and images in SpreadsheetWeb Elements to generate interface controls, then refine their layout in the Designer.Layout & ControlsBuild application pages in SpreadsheetWeb Designer with the Design Library, control toolbar, Properties panel, Pages drawer, and guided workbook connections.Names EditorNames Editor The “Names” module of the SpreadsheetWeb Hub Designer facilitates the management of named ranges in spreadsheet applications. Named ranges…Pages and NavigationConfigure SpreadsheetWeb pages, navigation and loading appearances, wizard tracking, and page transitions with previews and application-wide style options.Power QueriesThe Power Queries module enables you to import your Power Query scripts directly from your Excel file into a SpreadsheetWeb application. This allows you to…QueriesIn the Queries module you can create database queries to retrieve data from applications in your workspace. Queries are created using an intuitive user…ScriptsScripts allow you to modify the behavior of your applications by executing additional JavaScript functions at various points of the application session…StylesheetsUsing CSS (Cascading Style Sheets) code, Stylesheets will give your applications a unique style, and can also help you customize the user interface further.Text Resource (Run-time) EditorOverride application runtime text, import or export text resources, and customize labels used by current File Upload and other controls.Validation MessagesThe active spreadsheet has no named ranges! The message appears if the Excel file lacks named ranges. For a spreadsheet to be transformed into a web…
App Designer
Events
The Events submodule is comprised of a series of highly customizable, complex processing tasks that can be bound to and triggered by Action controls. These include actions that can be used to generate documents, map to Excel files, design and send emails, and execute custom code.
Email ProcessConfigure SpreadsheetWeb Email Processes, add dynamic content and attachments, and share saved records with expiring public View or Edit links.Excel ExportGenerating an Excel export from your web applications can be useful for when you want your users to be able to analyze their results.Goal Seek EventA Goal Seek is an iterative calculation event with custom action hooks. This feature is not supported on Public Cloud accounts.Print ProcessCreate PDF or Word print processes, map workbook data and images to templates, and use repeating documents and high-quality PDF output.Simulation EventLearn how to use the Simulations event in SpreadsheetWeb to run Excel Data Table simulations directly within your web application. Trigger multi-scenario…Solver EventA Solver Event is an optimization tool that can be used for what-if analysis. This feature is not supported on Public Cloud accounts.
App Designer
Misc
App Designer
Special Formulas
The Designer includes support for some special formulas. These formulas can be added to your Excel workbook. Though they will not be evaluated within Excel, the workbook will be able to evaluate them once uploaded to the server with a designer application. Inclusion of these formulas can significantly expand the potential of your workbook’s integration with the designer application at runtime and your overall workflow generation.
DbConnect FunctionDbConnect Function DbConnect is a custom SpreadsheetWEB Hub function used for database calls. The formula allows the application to connect an external…SpreadsheetWebRecordInfoThe SpreadsheetWebRecordInfo formula can inject record-related information into your workbook to build up logic based on records metadata.SpreadsheetWebUserInfoThe SpreadsheetWebUserInfo formula can inject user-related information into your workbook to build up logic based on the specific user.
App Designer
UI Controls
Advanced LabelA content control can simultaneously handle all static content of the page, as well as dynamic labelling based on named ranges defined in the spreadsheet.Button ControlA button control is used to trigger specific actions in the workflow of an application, such as navigation, calculation, and saving.CalendarA calendar control is a basic control that allows user to select dates and/or times for data entry. Each calendar control must be associated with a Single…ChartsA chart is a complex output control that allows users to display a visual representation of a data set in the user interface.CheckboxA checkbox control allows end users to enter a TRUE or FALSE value. Each checkbox must be associated with a bool named range in the workbookContainersOrganize controls with containers in SpreadsheetWeb Designer. Configure surface styles, colors, tabs, subdivisions, visibility, and dynamic headers.DropdownA dropdown control allows users to select a value from a defined list for data entry. Each dropdown must be associated with a Single Named Range (SNR) in…File UploadConfigure file uploads, image previews, maximum file counts, and the current File Upload appearance gallery in SpreadsheetWeb Designer.GaugesGauges are output controls that display a visual representation of a cell value in the user interface. Widely used in data analysis and presenting key…Input GridsAn input grid is a control that allows the user to select and edit a range of items corresponding to a Table Named Range (TNR) from the spreadsheet model.MapsA map is a complex output control that allows users to visualize geographic data and its relationships. You can choose from hundreds of available maps and…Output GridAn output grid is a control that allows the user to view a range of items corresponding to a Table Named Range (TNR) from the spreadsheet model.Radio ButtonA radio button list control allows users to select a value from a defined list for data entry. Each radio button list must be associated with a Single Named…SectionsA section is a row in the user interface that can be subdivided to break up the screen. All components must be placed within a section.Simple LabelCreate structured Simple Label content with disclosures, styled tables, tables of contents, image framing, inline emphasis, and dynamic workbook values.SliderA slider is a control that allows user to input values by shifting a horizontal or vertical button within a predetermined minimum and maximum values.TextboxA textbox is a basic control that allows user to input values for capture, storage, or calculation. Each textbox must be associated with a Single Named…