GS-Calc 21.3
- Introducing GS-Calc
- Notational conventions (numbers, formulas, dates)
Performance and compatibility
- Ensuring high performance
- Formula compatibility between GS-Calc and other spreadsheets
Entering data
- Editing and filling cells
- Copying cells vs duplicating copied cells
- Using AutoScroll Range to automatically move between 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
- Update options
- Ensuring high performance
- Replacing formulas automatically in worksheets
- Entering Unicode characters
- Selecting cells, navigation, scrolling, key shortcuts
- Performing multiple selections to combine their values
- 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
- Selecting functions to display within the table toolbar and related options
- Hiding view elements / maximizing the table view display areas
- Cross-highlighting columns/rows for better readability
- Using the Dark Mode
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
Output functions
- imageIf(), messageIf(), playSoundIf(), setFormatIf()
Solver functions
- Solver functions
Regular Expressions
- Using regular expressions in formulas
- Find & Replace
- Syntax
Using the FILTER() function
- Filtering data tables
- Creating the Filtering Expressions
Using Python in GS-Calc()
- Using Python functions as UDF()
- Installing Python and GS-Calc integration
Inspecting cells and finding certain cell types
- Using the Inspect Cells pane
Comparing workbooks, worksheets and cell ranges
- Comparing workbooks, worksheets and cell ranges
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
- Creating mini-charts in cells
- Inserting images, files in worksheets
- Images and lists of images in cells
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
|