Re: [tdf-discuss] Macro Difficulties

2013-03-12 Thread Charles Jenkins
Thank you very much, Eduardo and Christian. I guess I misread that post I 
linked to, because it left me with the impression that creating those 
properties couldn't be done in regular VB. 

Now if only I can find a way to convert my tab-separated .txt file to a 
comma-separated .csv file, I think all would be golden.

I tried using VB to open the text file, read from it, convert each line, and 
write to an output file. Unfortunately, on Windows, the output is garbage. From 
what I can tell, it looks like LibreOffice's LINE INPUT command reads in 
garbage from the source file, probably because of an error in Unicode 
conversion.

Could LibreOffice VBA call an extension written in Python? Converting TSV to 
CSV should be trivial, and I'm betting a Python extension would do it 
flawlessly. 

--

Charles


-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [tdf-discuss] Macro Difficulties

2013-03-12 Thread Christian Lohmaier
Hi Charles, *,

On Tue, Mar 12, 2013 at 1:07 PM, Charles Jenkins  wrote:
>
> Now if only I can find a way to convert my tab-separated .txt file to a 
> comma-separated .csv file, I think all would be golden.

Hmm. Either I'm completely missing the point here, or you do :-)

With the properties, you explicitly set the filter to the spreadsheet
one (FilterName), and with the other (FilterOptions), you define how
the file is structured - you can configure what separator is used,
what column types they have. Just read the linked wiki page.

Here once again:
http://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options#Filter_Options_for_the_CSV_Filter

ciao
Christian

-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted



[tdf-discuss] January 2013 profits & losses (was: Re: [board-discuss] TDF Budget as of 2013-02-12)

2013-03-12 Thread Thorsten Behrens
Dear members, TDF supporters,

please find attached our January 2013 profits & losses report, and,
separately, the budget summary as of 2013-01-31 for the Berlin
entity. This already incorporates the 2013 budget decision from last
week, see here

 https://wiki.documentfoundation.org/File:Tdfbudget2013.pdf

for the detailed items.

Many thanks for your ongoing support, with kind regards,

-- 
Thorsten Behrens, Director, Deputy Chairman of the Board
The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany
Rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: http://www.documentfoundation.org/imprint

-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [tdf-discuss] Experimental UI for LibreOffice proposal

2013-03-12 Thread Keith Curtis
Hi;

On Mon, Mar 11, 2013 at 11:54 AM, Wolfgang Keller  wrote:
>> I'm working on a proposal for building an experimental new LibreOffice
>> toolbar / UI in Python:
>> https://wiki.documentfoundation.org/User:KeithCu
>
> Err, I would like to point out the fact that trying to emulate MS in any
> way is always a B-A-D idea.

I agree that one should never blindly copy anything MS is doing,
especially around radical UI changes which can be disruptive. This
proposal is a prototype, which could also be relatively quickly
changed based on unhappy user feedback.

>
> Your idea of a "ribbon" turned into a "sidebar" by 90° rotation imho is
> nothing else than the revival of the old (pre-Windows) Lotus 1-2-3 menu
> system. Pulldown-menus (and dialog boxes) are a far more advanced
> concept. Besides the issues with screenspace.
>
> A concept that could be a *lot* more useful imho would be to allow
> tearing off individual (sub-)menus and placing them as floating (or
> docked if the user prefers that) "toolboxes" next to the workspace. See
> typical graphics software or e.g. RagTime. When I was working in
> RagTime (or FrameMaker, but that was more than a decade ago), all I
> had on-screen besides the document itself and the pull-down menubar
> above were the listboxes with character and paragraph styles and very
> few other floating palettes.

Hmmm, that sounds interesting. To be honest, I liked the image I
picked, but I think that when starting, it makes sense to consider
other designs. If it turns out you don't want a "radically different
toolbar", then my proposal is a bad idea. Otherwise, you could build a
reasonable experiment in a few months. I would be excited to see what
you all came up with, perhaps even two designs / modes ;-)

Warm regards,

-Keith

-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [tdf-discuss] Scripting for LibreOffice

