Spreadsheet Report Designer

Features: True Excel Authoring

e.Spreadsheet Designer is a true Excel authoring environment that supports and automates virtually all of Excel's functions. It is a visual development tool designed specifically for authoring Excel reports that use Excel features.

Formatting, Functions and Formulas

e.Spreadsheet Designer can automate the creation, formatting and formula processing of spreadsheet data.

• Sheet Creation - creates and names worksheets while inserting rows, columns, and graphical objects.
• Formulas - creates Excel syntax for formulas, calculations and totals that can use dynamic cell references.
• Formatting - supports all the Excel fonts, types and sheet formatting options for cells, rows, columns and headers; for example, borders and merged cells.
• Conditional Formatting - highlights items of interest based on their data value.
• Data Listings - sorts and filters data.

Advanced Features

Spreadsheet reports created with e.Spreadsheet Designer can leverage even the most sophisticated Excel features such as multiple-sheet workbooks and pivot tables.

• Pivot Tables - generates Excel reports that sort, sum and flip data for analysis using the Pivot Table feature.
• Row and Column Groupings - generates spreadsheets using Excel outlining feature with row and column groupings so details can be shown or hidden as needed.
• 2D and 3D Excel charts - supports a variety of Excel charts including column, line, area, step, bar, combination, pie, doughnut, XY (scatter), stock and bubble.
• 3D Multi-sheet Crosstab Workbooks - supports cross-sheet references; for example, a table of contents or a summary worksheet that subtotals the values on other worksheets with control over the ordering of the tabs.
• Cell-level security - supports the ability to control end user access to individual rows, columns and cells when used in conjunction with iServer Express and its Smart Sheets option.

Features Overview Next: Data-driven Layout