Stack Overflow
Stack Overflow

Questions tagged [farpoint-spread]

FarPoint Spread from GrapeCity is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft 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.

FarPoint Spread from GrapeCity is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft 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 data at the cell, row, column, or worksheet level.

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 and the .NET Framework. Developers use it to add grids and spreadsheets to their applications, and to bind them to data sources. In version 4.0, new cell types were added to display barcodes and fractions, and exports for XML and PDF were added.

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.

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. 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.

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
28 questions
0
votes
1 answer

HOSTING ONLY - FpSpread DataSource Font Case Not Preserved

.NET Framework 4.5.2 OS: Windows Server 2012 RS Standard IIS: 6.2 Application Pool: .NET CLR Version v.4.0.30319 Managed Pipeline Mode: Integrated Spread.NET Version: 11.45.20183.0 NOTES: The problem below ONLY occurs when hosted in IIS from our…
spyder1329
  • 656
  • 5
  • 15
0
votes
1 answer

Cancel EnterCell event of spread farpoint

My program use spread farpoint as a 3rd-party control, it has a TextBox control and a Spread control for showing data. When user change active cell in spread, I want to validate that the TextBox must not empty. If the TextBox is empty, EnterCell…
huypham99
  • 67
  • 7
0
votes
0 answers

How to capture multiple key pressed using keydown or keypress event in farpoint spread in c#?

Consider a Farpoint spread control containing multiple columns and rows. On Entering/Pressing multiple alphabetical keys,it should select the row which has entered combination of words. Example:If 'a','n','u' is typed it should automatically select…
SUJITHA M
  • 1
  • 1
0
votes
2 answers

Populating FarPoint Spread with huge chunk of Data (64-bit Spreadsheet Issue)

In C# 64-bit, i am trying to populate a FarPoint Spreadsheet with approx 70000 rows. The entire data gets loaded on spredsheet after taking 3-4 hours of time duration, which makes the entire process to have lot of performance issues. Currently i am…
Abhishek Singh
  • 63
  • 6
0
votes
1 answer

stop refreshing the farpoint spread sheet

I have a problem with farpoint spread sheet, that while loading the data into the spread sheet, the sheet refreshes each time a value is set. I have large number of rows and columns so, the sheet take quite large time till loading. any idea how to…
omar
  • 436
  • 6
  • 18
0
votes
2 answers

not able to create object with Activator.CreateInstance

I am trying to load the old version of farpoint dll in my project by using below code System.Reflection.Assembly assembly = System.Reflection.Assembly.LoadFile(@"FarPoint.Web.Spread.dll"); System.Type MyDLLFormType =…
Code's
  • 208
  • 2
  • 18
0
votes
1 answer

Far Point Spread Unable to make column type "Date"

We are experiencing a problem due to the fact that we are unable to format a particular column as a date. When the information is configured "MM/DD/YYYY" we can format it as a date, but, when we format the information "MM/DD/YYYY hh:mm:ss AM/PM" we…
jcalder
  • 11
  • 3
0
votes
1 answer

Custom CellType in ComponentOne Spread for WPF

we're currently migrating a very old VB 6 application to .NET 4.5 WPF. This application uses the old Farpoint Spread 7.0 component. The old spreadsheet uses CellTypeButton extensively, but Spread for WTF doesn't provide this cell type. I also didn't…
ASP
  • 773
  • 1
  • 8
  • 22
0
votes
1 answer

Runtime error on casting Array to string Enumerator

This is a follow up question to Design issues and implementing Enumerable.AsEnumerable I have casted my farpoint row to a 2 d object array like this: object[,] nthRow = fpSpread2.ActiveSheet.GetArray(e.Row, e.Column, 1,…
Expert Novice
  • 1,943
  • 4
  • 22
  • 47
0
votes
1 answer

Best way to get data from a DataReader into a Farpoint Spreadsheet?

I need to move data from a datareader into a Farpoint Spreadsheet component in a Windows form. The DataSource of an fps sheet can't be set to a datareader. I don't want to change my app to use ADO just for this purpose. Right now I'm looping…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
-1
votes
1 answer

Getting error on making class IEnumerable

I am trying to inherit the FarPoint.Win.Spread.FpSpread class and implement IEnumerable so that i should be able to apply linq on FarPoint spread rows or cells. I tried multiple ways but i keep getting errors: class myspread…
Expert Novice
  • 1,943
  • 4
  • 22
  • 47
-1
votes
1 answer

Design issues and implementing Enumerable.AsEnumerable

How can i make a datatype return IEnumerable if it does not have AsEnumerable() method. For example: FarPointSpread1.ActiveSheet.Rows[e.Row] does not contain AsEnumerable() so i cannot do…
Expert Novice
  • 1,943
  • 4
  • 22
  • 47
-2
votes
1 answer

Write text on spreadsheet cell

I use Farpoint Spread Version 5.0.3514.2008.(Visual Studio 2015, .Net 4.0, C#) And I want to input long text into spread cell. But when string length is larger than 15153 then the sheet(Cell) can't show data normally. I didn't set-up MultiLine…
young hwa seo
  • 39
  • 4
1
2