Friday, July 04, 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 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 Windows Forms » Product Tour » Managing Data » Removing Data Removing Data from a Sheet   Back to Top  Clearing Data from a Sheet You can remove both data and cell formatting from a selected cell or range or cells, or remove only the data, leaving the cell formatting intact. You can remove the data using any of these clear methods in the default data model: Clear, which clears both data and formulas ClearFormulas, which clears only formulas ClearData, which clears only data ClearRange, which clears data for a range of cells Parameters Row Row index of first cell in range Column Column index of first cell in range rowCount Number of rows in range columnCount Number of columns in range dataOnly Whether only the data is copied, or the data and formatting Clear only data ' Clear the data, formatting, formulas, and notes from a range of cells. FpSpread1.ActiveSheet.ClearRange(0, 0, 6, 1, False)

Have a question? RSS Subscribe     Tour Home Overview Appearance User Interaction Cell Types Formulas Managing Data Data Binding Import/Export Printing Keyboard Interaction Shapes Models Spread Designer   Map

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