open/libre office help needed with cell write command

[dickjones007]

my code:

#include <OOoCalc.au3>

$file = @ScriptDir & "\slanje.ods"

If ProcessExists("soffice.exe") Then
;~  $oCalc = _OOoCalcBookAttach($file)
; _OOoCalcBookAttach doesnt work. i need to define here what $oCalc will be for _OOoCalcWriteCell to work
    WinWait("Calc")
    WinSetState("Calc", "", @SW_MAXIMIZE)
    WinActivate("Calc", "")

Else
    $oCalc = _OOoCalcBookOpen($file)
    WinWait("Calc")
    WinSetState("Calc", "", @SW_MAXIMIZE)
    WinActivate("Calc", "")

EndIf

_OOoCalcWriteCell($oCalc, "comething to write in cell","C25")

so calc write cell doesnt work if slanje.ods is already opened. it only works if the ELSE condition is met.

[water]

You always have to open an ODS file using _OOoCalcBookOpen. It doesn't work by mixing hte OO UDF, GUI Automation and process checking.

Have a look at the Example Scripts forum and search for "OpenOffice Calc". You will find a lot of good examples there.

[dickjones007]

the problem only happens when file is already open in openoffice

in that situation _OOoCalcWriteCell doesnt put values into cell

$oCalc is not defined good when i run the script while the file is open

i get this error when file is already open

C:Program FilesAutoIt3IncludeOOoCalc.au3 (302) : ==> The requested action with this object has failed.:
Local $oReturn = $oDesktop.loadComponentFromURL($sURL, "_default", 0, $aoProperties)
Local $oReturn = $oDesktop.loadComponentFromURL($sURL, "_default", 0, $aoProperties)^ ERROR

and this

: ==> Variable used without being declared.:
_OOoCalcWriteCell($oCalc, $nameart,"C23")
_OOoCalcWriteCell(^ ERROR

Edited December 1, 2013 by dickjones007

[water]

You ALWAYS have to run _OOoCalcBookOpen to return the book object. Function _OOoCalcWriteCell relies on this object.

That's what I mean by "mixing OO UDF, GUI Automation and process checking". That's the wrong approach.

[dickjones007]

ok i understand

i know it relies on it

do you maybe have any solution for me on how to write to cells to already open book?

i searched everv post related to openoffice and found no such thing

[water]

I'm not familiar with the OO UDF but the Excel UDF has a function to open a workbook and another to attach to an already open workbook.

With Excel I would try to attach to the workbook. If an error is returned then I would try to open the workbook.

[dickjones007]

for OO there is _OOoCalcBookAttach, but it does not return good value for calc write to recognize it

also when i tried to put value of $oCalc to msgbox it returns empty.

do u know if there is any other/deeper way to check the value of $oCalc when the script opens book?

[dickjones007]

omg i found the error

i was using $file for calc attach which equals full path of the file

i should have used $ime which is only the name of the file

BIG LOL and a relief

Edited December 1, 2013 by dickjones007

[water]

[Silviu]

Hello,

I tried the the script with a .ods file created with Libreoffice 6.0.2 which works on Windows 7 64bit. But I didn't have success.

I tried this code:

$oCalc = _OOoCalc_BookOpen("Results.ods")
WinWait("Results.ods")
WinSetState("Results.ods", "", @SW_MAXIMIZE)
WinActivate("Results.ods", "")
_OOoCalc_WriteCell($oCalc, "something to write in cell", 1, 1)
_OOoCalc_CellSetColors($oCalc, 0x0000FF, 0x00FF00, 0, 0) ;Foreground and Background color in 0xRRGGBB
_OOoCalc_WriteCell($oCalc, "'===================", "C3") ;...or with direct address

but nothing happen.

My suspicion is that could be from some incompatibilities with the last Libreoffice version 6.0.2.

Someone else tries the script with 6.0.2 Libreoffice version?

Another problem could be because Libreoffice is not installed; I worked with it as portable tool. Even this, .ods file type is set to be opened default with portable Libreoffice 6.0.2

 

Many thanks for your help!