Spread for windows forms。 Spread for WinForms

Spread Windows Forms Documentation

For windows forms spread

Interact with the data in Spread from within your application, then export your spreadsheets to Microsoft Excel for portable distribution to your users. Spread also supports binding a range of cells to a data source and providing a range of cells as a data source. T CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVARIANCE. for a quick summary of importing and exporting Excel files• "We integrated SpreadsheetGear for. CEILING ISOWEEKNUM MUNIT NUMBERVALUE PDURATION PERMUTATIONA PHI RRI SEC SECH SHEET SHEETS SKEW. WinForms spreadsheet components continue to deliver this familiar Excel experience to your end users. Charts can be bound to external data sources, and you can allow end users to make changes to the chart formatting at run time. Our customers have been very pleased. Document APIs Forums for all versions of GrapeCity Documents for Excel and GrapeCity Documents for PDF• NET Framework, Universal Windows Platform UWP , Xamarin. TEST FISHER FISHERINV FORECAST FREQUENCY GAMMA. with complete API description• Without writing a single line of code, design new application forms or edit existing application forms using the Microsoft Excel-like, visual, drag-and-drop user interface. The data visualization functionality provided in Spread gives your data a voice. Windows Forms spreadsheets, MultiRow grid, stand-alone Chart, Formula Provider and the Spread Designer run-time license. for a quick summary of importing and exporting Excel files• For more information about the satellite language assemblies, see. config Spread Windows policy files policy. Spread can bind to any. dll Excel file compatibility assembly FarPoint. Dashboard Data Visualization• Time-tested by Developers Worldwide• Spread Forums for all current versions of Spread. The run-time support for unbound rows and columns within bound data allows for inclusion of aggregated information or for performing what-if scenario analysis. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. NET app toolbox in one spreadsheet control Leverage the extensive. If you want to take advantage of the ink capabilities of Spread Win, you will need to install the runtime components of the Microsoft Tablet PC SDK. EQ RSQ SKEW SLOPE SMALL STANDARDIZE STDEV. msm Merge module for redistributing a project using Spread for WinForms ExcelCompatibility. PRECISE GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE COVAR EXPONDIST FDIST FINV FTEST GAMMADIST GAMMAINV LOGINV LOGNORMDIST MODE NEGBINOMDIST NORMDIST NORMINV NORMSDIST PERCENTILE PERCENTRANK POISSON QUARTILE RANK STDEV STDEVP TDIST TINV TTEST VAR VARP WEIBULL ZTEST AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETA. With Spread Windows Forms you can develop feature-rich user interfaces with an object-oriented, extensible set of classes to incorporate spreadsheet functionality into your applications. Spread for WinForms Spreadsheet Component Available as part of the Spread. NET products and VB for the Spread COM product. dll Input Man Designer assembly GrapeCity. dll Spread PDF assembly FarPoint. dll Spread Ink assembly FarPoint. NET Standard could also be used on other platforms such as the full. PRECISE GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT CELL ERROR. dll Base Windows Forms design assembly FarPoint. Spread for WinForms Features• config Spread policy files FarPoint. Flexible Data Binding Support• This means you get thorough documentation, technical support, and expert advice. I conducted a three month analysis comparing three top spreadsheet controls for. Forum Channels• I build a reporting engine for my company and SpreadsheetGear made it awesome. Formatting the appearance of cells and changing its color• It's one of the few components to be succesfully localized, sold, and supported in Japan, Europe, the United States, and other parts of the world. When you need the power of a Microsoft Excel-like spreadsheet combined with the functionality of an advanced data grid, you need Spread —the world's 1 selling spreadsheet component for Microsoft Visual Studio development. NET spreadsheet apps Code-free extensibility and customization with Spread designers Instantly design a powerful Excel-like. Import Microsoft Excel documents and preserve complete formatting. You can easily use the capabilities of this component in. dll is not installed to the GAC. Developers use the Spread for WinForms controls to embed advanced Microsoft Excel-compatible spreadsheet features into their Windows Forms applications — features that would otherwise be considered impossible to achieve. It has 80 graphic charts with the ability to customize its appearance in a graphical environment• For example, you can use sparklines to provide small, focused cell-level charts or use Camera Shapes to bring together content from various locations within a spreadsheet — even on different sheets — into a dashboard. with complete API description• For an introduction to the use of the product, this user documentation is available:• NET application developers: SpreadsheetGear, SyncFusion XlsIO, and ComponentOne Spread. PRECISE GEOMEAN GROWTH HARMEAN HYPGEOM. Add this DLL as a project reference in order to use it with Microsoft Visual Studio 2008. You can use the application-ready templates, the Component Chart and Computing Engine, and its rich API to build a variety of spreadsheet programs and information dashboards. Spread for WinForms is available as part of the Spread. dll Spread Text Renderer assembly FarPoint. XLOOKUP and XMATCH are enhanced in Spread. You may download the modified SharpZipLib source code used in the Spread Excel assembly for xlsx file compression from. with complete list of calculation functions• Designers are available for WinForms, WPF, and ASP. Spread introduced a number of technologies to Microsoft developers, including the first full-featured spreadsheet component for Visual Basic originally called FarPoint Spread , and the first spreadsheet designer. Unlike generic arrays, dynamic arrays automatically resize when the data is inserted or removed from the source range. Embedded, Programmable Microsoft Excel Platform Import Microsoft Excel documents and preserve complete formatting. NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. exe Spread Designer executable FarPoint. INTL YEAR YEARFRAC BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERF. Spread supports the current versions of Excel as well as multiple Excel file formats, including Excel 2007 - current XLSX , Excel 97 XLS , comma-delimited CSV , and text TXT. NET spreadsheets, SpreadJS JavaScript spreadsheets, and SpreadCOM spreadsheets. MATH COMBINA COT COTH CSC CSCH DAYS DECIMAL ENCODEURL FILTERXML FLOOR. INV NORMSINV PEARSON PERCENTILE. with complete list of calculation functions• dll Spread control assembly FarPoint. The built-in Chart Designer and UI-type editors make it easy to design stunning charts and spreadsheet dashboards. Ink assembly is currently built with version 1. Make life easier for your users with the SpreadsheetGear Windows Forms and WPF spreadsheet controls which combine Visual Studio integration with the ability to create, read, modify, view, edit, format, calculate, sort, filter, print and write Microsoft Excel 97-2019 and Excel for Office 365 workbooks without Excel. ActiveReports Forums for all versions of ActiveReports and ActiveReports Server• dll Calendar control assembly FarPoint. dll Localized resource assembly for Chinese and English GrapeCity. DIST HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGNORM. Add charts at design time using the Spread Designer and Chart Designer, or through code using the comprehensive Chart object model. The easy-to-use, intuitive Spread Designer makes designing detailed spreadsheets and input or data grid display screens a snap. ComponentOne Forums for all current editions of the ComponentOne. NET Standard product, official support for Excel 2013, Excel 2016, Excel 2019 V8. is a registered trademark and is a trademark of SpreadsheetGear LLC. INV MAX MAXA MEDIAN MIN MINA MODE. When a cell contains a dynamic array formula, multiple values are returned because the elements of the array spill into the adjacent empty cells. The definite winner was SpreadsheetGear, with ComponentOne Spread. NET, WPF and the new WinRT platform. Create expressive 2D and 3D charts within your spreadsheets. Comprehensive Excel document support for information sharing across the Enterprise. Computing Engine This component provides you with over 300 different functions to perform different calculations. SpreadsheetGear provides the most Excel-like experience, is the most performant, and provides the most responsive and capable product support. Native Microsoft Excel Compatibility• TEST CHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIND FINDB FIXED LEFT LEFTB LEN LENB LOWER MID MIDB PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TRIM UPPER USDOLLAR VALUE ACOT ACOTH AGGREGATE ARABIC BASE BINOM. NET, and ClubFarPoint are trademarks of GrapeCity, Inc. MATH GAMMA GAUSS IFNA IMCOSH IMCOT IMCSC IMCSCH IMSEC IMSECH IMSINH IMTAN ISFORMULA ISO. Design Time Support for Code-free Development• SpreadsheetGear 2017 adds a new SpreadsheetGear for. For product details, this reference documentation is available:• Enhanced Shape Engine• This product supports more than 80 different chart types and in a graphical environment you can choose and customize the graphical appearance of the desired chart. Spread for WinForms features built-in design dialogs for end-user interaction to create and modify charts like in Microsoft Excel. for a quick comparison to the COM version If, after looking at this documentation, you still have a question or need technical support, see. NET UI control product line, including ComponentOne Studio and ComponentOne Studio for Xamarin. Forms, Mono and any other platform that supports. Software Architect Thermo Fisher Scientific Austin, TX Tutorials demonstrate SpreadsheetGear for. NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications High-speed performance and optimized app size Every platform of Spread. While Spread has continued to evolve over the years, the development team has stayed true to the legacy and continues to support VB. The Spread for WinForms object model allows. Wijmo Forums for all Wijmo products, including Wijmo Core, FinancialChart, FlexSheet, MultiRow, OLAP, and ReportViewer• For an introduction to the use of the product, this user documentation is available:• DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP DATE DATEDIF DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NETWORKDAYS. You can easily manage, analyze, and calculate the data, and ultimately display the results graphically with different charts in the dashboard. For product details, this reference documentation is available:• NET Windows Forms developers to customize UI elements and manage the behavior of the control by extending built-in classes and assigning custom objects to Spread. for a quick comparison to the COM version If, after looking at this documentation, you still have a question or need technical support, see. When you purchase Spread, you get a market leader. Ability to build information dashboards• Connect and combine into Group Shapes to design logos or custom dashboard controls that can be scripted to perform user actions. NET Framework for Windows Forms solutions. NET spreadsheet app with our desktop designer apps—no learning curve required. Integrated Spreadsheet Chart Control• Extensive Customization Options• NET Architect Applied OLAP, Inc. You can view the print preview; customize the print output; output the information in PDF format, and even customize the print API to change the printing function. With this component you can design spreadsheet applications in a variety of desktop and web platforms in the least amount of time. Spread, FarPoint Spread, FarPoint Spread for Windows Forms, Spread Windows Forms, FarPoint Spread for Web Forms, Spread ASP. Create flowcharts, process diagrams, cell callouts, and more with over 150 shapes, lines, and arrows. NET ensures maximum performance and speed for your enterprise apps, and its modular structure means you only need to add what you use to your. In addition to creating spreadsheets, this product also has the ability to build Grid, entry forms and information dashboards. 2 , 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering and. NET is an advanced spreadsheet component for the Visual Studio environment. dll Spread Chart Designer assembly FarPoint. dll the Spread Designer assembly and FarPoint. TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE AND FALSE IF IFERROR NOT OR TRUE ADDRESS AREAS CHOOSE COLUMN COLUMNS HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS TRANSPOSE VLOOKUP ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING CEILING. To get started, use the product documentation listed here. dll Spread Chart Windows Forms control assembly FarPoint. dll Base Windows Forms assembly FarPoint. Applicable to desktop and web applications. Use Spread Windows Forms to develop front-ends to database applications and give your users access to multiple sheets using many types of cells and predefined sheet styles. Build spreadsheets with data grouping, filtering, sorting, and more• Spread for WinForms delivers: A complete high-performance. Compatible with Excel and available in a variety of formats• In the discussion of printing, this component is also a stepping stone and offers various options for printing information. That difference makes it possible for us to develop and release a viable product with the Microsoft. Integrated charting engine and data visualizations for informative and effective business dashboards. Dynamic Arrays• NET spreadsheets, custom functions, and the formula text box, your computing power is optimized for big data, complex calculations, and advanced Excel models Advanced Data Visualization Use the many chart types, sparklines, custom data visualization functions and more to enable your users to create the most advanced data visualizations. Multi-language support• It is also possible to import and export data from Excel files, formatting and applying security rules. Strong Public Knowledge Base• NET Standard enables developers for iOS, Android, Linux, macOS and UWP to easily take advantage of scalable Excel Reporting, comprehensive Excel compatible charting APIs, the fastest and most complete Excel compatible calculations and more using a single assembly which implements the same API employed by thousands of Windows developers for more than a decade. PRECISE COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR FLOOR. NET is capable of sorting data, filtering, grouping and displaying hierarchies and data sheets. Powerful computing engine with 300 different computing functions• As the first spreadsheet component on the market for Visual Basic, Spread has been used by tens of thousands of developers worldwide for the past 20 years. Ability to print and customize the print process• NET versions added an array of new Excel-compatibility features and advanced customization options. RANGE BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CEILING. Interact with the data in Spread from within your. Spread for WinForms provides extensive support for using dynamic array formulas in the spreadsheets. Add powerful viewing, editing, formatting, calculating, charting and printing capabilities to your Windows Forms, WPF and Silverlight applications with WorkbookView and FormulaBar controls. 2 and Excel for Office 365 V8. WinForms and WPF applications can also utilize the Workbook Explorer, Range Explorer, Chart Explorer and Shape Explorer dialogs. You can even take ultimate control of the printing in your code using the owner print drawing support to easily create reports on your data. Spreadsheets also supports printing to PDF documents. All other trademarks and registered trademarks are the property of their respective owners. dll Spread designer assembly FarPoint. 7 of the Microsoft Tablet PC SDK. I wanted to share my extensive analysis with any other developers out there trying to find the right spreadsheet control for their. imp Load key map API XML files Text for IntelliSense support in Visual Studio. Additional data visualization is provided in Spread through Chart support, conditional formatting, filtering, and grouping. Special thanks to the SharpDevelop Team for allowing us to use the SharpZipLib file compression library. Select from a wide range of printing options to customize the printing of your spreadsheets. Select from various chart types, including Column, Line, Pie, Bar, Area, XY, Bubble, Stock, XYZ, Doughnut, Radar, and Polar. NET data source, and includes built-in support for displaying relational datasets. Plus, be confident knowing that for nearly 20 years, over 100,000 developers have adopted and enriched Spread with their experience and skill, and have contributed to a global online knowledge base in the form of forum discussions, articles, and blogs. Thanks for making my team look like miracle workers! exe Spread Designer executable for x64 and other environments SpWinREDIST. INTL NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY WORKDAY. dll Spread control assembly for exporting to HTML FarPoint. " Luke Melia, Software Development Manager Oxygen Media, New York "We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for. Cut and paste the Slicer to another sheet to operate as a dashboard control.。 。 。

8

GrapeCity predict.i2pi.com for WinForms 11.40.20177

For windows forms spread

。 。 。

16
。 。

Spread Windows Forms Documentation

For windows forms spread

。 。 。

7
。 。

Spread for WinForms Spreadsheet Component

For windows forms spread

。 。

4

%%ItemTitle%%

For windows forms spread

。 。

14
。 。

Spread Windows Forms Documentation

For windows forms spread

。 。 。

15

GrapeCity predict.i2pi.com for WinForms 11.40.20177

For windows forms spread

4

Spread Windows Forms Documentation

For windows forms spread

。 。

。 。