Saturday, May 17, 2008
HOME

.NET Product Center SPREAD FOR .NET BUNDLE SPREAD FOR WINDOWS FORMS SPREAD FOR WEB FORMS 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    Our Company CUSTOMERS SAY... ABOUT US CONTACT US JOB OPENINGS AWARDS CASE STUDIES WHY CHOOSE FARPOINT  FarPoint Technologies  (800) 645-5913  fpsales@fpoint.com  FarPoint Europe (UK)  +44 (0) 1798 812 372  salesEurope@fpoint.com

»Spread for Web Forms » What's New What's New The following lists the new features and enhancements that have been added to Spread for Web Forms 3: New Performance Features and Improvements 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 The following lists the new features and enhancements that have been added to Spread for Web Forms 2.5: 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 The following lists the new features and enhancements that have been added to Spread for Web Forms 2: 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     "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.