in basic i use this function
Function TaskonDesktop(DocPath as String) as Boolean
Dim oComponents as Object
' Search if one of the active Components ist the one that you
oComponents = StarDesktop.Components.CreateEnumeration
oComponent = oComponents.NextElement
'print UCase(oComponent.URL) & " - " & UCase(converttoURL(DocPath)
If UCase(oComponent.URL) = UCase(converttoURL(DocPath)) then
TaskonDesktop = True
TaskonDesktop = False
hope it helps
Thanks a lot for your reply.
Q1: In your case do you only care about documents that have been
saved... Ignoring new never saved to disk docs?
àWhat I want to get is all calc documents as long as the doc is
opened, no matter it have been saved or not.
So firstly, I want to know if it’s possible to do it in this case.
If no, maybe I can only care the doc which have been saved and ignore
which is not saved.
Q2: You enumerate the open components from the desktop object and
check of the component is a calc document.
àSorry, I know how to get the desktop object, but I am not clear how
to get the open component and check them as you mentioned.
This is my gap, would you please give example code based on my
comment for Q1?
Thanks in advanced!
From: Andrew Pitonyak [mailto:email@example.com]
To: Zhang, William
Subject: Re: Q: How to get the path of all opened spreadsheet documents
No time to find the solution now.... But I have done this sort of
thing in basic.
You enumerate the open components from the desktop object and check of
the component is a calc document.
In your case do you only care about documents that have been saved...
Ignoring new never saved to disk docs?
Think I can find a basic example of it helps
On Jun 4, 2015 10:35 PM, "Zhang, William"
> In RedHat7, I want to get the path of all opened spreadsheet documents with Java.
> What I’ve done:
> 1.I used Runtime.exec(cmd…) with Java code, the ‘cmd’was defined with
“ps –ef | grep xxx”
> ->if only one spreadsheet document opened, the returned info list the correct
document, I can parse it and get the file path
> ->but if multi spreadsheet documents opened, the returned process still only
list the first document, I cannot get other documents.
>2.I also test in bash, it seems “ps -ef”cannot list all files.
> So , I want to know is there any other way to do it. such as using UNO service with
libreoffice API to get it.
> Anyone who knows it is much appreciate.
> Best Regards
LibreOffice mailing list
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Re: Q: How to get the path of all opened spreadsheet documents · SOS
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy