Spread Windows Forms Developer’s Guide

[Pages:806]Spread Windows Forms Developer's Guide

0

Developer's Guide

This

guide

provides

introductory

conceptual

material

and

how-to

explanations

for

routine

tasks

for

developers

using Spread

Windows

Forms.

It

describes

how

an

application

developer

would

use

the

properties

and

methods

in

Spread

to create

spreadsheets

on

Windows

Forms,

bind

to

databases,

and

otherwise

create

a

grid

on

data-intensive

applications for

the

.NET

platform.

Getting

Started Understanding

the

Product Understanding

the

Spreadsheet

Objects Understanding

the

Underlying

Models Customizing

the

Sheet

Appearance Customizing

Row,

Column,

and

Cell

Appearance Customizing

Sheet

Interaction Customizing

Row

or

Column

Interaction Customizing

Interaction

with

Cell

Types Customizing

Interaction

in

Cells Managing

Data

Binding Managing

Data

on

a

Sheet Managing

Keyboard

Interaction Managing

Events

from

User

Actions Managing

File

Operations Managing

Printing Working

with

the

Chart

Control Using

Touch

Support

with

the

Component

For

more

information,

be

sure

to

look

at

the

additional

helpful

resources:

For

sample

information,

refer

to

Getting

Started.

For

complete

API

reference

information,

refer

to

the

Assembly

Reference

(on-line

documentation).

For

a

complete

list

of

documentation,

refer

to

the

Spread

Windows

Forms

Documentation

(on-line documentation).

Copyright ? GrapeCity, Inc. All rights reserved.

Spread Windows Forms Developer's Guide

1 Table of Contents

Developer's

Guide 1. Table

of

Contents

Getting

Started Handling

Installation Installing

the

Product Licensing

a

Trial

Project

after

Installation End-User

License

Agreement Creating

a

Build

License Handling

Redistribution Product

Requirements Using

Windows

Regional

Settings

or

Options Using

Satellite

Assemblies

for

Languages Working

with

the

Component Adding

a

Component

to

a

Visual

Studio

2015

or

2017

Project Adding

a

Component

to

a

Visual

Studio

2013

Project Understanding

Parts

of

the

Component Using

Smart

Tags

Drop-Down Using

Verbs

in

the

Property

Window Working

with

Collection

Editors Adding

Support

for

High

DPI

Settings Understanding

the

Spread

Wizard Starting

the

Spread

Wizard Using

the

Spread

Wizard Getting

More

Practice Finding

the

Documentation Getting

Technical

Support Tutorial:

Creating

a

Checkbook

Register Adding

Spread

to

the

Checkbook

Project

Copyright ? GrapeCity, Inc. All rights reserved.

1

0 1-21

22 22 22 22 22-23 23-24 24-26 26 26-27 27 27 27-29 29-31 31-32 32-34 34-36 36-37 37-39 39-40 40 40-41 41 41-43 43 43-44 44

Spread Windows Forms Developer's Guide

Setting

Up

Rows

and

Column

of

the

Register Setting

the

Cell

Types

of

the

Register Adding

Formulas

to

Calculate

Balances Understanding

the

Product Product

Overview Feature

Overview Camera

Shapes Cell

Types

for

Cell

Functionality Chart

Controls

on

a

Sheet Child

Controls

on

a

Sheet Column

Footers

and

Group

Footers Conditional

Formatting Data

Binding Excel

Support

with

Import

and

Export

Capabilities External

Variable Filtering

Data

on

a

Sheet Formula

Text

Box

(Formula

Bar) Formula

Provider

Control Functions

and

Formulas Gradients

for

Button

Cells,

Headers,

and

More Grouping

Rows

in

the

Display Grouping

Rows

or

Columns

in

an

Outline Headers

with

Multiple

Columns

and

Rows Hierarchical

Display HitTest

for

Locating

the

Cursor Indicators

and

Icons

in

the

Interface Ink

Notation

Support Keyboard

Action

Mapping Multiple

Sheets

Copyright ? GrapeCity, Inc. All rights reserved.

2

44-46 46-48 48-49

50 50-51 51-52 52-53

53 53 53 53 53 53 54 54 54 54 54 54-55 55 55 55 55 55 55-56 56 56 56 56

Spread Windows Forms Developer's Guide

Name

Box

Control Notes

for

Cells Panes

or

Viewports Printing

and

PDF Quick

Start

Wizard Right-to-Left

Layouts Row

Preview Searching

and

Search

Dialog Shapes,

Drawing,

and

Annotations

(Freehand

Drawing) Skins

and

Styles

for

Customized

Appearance Sorting

Rows

or

Columns Spannable

Cells Sparklines Spread

Designer Status

Bar Tables Tab

Strip

and

Sheet

Name

Tabs Text

Rendering

with

GDI Title

and

SubTitle Touch

Support Undo

and

Redo

Actions Validation Visual

Styles

for

XP

Themes Namespace

Overview Concepts

Overview Shortcut

Objects Object

Parentage Formatted

versus

Unformatted

Data Cell

Types

Copyright ? GrapeCity, Inc. All rights reserved.

3

56 56-57

57 57 57 57 57 57-58 58 58 58 58 58-59 59 59 59 59 59-60 60 60 60 60 60 60-61 61 61-64 64 64-65 65-67

Spread Windows Forms Developer's Guide

Underlying

Models Understanding

the

Spreadsheet

Objects

Working

with

Sheets Working

with

the

Active

Sheet Working

with

Multiple

Sheets Adding

a

Sheet Working

with

1-Based

Indexing Copying

and

Inserting

a

Sheet Moving

a

Sheet Removing

a

Sheet Showing

or

Hiding

a

Sheet

Working

with

Rows

and

Columns Customizing

the

Number

of

Rows

or

Columns Adding

a

Row

or

Column Removing

a

Row

or

Column Showing

or

Hiding

a

Row

or

Column

Working

with

Headers Understanding

Headers Creating

a

Header

with

Multiple

Rows

or

Columns Showing

or

Hiding

Headers

Working

with

Cells Working

with

the

Active

Cell Creating

a

Range

of

Cells

Understanding

the

Underlying

Models Understanding

the

Types

of

Sheet

Models Understanding

the

Sheet

Model

Classes

and

Interfaces Finding

More

Details

on

the

Sheet

Models Understanding

the

Data

Model Understanding

the

Axis

Model

Copyright ? GrapeCity, Inc. All rights reserved.

4

67 68 68 68-69 69-70 70-71 71-72 72-73 73-74 74-75 75-76 76 76-78 78-79 79-80 80-81 81 81-82 82-85 85-87 87 87-88 88-89 90 90 90-92 92-93 93-94 94-95

Spread Windows Forms Developer's Guide

Understanding

the

Selection

Model Understanding

the

Span

Model Understanding

the

Style

Model Creating

a

Custom

Sheet

Model Understanding

the

Optional

Interfaces Customizing

the

Sheet

Appearance Customizing

the

Appearance

of

the

Overall

Component Setting

the

Component

to

the

Original

Appearance Applying

a

Skin

to

the

Component Creating

a

Custom

Skin

for

a

Component Customizing

the

Renderers Customizing

the

Dimensions

of

the

Component Customizing

the

Outline

of

the

Component Customizing

the

Display

of

the

Pointer Customizing

Painting

of

Parts

of

the

Component Using

XP

Themes

with

the

Component Handling

Right-to-Left

Layouts Applying

Theme

to

Customize

the

Appearance Customizing

the

Individual

Sheet

Appearance Setting

the

Background

Colors

for

a

Sheet Setting

a

Background

Image

for

a

Sheet Displaying

Grid

Lines

on

a

Sheet Adding

a

Title

and

Subtitle

to

a

Sheet Displaying

a

Footer

for

Columns

or

Groups Applying

a

