Tag Archives: spreadsheet

Spreadsheet for WinForms, V1.1 Released

Posted on by

MindFusion has released Spreadsheet for WinForms 1.1. Here is an overview of the new features:

Export to XLSX (Office Open XML) format
You can use the new ExcelExporter class to export MindFusion.Spreadsheet Workbook objects to Excel. The export is very easy to do – just create an instance of the ExcelExporter class and call its Export method, passing the Workbook object as a parameter.

Export to ODS (OpenDocument Spreadsheet) format
You can now export MindFusion.Spreadsheet Workbook objects to the OpenDocument format. To export a workbook, simply create an instance of the new CalcExporter class and call its Export method, passing the Workbook object as a parameter.

Moving cell ranges
You can now move cells and cell ranges both programmatically and interactively. To move a cell range programmatically, call one of the MoveTo overloads of a CellRange object representing the range to move and specify the destination. To move a range interactively, select the range, click near the end of the selection rectangle and drag the rectangle to the desired location. If you want to disable interactive movement set the AllowMoveCells property of the WorkbookView class to false.

Rows, columns and cell ranges can be moved either programmatically or interactively with the mouse.

Rows, columns and cell ranges can be moved either programmatically or interactively with the mouse.

Moving rows and columns
You can move columns and rows programmatically as well interactively. To move a column/row programmatically, call one of the Move overloads of the ColumnCollection or RowCollection classes respectively, and specify the column/row to move and the desired location. To move columns or rows interactively, select the columns or rows entirely, click on any of the selected column or row headers and drag.

Find and replace
The workbook now provides a set of methods for searching and replacing text. You can search text with the Find and FindAll methods. The former searches for the first cell containing a given text, the later returns all cells matching the criteria. To replace text, use the Replace and ReplaceAll methods.

Improved in-place editing
You can use the extended in-place formula editing, which supports automatic literal, string, cell and cell range coloring and context-sensitive tooltip information for functions. The information for custom functions can be provided through the new ExtendedInformationProvider property of the Workbook class.

You can download the trial version from the link below:

Download MindFusion.Spreadsheet for WinForms 1.1, Trial Version

If you require technical support, you can post a message at the forum, send us an e-mail at support@mindfusion.eu. or use the help desk. MindFusion takes special effort in providing fast and detailed answers to all inquiries that we receive.

About MindFusion.Spreadsheet for WinForms: An easy-to-use programming component suitable for building all types of spreadsheets fast and easy. The tool supports formulas, tool-tips, cell annotations, cell spanning, scrolling and many more. You can add charts and images as well use the flexible style system to design the perfect spreadsheet. The component supports full undo and redo as well copy and paste from Windows clipboard.
You can import spreadsheet data from CSV, XLSX or ODS files and export the final spreadsheet in a number of formats – as images, PDF or CSV, XLSX or ODS files. Various auxiliary forms help you quickly adjust the data and appearance of your spreadsheet. Read more about the features of the component here or check the license prices at the buy page.

Spreadsheet for WinForms is part of MindFusion Pack for WinForms, which offers other useful components that are of great use when you build any type of WinForms application – from a diagramming library to map control to gauges: check them here.

MindFusion.Spreadsheet for WinForms 1.0.1

Posted on by

MindFusion has released version 1.0.1 of its spreadsheet component. The new release has fixed various bugs and offers improved binary and XML serialization. We have made some major changes to the control and it is not backward compatible.

A spreadsheet created with MindFusion.Spreadsheet for WinForms

A spreadsheet created with MindFusion.Spreadsheet for WinForms

You can download the trial version from the link below:

MindFusion.Spreadsheet for WinForms 1.0.1

If you require technical support, you can post a message at the forum, send us an e-mail at support@mindfusion.eu. or use the help desk. MindFusion takes special effort in providing fast and detailed answers to all inquiries that we receive.

About MindFusion.Spreadsheet for WinForms: An easy-to-use programming component suitable for building all types of spreadsheets fast and easy. The tool supports formulas, tool-tips, cell annotations, cell spanning, scrolling and many more. You can add charts and images as well use the flexible style system to design the perfect spreadsheet. The component supports full undo and redo as well copy and paste from Windows clipboard. You can import spreadsheet data from CSV, XLSX or ODS files and export the final spreadsheet in a number of formats – as images, PDF or CSV files. Various auxiliary forms help you quickly adjust the data and appearance of your spreadsheet. Read more about the features of the component here or check the license prices at the buy page.

Spreadsheet for WinForms is part of MindFusion Pack for WinForms, which offers other useful components that are of great use when you build any type of WinForms application – from a diagramming library to map control to gauges: check them here.

WinForms Spreadsheet Databinding

Posted on by

In this blog we will discuss how to display the information from a database inside MindFusion.Spreadsheet for WinForms, how to validate and edit the data and how to write back any changes.

Introduction

We start off by creating a new Windows Forms Application in Visual Studio, adding a WorkbookView control to the main form and adding the Northwind database (nwind.mdb) as a data source. For simplicity we only add the Categories table. After compiling the application we can add the DataSource and the CategoriesTableAdapter as components to the main form.

Loading the data

We traverse the rows in the data source and populate the spreadsheet by assigning the data to the Data property of the respective worksheet cells. To prevent certain columns from being edited (for example auto-increment keys and image fields), we mark these columns by setting their Tag property. All columns and rows beyond those that actually display data are hidden by setting their IsHidden property to true. The column titles are set to the names of the corresponding database columns. Finally, the columns are resized to fit their contents through the ResizeColumnsToFit method of the view. The complete code of the data loading can be found in the LoadData method.

Note, that during the data loading, the loading flag is set to true. This is done to prevent some unnecessary operations in the CellChanging and CellChanged event handlers.

Setting up the view

To resemble a data grid, we need to disable certain functions in the view. More specifically, we need to hide the tabs, the formula bar, the auto-fill handle and the hidden header indicator.

workbookView1.ShowHiddenHeaderIndicators = false;
workbookView1.AllowAutoFill = false;
workbookView1.ShowTabs = false;
workbookView1.ShowFormulaBar = false;

Performing validation

We want to prevent the users from changing the values of certain cells – for example, the cells in the auto-increment column and the cells representing pictures. To do this, we will handle the InplaceEditStarting event of the WorkbookView and the WorksheetCellChanging event of the Workbook. In the event handlers we check the Tag value of the related column. If the column is marked as read-only, we set the Cancel property of the event argument to true, to prevent the edit or change.

Adding new rows

When we populated the data from the dataset, we left an empty row at the bottom of the spreadsheet. The intent is that this empty row should be used to add new rows to the table. When the user edits a cell of the empty row, the row key is automatically calculated and a new empty row is added at the bottom of the spreadsheet. To implement this functionality, we handle the WorksheetCellChanged event of the Workbook. In the event handler, we inspect the row of the edited cell. If this is the last visible row in the spreadsheet, we calculate a key for this row and reveal another row at the bottom of the spreadsheet by setting its IsHidden property to false.

Saving changes to the database

Changes are immediately reflected back to the database from within the WorksheetCellChanged event handler. New rows are added via the Rows.Add method of the Categories data table. Existing rows are updated directly through the respective DataRow object. The changes are effectively performed by calling the Update method of the table adapter.

The following image shows the running sample:

spreadsheet-databinding

The source code is available for download from here:

https://mindfusion.eu/_samples/SpreadsheetDatabase.zip

The trial version of MindFusion.Spreadsheet for WinForms can be downloaded from here:

Download MindFusion.Spreadsheet for WinForms Trial Version

About MindFusion.Spreadsheet for WinForms: A powerful .net spreadsheet component with great capabilities for editing, styling and formatting large amounts of data.

MindFusion.WinForms Pack 2014.R1

Posted on by

MindFusion has just released a new version of its pack of components for WinForms. Here is an overview of the major new features:

Support for Visual Studio 2013

You can now install a toolbox palette for the components in VS2013 as well choose to install VS2013 sample projects.

Spreadsheet-16x16MindFusion.Spreadsheet

MindFusion.Pack for WinForms boasts a brand new component – MindFusion.Spreadsheet for WinForms. It’s a powerful tool for creating complex spreadsheets of all type. The control supports formulas, cell spanning, various import/export options, images and a long list of style & appearance settings. Read more about MindFusion.Spreadsheet for WinForms here.

