Bill Gradwohl | 1 Aug 2011 01:00

Re: Code snippet


On 07/31/2011 08:19 AM, Andrew Douglas Pitonyak wrote:

>>>          If ashape.Control.Name = CName then

Andrew
FYI - I had to put an additional test in front of the above if statement
as in:
	if not IsNull(aShape.Control)
Some of the items returned do have Control=Null via the debugger.

Other than that, It's working fine.

--

-- 
Bill Gradwohl
Roatan, Honduras
504 9 899 2652
Andrew Douglas Pitonyak | 1 Aug 2011 03:49

Re: Code snippet

On 07/31/2011 02:19 PM, Bill Gradwohl wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote:
>> I expect that you need to set this from the sheets draw page
> ....
>
>
> Thank You Andrew.
>
> I have a copy of your book back in Texas. I wish I had it here on the
> island.

This is NOT complete, but it is updated. I am in the process of writing 
a new version.

http://www.pitonyak.org/OOME_3_0.odt

> I wrote most of the POS system we use in our restaurant by
> referencing your book. It's 9000 lines of macro code.
>
> I was up on your web site yesterday and noted that you're putting out a
> new edition. I tried wrapping my head around UNO several times and
> failed. I just don't get it. I've hit api.openoffice.org trying to make
> heads or tails out of what's there, but no joy. The API is an
> impenetrable collection of unrelated spare parts as far as I'm
> concerned, and I'm a professional programmer (IBM Mainframes&  Linux O/S
> utilities). I can't seem to get the right approach or frame of mind to
> understand the API set and UNO in particular.
(Continue reading)

Cliff Scott | 1 Aug 2011 03:49
Favicon

Re: unsubscribe

** Reply to message from Leon Cych <leoncych <at> gmail.com> on Sun, 31 Jul 2011
18:53:59 +0100

> Unsubscribe
> 
> -- 
> Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.org
> Problems? 

Leon,

Check that your email client is using the correct address, i.e.
users+unsubscribe <at> globel.libreoffice.org. Some clients don't handle the "+"
correctly and drop the word after the + and put it as subject if you click on
the link or copy and paste the address.

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Andrew Douglas Pitonyak | 1 Aug 2011 03:53

Re: Code snippet

On 07/31/2011 03:48 PM, Tom Davies wrote:
> Hi :)
> +1
> The devs guide is not meant to be elitist but probably needs a re-write from a
> more "normal user" perspective lol.  I'm sure the Documentation Team will work
> on it one day but it's not top priority just yet.

Well, if you really understand things like UML and such, then the 
developers guide provides significant information.

> Oh! So I'm not a moron after all. However, I downloaded AndrewMacro.pdf few days
> ago and found Andrew's approach more practical and easier to grasp...and I'm
> approaching UNO and OOo/LibreOffice from python.

Excellent. Glad that it helped. I tried to fire up a few Python examples 
using old libraries created by Danny Brewer (who used to be very active 
in the OOo community). Unfortunately, they failed :-(

I was able to run simple Python examples, however.

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andrew Douglas Pitonyak | 1 Aug 2011 03:57

Re: Python Equivalents for some BASIC uno calls

On 07/31/2011 05:12 PM, Onyeibo Oku wrote:
> BASIC macro devs are having it good with all the documentation on OOo. May I use this forum to say a big thanks
to Andrew Pitonyak for his works on the subject.

Your welcome

> I was trying to clear cell contents in python but I've not been able to figure out the equivalents for the
constants e.g. com.sun.star.sheet.CellFlags.FORMULA for clearing formulas. Which module provides
the definitions? I found that the example above is same as 16, but I'm trying to avoid explicit use of those constants.

There is a service that allows you to find values based on the string 
name..... If you need it, I can likely find it. I intended to add an 
example into the next edition of OOME, I do not remember if it is 
already there or not. Apart from that, I usually just look up the value. 
Worst case, print the value.

>
> I'm also wondering if two constants can be used simultaneously in one clearContents() call e.g. VALUE and STRING
> sent from mobile device
I do believe that you have seen AndrewMacro, which contains an example 
that demonstrates that yes, you can. Just OR the values together. I 
likely show the same thing in OOME. I am currently working through the 
Calc chapter as time permits. I need to hurry, because the German 
translator is translating faster than I am creating more content.

--

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

(Continue reading)

Hoang Le | 1 Aug 2011 05:35
Picon
Gravatar

Re: Re: LibreOffice: text is displayed incorrectly after being selected

> I suggest filing a bug report about the poor rendering. The site is
> https://bugs.freedesktop.org/ . You will need to create an account and
> log in. Then select LibreOffice from the project list to enter the
> report. Please include your screenshots.

Sure, Jay

I'll submit a bug report now.

Thank you for your support ;)
Hoang

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Hoang Le | 1 Aug 2011 05:43
Picon
Gravatar

Word completion as a drop-down list like in IDEs ?

Hi everybody,

I want to ask if it's possible to have word completion as a drop-down
list just in many IDEs? I've been looking on the web but there's no
such thing.

The current completion feature only suggests one word among many
possible matches, making typing much slower than it could be. I'm not
sure how difficult it is to implement this feature

Best regards,
Hoang

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

planas | 1 Aug 2011 06:29
Picon

Re: Code snippet

Andrew,

On Sun, 2011-07-31 at 21:49 -0400, Andrew Douglas Pitonyak wrote: 

> On 07/31/2011 02:19 PM, Bill Gradwohl wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote:
> >> I expect that you need to set this from the sheets draw page
> > ....
> >
> >
> > Thank You Andrew.
> >
> > I have a copy of your book back in Texas. I wish I had it here on the
> > island.
> 
> This is NOT complete, but it is updated. I am in the process of writing 
> a new version.
> 
> http://www.pitonyak.org/OOME_3_0.odt
> 
> > I wrote most of the POS system we use in our restaurant by
> > referencing your book. It's 9000 lines of macro code.
> >
> > I was up on your web site yesterday and noted that you're putting out a
> > new edition. I tried wrapping my head around UNO several times and
> > failed. I just don't get it. I've hit api.openoffice.org trying to make
> > heads or tails out of what's there, but no joy. The API is an
(Continue reading)

Steve Edmonds | 1 Aug 2011 06:43
Favicon

PDF creation with Nimbus font in bold

Hi.
I have been updating some PDFs, now creating with LO3.3.2 and 3.4.1
using the little PDF button. When I open in acrobat I get an error
"Cannot extract the embedded font 'NimbusRomNo9L-Medi'. Some characters
may not display or print correctly".

If I create the PDF with OO3.2.1 there is no error from Acrobat.
The error only occurs if I have the text in bold.
It doesn't happen with a couple of other fonts I have tried in bold.

Filed a bug https://bugs.freedesktop.org/show_bug.cgi?id=39707 with files
Confirmed the bug on Suse and Mac but not Windows.

steve

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Andreas Säger | 1 Aug 2011 03:42
Picon
Favicon

Re: Code snippet

Am 31.07.2011 20:31, Onyeibo Oku wrote:
> Oh! So I'm not a moron after all. However, I downloaded AndrewMacro.pdf few days ago and found Andrew's
approach more practical and easier to grasp...and I'm approaching UNO and OOo/LibreOffice from python.
>
> The Developers guide is for elitist coders.

It's for coders. That's all.

--

-- 
Unsubscribe instructions: E-mail to users+help <at> global.libreoffice.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.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Gmane