FarPoint Spread 8 COM - Support

by GrapeCity - Product Type: Component / ActiveX OCX / DLL

Support Forum

FarPoint Spread anoopplenin [India] 06-Nov-2010 05:12:00

hi,
we are currently using VB6 and spread2. Now i want to upgrade our Spread to v7 or 8 as we are facing some troubles with older version of spread.
So pls help me how to upgrade the spread.
Thanks in advance.
Reply

FarPoint Spread 8.0 file missing etc steveb [Canada] 08-Oct-2009 17:29:32

Hi as a limited user on Vista (Home Premium SP1) when I launch a vb6 app with fpspr80.ocx in it I get an error.
"Component 'fpspr80.ocx' or one of it's dependencies not correctly registered: a file is missing or invalid".

It works fine as an administrator. I've tried launching the app as administrator from a standard user account and turning off UAC all to no avail.

Any ideas?
Reply

RE: FarPoint Spread 8.0 file missing etc nawras-1979 [Kuwait] 21-Jul-2010 06:48:36

356353
Reply

FarPoint Spread coperman [Mexico] 21-Aug-2009 20:02:19

Compre un componente para desarrollo en el cual esta incluido el fpspr80.ocx, el cual se ejecuta correctamente. Pero compilo mi programa y lo ejecuto con Windows XP copiando dicho componente simplemente con un copy y tambien no hay problema. Pero para que funcione en Windows Vista no es posible hacerlo con un simple Copy. Es por ello que requiero que me indiquen como debo instalar dicho componente en el sistema operativo Windows Vista.

Muchas gracia de antemano por su atencion.
Manuel Cortes Perez.
Reply

FarPoint Spread nandish.sk [India] 10-Dec-2008 13:56:51

Hi
In one of our client application that is coded in vb6.0 they are using Farpoint Spread Grid and they are populating the data .
Can any one tell me how can i send the data present in the Spread Grid to Printer for printing
Reply

RE: FarPoint Spread sendhilll [India] 03-Dec-2011 10:19:06

How to print multiple sheets as a single print job
Reply

FarPoint Spread Gav [Australia] 30-Sep-2008 09:18:29

Hi I am attempting to use farpoint spread for a VB6 program that is primarily a client database management system. We until recently have been using standard VB datagrids and I would appreciate directiions to any resources / tutorials that outline the population of spread cells with imported data. I have successfully created all queries and conversion code however am struggling with the input into Spread. Thanks in Advance.
Reply

FarPoint Spread gpkumaravel [India] 08-Sep-2008 12:48:37

Is Far Point spread support grouping the rows?
If yes,
I want to group rows (i.e One parent row in that many child rows)
Show or Hide the row by pressing +, - button on the row

Is this support is available in Far Point Spread?

Thanks

Kumaravel
Reply

virtual mode with web forms Abhishek 27-Jan-2008 17:56:20

Hi,

Could you guide me how to use virtual mode with web forms. I am working on an application in ASP which is trying to pull thousands of records from the db. I would like to know how to bind the spread to the record set on initial page load and how it would then use the query data event. I am using spread 7.0.

Thanks
Reply

Spread grameshreddy [India] 14-Dec-2006 13:57:29

I am using Sprerad 6.0

I want to set the back ground color of a row based on the value in one column. The column number to check in the spread is 22.

I tried the following

for i = 1 to vaSpread1.MaxRows
vaSpread1.Col=22
if (trim(vaSpread1.Text) = "1") then
vaSpread1.BackColor = vbBlue
end if

next

But i am not succedd in this.

Any one please help me in this regard.

Thanks in Advance,

Ramesh Reddy
Reply

Spread V7.0 rosa_nidia [Mexico] 06-Jun-2006 17:21:34

Hello to all
I am proving the new version of Spread-Active X/DLL V7.0 and liked to know to me if this it works in an application of Access,
I am using a data base of Visual BASIC I want to change the colors of activates x when it brings the data to me that are been from a consultation.
it is this possible one with this version? and using Microsoft Access?
Reply

Spread v7.0 rosa_nidia [Mexico] 06-Jun-2006 17:16:39

Hola a todos

estoy probando la nueva version del Spread-Active X/DLL V7.0 y me gustaria saber si este funciona en una aplicacion de access, estoy usando
una base de datos de visual basic
quiero cambiar los colores del active x cuando me trae lo datos que son resultado de una consulta.. es esto posible con esta version? y usando microsoft access?
Reply

Spread 7/VB6 info [USA] 10-May-2006 22:05:25

I have a sheet in a VB6 form, when I run the program I can't enter anything into the inital cell until I first click on the cell 1,1 -- then the sheet activates and I can enter data and scroll -- I can't figure how to programatically bring the sheet alive. Any suggestions?

Thanks,
Alan
Reply

Spread 7.0.05 shiva16112002 [India] 30-Sep-2005 12:22:26

Hi

I am using Spread 7.0.05 in my VB 6 Application and i came across a error. Use of spread is causing crash of my application. I need you suggestions on this.
In my application i have search after searching if i use spread export function to export the data to the excel sheet. after all selection and export completion
if i minimise my window of the program and again maimise and close my MDI form application without closing the my child form it get crash.