A spreadsheet created with the new component.

A spreadsheet created with the new component.

diagram16x16MindFusion.Diagramming

Import of Visio 2013 Fies

The new Visio2013Importer class can import .vsdx files created by Visio 2013. The class is part of the MindFusion.Diagramming.Import.Visio.dll assembly and you must reference it if you want to use the importer in your project. The class provides various overloads of the Import method, which let you choose how the diagram is imported – as a DiagramDocument, whose pages correspond to the Visio drawing pages or as a single Diagram, whose content is merged from all imported pages.

Zoom control

The ZoomControl class lets you interactively change the zoom level and scroll position of a DiagramView. It is very easy to set it – place the Zoom control anywhere over a DiagramView and set the control’s Target property to that view. The control provides various customization properties like ZoomStep, ScrollStep, Fill, BorderColor, CornerRadius and more.

Miscellaneous

  • You can change the active page in a TabbedDiagramView control with the arrow buttons When AllowRenamePages is enabled, DiagramPage titles can be renamed interactively by clicking the active tab in a TabbedDiagramView.
  • Several new shapes added for better compatibility with Visio 2013 basic stencil: RightTriangle, Decagon, Trapezoid, Star4Pointed, Star5Pointed, Star6Pointed, Star7Pointed, Star16Pointed, Star24Pointed, Star32Pointed, Donut, Plaque.
  • and more.
The new predefined node shapes.

The new predefined node shapes.

Calendar-16x16MindFusion.Scheduling

Improved support for non-Gregorian calendars

MindFusion.Scheduling now provides better support for non-Gregorian calendars, such as Hijri. The control can also display a Persian calendar through the new PersianCulture. Use the Culture property of the Calendar class to specify the calendar to be used by the control.

New holiday provider

You can use the new AustraliaHolidayProvider (available in the MindFusion.HolidayProviders.dll assembly) to supply the major holidays in Australia for a specific time interval.

A sample calendar with holidays.

A sample calendar with holidays.

The trial version is available for direct download from this link:

Download MindFusion.WinForms Pack 2014.R1

If you run into problems with any of the components, please let us know. We shall be glad to assist you. MindFusion is proud with its excellent technical support – the majority of the questions are answered within hours of receiving them.

About MindFusion.WinForms Pack: A set of five WinForms programming components that provide your application with a rich choice of diagramming, charting, scheduling, mapping, reporting and gauge features. The tools are very easy to implement and use. They boast intuitive API and various step-by-step tutorials to get you started. Both online and offline documentation is available. A sample browser presents you with all the samples for each control to let you easily navigate to what you need. You can check some of the features of each component right now if you look at the online demos:

Visit the features – page of the components for more information about their capabilities:

You can check the prices and licensing scheme here. All components are royalty-free.

MindFusion.Spreadsheet for WinForms Beta Version

Posted on by

MindFusion.Spreadsheet is a spreadsheet component that can be used to create, open, manage, and export spreadsheet documents in many different formats without requiring Microsoft Excel. It is implemented as a .NET control and can be easily integrated into any application targeting the Microsoft .NET platform.

MindFusion.Spreadsheet supports:

  • Importing documents from CSV, XLSX, ODS
  • Export to PDF,CSV,image
  • Numerous chart types
  • Customizable cell appearance
  • Merged cells
  • Conditional formatting
  • Data validation
  • Images
  • Cell annotations
  • Previewing and printing
  • Undo and redo
  • Auxiliary forms
MindFusion.Spreadsheet lets you use an impressive range of calculation formulas.

MindFusion.Spreadsheet lets you use an impressive range of calculation formulas.

MindFusion.Spreadsheet provides intuitive user-interaction model for creating or editing spreadsheet documents. Its programmatic interface is powerful and simple to use. The control has been tested with the most popular .NET development environments and programming languages.

The beta version of the component is available for download from this link:

Download MindFusion.Spreadsheet for WinForms Beta Version

You can learn more about the features of the component here. Take a look at the gallery, which illustrates some of the capabilities of the control. Online documentation is also available at this link.

For technical support, please write at the forum or use email support@mindfusion.eu. You can also use the help desk.

Numerous chart types are available.

Numerous chart types are available.