Skin

to

a

Sheet Creating

a

Custom

Skin

for

a

Sheet Customizing

the

Sheet

Corner

Appearance General

Style

of

the

Sheet

Corner Text

Display

in

the

Sheet

Corner

Copyright ? GrapeCity, Inc. All rights reserved.

5

95-96 96

96-99 99-100 100-101

102 102 102-103 103-105 105-108 108-112 112-113 113-114 114-115 115-116 116-117 117-118 118-119 120 120-122 122-123 123-126 126-127 127-131 131-133 133-135 135-136 136-138 138-139

Spread Windows Forms Developer's Guide

Table

Display

in

the

Sheet

Corner Customizable

Cell

in

the

Sheet

Corner Cell

Spans

in

the

Sheet

Corner Header

Count

Synchronization

in

the

Sheet

Corner Drawing

(Rendering)

Style Customizing

Row,

Column,

and

Cell

Appearance Customizing

the

Row

or

Column

Appearance Setting

the

Row

Height

or

Column

Width Resizing

the

Row

or

Column

to

Fit

the

Data Using

Auto

Row

Height Finding

Rows

and

Column

That

Have

Data Creating

Alternating

Rows

and

Columns Customizing

the

Appearance

of

Headers Customizing

the

Default

Header

Labels Customizing

Header

Label

Text Customizing

the

Style

of

Header

Cells Adding

a

Gradient

to

Header

Cells Customizing

the

Header

Grid

Lines Setting

the

Height

or

Width

of

Header

Cells Creating

a

Span

in

a

Header Customizing

the

Appearance

of

a

Cell Coloring

a

Cell Setting

a

Background

Image

to

a

Cell Aligning

Cell

Contents Resizing

the

Cell

to

Fit

the

Data Resizing

the

Data

to

Fit

the

Cell Customizing

Cell

Borders

Creating

and

Customizing

Cell

Borders Creating

Borders

with

Diagonal

Lines

Copyright ? GrapeCity, Inc. All rights reserved.

6

139-141 141-142 142-143 143-144 144-145

146 146 146-148 148-149 149-151 151 151-155 155-156 156-158 158-160 160-162 162-163 163-166 166-167 167-169 169-170 170-172 172-174 174-176 176-177 177-178 178 178-182 182-184

Spread Windows Forms Developer's Guide

Creating

a

Complex

Border

with

Multiple

Lines Creating

a

Span

of

Cells Allowing

Cells

to

Merge

Automatically Allowing

Cell

Data

to

Overflow Creating

and

Applying

a

Style

for

Cells Working

with

Pattern

and

Gradient

Fill

Effects Using

Sparklines

Adding

a

Sparkline

to

a

Cell Customizing

Markers

and

Pointers Specifying

Horizontal

and

Vertical

Axes Working

with

Sparklines Customizing

Sheet

Interaction Customizing

Interaction

with

the

Overall

Component Customizing

the

Scroll

Bars

of

the

Component Customizing

the

Scroll

Bar

Tips Customizing

the

Sheet

Name

Tabs

of

the

Component Customizing

the

User

Interface

Images Allowing

the

User

to

Zoom

the

Display

of

the

Component Customizing

the

Scale

Mode Adding

a

Context

Menu

to

a

Component Adding

a

Status

Bar Hosting

the

Component

on

a

Web

Page Customizing

Clipboard

Operation

Options Customizing

Undo

and

Redo

Actions Locating

the

Pointer

Using

HitTest Customizing

Interaction

Based

on

Events Handling

Events

of

Subeditors Customizing

the

User

Error

Messages Customizing

Interaction

with

a

Sheet

Copyright ? GrapeCity, Inc. All rights reserved.

7

184-186 186-188 188-190 190-192 192-195 195-196

196 196-198 198-200 200-201 201-204

205 205 205-209 209-211 211-216 216-218 218 218-219 219-220 220-221 222 222-224 224-225 225 225-226 226 226 226-227

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download