FiveTech Software tech support forums

The poll is in Portuguese, but who can answer using Google Translate is welcome.

https://docs.google.com/spreadsheet/vie ... a0t1N0E6MQ

... is 4Kb (bshell limit). • The maximum size of the ReturnValue string is 4Kb (bshell limit). The following simple example will fill an MS-Excel spreadsheet with the names of all BAAN users. To implement this, we have to do two things: 1.  Implement DLL function(s) to obtain the names of the ...

Hi: I have a customer that is using MS Office 2010. When I call ToExcel in xbrowse they get an error message stating "spreadsheet software not installed". It works fine with Office 2003 and 2007. Can anyone tell me what the problem might be? Using FWH 10.9 and xHarbour 1.2.1. ...

André

Thanks .. I thought about that .. I figure Open Office and it successors do not want the ServiceManager closed .. my guess is it may effect other Open office programs already open if you close it

Rick

You can try a brute force solution: FUNCTION KillOO( cTask ) // cTask is the name of the OO stub LOCAL nShel := fCreate( "kill.bat" ) fWrite( nShel, "taskkill /F /IM " + cTask ) fClose( nShel ) ShellExecute( 0, "open", "kill.bat",,, ) fErase( "kill.bat&qu...

How to create a 2-dimensional associative array? For example let's consider something similar to a spreadsheet where the columns are A to E, the rows are 1 to 6 [equivalent to array(5,6) matrix] The few questions that I have are: i. How to initialize it? [I mean its array(5,6) ...

Shuming Tell me what the difference is with using SetString( "aaa" ) and assigning the value with the in-line equal operator ?? .. Using a character string makes it more difficult to write this : oSheet:GetCellByPosition( 0, nRow ):SetString := D->address Do you know how to close the oC...

oSheet:GetCellByPosition( 0, nRow ):SetString :="aaa"
should change into
oSheet:GetCellByPosition( 0, nRow ):SetString ("aaa")

Anser Soffice.exe and soffice.bin are still present after I close the oBook .. Like you allude to .. there does not seem to be a way to close the oCalc service .. terminate() does not work .. see this thread .. Rick Lipkin Rocko wrote: I didn't find the solution, but I can confirm this is the defaul...

Dear Mr.Rick, Right now, I don't have OpenOffice/Libre Office installed on the Laptop which I am using right now. :( (I have never tried LibreOffice) On a later date, I shall install and check. 1. After a fresh reboot of you PC, please check the process list via your task manager and note whether th...

Anser I was able to figure out how to save the file and your solution is correct ! .. The final problem is closing the oCalc object .. end(), quit(), terminate() .. I have exhausted the internet to find a solution to close the oCalc := CreateObject( "com.sun.star.ServiceManager" ) .. FYI ....

Dear Mr.Rick, It would be nice if I could boil this down to just convert and save the oBook as .xls ?? Here is my working code so far .. any suggestions to solve these last two problems would be appreciated. Rick Lipkin Try this aProp:={}AAdd(aProp,GetPropertyValue(oCalc, "Fil...

Ok, sorry.

EMG

Enrico

Your suggestion compiled but gave a run-time error and the Libre Office interface still opened ..

Rick

Please try exactly

Code: Select all  Expand view

? oCalc:Hidden

It could not execute but must compile.

EMG