Filters: Export to Non-Office, Import/Export Alien Formats

Creating Extension - Shared Libraries
Forum rules
For sharing working examples of macros / scripts. These can be in any script language supported by OpenOffice.org [Basic, Python, Netbean] or as source code files in Java or C# even - but requires the actual source code listing. This forum is not for asking questions about writing your own macros.

Filters: Export to Non-Office, Import/Export Alien Formats

Postby Lupp » Wed Feb 20, 2019 4:13 pm

Now and then there is a question concerning the available "filters". There also is a macro from the famous texts by Andrew Pitonyak listing all available "filters" of the kind for the used version. This macro works in AOO and in any version of LibO as far as I know.
However, for unknown reasons it makes its output to a Writer document.

As there my be reasons to filter (now in a clearer sense) the results by some criteria, I prefer output to a spreadsheet, and recently I made a very simple but "pretty" spreadsheet version for the task which may be of some interest for others.

I now don't publish the plain code here, because I want to estimate the interest by the number of downloads. The attched document is containing the code and in addition some formulae and settings (and a few explanations) supporting the usage. Always refresh data before trusting in them.
impexpFilterNames_1.ods
(40.66 KiB) Downloaded 17 times

As always: Highly interested in criticism!
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2412
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: filters: Export to Non-Office, Import/Export Alien Forma

Postby JeJe » Wed Feb 20, 2019 8:50 pm

In Pitonyak's OpenOffice.org Macros Explained
OOME Third Edition there's Listing 266. List supported filters in a Calc Sheet.
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 481
Joined: Wed Mar 09, 2016 2:40 pm

Re: filters: Export to Non-Office, Import/Export Alien Forma

Postby Lupp » Wed Feb 20, 2019 10:07 pm

@JeJe: You are right (of course) again. I had missed or forgotten it. (In my pdf it's Listing 260.)
In addition my version does not list the properties. It's simply poor.

Do you think I should remove the post?
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2412
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: filters: Export to Non-Office, Import/Export Alien Forma

Postby JeJe » Wed Feb 20, 2019 10:19 pm

"Do you think I should remove the post?"

No - you never know when someone might do a search looking for this exact thing and this thread might pop up for them...
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 481
Joined: Wed Mar 09, 2016 2:40 pm

Re: Filters: Export to Non-Office, Import/Export Alien Forma

Postby Sébastien C » Sat Feb 23, 2019 11:11 pm

In the same way, the evocation of this specific problem is already very open to teach people (like me) who knew nothing about it.
Thank you !
LibreOffice 5.2.7.2 under GNU-Linux ARMbian on the Rock64 and M$-W XP
User avatar
Sébastien C
 
Posts: 81
Joined: Mon Jan 04, 2010 5:06 pm
Location: Meymac, France


Return to Code Snippets

Who is online

Users browsing this forum: No registered users and 2 guests