Bogemic Grid Control Developer Tour

In the Developer Tour we will show you how easily the Bogemic Grid component can be customized using its basic properties and methods. We will use VBScript for our examples because this language is supported in Bogemic Studio. You can test all these examples in the script editor of Bogemic Studio.

For more information about the properties and methods of Bogemic Grid, please refer to documentation for developers.

Begin Bogemic Grid Developer Tour

Add, remove columns and rows, access internal objects

» Adding columns and rows

» Number of columns and rows

» Accessing columns, rows and cells

» Checking that the column with specified name exists

» Removing columns and rows

» Removing all rows at once

» Resetting the entire Grid object

Customizing columns and rows

» Setting the column height

» Setting the row height

» Defining default sizes

» Changing visibility of columns and rows

» Changing the column title

» Setting data type

Cell properties, adding data

» Adding data to a cell

» Setting the input direction

» Setting the alignment

» Customizing background and font

» Customizing borders and paddings

» Setting data type, inserting objects

Data formatting

» Formatting date and time

» Formatting currency

» Formatting numbers

Formulas and calculations

» Specifying a formula

» Using built-in aggregate functions

» Ranges, formulas, formatting: putting it all together

Data serialization

» Saving to a file

» Importing data in CSV format

» Loading from a file

Merging and splitting of cells

» Merging cells

» Splitting cells

» Merging selection

Customizing headers and appearence

» Changing the visibility and sizing of headers

» Setting the background color and text color of headers

» Setting the line color

» Setting the selection color

» Setting the active cell color

» Changing the visibility of grid lines

Sorting

» Setting the sorting properties of the column

» Sorting, automatic mode

» Resetting sorting

Undo and Redo commands

» Enabling the Undo and Redo mode

» Saving the state of the grid

» Checking that Undo or Redo can be done

Scripting

» Using the ScriptControl object

» Executing script at the time of loading from the file

Adding chart

» Creating a chart

» Customizing the chart properties

Printing

» Customizing the footer and header

» Print setup

» Print preview

» Printing the document