Thursday, August 28, 2008
HOME

.NET Product Center SPREAD FOR .NET BUNDLE SPREAD FOR WINDOWS FORMS SPREAD FOR ASP.NET INPUT PRO FOR WIN FORMS SUBSCRIPTIONS    SOA Center SPREAD FOR BIZTALK SERVER SPREAD FOR SHAREPOINT SERVER    COM Product Center DEVELOPER TOOLBOX DATABASE PACK SPREAD TAB PRO INPUT PRO LIST PRO CALENDAR OBJX BUTTON OBJX    Download Center TRIALS UPDATES    Purchase Center ORDER NOW GOVT / GSA LICENSE AGREEMENT WORLDWIDE RESELLERS CORPORATE DISCOUNTS WHY BUY?    Support Center TECHNICAL SUPPORT FORUM SUPPORT OPTIONS VIDEO LIBRARY SECTION 508 TRAINING CLASSES    Our Company CUSTOMERS SAY... ABOUT US CONTACT US JOB OPENINGS AWARDS CASE STUDIES WHY CHOOSE FARPOINT  FarPoint Technologies  (800) 645-5913  fpsales@fpoint.com

»Spread for ASP.NET » What's New What's New   I own: version 3 | version 2.5 | version 2.0 What's new in v.4 since v.3: The following lists the new features and enhancements that have been added to Spread for ASP.NET 4: Improvements to the Component AJAX Extenders All controls in the AJAX Control Toolkit can add or attach client behaviors to a target control. The target control is exposed as the Editor property of the extender cell type in FarPoint Spread. Print to PDF Use one of the SavePdf methods or the SavePdfToResponse methods. The former saves the FarPoint Spread to the specified PDF file. The latter saves the FarPoint Spread to the specified PDF response. New skins Sheet corner customization Add client events at design time Row template editor You can allow a row edit template to be displayed so the user can edit the contents of an entire row using a specified template or form. In the example shown here, the entire row of data is presented to the user as a vertical form with an Update and Cancel button at the bottom of the form. New default appearance Title and SubTitle Column footers and group footers You can show a column footer or a group footer or both for the sheet and put information in the footer such as formulas or text. The column footer is an area at the bottom of the sheet. The group footer is an extra row of footer cells at the bottom of a sheet with grouping, if you are using the grouping feature. Quick start wizard New improved Spread Designer You can quickly customize a spreadsheet component using the Spread Designer. Whether you are prototyping a complete spreadsheet component or simply customizing some aspect of your spreadsheet component, the dedicated graphical interface offers many features to save time and effort. It also provides a way for you to add data to and set properties for the component easily, including properties that are not available at design time in Visual Studio. You can set both design-time and run-time properties. In most cases you can preview changes before applying them to the spreadsheet. Enhanced color support when saving to xls LayoutMode For a more compressed format of displaying information, you may want to display columns with multiple lines of information. You can create row templates, also called aggregation subtotals or multiple-line columns. You can display multiple lines within a column, such as to display address information together in one column that involves multiple fields of information. New Cell and Cell Features Multi-Column combo cell HyperLink cell tooltips ForeColor for button cell BackColor for button and combo cells OnClientClick property for button cells OnClientChanged property for combo cells Tag cloud Improvements to the User Interaction Texttips for scroll bars (ScrollingContentVisible) This feature adds the ability to display scroll tips when the control is scrolled. The scrolling grid content can be displayed in a horizontal direction or vertical direction. By default, the content of the scroll tips is the contents of row header or column header but the developer can also customize this content to display other information. Skip cells with tab key (TabStop) Move multiple columns New Events FetchGroupText New Methods Open and Save methods for sheets Import or Export Open XML (.xlsx) files New Properties SelectionPolicy New CursortType enum SaveViewStateToSession New Client Methods GetActiveChildSheetView HideMessage ShowMessage Back to Top What's new in v.4 since v.2.5: The following lists the new features and enhancements that have been added to Spread for Web Forms 3: New Performance Features and Improvements All of the features listed above plus: Optimized page load time due to smaller page size for various cell types Tested with ASP.NET AJAX and continued AJAX support Load on Demand paging (virtual mode) You can allow the Web page to load on demand -- as the user scrolls further down the spreadsheet the FarPoint Spread component on the client loads another page of rows from the server as needed. This is similar to what was called "virtual mode" in the COM version of the product. You can specify the number of rows to load initially and how many are added in subsequent loads. You can specify these properties at the component level (for FpSpread) or at the sheet level. FpSpread         AllowLoadOnDemand         OnLoadOnDemand         LoadInitRowCount         LoadRowIncrement SheetView         AllowLoadOnDemand         LoadInitRowCount         LoadRowIncrement New User Interaction Features and Improvements Grouping You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this is helpful to display the data in the order the user needs. The user selects columns by which to sort and the component then organizes and displays the data in a hierarchy with rows organized accordingly. To select a column by which to group and display that data, either double-click on the header of that column or click and drag that column into the grouping bar at the top of the page. You can provide grouping to allow users to sort the data with multiple levels of groups by dragging additional column headers into the grouping area. You can set up the display so that the items are shown initially all expanded or all collapsed when grouping is performed. You can set the colors and other formatting of both the hierarchy names and the data in the rows when grouping is performed. SheetView Property Description GroupBarBackColor   Set the background color of the grouping bar GroupBarHeight   Set the height of the grouping bar GroupBarVisible   Set whether to display the grouping bar GroupInfos   Set the data model to use in grouping GroupMaximumLevel   Set the maximum number of levels of grouping allowed Grouping API Member Description  IGroupSupport Interface   Interface that supports grouping GroupDataModel Class   Class of grouping data in the underlying models Group Class   Class in the underlying models that supports grouping Grouped and Grouping Event   Events in FpSpread class GroupingEventArgs   Event data for grouping GroupInfo   Class that represents grouping information GroupInfoCollection   Collection of grouping information Conditional Formatting You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional statement. You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid, that is, if the operation is satisfied. For example, you may want to change the background color of a cell based on the value of the cell. If the value is below 100 then the background color would be changed to red. The condition statement is "less than 100" and consists of a comparison operator "less than" and a condition, in this case a single constant "100". The condition can be a constant (expressed as a string) or an expression. Some condition statements have two conditions and an operator: for instance, if the cell value is between 0 and 100, then change the background color. In this case, the comparison operator is "between" and the first condition is 0 and the last condition is 100. For a complete list of operations, refer to the ComparisonOperator enumeration. GetConditionalFormats methods SetConditionalFormat methods ClearConditionalFormats method IConditionalSupport interface ConditionalFormat class Drag and move columns in a sheet Moving columns just got easier.You can allow your users to click on the header of a column and drag it to another location on the spreadsheet. You can set this with the AllowColumnMove property in the FpSpread class. Additional operation modes Now you have two more options when setting up the amount of interactivity with the spreadsheet. You can now allow users to select multiple contiguous rows in the spreadsheet. To the OperationMode enumeration, we have added these settings: MultiSelect - Allows the user to select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)   ExtendedSelect - Allows the user to select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)  Expando support (for additional properties) We have added an interface that supports the ability to extend objects by adding arbitrary properties (called expando properties). Additional methods for getting an object based on tags You can get objects in the spreadsheet based on application tags you have assigned. You can get cells, columns rows. The following methods have been added to the SheetView class: GetCellFromTag GetColumnFromTag GetRowFromTag New Properties Allow Header resize option You can allow the user to resize the header. The AllowHeaderResize Property in the FpSpread class determines whether to allow the user to resize the header. CSS support for sheet name tabs You can customize the appearance of the sheet name tabs using cascading style sheets (CSS). UseClipboard New Combo Box Cell Properties You can bind a datasource to a combo box cell. DataSource DataSourceID DataMember DataTextField DataValueField New Client-side Features AddKeyMap Adds a key map. This method allows you to map a keyboard key which causes an action, such as moving to the next or previous cell or row, or the first or last column. You can also scroll to a cell. MoveToFirstColumn Moves the active cell to the first column. MoveToLastColumn Moves the active cell to the last column. MoveToNextCell Moves the active cell to the next cell. MoveToPrevCell Moves the active cell to the previous cell. MoveToNextRow Moves the active cell to the next row. MoveToPrevRow Moves the active cell to the previous cell. ScrollTo Moves the active cell to the specified cell. New Calculation Engine Features and Improvements GoalSeeking capability COLUMN function ROW function VALUE function  Back to Top What's new in v.4 since v.2.0: The following lists the new features and enhancements that have been added to Spread for Web Forms 2.5: All of the features listed above plus: More Control Features AJAX support  - [View Sample] Fp_Client folder configuration Searching options  - [View Sample] More Row and Column Level Features Row filtering added - [View Sample] Frozen rows and columns using Microsoft Internet Explorer  - [View Sample] More Browser Support Client script support for Mozilla FireFox New Text Cell Properties MaxLength property PasswordChar property TypeEllipses property New Printing Features PrintHeader/PrintFooter PrintSheet event New Properties AllowUserFormulas property CurrentPage property New Formula Functions DAVERAGE formula DCOUNT formula DCOUNTA formula DGET formula DMAX formula DMIN formula DPRODUCT formula DSTDEV formula DSTDEVP formula DSUM formula DVAR formula DVARP formula OFFSET formula  Back to Top What's new in v.4 since v.1: The following lists the new features and enhancements that have been added to Spread for Web Forms 2: All of the features listed above plus: More Cell-Level Control of Data Cell referencing across sheets (cross-sheet referencing) Allow automatic merging of cells with identical content Over 300 built-in functions for formulas; Date and Time, Engineering, Financial, Information, Logical, Look Up, Math and Trigonometry, Statistical, Text Adding a cell span now supports zero-width anchor cells More Cell Type Features Percent cell type for percent values Cell type can have background image Allow postback of combo box and check box cells More Sheet-Level Control of Data Save to and load from Excel stream object Printing an entire sheet Hiding an entire sheet Hierarchical view support for collections More Customization of the Interface Command bar can be at top or bottom of control Scroll bar colors can be customized Hierarchy expand and collapse image can be customized Sort indicator image can be customized Allow hiding buttons (while not disabling them) Manage ability of user to expand rows in hierarchical display Manage ability of user to use tab key for advancing More Client-Side Scripting Features Event notifying scrolling of sheet Event notifying active cell changing ActiveCol and ActiveRow properties are read/write Method to hide a column by setting width to zero Method to set column width Method to put Spread into edit mode

