包含：

• TAdvStringGrid：高增壓式字符串網(wǎng)格

• TAdvGridWorkbook：TAdvStringGrid的多表單版本

• TAdvColumnGrid：具有靈活的列導(dǎo)向?qū)傩怨芾淼淖址W(wǎng)格

• TAdvSpreadGrid：TAdvStringGrid的公式識(shí)別擴(kuò)展表單版本

• TDBAdvGrid：TAdvStringGrid的數(shù)據(jù)識(shí)別版本

• TAdvPreviewDialog：打印預(yù)覽對(duì)話框

• TAdvGridPrintSettings：設(shè)置網(wǎng)格打印選項(xiàng)的對(duì)話框

• TAdvGridHTMLSettings：設(shè)置網(wǎng)格HTML輸出功能的對(duì)話框

• TAdvGridFindDialog：網(wǎng)格的查找功能對(duì)話框

• TAdvGridImportDialog：TXT或CSV文件輸入對(duì)話框

• TAdvGridExcelIO：TAdvStringGrid、TAdvColumnGrid、TAdvSpreadGrid和TAdvGridWorkbook的本地XLS文件輸入和輸出

• TAdvGridRTFIO：將網(wǎng)格輸出為RTF文件的組件

• TAdvGridCSVPager：使用分頁CSV文件的組件

• TESBMathsLib：TAdvSpreadGrid的ESB Mathematics庫

• TChartLink：在無需編程的方式下使TChart和網(wǎng)格數(shù)據(jù)保持同步

• TFormCtrlLink：鏈接任何TWinControl派生作為網(wǎng)格內(nèi)置編輯器的組件

• TAdvGridFilterPanel和TAdvGridFilterDialog：TMS網(wǎng)格建立過濾器可視的組件

• TAdvDBFilterPanel和TAdvDBFilterDialog：數(shù)據(jù)集建立過濾器可視的組件

• TAdvGridPDFIO：輸出TAdvStringGrid內(nèi)容為PDF文件的組件

• TAdvGridColumnPicker：用于選擇在網(wǎng)格中顯示的列的彈出控制。列可通過托和拽在列選擇列表和網(wǎng)格中移動(dòng)

靈活打印

• 頁碼、日期、時(shí)間、頁眉或頁腳標(biāo)題

• 不同的頁眉和頁腳字體

• 從顯示或不同打印字體控件使用單元格字體和顏色

• 如果必要的話可以自動(dòng)拆分列到多個(gè)頁面

• 打印網(wǎng)格中選中的區(qū)域

• 設(shè)置頁邊距、打印居中

• 為多頁面輸出使用重復(fù)的固定行和固定列

• 自動(dòng)適應(yīng)頁面

• 打印前預(yù)覽

• 指定每個(gè)單元格的打印邊框

• 附加的自定義打印

• 自動(dòng)換行、富文本、HTML格式的文本打印

• HTML格式的標(biāo)題打印

增強(qiáng)的顯示功能

• 為每一個(gè)單元格設(shè)置文本的左、居中、右對(duì)齊

• 每一個(gè)單元格可以有不同的字體和背景顏色

• 從單行、多行選擇的文本自動(dòng)換行

• 將URL顯示為可點(diǎn)擊的URL

• 當(dāng)文本大于列時(shí)用省略號(hào)替換    

• 隱藏列

• 墻紙

• 富文本單元格

• HTML格式的單元格

易于導(dǎo)航

• 自動(dòng)跳轉(zhuǎn)到下一個(gè)單元格

• 通過單一鍵插入和刪除行

• 單元格自動(dòng)剪切和粘貼

• 具有自動(dòng)跳轉(zhuǎn)的掩蔽編輯內(nèi)容

• 通過鼠標(biāo)點(diǎn)擊立即定位插入符

• 當(dāng)列標(biāo)題被多個(gè)排序方法和自定義方法點(diǎn)擊會(huì)自動(dòng)排序

• 單元格搜索功能

• 禁用單元格編輯功能

• 每個(gè)單元格的不同提示

• 增量鍵查找

• 動(dòng)態(tài)滾動(dòng)提示

• 自動(dòng)填充和自動(dòng)擴(kuò)展范圍以及富文本識(shí)別的簡單、智能剪貼板功能

