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
29
votes
3 answers

Download file directly to memory

I would like to load an excel file directly from an ftp site into a memory stream. Then I want to open the file in the FarPoint Spread control using the OpenExcel(Stream) method. My issue is I'm not sure if it's possible to download a file directly…
daved
  • 392
  • 1
  • 4
  • 11
5
votes
4 answers

What is the easiest way to display an editable list(like a spreadsheet) in HTML?

We have a requirement to display an editable list in a web page. What would be the easiest way to do that? Farpoint Spread was something I have used to achieve this earlier but it was quite slow when a large number of records were involved and it…
sarego
  • 2,957
  • 6
  • 28
  • 39
4
votes
2 answers

Any specific event for clicking on the Button of the combobox

C# WinApps: is there any separate event that can tell us user has clicked on the small drop button next to the combobox? Suggestions?
Bohn
  • 26,091
  • 61
  • 167
  • 254
3
votes
1 answer

Is it possible to populate a Farpoint Spread 6.0 vaSpread component using a SQL query in VB6?

I have written a query using T-SQL on SQL Server 2008 R2 that provides the correct information that I need to display on a vaSpread component named SSlist on Visual Basic 6. I have already opened the connection to the database, but I am having…
J. Lee
  • 65
  • 8
2
votes
1 answer

how to make specific columns editable in vb6

I have this event when you click on a cell, it checks which column (enum) it has been clicked, and then it enables editing if the columns should be editable. The following columns should be editable and are working ok, but on the else statement I…
Jean Camargo
  • 340
  • 3
  • 17
2
votes
1 answer

Old VB6 Application - Requires Old Custom Control Possible Sources

So I have been given an old VB6b application that needs some minor modifications to get it working with a later version of SQL Server - however, It uses some 3rd party custom controls - Farpoint Spread and Input, Sheridan. As this is really old -…
user3502865
  • 143
  • 7
2
votes
0 answers

Slow performance loading VBNET DLL

I have a performance issue for some projects I am developing in VBNET. My projects are DLLs, and they are called by an exe with parameters, that is like a tab manager. The problem is that when I call my first DLL in the exe the InitializeComponent…
Diego Ferrero
  • 41
  • 4
2
votes
1 answer

Get data from FarPoint Spread control running in another application

I'm attempting to write a application in C# utilizing the Microsoft UI Automation framework. The application to be controlled uses a component called "FarPoint Spread". It's easy enough to automate the rest of the application (e.g. its WinForms…
theorize99
  • 57
  • 5
2
votes
1 answer

How to set the Farpoint Spread control width auto

I'm having an issue with a Farpoint Spread control which has already set the grid's height by code behind and the width directly in the markup. My question is, is there any way to set the width as auto, because if I open the grid with 1440x900…
agus.sanchez
  • 21
  • 1
  • 2
1
vote
3 answers

Excel files in ASP.Net MVC

Is there any way to use server controls in ASP.NET MVC? Specifically I need to use the FarPoint Spread control in my application to display an Excel file that exists on the server with the ability to display updates on the client in real time. The…
Jeff Hornby
  • 12,948
  • 4
  • 40
  • 61
1
vote
1 answer

Adding some text in FarPoint while Export To Excel

I am having FarPoint Web Spread and a Panel with a text box [T1] in my webpage. I am using SaveExcel method of FpSpread to write the contents into Excel. Is there any way by which i can write the contents of text box [T1] into the excel. Below is…
Code's
  • 208
  • 2
  • 18
1
vote
1 answer

Sys.WebForms.PageRequestManagerServerErrorException: Exception has been thrown by the target of an invocation

I upgraded an asp.net website from 2.0 to 4.0 framework. This websites uses farpoint. After framework upgrade, one of the page is throwing the error mentioned in the title. FarPoint.Web.Spread assembly registred in this page and FPSPREAD is used.…
Sreekanth Mohan
  • 340
  • 4
  • 29
1
vote
1 answer

SetSelectedRange Spread.NET javascript issue

I'm trying to add functionality to Spread.NET control where it will permit a hold shift-click to select a range of cells in ASP. I'm creating the event onActiveCellChanged to call the selectRange function on execution var shiftPressed = false; …
dright
  • 613
  • 1
  • 9
  • 19
1
vote
2 answers

Spread.NET and javascript

I’m trying to add a hold shift-click functionality to select a range of cells (Exactly what spread does in winforms by default). What I’m trying to do is recognize when the shift key is first hit while the spread component is onfocus and saving the…
dright
  • 613
  • 1
  • 9
  • 19
0
votes
0 answers

Public Static is not allow to decalre Function or set Farpoint grid value

How to solve this issue, (Not allowing the declaration of any function in the Public static method, and also I can't set the value to the Farpoint grid)
Jerin Johnson
  • 11
  • 3
1
2