# FarPoint Spread
> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/FarPoint_Spread
> Markdown URL: https://mediated.wiki/source/FarPoint_Spread.md
> Source: https://en.wikipedia.org/wiki/FarPoint_Spread
> Source revision: 1354431460
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)
{{Short description|Computer software}}
{{Multiple issues|
{{COI|date=December 2019}}
{{More citations needed|date=December 2009}}
}}
{{Infobox software
| name = FarPoint Spread
| logo = SpreadLogo.jpg
| screenshot =
| caption = FarPoint Spread displaying a spreadsheet designer in Visual Studio 2010
| developer = FarPoint Technologies, now [GrapeCity](/source/GrapeCity)
| released = 1991
| programming language =
| operating system = [Microsoft Windows](/source/Microsoft_Windows)
| language = English, Japanese
| genre = [Business intelligence](/source/Business_intelligence) [Spreadsheets](/source/Spreadsheets) [Reporting](/source/Financial_reporting)
| license = [GrapeCity](/source/GrapeCity) [EULA](/source/Software_license_agreement)
| website = {{URL|https://www.grapecity.com/en/spread/}}
}}
'''FarPoint Spread''' is a suite of [Microsoft Excel](/source/Microsoft_Excel)-compatible [spreadsheet](/source/spreadsheet) components available for [.NET](/source/.NET_Framework), [COM](/source/Component_Object_Model), and Microsoft [BizTalk](/source/BizTalk) Server. Software developers use the components to embed Microsoft Excel-compatible spreadsheet features into their applications, such as importing and exporting Microsoft Excel files, displaying, modifying, analyzing, and visualizing data. Spread components handle [spreadsheet](/source/spreadsheet) data at the cell, row, column, or worksheet level.
This article is about the last FarPoint edition of the Spread product line. Spread is now developed by [GrapeCity](/source/GrapeCity), Inc. Since the acquisition, Spread for Biztalk Server has been removed from the product line and SpreadJS, a JavaScript version, has been added.
==History==
* '''1991''' Spread released as a [DLL](/source/Dynamic-link_library) control as the initial product offering from FarPoint Technologies, Inc.
* '''1990s'''
** Spread [VBX](/source/VBX) released.[{{Citation
| last = Glass
| first = Brett
| author-link =
| publication-date = May 1, 1995
| date = May 1, 1995
| title = PRODUCT COMPARISON Visual Basic custom controls, Dress up your VB apps
| periodical = InfoWorld
| series =
| publication-place =
| place =
| publisher =
| volume =
| issue =
| pages = 74–75
| url = https://books.google.com/books?id=0zoEAAAAMBAJ&q=%22FarPoint+Spread%22+-inpublisher%3Aicon&pg=PA97
| issn = 0199-6649
| pmid =
| pmc =
| doi =
| oclc = 6510141
| accessdate =
}}]
** Spread [ActiveX](/source/ActiveX) released.
** These components are now known as Spread COM.
* '''2003''' Spread for Windows Forms released as a completely new managed C# version prompted by the launch of Visual Studio .NET.
* '''2003''' Spread for Web Forms (now Spread for ASP.NET) released.
* '''2006''' Spread for BizTalk released.[[http://reddevnews.com/articles/2008/04/01/dundas-chart-for-net-farpoint-spread-for-biztalk-and-netadvantage-for-net-and-wpf.aspx Redmond Developer News: FarPoint Spread for BizTalk Released]]
* '''2009''' FarPoint Technologies acquired by GrapeCity.[[http://www.businesswire.com/portal/site/home/permalink/?ndmViewId=news_view&newsId=20090916005077&newsLang=en Business Wire press release: GrapeCity Acquires FarPoint Technologies]][[http://www.bizjournals.com/triangle/stories/2009/09/14/daily44.html BizJournals press release: GrapeCity to buy 50-person Triangle concern]]
==Versions==
* Spread for Windows Forms: 5.0
* Spread for Web Forms: 5.0
* Spread COM: 8.0
* Spread for BizTalk: 3.0
Image:Sdv5_cap_vs2010_LORES.jpg|Screenshot of FarPoint Spread for Windows Forms version 5 in Visual Studio 2010.
Image:SpreadAspNet.jpg|Screenshot of FarPoint Spread for Web Forms (ASP.NET).
Image:FarPointSpreadCOM.jpg|Screenshot of FarPoint Spread COM.
===Spread for Windows Forms===
FarPoint Spread for Windows Forms is a Microsoft Excel-compatible spreadsheet component for Windows Forms applications developed using Microsoft [Visual Studio](/source/Visual_Studio) and the [.NET Framework](/source/.NET_Framework). Developers use it to add grids and spreadsheets to their applications, and to bind them to data sources.[[http://www.vsj.co.uk/articles/display.asp?id=548 VSJ magazine review: Spread for Windows Forms]] In version 4.0, new cell types were added to display barcodes and fractions, and exports for XML and PDF were added.[{{Cite web |url=http://www.sdtimes.com/SearchResult/31704 |title=SDTimes review: FarPoint Spread for Windows 4.0 |access-date=2009-12-18 |archive-url=https://web.archive.org/web/20120225175949/http://www.sdtimes.com/SearchResult/31704 |archive-date=2012-02-25 |url-status=dead }}][[http://reddevnews.com/articles/2008/03/01/chart-fx-7-farpoint-spread-for-windows-forms-4--and-the-dotfuscator-product-line.aspx Redmond Developer News: FarPoint Spread for Windows Forms 4.0 Released]]
===Spread for ASP.NET===
FarPoint Spread for ASP.NET is a Microsoft Excel-compatible spreadsheet component for ASP.NET applications. Developers use it to add grids and spreadsheets to their applications,
===Spread for COM===
FarPoint Spread 8 COM allows COM and ActiveX applications to incorporate spreadsheet features. In the 1997 book ''Visual Basic 5 for Windows for Dummies'', Wally Wang lists an early version of Spread COM in Chapter 35: The Ten Most Useful Visual Basic Add-On Programs.[{{Citation
| last = Wang
| first = Wally
| title = Visual Basic 5 for Windows for Dummies
| publisher = IDG Books Worldwide
| place =
| year = 1997
| page = 443
| isbn = 9780764501227
| url = https://books.google.com/books?id=FQyjsMG1Q_wC&q=%22FarPoint+Spread%22+-inpublisher%3Aicon
}}]
===Spread for BizTalk===
FarPoint Spread for BizTalk Server allows developers to integrate Microsoft Excel documents into Microsoft BizTalk applications. Spread for BizTalk Server includes two components:
* '''Spreadsheet Pipeline Disassembler''' - Parses data from Microsoft Excel (XLS and Excel 2007 XML, CSV, TXT) documents into XML data for processing through Microsoft BizTalk Server receive pipelines.
* '''Spreadsheet Pipeline Assembler''' - Assembles data from Microsoft BizTalk applications into Microsoft Excel (XLS or Excel 2007 XML) or PDF documents for transport through Microsoft BizTalk Server send pipelines.
Developers find it a useful tool for organizations with Microsoft BizTalk Server Enterprise Application Integration.[{{Cite web |url=http://pcquest.ciol.com/content/enterprise/2007/107062901.asp |title=PCQuest article: "XLS to XML in Just a Few Steps" |access-date=2009-12-18 |archive-url=https://web.archive.org/web/20090602233025/http://pcquest.ciol.com/content/enterprise/2007/107062901.asp |archive-date=2009-06-02 |url-status=dead }}] Prior to this release, BizTalk users wanting to use Excel data had to manually open the files and copy and paste data between the two applications.[{{Cite web |url=http://codebetter.com/blogs/jeff.lynch/archive/2006/09/09/BizTalk-Server-2006_3A00_-FarPoint_2700_s-Spread-for-BizTalk-Server-2006-Released_2100_.aspx |title=CodeBetter MVP: Spread is a "long awaited innovation" |access-date=2009-12-17 |archive-date=2008-10-26 |archive-url=https://web.archive.org/web/20081026065821/http://codebetter.com/blogs/jeff.lynch/archive/2006/09/09/BizTalk-Server-2006_3A00_-FarPoint_2700_s-Spread-for-BizTalk-Server-2006-Released_2100_.aspx |url-status=dead }}]
==Features==
These features are common to all versions.
* Predefined cell types, including:
** currency
** date time
** number
** percent
** regular expression
** button
** check box
** combo box
** hyperlink
** image
* Formula support, including:
** cross-sheet referencing
** over 300 built-in functions
* Import and export:
** import to Microsoft Excel-compatible files
** export to Microsoft Excel-compatible files
** export to HTML files
** export to XML files
* Design-time spreadsheet designer
* Data-binding with customizable options
* Hierarchical data views, with parent rows and child views
* Grouping of rows or columns
* Sorting by row or column on multiple keys
* Cell spanning
* Multiple row and column headers
* Bound and unbound modes
==Version-Specific Features==
===Spread for Windows Forms===
* Support for Microsoft [Visual Studio](/source/Visual_Studio) 2010
* Support for [Windows Azure](/source/Windows_Azure) AppFabric
* Integrated chart control
* Custom cell types
* Cell notes
* Child controls
* Splitter bars
* Built-in and custom skins and styles
* PDF export
* Microsoft Excel 2007 XML Support (Office Open XML, XLSX)
* Floating Formula Bar
* Range Selection for Formula
* Automatic Completion (type ahead)
===Spread for ASP.NET===
* Support for Microsoft [Visual Studio](/source/Visual_Studio) 2010
* Support for [Windows Azure](/source/Windows_Azure) AppFabric
* Integrated chart control
* AJAX-enabled
* Support for Open Document Format (ODF) files
* Multiple edits on multiple rows without server round trips
* Client-side column and row resizing
* Load on demand, which loads data from the server as needed for viewing
* Native Microsoft Excel import and export
* In-cell editing
* Multiple edits on multiple rows without server round trips
* Client-side column and row resizing
* Multiple sheets
* Searching
* Filtering
* Validations
* Cell spans
* PDF export
===Spread COM===
* Custom cell types
* Cell notes
* Virtual mode for data loading
* Unicode support
* Customizable printing
* Text tips
* Import and export:
** Microsoft Excel 97
** Excel 2000
** Excel 2007 (requires the .NET Framework)
* Enhanced printing
* 64 bit DLL
===Spread for BizTalk===
* Integration of Microsoft Excel data into Microsoft BizTalk applications
* Design-time spreadsheet schema wizard and spreadsheet format designer
==Supported document formats==
* Adobe Portable Document Format [PDF](/source/PDF) (*.pdf)
* [HTML](/source/HTML) Web Page (*.html)
* [Microsoft Excel](/source/Microsoft_Excel) Workbook (*.xls)
* [Plain Text](/source/Text_file) (*.txt)
* [Comma-Separated Values](/source/Comma-Separated_Values) (*.csv)
* [Open Document Format](/source/Open_Document_Format) (Spread for ASP.NET)
==References==
{{reflist}}
==External links==
* {{official website|spread.grapecity.com}}
{{DEFAULTSORT:Farpoint Spread}}
Category:Programming tools
Category:Spreadsheet software
---
Adapted from the Wikipedia article [FarPoint Spread](https://en.wikipedia.org/wiki/FarPoint_Spread) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/FarPoint_Spread?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.