• 增強(qiáng)的列和行帶著位置指示器移動(dòng)的功能

• 自動(dòng)跳過固定和只讀單元格

靈活的文件輸入和輸出

• 保存到文件、從文件加載

• 保存到CSV、從CSV加載

• 保存到XLS和XLS表單、從XLS和XLS表單加載

• 保存到流、從流加載

• 保存到HTML并且?guī)в蓄伾?、?duì)齊和字體標(biāo)記

• 從ASCII文件格式保存和加載

• 保存為Word DOC文件

• 保存為XML文件

• 從MDB表加載

高級(jí)的編輯控件

• 普通的左對(duì)齊和右對(duì)齊編輯控件

• 掩蔽的編輯內(nèi)容自動(dòng)單元格跳轉(zhuǎn)控件

• 復(fù)選框、組合框、單元格數(shù)據(jù)綁定的復(fù)選框

• 帶有up和down的datetimepicker、timepicker和datetimepicker

• 帶有省略按鈕的編輯控件

• 帶有自動(dòng)查詢和自動(dòng)記錄的復(fù)選框和編輯控件

• 整數(shù)、浮點(diǎn)數(shù)、時(shí)間、日期和spinedit控件

• 按鈕控件

• 單選按鈕控件

• 使用其它自定義編輯器

• 節(jié)點(diǎn)擴(kuò)展和收縮控件

• 富文本內(nèi)置編輯

無處不在的圖形

• 將圖像定位在頂部、底部、右邊、左邊......

• 添加圖標(biāo)、位圖、圖像列表項(xiàng)和基于數(shù)據(jù)的圖像

• 旋轉(zhuǎn)文本

• 多圖像單元格

• TPicture和TFilePicture對(duì)象支持所有種類的圖形格式

• 進(jìn)度條

• 按鈕

• 注釋指示符

TADVSPREADGRID使你的網(wǎng)格自動(dòng)識(shí)別公式

• 簡單的公式編輯接口

• 自動(dòng)重新計(jì)算

• 單個(gè)單元格重新計(jì)算、全部重新計(jì)算

• 廣泛的數(shù)學(xué)函數(shù)

• 保存公式

• 公式中的單個(gè)單元格引用

• 單元格范圍公式

• 基于單元格的網(wǎng)格公式精度

• 公式或公式結(jié)果顯示

• 日期和時(shí)間函數(shù)

• 智能公式識(shí)別復(fù)制和粘貼

• 可擴(kuò)展帶有自定義功能

• 單元格名稱

• 單元格名稱格式可以是RxCy樣式或A1-樣式

• 公式和常量庫

• 內(nèi)部網(wǎng)格公式

更多......

• 支持鼠標(biāo)滾動(dòng)事件

• 將用戶調(diào)整的列寬保存為.INI文件或注冊(cè)表

• 自動(dòng)列編號(hào)

• 各種刪除、清除、移動(dòng)以及隱藏列&行程序

• 通過鼠標(biāo)對(duì)行和列進(jìn)行全選

• 在設(shè)計(jì)時(shí)設(shè)置列標(biāo)題和固定行

• 間斷行選擇

• 扁平和比例滾動(dòng)條

• 網(wǎng)格內(nèi)部或網(wǎng)格、Excel、Word間的OLE拖&拽

• Group和UnGroup功能以及分組排序

• 多列過濾

•  ......

免費(fèi)更新和支持
注冊(cè)用戶會(huì)收到用于商業(yè)用途和源代碼的許可證。所有版本的源代碼更新免費(fèi)的，以及注冊(cè)用戶24小時(shí)支持服務(wù)節(jié)假日除外。

Includes:

TAdvStringGrid: highly supercharged string grid
TAdvGridWorkbook: multisheet version of TAdvStringGrid
TAdvColumnGrid: string grid with flexible column oriented property management
TAdvSpreadGrid: formula-aware spreadsheet version of TAdvStringGrid
TDBAdvGrid: data-aware version of TAdvStringGrid
TAdvPreviewDialog: print preview dialog
TAdvGridPrintSettings: dialog for setting the various grid's print options
TAdvGridHTMLSettings: dialog for setting the various grid's HTML export features
TAdvGridFindDialog: dialog wrapping all grid's find functionality
TAdvGridImportDialog: dialog for help during TXT or CSV file import
TAdvGridExcelIO: native XLS file import & export with TAdvStringGrid, TAdvColumnGrid, TAdvSpreadGrid and TAdvGridWorkbook TESBMathsLib: ESB Mathematics library for TAdvSpreadGrid by ESB Consultancy
TChartLink: Synchronize TChart's with grid's data in a codeless way
TFormCtrlLink: component to link any TWinControl descendent as inplace editor for grids

