FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Formulas in exel
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Formulas in exel
Posted: Mon Jul 28, 2008 12:37 AM

Dear friends:

Have a nice day.

I am looking for a small sample to record formulas in a excel sheet using TOLE.

somebody can help me ?

Best regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Formulas in exel
Posted: Mon Jul 28, 2008 07:37 AM
oSheet:Cells( nRow, nCol ):Value = "=your formula here"


Note the equal sign.

EMG
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Formulas in exel
Posted: Mon Jul 28, 2008 01:35 PM

Enrico:

Thanks so much, problem solved with your help (as usual) :wink:

Now another question !

Is there a way to know the version of excel that is being used ?

I mean, =SUM(), (English language) is not equal to =SUMA() (Spanish language) how to know when to use one and when to use an other one ?.

Best regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Formulas in exel
Posted: Mon Jul 28, 2008 04:20 PM

First try if the English version works in Spanish version too, at least using OLE.

EMG

Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Formulas in exel
Posted: Mon Jul 28, 2008 04:54 PM

Enrico:

Thanks for your replay.

In Spanish versión does not work a formula in English language

=SUM() <> =SUMA()

Regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Formulas in exel
Posted: Mon Jul 28, 2008 08:04 PM
#define msoLanguageIDInstall 1
#define msoLanguageIDUI      2
#define msoLanguageIDHelp    3


FUNCTION MAIN()

    LOCAL oExcel := CREATEOBJECT( "Excel.Application" )

    LOCAL oApp := oExcel:CommandBars( "Standard" ):Application

    ? oApp:LanguageSettings:LanguageID( msoLanguageIDInstall )
    ? oApp:LanguageSettings:LanguageID( msoLanguageIDUI )
    ? oApp:LanguageSettings:LanguageID( msoLanguageIDHelp )

    ? oExcel:LanguageSettings:LanguageID( msoLanguageIDInstall )

    INKEY( 0 )

    RETURN NIL


EMG
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Formulas in exel
Posted: Mon Jul 28, 2008 09:14 PM

Thank you Mr. Enrico:

I'll try

Best regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

Continue the discussion