Tag Archives: formula

Spreadsheet for WinForms, V1.2

Posted on by

MindFusion has released a new version of Spreadsheet for WinForms with the following new features:

Formatted text support
You can import, display and export texts with mixed formatting. You can create formatted texts programmatically by assigning a FormattedText instance to the Data property of cells. Currently the control supports: font name and size, bold, italic, underlined, strikeout, and text color.

New Functions
At your disposal are 22 new functions, which have been added to the core calculation engine, including a full set of database functions, such as DGET, DSUM, and so on. Check Function Reference for additional information.

Improved in-place editing
Now when you type a new formula, pressing the arrow keys will result in navigation within the worksheet (instead of adjusting the caret position) and the selected cell or cell ranges will be inserted as a reference in the currently edited formula.

Sport events schedule

Sport events schedule

You can download the trial version from the link below:

Download MindFusion.Spreadsheet for WinForms 1.2, 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.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.