GS-Calc
- Introducing GS-Calc
Entering data
- Editing and filling cells
- Entering numbers, text strings, date/time strings and error codes
- Using cell references
- Merging and splitting cells
- Entering formulas
- Using formula composer
- Using array formulas
- Ensuring high performance
- Replacing formulas automatically in worksheets
- Entering unicode characters
- Selecting cells, navigation, scrolling, key shortcuts
- Inserting series
- Inserting sequences and series using formulas
- Drop-down lists
- Using the Increment, Decrement and Operations commands
- Spell-checking and adding Hunspell dictionaries
- Generating and inserting passwords
Worksheet views
- Splitting worksheet views
- Row and column synchronization options
Pivot Tables
- Using pivot tables
- Creating Pivot Table Reports
- Pivot Table Functions
Monte Carlo Simulations
- Using Monte Carlo simulations
Lookup functions
- vLookUp() function
- hLookUp() function
- Match() function function
- Unique() function function
- Sort() function function
Regular Expressions
- Using regular expressions in formulas
- Find & Replace
- Syntax
Using the FILTER() function
- Filtering data tables
- Creating the Filtering Expressions
Inspecting cells and finding certain cell types
- Using the Inspect Cells pane
Formatting
- Data styles and numeric formats
- Using cell style palettes
- Using custom cell styles
- Conditional formatting
- Using hyperlinks
- Lists of images in cells
- Charts in cells
Charts and images
- Creating charts and selecting chart data
Password protection
- Protecting and encrypting workbooks
- Protecting workbook structure
- Protecting individual cells
- Protecting and encrypting workbooks
Opening and saving files
- Content and statistics
- Managing the list of recently used files and folders
- GS-Calc *.gsc and ODF *.ods files
- Excel (*.xlsx, *.xml, *.xls) files
- GS-Base (*.gsb) file
- PDF files
- Text files
- Text *.zip archives
- dBase/Clipper/FoxPro files
- MySQL files
- SQlite (*.db) files
Printing workbooks
- Printing and print previewing
Settings
- Modifying program settings
- Legacy compatibility
Scripting
- Methods, properties and sample usage
- Samples
Custom DLL libraries
- Adding functions in DLL libraries
COM Programming
- Interfaces, methods and properties
- C++ samples
Support
- Contacting technical support
Copyrights
- Copyrights
|