2013-03-12 Thread Keith Curtis
On Mon, Mar 11, 2013 at 11:54 AM, Wolfgang Keller  wrote:
>> While working on my wiki page about a new Writer toolbar, I realized
>> that independently of my proposal, I believe it makes sense for
>> LibreOffice to prefer Python. I see how LO is heading in this
>> direction, but you could be explicit about it, create more workitems,
>> perhaps track it like you do the German comments and uncalled
>> functions, etc.
>
> It could also be helpful to have a handbook for PyUno... ;-)
>
> The point is that a *lot* of users of Python (and there are bulkloads
> out there) are non-developers who don't give a darn for Java or VBA
> (because those don't provide what these users need) and who might have
> never even learned C++.
>
> So without specific documentation they're essentially stalled, while
> with a handbook, you could get a lot of helpers to implement additions
> in Python.
>
> Looks like a classic "multiplier" situation to me.

Is there a bug about this? Is the handbook to be built by the doc
team? It seems like a lack of samples / handbook could be a big reason
for the stalled pipeline of Python patches.

Warm regards,

-Keith

-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [tdf-discuss] About.com "Readers' Choice Awards 2013 for Office Software"

2013-03-12 Thread Johnny Rosenberg
2013/3/3 Marc Paré :
> FYI, the About.com "Readers' Choice Awards 2013 for Office Software" started
> on Feb. 19 and will end on March 19.
>
> You may vote every 24hrs. Let's make our LibreOffice suite the office suite
> of choice and it would be nice if we won out on all categories where we
> appear!
>
> To vote, you can log in with your Facebook or About.com accounts or you can
> enter your email address in a field on the page.
>
> Here are the details:
>
> =
> =
>
> The "Readers' Choice Awards 2013 for Office Software" categories webpage can
> be found here:
>
> http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm
>
> =
> =
>
>
> As of today, March 3 2013, LibreOffice ranking in the various "Office
> Software Suites" categories is:
>
> =
> Favorite Office Suite for Android: LIBREOFFICE does not have an official
> implementation of an Android version.
> Favorite Office Suite for Android: Google Docs/Apps 80% -- Quickoffice Pro
> HD 20%
> =
> Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an
> official implementation of an iOS version.
> Favorite Office Software Suite or App for iOS: Google Apps 60% -- iWork 20%
> -- Documents Free 20%
> =
> Favorite Office Software for Mac: LibreOffice 75% -- iWork and MSO both 12%
> =
> Favorite Office Software for Windows: LibreOffice 75% -- MSO 14% -- AOO 10%
> =
> Favorite Office Software for BlackBerry: LibreOffice 100%
> =
> Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!!
> ITALO IS AWARE OF THIS.
> Favorite Office Software for Business: MSO 33% -- Google Docs/Apps 33% --
> AOO 33% ??? -- IMO strange as LibreOffice is most likely used in Business
> =
> Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO
> IS AWARE OF THIS.
> Favorite Academic Software Suite: MSO Home and Student 50% -- Google Apps
> for Education 50% -- IMO, strange as LibreOffice is most likely used in
> education extensively!!!
> =
> Favorite Site for Office Software Templates: LibreOffice templates 80% --
> MSO templates 20%
> =
> Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an
> official "Cloud" implementation, but is working on it.
> Favorite Cloud Office Suite: Google docs 100%
> =
> Favorite Office Software Company or Organization Based on Social
> Responsibility: TheDocumentFoundation 60% -- TheApacheFoundation 20% --
> Microsoft 20%
> =

Can't vote since there is no suitable category to vote in, that is
”Favourite office suite for Linux” seems to be left out.


Johnny Rosenberg


>
> Congrats to all who are voting every 24hrs. If you are not voting yet, feel
> free to join in. It will make a difference to our brand and show that we are
> a very committed community.
>
> Cheers,
>
> Marc
>
> --
> Marc Paré
> m...@marcpare.com
> http://www.parEntreprise.com
> parEntreprise.com Supports OpenDocument Formats (ODF)
> parEntreprise.com Supports http://www.LibreOffice.org
>
>
> --
> Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.documentfoundation.org/www/discuss/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted