Spread WPF and Spread Silverlight 1.0.4.0 Released!

Spread WPF and Spread Silverlight version 1.0.4.0 is now released! Enhancements in this version include:

• Full Visual Studio 2012 support

• Enhanced data visualization with new data bar and icon set options

• Enhanced data validation with popup list of valid values and invalid value indicator

• Enhanced PDF export includes sparklines, data bars, and icon sets

• New Custom Drawing Object API for easily adding controls in cells

`  public partial class UserControl1 : UserControl  
  {  
    public UserControl1()  
    {  
      InitializeComponent();  
      DrawingObjectManager.SetDrawingObjectProvider(this.gcSpreadSheet1, new MyDrawingObjectProvider());  
    }  
  }  

  public class MyDrawingObjectProvider : IDrawingObjectProvider  
  {  
    public DrawingObject[] GetDrawingObjects(Worksheet sheet, int row, int column, int rowCount, int columnCount)  
    {  
      if (row == 1 && column == 1)  
      {  
        return new ControlDrawingObject[] { new ControlDrawingObject(row, column, new Button()) };  
      }  
      return sheet.GetDrawingObject(row, column, rowCount, columnCount);  
    }  
  }  

  public class ControlDrawingObject : CustomDrawingObject  
  {  
    private Control _rootElement;  
    public ControlDrawingObject(int row, int col, Control control) : base(row, col) { _rootElement = control; this.ShowDrawingObjectOnly = true; }  
    public override FrameworkElement RootElement  
    {  
      get { _rootElement.Margin = new Thickness(1); return _rootElement; }  
    }  
  }  
`

• Enhanced SplitBoxPolicy for automatic hiding of the split box after the sheet is split;
• Enhanced user keyboard input handling to move the active cell when navigation keys are pressed in edit mode;
• Enhanced IME support to handle entering edit mode using IME;
• More real world samples including 1040 tax form, student calendar, profit/loss projection, and database records operation form

Download the new Spread WPF-Silverlight v1.0.4.0 and start your free 30-day trial today!