spread 部分技巧（国外英文资料）.doc

spread 部分技巧（国外英文资料） How to set Spread for ASP.NET to fill the form form id = form1 runat = server style = height: 100% div style = height: 100%; border: solid 1px red FarPoint: FpSpread ID = FpSpread1 runat = server Height = 100% Width = 100% Hide the command bar (command bar) We need to add the following code fp_client folder in the web.config file to load correctly: The appSettings add key = fp_client value = fp_client / / appSettings The browser that detects the page is IE8, IE9, or Firefox. Window.onload = function () { Var spread = document.getelementbyid ( FpSpread1 ); If (document.all) { / / the test is IE9 (spread. AddEventListener) / / addEventListener event listener Spread. AddEventListener ( EditStopped , EditStopped, false); } The else / / if IE is the other version of IE Spread. OnEditStopped = editStopped; } / / if its Firefox The else { Spread. AddEventListener ( EditStopped , EditStopped, false); } } Use the editstopevent event to get the value of the cell on the client The function editStopped () { Var spread = document.getelementbyid ( FpSpread1 ); Var activeRow = spread. GetActiveRow (); Var activeCol = spread. GetActiveCol (); Var value = spread.getvalue (activeCol); Alert (value); } Specify a sequence of columns by customizing the cell type (allowing the user to only click on a specific column header to order the rows in the form) Create a new cell type by inheriting GerenralCellType. Override the PaintCell method, and add the onDoubleClick attribute to the client to implement the custom sorting function. You then invoke the PaintCell method of the base class. Apply custom cell types on columns that are allowed to be sorted. 3. Add the control column head show/hide image code for sorting indicator, also need to add a page Render event, in this case, and build an HTML table, the ranking indicator picture added to the HTML table of single cell, and then added to the column header cell. The image of the sorting indicator needs to be inc