If i do all this my process without exporting anything then application works perfectly.

Please help me out in this

Its very urgent

Thanks
Shivani
Reply

Spread7 is possible IN JSP ??? thistm [Korea, Republic Of] 08-Sep-2005 03:09:12

Hi.
A few days age I buy Spread7.
But I'm puzzled at DATA BINDING.

All sample is ASP Programing with ADO...
Spread7 is impossible in JSP?

Is there any source Sample in JSP ???

Show me ~ please.
Reply

Handling Spread Grid event in VC++ sandhya [India] 05-Jul-2004 08:28:18

I am trying to trap Spread Grid events (e.g. LeaveCell, LeavelRow etc.) in VC++, but is not able to do it correctly. Can anyone let me know the steps of doing that?
Reply

Spread nirosh [Sri Lanka] 07-May-2004 07:48:09

How do I make a Combo box in a Farpoint spread sheet cell?
How do I access the selected value from the above combo?
I used ComboBoxCellType object
Reply

RE: Spread fechadoprimero [Colombia] 13-Feb-2006 19:00:57

ejemplos de combobox
Reply

RE: Spread mail2st68 [India] 31-Mar-2006 04:54:47

Farpoint Spread Control help
Reply

Spread ctrianac [Colombia] 06-May-2004 16:51:00

Hola

Estoy haciendo pruebas con la versión 7 y me gustaría saber si es posible habilitar clave de acceso para el archivo exportado a excel. O si es posible bloquear las filas y columnas para que no sean editables para el usuario?(En el archivo exportado a excel).

En cuanto al licenciamiento si lo utilizo para un solo desarrollador pero los informes para los clientes los utiliza 20 personas, cuantas licencias debo comprar?

Gracias por su atención

Cesar Triana
Reply

Spread gottipatti_k [USA] 11-Feb-2004 10:48:06

How to add colors in a spread grid while loading the form dynamically.
Each row will be loaded dependng on the condition and color will be added to each condition.
Reply

Spread alan_barnard [Switzerland] 09-Sep-2002 11:40:00

What is the status of a .net ready version of spread? I have several other grids from other vendors, but my fav is Spread. Reviewing the comments i other posts I note that Farpoint Tech Support stated that the .net version would be available Feb 2002. It is now Sept 2002!

Regards,

Alan
Reply

Spread sumaseetharam [USA] 28-Aug-2002 11:12:28

Does FarPoint Spread 6 Support Unicode ?
Reply

Pull in excel data in VB app learn [USA] 27-Jun-2002 22:03:29

i am trying to pull in excell data into a vb application. Also am trying to display display it in the same tabular form as it exists in excel ... does this application help me do that ?
Reply

Spread S S V[India] 16-May-2002 13:36:50

Dear Sir,
I am using spread control since few months. I have ver 3.0 of Spread. As per customers requirements I want to have positive numbers preceeded with + and -ve number with -.
Dealing with -ve number is not a prob, but for +ve numbers how to get + at the start while displaying in spread. i. e. +145
Pls help.
Thanx.
-S S V
Reply

RE: Spread support@componentsource.com 16-May-2002 16:37:16

Hello,

I asked FarPoint this question, and they replied with this answer:

The number celltypes (integer and float) cannot have a + sign in the
cell. You would either need to make the cells edit cells, or use two
columns (that you can make to look like one), where the first column
would hold the sign.

If the user had Spread 6 they could show a + in a currency cell but, the
symbol would always be a plus unless they used code to change it (the
user would not be able to toggle the currency symbol).
Private Sub Form_Load()
vaSpread1.Col = 1
vaSpread1.Row = 1
vaSpread1.CellType = CellTypeCurrency
vaSpread1.TypeCurrencyShowSymbol = True
vaSpread1.TypeCurrencySymbol = "+"
End Sub

Another option might be to try a mask celltype.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply

spread cell combotype vb_big [India] 02-Jun-2006 13:07:20

Hi

I have 1 cell which is combotype in Grid , I bind data to that cell(combotype) but on clicking it values r not dispalyed(combobox is not droping)
what properties I have to set so that I can see data on that drop down combobox(cell)

VINU
Reply

RE: Spread prabhu_projects [India] 11-Oct-2006 14:53:02

hi s s v

i need some technical clarifications

sp plz feel free to mail me at this mail address prabhu_projects at yahoo dot com
Reply

Spread jball [USA] 17-Apr-2002 16:15:24

If I have a "Spread" on a web page inside of a form and the 'submit' button is pressed, will the data in the spreadsheet show up in the request object? If so, how?
Reply

Spread kendalesachin [USA] 25-Mar-2002 19:00:50

Following questions are related to Spread run time mode and not Spread Designer run time.
Is there a way to invoke Spread Designer at run time ?
How can user enter/type in the formula in a Spread cell at run time ?

Response is greatly appreciated !
Reply

RE: Spread support@componentsource.com 04-Apr-2002 23:01:39

Hello,

I received a reply from the author if Spread regarding your questions. They sent the following reply:

The designer is only for use on the design machine. You can save to an
ss6 file using code (savetofile) and load that file with code
(loadfile). If you set allowuserformula to true, the user can hit = and
type in a formula. The formula must be valid and the celltype must be
the correct celltype.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply

Spread Ravikumarh [USA] 22-Mar-2002 21:30:53

Hi ,

the documentation says that I can export entire spreadsheet in XML format to a file or a buffer But i am not sure if i can use the same xml format output and set the data back into the spread 6 during runtime.

Basically Anything like this.

I want to save the data in the xml format which is entered by the user and then when he visits back. I should be able to retrieve his data and display back to him. the Only limitations is that i know that this spread sheet control supports exporting to Excel and Importing from excel. But if i dont have Excel on my system, then how do I do ?
I want to know anyother means of doing this.

the second part is whether this product supports unicode and internationalization.

Thank you in advance
Reply

RE: Spread sumaseetharam [USA] 28-Aug-2002 11:07:25

Does FarPoint Spread 6 Support Unicode ?
Reply

Spread shilpa [India] 01-Feb-2002 11:45:37

How can images be loaded onto a spread control in a web enviroment

Thanks
Shilpa
Reply

Spread bergsteinsson [USA] 11-Dec-2001 15:53:11

Can Spread be used under Delphi 6?
Reply

RE: Spread FarPoint Technical Support 11-Dec-2001 16:49:56

Sorry, we have not tested Spread under Delphi. A Delphi user sent us some information about a write only error. That information is on our web site in the knowledge base under Technical Support, www.fpoint.com.

FarPoint Technical Support
Reply

Spread compatible with Visual Studio.net recycle12866 [USA] 21-Nov-2001 21:49:28

Does anyone know if Spread can be used from Visual Stuido.net (wrapped COM control)? I'd like to use it from C#.

Thanks,
Jason
Reply

RE: Spread compatible with Visual Studio.net Scott, FarPont 26-Nov-2001 13:57:47

Beta 2 of Visual Studio.NET does support ActiveX controls. I would not suggest using them for two reasons. One, this product is still in Beta. Two, most companies who make ActiveX controls will release a .NET version of the same control. More than likely the ActiveX and the .NET versions of the controls will not be compatable, so you would need to restart any development. Spread will have a .NET version released early next year. The WebForm version of Spread will release mid February (same time as release of Visual Studio .NET) and the WinForm version of Spread will be available a couple of months after that.

-Scott
FarPoint
Reply

RE: RE: Spread compatible with Visual Stud... shansivamani [India] 21-Sep-2006 07:51:36

hi,
im using spread 6.0.11 version..does it supports .NET version?
Reply

Spread y.joubert [France] 26-Oct-2001 15:04:52

I am looking for a feature that may be Spread performs.

I would like to present to the user a classic spreadsheet interface and had him fill it.
Save the spreadsheet under an Excel format, re-use it as many times as needed.
Once this is over, I would like to re-access the sheet and then build some kind of image (BMP ?) or Clipboard image in order to plug it into an Alltext control that contains an RTF report being prepared...

Is it possible with Spread ?

Thanks and best regards
Yves Joubert

PS- this is like doing special-copy/printer-like option under Excel and then paste the clipboard image into Word
Reply

RE: Spread FarPoint Technical Support 29-Oct-2001 14:55:11

You can export and import xls files (Biff8) with Spread. I'm not sure what you mean by re-use it as many times as needed? Spread does not have a property to save to a bmp type file. You can copy the data from Spread to the clipboard with action 2, action 22, and action 14 (set row, col, col2, and row2 first).
Reply

Spread kuruption36 [USA] 28-Sep-2001 23:42:46

About the license "Developer License(s) One software license is required per machine.
Run-time royalty free."

Can you be more specific?

I would like to impletement this spread ActiveX running on my server and provide services for my customers from my website. The question is that "Do my clients/customers have to purchase another license for it?".

Thank in advance
Kuruption36
Reply

RE: Spread FarPoint Technical Support 02-Oct-2001 09:16:36

As long as these users are just running a web page with Spread on it (one that a licensed developer created) then they do not have to have a design license.
You need a design license for development work with Spread.
Reply

Spread mattblu [United Kingdom] 19-Sep-2001 10:32:00

Does anyone know if the spread 3.5 control can handle working with and the correct displaying of Unicode Characters?
thanks
Matt
Reply

RE: Spread FarPoint Technical Support 19-Sep-2001 14:32:15

Spread 3.5 does not support unicode but, it should work with double byte characters.
FarPoint Technical Support
Reply

Spread ranoj 31-Aug-2001 02:13:54

Hi!
When I bought spread about a month back, I was told that the latest version would be free when released. Now that Farpoint has released the newer version how do I download it?

Thanks,
Manoj
Reply

RE: Spread ComponentSource Tech Support 31-Aug-2001 14:47:11

Hello Manoj
By now you should have received an email notifying you of the new version.
Please, send an email to Support@ComponentSource.com, if you haven't.
Reply

RE: Spread theodore.ivanov [France] 11-Jun-2002 09:17:54

Can Spread be used in unbound mode?
Reply