Apache OpenOffice Community Forum

Hi
I use Delphi with Hojacalc to connect to my spreadcheet
But when the spreadsheet is Open I receive an error message when I send HojaCalc.saveDoc
How I can detected if the spreadsheet is allready open in another program

Thanks

https://www.openoffice.org/api/docs/com ... oader.html returns the document specified by its URL and loads it if required.

Hi

I am using the loadComponentFromURL function to open the spreadsheet and it works
My problem is not when I load the spreadsheet, if the worksheet is open (with OOCalc) the document can open it. But when I want to update the worksheet an I/O error occurs due to locking by OOCalc
I want to check if the spreadsheet is locked when I open it and open a message dialog to inform the user. Exception sends a generic IO error message (the same as when the file exists not)

Thankyou

No idea other than catching the IO error.

Hi

I solved my problem by checking, in the directory, if the file with the name ".~lock.filename,ods#" exists
This file is created by openoffice when it opens the file (not if readonly)

Thank