Re: [libreoffice-users] Error When Closing Document Using Automation

2018-08-31 Thread Andrew Pitonyak



Sorry, I do not know what is going on, but

DO you see anything different if you:

1. Pause for a few seconds before you call close? In the back of my  
mind I am wondering if for some silly reason, control returns to you 
before the save command finishes running.

2. out of curiousity, what value is in the isModified property?
3. I assume that you are calling terminate on the desktop object, is 
this correct?
4. Assuming you sleep a few seconds first, what happens if you call 
dispose on the document rather than close? I do not even know if the 
dispose method still exists, but, if it does. Note that you should not 
in general use dispose, but, that is what existed before close() was 
added to the API.



On 2018-08-31 13:00, dCipher wrote:

Hi

I have been automating Calc for years from Visual FoxPro.  It has 
worked
flawlessly until this week. Now the document close method often 
produces an
ole error 80010105.  I was using verison 5.1 so I updated everything 
to the
latest 6.1 version but the problem persists.  If I remove the Close() 
method
and just use Terminate() I get the same result that 30%-50% of the 
time it
crashes.  The spreadsheet is created correctly but Libre Office 
crashes on
the Close() method.  Does anyone have any ideas what might be the 
cause?  I
am running on Windows Server 2012 64bit.  I am using the 32bit 
version of

Libre Office.

If I try opening the document in Calc and makes some changes then use
"Close" from the File menu. I am prompted to save the document and
everything closes as expected.  It only seems to occur when 
automating the

process.

laArgs(1).Name="FilterName"
laArgs(1).Value="MS Excel 97"
laArgs(2).Name="Overwrite"
laArgs(2).Value=.T.
ComArray(toBizObj.oMergeDoc,10)


toBizObj.oMergeDoc.storeAsURL(ConvertToURL(toParam.Destination),@laArgs)

toBizObj.oMergeDoc.close(1)  <== Produces and error 30% - 50% of the 
time

toBizObj.oMerge.Terminate()

Thanks,
Simon




--
Sent from:

http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



[libreoffice-users] Error When Closing Document Using Automation

2018-08-31 Thread dCipher
Hi

I have been automating Calc for years from Visual FoxPro.  It has worked
flawlessly until this week. Now the document close method often produces an
ole error 80010105.  I was using verison 5.1 so I updated everything to the
latest 6.1 version but the problem persists.  If I remove the Close() method
and just use Terminate() I get the same result that 30%-50% of the time it
crashes.  The spreadsheet is created correctly but Libre Office crashes on
the Close() method.  Does anyone have any ideas what might be the cause?  I
am running on Windows Server 2012 64bit.  I am using the 32bit version of
Libre Office.

If I try opening the document in Calc and makes some changes then use
"Close" from the File menu. I am prompted to save the document and
everything closes as expected.  It only seems to occur when automating the
process.

laArgs(1).Name="FilterName"
laArgs(1).Value="MS Excel 97"
laArgs(2).Name="Overwrite"
laArgs(2).Value=.T.
ComArray(toBizObj.oMergeDoc,10)

toBizObj.oMergeDoc.storeAsURL(ConvertToURL(toParam.Destination),@laArgs)

toBizObj.oMergeDoc.close(1)  <== Produces and error 30% - 50% of the time
toBizObj.oMerge.Terminate()

Thanks,
Simon




--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy