Features

This section comprises the features available in GcExcel.

Worksheet

• Work with cells, range and basic worksheet operations.

Workbook

• Work with basic workbook operations.

Comments

• Add or delete comments, show or hide comments, set rich text, comment layout or author of a comment.

Hyperlinks

• Add, configure or delete hyperlinks.

Sort

• Apply sorting and its various types.

Filter

• Apply filtering and its several types.

Group

• Apply grouping over data in rows or columns.

Conditional Formatting

• Apply conditional formatting in a cell or range of cells.

Data Validations

• Add, modify and delete data validations.

Data Binding

• Bind data to sheet, cell or table columns.

Digital Signatures

• Add, countersign, verify and delete digital signatures.

Formulas

• Use formulas to carry complex calculations.

Custom Functions

• Create custom functions to implement custom arithmetic logic.

Shapes and Pictures

• Work with shapes and pictures in a worksheet.

Dynamic Array Formulas

• Work with Dynamic Array Formulas.

Styles

• Set styles to format cell appearance.

Document Properties

• Learn how to set built-in or custom document properties.

Form Controls

• Use form controls to make your worksheet interactive and to get inputs from the users.

Barcodes

• Supports 11 types of barcodes in worksheet, their JSON I/O and export to PDF.

Theme

• Apply built-in or custom themes to change the workbook appearance.

Chart

• Work with charts to display data graphically.

Table

• Use tables to organize large amount of data efficiently.

Pivot Table

• Use pivot table to perform analysis of complex information and summarize data.

Pivot Chart

• Use pivot chart to display pivot table's data graphically.

Sparkline

• Use sparklines to insert graphical illustration of trends in data.

Slicer

• Use slicers to perform quick filtration of data in tables and pivot tables.

Print

• Configure print and page settings to manage printing options.

Logging

• Capture debug, error, information and warning logs to locate issues and finding out their root cause.

Defined Names

• Name the tables or ranges within workbook or worksheet scope.