Have a question? RSS Subscribe     SPREAD TRAINING DATES ANNOUNCED TakeNote is offering hands-on, instructor-led classes for Spread for Web Forms and Spread for Windows Forms here in the RTP, NC location. When? June 26-27, 2008 FPS201: Implementing FarPoint Spread for Web Forms "This is an EXCELLENT product, well worth the money spent. Your developers have made it possible for us to produce an excellent system in a time frame which far exceeded our initial goals. In no way would we have been able to develop a grid which so perfectly suited our needs with the same cost." Guy Munton Jackson Software Developer "In many instances, our web based solutions simply would not be possible without FarPoint, and would have forced to look at alternative methods of delivering this functionality. As a Microsoft Certified Gold Partner, our small company reaches corporations in the Fortune 50(yes, fifty) list. Utilizing FarPoint products has allowed us to provide software to these companies for a fraction of the cost as compared to other 3rd part controls. Thank you for all of the hard work and amazing support you have given us over the years! " Brian Rudolph Lead Software Architect "Spread for Web Forms is a 'gotta-have-it'! If you are doing anything even remotely grid or spreadsheet related you are wasting time if you are not using this product. Couple that with the great support and now you're rockin!" Ed Staffin Chief Technology Officer

Copyright © 1991-2007 FarPoint Technologies, Inc. All rights reserved. All names are property of their respective owners.