FLEXIBLE PRINTING

Through properties you can have :

• page number, date, time, title in footer or header
• different header & footer font
• use cell font and color from display or different print font control
• automatically splits columns over multiple pages if needed
• print selected regions from the grid
• set margins, print centered
• use repeated fixedrows and fixedcolumns for multiple page output
• automatic fit to page
• see before you print with preview
• specify borders of each cell for printing
• additional custom printing
• wordwrapped, rich text, HTML formatted text printing
• HTML formatted print titles

ENHANCED DISPLAY

• set text alignment to Left, Justify, Right for each cell
• each cell can have different font & background color
• select from singleline, multiple line to automatic wordwrap
• show URLs as real clickable URLs
• draw ellipsis when text doesn't fit column
• hidden columns
• wallpaper
• rich text cells
• HTML formatted cells

EASY NAVIGATION

• automatically advance to next cell
• single key insert and delete rows
• automatic cells cut and paste
• masked edits with autoadvance
• immediate caret positioning on mouseclick
• automatic sorting when column headers are clicked with several sort methods and customizations.
• cell search functions
• cell editing disable capability
• different hints for each cell
• incremental key lookup
• dynamic scroll hinting
• easy & intelligent clipboard functions with auto fill and auto expand ranges & rich text aware
• enhanced row and column moving with position indicators
• automatic skip over fixed and read-only cells

FLEXIBLE FILE INPUT OUTPUT

• save to file, load from file
• save to CSV, load from CSV
• save to XLS, XLS sheets, load from XLS, XLS sheets
  (native support, without the need to have Excel installed)
• save to streams, load from streams
• save to HTML with color,  alignment and font markup
• save / load from formatted ASCII files
• save to Word DOC files
• save to XML files
• load from MDB tables

ADVANCED EDIT CONTROLS

Have your choice of edit controls

• normal left or right aligned edit controls
• masked edit controls with automatic cell advancement
• checkboxes, comboboxes, cell data bound checkboxes
• datetimepicker, timepicker, datetimepicker with up/down
• edit control with ellipsis button
• comboboxes and edit controls with auto-lookup and auto history
• integer, float, time, date, spinedit control
• button control
• radio button control
• use another custom editor
• expand/contract node controls
• rich text inplace editing

HAVE GRAPHICS EVERYWHERE

Add images to your cells

• control positioning of image on top, bottom, right, left ...
• add icons, bitmaps, imagelist items and data dependent images
• rotated text
• multi image cells
• TPicture, TFilePicture objects opening support for all kinds of graphic formats
• progress bar
• button
• comment indicator

MAKE THE GRID FORMULA-AWARE WITH TADVSPREADGRID

• simple formula editing interface
• auto recalculation
• single cell recalculation, full recalculation
• extensive range of mathematical functions
• save with formulas
• single cell references in formulas
• cell range formulas
• formula precision for grid on cell basis
• display formulas or formula results
• date / time functions
• intelligent formula aware copy and paste
• can be extended with custom functions
• cell names
• cell name mode can be RxCy style or A1-style
• formula & constants libraries
• inter grid formulas

AND MORE ...

• Supports mousewheel events
• Saves user resized column widths to .INI file or registry
• Automatical column numbering
• All kinds of routines to delete, clear, move, hide columns & rows
• Selection of full rows & columns with mouse
• Set column headers and fixed rows at design time
• Disjunct row selection
• Flat and proportional scrollbars
• OLE drag & drop within grid and between grid and Excel, Word, ...
• Group and UnGroup functions and grouped sorting
• Multicolumn filtering
• and more ...
• Your feature could be here too, ask for it !

FREE UDATES & SUPPORT

Registered users receive license for commercial use and source code.
All source code updates for a full version cycle are free upon request.
First class support for registered users within 24h except on holidays.

New gallery of styles makes it easier and faster to choose a visually appealing look for your application: