![]() The Spreadsheet control supports a broad range of 2D and 3D charts: from the commonly used Column and Line charts to modern Excel 2016 charts (Box and Whisker, Histogram, Pareto, Waterfall, Treemap, Sunburst, and Funnel). Charts and Sparklines You can create charts and sparklines to visualize data in your documents. All shape types are supported: from simple lines and rectangles to 3D shapes with advanced effects. Shapes and Pictures The Spreadsheet control allows you to add shapes and pictures to worksheets. ![]() The Spreadsheet control ships with the Name Box and Name Manager that allow users to create, view, edit, and delete names. Defined Names You can define descriptive names for cells, formulas, and constants to make your formulas easier to understand and maintain. You can embed custom data editors within cells to facilitate and validate user input. A cell reference defines the position of a cell or cell range in a worksheet.Ĭells can contain different values: numbers, dates, text, logical values, and formulas. Cells and Cell RangesĪll worksheet data is stored in cells. You can insert, copy, hide, freeze, resize, or remove rows and columns. Rows and Columns Worksheets in the Spreadsheet control display 1,048,576 rows and 16,384 columns (the number of rows and columns in spreadsheet management programs such as Microsoft Excel). You can create, rename, move, copy, hide, or delete worksheets. Supported File Formats Worksheet A worksheet is a single page within a workbook. The Spreadsheet control allows you to save modified data to a file or export your document to PDF and HTML. You can create a new document, load an existing file, or retrieve data from different data sources (arrays, lists, data tables, and so on). When you load the Spreadsheet control, it displays an empty workbook. WorkbookĪ workbook is a spreadsheet document. You can manage these elements in code or from the Spreadsheet control’s user interface. Review the list of supported document elements. Get Started with the WinForms Spreadsheet If you are new to the SpreadsheetControl or consider it for an upcoming project, review the following topics first: The WinForms Spreadsheet control emulates Microsoft® Excel® capabilities and allows you to create, load, edit, save, and print spreadsheet documents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |