[libreoffice-users] Re: Code snippet

[Andreas Säger]

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+h...@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

[libreoffice-users] Re: Python Equivalents for some BASIC uno calls

[Andreas Säger]

import uno
form com.sun.star.sheet.CellFlags import FORMULA

ThisComponent = XSCRIPTCONTEXT.getDocument()
sh = ThisComponet.Sheets.getByIndex(0)
oBasket = sh.queryContentCells(FORMULA)


--
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Re: spellcheck in calc

[Andreas Säger]

menu:Tools>Options...LanguageSettings>Languages...

"Locale settings" are for numbers (for instance 1.23,99 vs 1,234.99 and 
12/13/99 vs 13/12/99)


"Western Language" refers to human language. Change the western language 
for newly generated documents or for your currently active template you 
generate your documents from.



--
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] PDF creation with Nimbus font in bold

[Steve Edmonds]

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+h...@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

Re: [libreoffice-users] Code snippet

[planas]

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
> > 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.
> 
> Do you know about Object Oriented Programming? For obvious reasons, 
> OOo/LO is built using objects. If you look at the code that is LO, these 
> objects are used and manipulated.
> 
> The idea behind UNO is that I can access those internal LO objects 
> directly. The tricky part is that when you get an object that is one of 
> those internal LO objects, it typically supports many services and 
> interfaces. You then need to understand how those services and 
> interfaces tell you how to use the object.
> 
> I think that my head is beginning to hurt.
> 
> > That's why I had to ask for help, and you came through.
> >
> > Thank You.
> 
> Your welcome!
> 
> >
> > - -- 
> > Bill Gradwohl
> > Roatan, Honduras
> > 504 9 899 2652
> > -BEGIN PGP SIGNATURE-
> > Version: GnuPG v1.4.11 (GNU/Linux)
> > Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
> >
> > iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj
> > cosAninW5UjFnmRKHrlpKVqsGubBLjrB
> > =tKaN
> > -END PGP SIGNATURE-
> >
> 
> -- 
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
> 
> 

Your 3rd edition is very good, you seem to hit the right level and tone.

-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Word completion as a drop-down list like in IDEs ?

[Hoang Le]

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+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Hoang Le]

> 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+h...@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

Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

[Andrew Douglas Pitonyak]

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


--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Andrew Douglas Pitonyak]

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+h...@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

Re: [libreoffice-users] unsubscribe

[Cliff Scott]

** Reply to message from Leon Cych  on Sun, 31 Jul 2011
18:53:59 +0100

> Unsubscribe
> 
> -- 
> Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
> Problems? 

Leon,

Check that your email client is using the correct address, i.e.
users+unsubscr...@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+h...@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

Re: [libreoffice-users] Code snippet

[Andrew Douglas Pitonyak]

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.


Do you know about Object Oriented Programming? For obvious reasons, 
OOo/LO is built using objects. If you look at the code that is LO, these 
objects are used and manipulated.


The idea behind UNO is that I can access those internal LO objects 
directly. The tricky part is that when you get an object that is one of 
those internal LO objects, it typically supports many services and 
interfaces. You then need to understand how those services and 
interfaces tell you how to use the object.


I think that my head is beginning to hurt.


That's why I had to ask for help, and you came through.

Thank You.


Your welcome!



- -- 
Bill Gradwohl

Roatan, Honduras
504 9 899 2652
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj
cosAninW5UjFnmRKHrlpKVqsGubBLjrB
=tKaN
-END PGP SIGNATURE-



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


--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Bill Gradwohl]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

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
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk413n8ACgkQ7Orvev+eC8p6wACghowvArWYqnDYmNIUnRVhWMEY
4H8An2fManqw04EYz2osfMiYhsvLVs5V
=2N1t
-END PGP SIGNATURE-

-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Re: create symbolic links to LO program components

[NoOp]

On 07/31/2011 12:47 PM, e-letter wrote:
> Readers,
> 
> In previous software versions, there would be an executable file such
> as 'scalc' and so a symbolic link could easily be created:
> 
> ln -s /path/to/lo/scalc /usr/local/bin/calc
> 
> Therefore calc could be activated via the command terminal or 'run
> application' dialogue window (i.e. alt+f2).
> 
> In LO341, there seems only to be an executable file
> '/usr/bin/libreoffice34'. How now to create symbolic links please?
> 

scalc is a shell file:

$ cat /opt/libreoffice/program/scalc
#!/bin/sh

cmd=`dirname "$0"`/soffice
exec "$cmd" -calc "$@"




-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Python Equivalents for some BASIC uno calls

[Onyeibo Oku]

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.

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. 

I'm also wondering if two constants can be used simultaneously in one 
clearContents() call e.g. VALUE and STRING
sent from mobile device

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] create symbolic links to LO program components

[Tom Davies]

Hi :)
Have you installed multiple versions using the instructions
http://wiki.documentfoundation.org/Installing_in_parallel
If so then the path might be slightly different but the different executables 
should still be around somewhere.
Good luck and regards from
Tom :)





From: e-letter 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 20:47:29
Subject: [libreoffice-users] create symbolic links to LO program components

Readers,

In previous software versions, there would be an executable file such
as 'scalc' and so a symbolic link could easily be created:

ln -s /path/to/lo/scalc /usr/local/bin/calc

Therefore calc could be activated via the command terminal or 'run
application' dialogue window (i.e. alt+f2).

In LO341, there seems only to be an executable file
'/usr/bin/libreoffice34'. How now to create symbolic links please?

-- 
Unsubscribe instructions: E-mail to users+h...@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

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Tom Davies]

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.  

Regards from
Tom :)





From: Onyeibo Oku 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 19:31:37
Subject: Re: [libreoffice-users] Code snippet

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. If the devs wants to attract 
extension development via macro scripting, they should consider making those 
docs more like english language.

sent from mobile device

-Original Message-
From: Bill Gradwohl 
Date: Sun, 31 Jul 2011 12:19:25 
To: 
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Code snippet

-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. 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.

That's why I had to ask for help, and you came through.

Thank You.

- -- 
Bill Gradwohl
Roatan, Honduras
504 9 899 2652
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj
cosAninW5UjFnmRKHrlpKVqsGubBLjrB
=tKaN
-END PGP SIGNATURE-

-- 
Unsubscribe instructions: E-mail to users+h...@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


-- 
Unsubscribe instructions: E-mail to users+h...@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
-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] create symbolic links to LO program components

[e-letter]

Readers,

In previous software versions, there would be an executable file such
as 'scalc' and so a symbolic link could easily be created:

ln -s /path/to/lo/scalc /usr/local/bin/calc

Therefore calc could be activated via the command terminal or 'run
application' dialogue window (i.e. alt+f2).

In LO341, there seems only to be an executable file
'/usr/bin/libreoffice34'. How now to create symbolic links please?

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Tom Davies]

Hi :)
+1
to making a bug-report.  It's a good thing to do.  

It is also worth trying LibreOffice 3.3.3 
http://www.libreoffice.org/download
as a temporary work-around
http://wiki.documentfoundation.org/Installing_in_parallel

Good luck and regards from
Tom :)





From: planas 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 19:36:33
Subject: Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly 
after being selected

Hoang

On Mon, 2011-08-01 at 00:50 +0700, Hoang Le wrote: 

> > I have not noticed this problem with LO either in 3.3.2 or 3.4.1, I have
> > seen occasionally a similar problem; letters not being shown in text.
> > This problem seems to be an OS rendering problem because it is not
> > limited to LO. An example is 'be ween' for 'between'.
> >
> > Have you seen your problem in other applications?
> 
> Dear Jay,
> 
> I have this problem only with LO.
> 
> But I notice that text in LO is rendered differently from most other
> applications, a little like Adobe Reader. Text in normal applications
> are very well-rendered, much sharper and very easy too read.
> 
> Here is a screenshot of normal applications:
> https://picasaweb.google.com/lh/photo/RX6ev9ACDevh0RQXO23bkQ?feat=directlink
> And LO screenshot:
> https://picasaweb.google.com/lh/photo/tI3-_4OFC0ijzdgRf4xMyQ?feat=directlink
> 
> LO 3.4 features include this: "Text Rendering: Linux text-rendering
> improvements. Text is now drawn via Cairo with the same subpixeling
> options as other Cairo-using apps. The outcome is that text in
> LibreOffice is rendered the same as the rest of your desktop". If font
> rendering in 3.4 is supposed to be the same as the rest of my desktop
> then my LO is not correctly functioning
> 
> Best regards,
> Hoang
> 

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.
-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@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

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] unsubscribe

[Tom Davies]

Hi :)
It is easier to look up the instructions in the guide
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

If you send an email to 
users+h...@global.libreoffice.org
then you should receive an email giving the same instructions as the guide but 
with additional help for other tasks.

Good luck and regards from
Tom :)





From: Leon Cych 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 18:53:59
Subject: [libreoffice-users] unsubscribe

Unsubscribe

-- 
Unsubscribe instructions: E-mail to users+h...@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
-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] unsubscribe

[planas]

Leon

On Sun, 2011-07-31 at 18:53 +0100, Leon Cych wrote: 

> Unsubscribe
> 

To unsubcribe send an email for instructions to  users
+h...@global.libreoffice.org 

They will send you an email with instructions and confirming you want to
unsubscribe.

We can not unsubscribe anyone from the list itself.
-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[planas]

Hoang

On Mon, 2011-08-01 at 00:50 +0700, Hoang Le wrote: 

> > I have not noticed this problem with LO either in 3.3.2 or 3.4.1, I have
> > seen occasionally a similar problem; letters not being shown in text.
> > This problem seems to be an OS rendering problem because it is not
> > limited to LO. An example is 'be ween' for 'between'.
> >
> > Have you seen your problem in other applications?
> 
> Dear Jay,
> 
> I have this problem only with LO.
> 
> But I notice that text in LO is rendered differently from most other
> applications, a little like Adobe Reader. Text in normal applications
> are very well-rendered, much sharper and very easy too read.
> 
> Here is a screenshot of normal applications:
> https://picasaweb.google.com/lh/photo/RX6ev9ACDevh0RQXO23bkQ?feat=directlink
> And LO screenshot:
> https://picasaweb.google.com/lh/photo/tI3-_4OFC0ijzdgRf4xMyQ?feat=directlink
> 
> LO 3.4 features include this: "Text Rendering: Linux text-rendering
> improvements. Text is now drawn via Cairo with the same subpixeling
> options as other Cairo-using apps. The outcome is that text in
> LibreOffice is rendered the same as the rest of your desktop". If font
> rendering in 3.4 is supposed to be the same as the rest of my desktop
> then my LO is not correctly functioning
> 
> Best regards,
> Hoang
> 

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.
-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Onyeibo Oku]

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. If the devs wants to attract 
extension development via macro scripting, they should consider making those 
docs more like english language.

sent from mobile device

-Original Message-
From: Bill Gradwohl 
Date: Sun, 31 Jul 2011 12:19:25 
To: 
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Code snippet

-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. 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.

That's why I had to ask for help, and you came through.

Thank You.

- -- 
Bill Gradwohl
Roatan, Honduras
504 9 899 2652
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj
cosAninW5UjFnmRKHrlpKVqsGubBLjrB
=tKaN
-END PGP SIGNATURE-

-- 
Unsubscribe instructions: E-mail to users+h...@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


-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Bill Gradwohl]

-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. 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.

That's why I had to ask for help, and you came through.

Thank You.

- -- 
Bill Gradwohl
Roatan, Honduras
504 9 899 2652
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj
cosAninW5UjFnmRKHrlpKVqsGubBLjrB
=tKaN
-END PGP SIGNATURE-

-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] unsubscribe

[Leon Cych]

Unsubscribe

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Hoang Le]

> I have not noticed this problem with LO either in 3.3.2 or 3.4.1, I have
> seen occasionally a similar problem; letters not being shown in text.
> This problem seems to be an OS rendering problem because it is not
> limited to LO. An example is 'be ween' for 'between'.
>
> Have you seen your problem in other applications?

Dear Jay,

I have this problem only with LO.

But I notice that text in LO is rendered differently from most other
applications, a little like Adobe Reader. Text in normal applications
are very well-rendered, much sharper and very easy too read.

Here is a screenshot of normal applications:
https://picasaweb.google.com/lh/photo/RX6ev9ACDevh0RQXO23bkQ?feat=directlink
And LO screenshot:
https://picasaweb.google.com/lh/photo/tI3-_4OFC0ijzdgRf4xMyQ?feat=directlink

LO 3.4 features include this: "Text Rendering: Linux text-rendering
improvements. Text is now drawn via Cairo with the same subpixeling
options as other Cairo-using apps. The outcome is that text in
LibreOffice is rendered the same as the rest of your desktop". If font
rendering in 3.4 is supposed to be the same as the rest of my desktop
then my LO is not correctly functioning

Best regards,
Hoang

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[planas]

Hoang,

On Sun, 2011-07-31 at 21:19 +0700, Hoang Le wrote: 

> I used LO 3.3.3 before and got this problem. Then I upgraded to 3.4.1
> when I saw in the release note something like "better text rendering"
> but it doesn't solve the problem so far
> 
> > I am running Windows, previously XP, now 7.  In every iteration of OO I have
> > used I have experienced the same misplacement of letters.  Scolling these
> > misplaced characters off screen and back re-paints them correctly.
> >
> > It has never been an issue to worry about but it seems that it has been
> > ported over to LO as well.  As I said it is not a big deal but there is some
> > code buried deep in OO, and now LO, that is not well behaved.
> 
> I think it is a problem, because while writing, I personally select
> text or move the cursor quite a lot. For example, I try to adjust or
> align text but selected text just moves down so I must force LO to
> re-render for to correct the view. Or sometimes, text is just
> unreadable.
> 

I have not noticed this problem with LO either in 3.3.2 or 3.4.1, I have
seen occasionally a similar problem; letters not being shown in text.
This problem seems to be an OS rendering problem because it is not
limited to LO. An example is 'be ween' for 'between'. 

Have you seen your problem in other applications?

-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: Base record access unacceptably slow

[Tom Cloyd]

On 07/31/2011 04:49 AM, Ian Whitfield wrote:

Hi All

I have contacted someone I know who is on the Steering Committee, and 
is a Founding Member, of 'The Document Foundation' and he has replied 
to me asking for the full details. He is not involved on the Base side 
of the project himself but I have asked him to pass the information on 
to the right person.


I have sent him full details of this thread.

Let's hope we get some proper feedback from TDF!!

Ian Whitfield.



Thank you Ian. Much appreciated. Hope it has an effect.

t.
~~
Tom Cloyd / t...@tomcloyd.com / (435) 272-3332

--
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Re: Base record access unacceptably slow

[Andreas Säger]

Am 31.07.2011 02:41, Tom Davies wrote:

Hi :)

It might be time to cut Base loose.  Most versions of MS Office don't include
Access.


Every version I used to know included MS Query. MS Query is the 
"equivalent" of the Base core functionality.
Base is much more important than MS Query. There are no serial letters 
nor bibliographic features without this type of connectivity.
All of my spreadsheets would be empty without Base. I import csv and 
other database row sets entirely through Base.


Nevertheless I aggree that the idiotic nonsense they added since OOo 2.0 
should be removed. There is almost no demand for database development 
within this office suite.
MS Access is a multi-million Dollar project which can not be imitated by 
a zip container and some ridiculous wizards.



--
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Re: Base record access unacceptably slow

[Andreas Säger]

Am 30.07.2011 23:07, Jean-Francois Nifenecker wrote:

Le 29/07/2011 10:41, Andreas Säger a écrit :


As a matter of fact you can disable/remove Java, hit F4 ... connect,
query, edit and dump.
If I would convert our Java databases and remove Java from our systems
nobody would notice the change.


Could you elaborate, please?

If I remove Java, can I open the Base module and create a query in
design mode? I happen to think I can't but I might be mistaken.



Stop thinking. Start trying. It takes 15 seconds.

1) There is a completely useless query wizard. This is the only query 
generator depending on Java.


2) There is an almost useless query designer which supports baby SQL 
only. You can learn that level of SQL for all databases within a day and 
use 3 with more features and less errors:

3) The SQL editor knows 2 modes:
3a) The "parsed mode" which works well in most cases and which may be 
viewed in the design view (which may destroy your valid SQL then).
3b) Direct SQL which always works properly when handled by a mature 
RDBMS such as HSQLDB. Unfortunately, Base makes these row sets read-only 
and parameter queries don't work.



--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Andrew Douglas Pitonyak]

On 07/31/2011 03:50 AM, Johnny Rosenberg wrote:

2011/7/31 Andrew Douglas Pitonyak:

I expect that you need to set this from the sheets draw page

' Gets the Shape of a Control( e. g. to reset the size or Position of the
control
' Parameters:
' The 'oContainer' is the Document or a specific sheet of a Calc - Document
' 'CName' is the Name of the Control
Function GetControlShape(oContainer as Object,CName as String)
Dim i as integer
Dim aShape as Object
   For i = 0 to oContainer.DrawPage.Count-1
  aShape = oContainer.DrawPage(i)
  If HasUnoInterfaces(aShape, "com.sun.star.drawing.XControlShape") then
 If ashape.Control.Name = CName then
GetControlShape = aShape
exit Function
 End If
  End If
   Next
End Function

So, how do I call it?

Sub gcs
  Dim oSize
  oSize = GetControlShape(ThisComponent.Sheets(0), "button1").Size
  Print oSize.Height
  Print oSize.Width
End Sub

In this example, I pass the sheet containing the button with the button name
to the "GetControlShape" function. I forget the unit of measure. Hmm, oh
yeas, 1" = oSize.Height / 2540

But wait, your units metric. I think life just got easier for you :-), just
set to 500 for 1/2 CM I believe.

So you mean that the size is measured in 10⁻⁵ m (1/100 000 m)? That's
kind of odd, isn't it? But on the other hand, odd doesn't necessarily
mean wrong…

So this is correct?
500 ⇨ ½ cm=5 mm (cm≠CM, by the way)
1000 ⇨ 1 cm
10 000 ⇨ 1 dm
100 000 ⇨ 1 m


I would need to look up the units, but, I believe that I stated it 
correctly.


What I did not mention, however, is that if you want to change the size, 
you likely need to do something like:



Dim oSize
Dim oShape
oShape = GetControlShape(ThisComponent.Sheets(0), "button1")
oSize = oShape.Size
oSize.Height=500
oShape.Size = oSize

You cannot simply use

oShape.Size.Height=500


Reason? Because the Size object is an UnoStruct, and copy semantics are 
used to return a struct rather than returning a reference as occurs with 
other objects. I seem to remember that there was one or two exceptions 
to that, but when I was told that, the core developer could not remember 
what the exception was.

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


--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Hoang Le]

I used LO 3.3.3 before and got this problem. Then I upgraded to 3.4.1
when I saw in the release note something like "better text rendering"
but it doesn't solve the problem so far

> I am running Windows, previously XP, now 7.  In every iteration of OO I have
> used I have experienced the same misplacement of letters.  Scolling these
> misplaced characters off screen and back re-paints them correctly.
>
> It has never been an issue to worry about but it seems that it has been
> ported over to LO as well.  As I said it is not a big deal but there is some
> code buried deep in OO, and now LO, that is not well behaved.

I think it is a problem, because while writing, I personally select
text or move the cursor quite a lot. For example, I try to adjust or
align text but selected text just moves down so I must force LO to
re-render for to correct the view. Or sometimes, text is just
unreadable.

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Gene Young]

On 7/31/2011 9:23 AM, Hoang Le wrote:

Interesting. What font is that? What locale? Which version of LO?
Backports?


I'm mostly using Times New Roman and Arial and they both have this
problem. Not sure if other fonts have this problem because I don't use
them much.
I'm Vietnamese (you can see some Vietnamese letters in the screenshot)
but my system locale is en-US.

I'm not sure what you mean by LO or Backport ;)

Thank you,
Hoang

I am running Windows, previously XP, now 7.  In every iteration of OO I 
have used I have experienced the same misplacement of letters.  Scolling 
these misplaced characters off screen and back re-paints them correctly.


It has never been an issue to worry about but it seems that it has been 
ported over to LO as well.  As I said it is not a big deal but there is 
some code buried deep in OO, and now LO, that is not well behaved.


--
Gene Young

--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Tom Davies]

Hi :) 
LO = LibreOffice.  They were asking which release of LibreOffice you are having 
trouble with.  


If it's the 3.4.1 then it's worth trying the 3.3.3 version (if you can) because 
it's supposed to be more stable.  You can install both versions alongside each 
other which allows you to use 3.4.1 for advanced features but still have the 
solid 3.3.3 for when you need it.  

http://wiki.documentfoundation.org/Installing_in_parallel

I'm not certain but i think "backports" means extra bits of code you have added 
to a previous release in order to try to bring it up to the level of a newer 
release.  It's something that people in companies do to try to avoid the chaos 
that usually surrounds doing a full upgrade on all machines.  


Regards from
Tom :)





From: Hoang Le 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 14:23:32
Subject: Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly 
after being selected

> Interesting. What font is that? What locale? Which version of LO?
> Backports?

I'm mostly using Times New Roman and Arial and they both have this
problem. Not sure if other fonts have this problem because I don't use
them much.
I'm Vietnamese (you can see some Vietnamese letters in the screenshot)
but my system locale is en-US.

I'm not sure what you mean by LO or Backport ;)

Thank you,
Hoang

-- 
Unsubscribe instructions: E-mail to users+h...@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
-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Hoang Le]

> Interesting. What font is that? What locale? Which version of LO?
> Backports?

I'm mostly using Times New Roman and Arial and they both have this
problem. Not sure if other fonts have this problem because I don't use
them much.
I'm Vietnamese (you can see some Vietnamese letters in the screenshot)
but my system locale is en-US.

I'm not sure what you mean by LO or Backport ;)

Thank you,
Hoang

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: Base record access unacceptably slow

[aon . 913450908]

Hello,
-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Re: LibreOffice: text is displayed incorrectly after being selected

[Mahesh T Pai]

Hoang Le  writes:


 > You can see the screenshot here
 > https://picasaweb.google.com/lh/photo/tI3-_4OFC0ijzdgRf4xMyQ?feat=directlink
>
 > Here is some information about my system:
 > - Debian 6.0.2 (Squeeze)
 > - Gnome 2.30.2
 > - Compiz
 > - ATI Radeon HD 3450


Interesting. What font is that? What locale? Which version of LO?
Backports?

I have no such problems here. 


-- 
Mahesh T. Pai   ||
Buy Free Software -- It gives you freedom!


-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] Impress Guide, 1st edition completed

[Tom Davies]

Hi :)

Jean Weber and the rest of the Documentation Team have completed the 1st 
edition 
of the Impress Guide
http://wiki.documentfoundation.org/Documentation#LibreOffice_Impress_Guide
This expands considerably on the documentation in the Impress Chapter in the 
"Getting Started" guide.  A good link :)  


Hopefully a paper-back book version will soon be available for purchase from 
Lulu with most of the profits (i think ALL actually) going back to TDF.  Here 
is 
the link to the Calc Guide.
http://www.lulu.com/product/paperback/libreoffice-3-calc-guide/16075944
Note that downloading from
http://wiki.documentfoundation.org/Documentation
or 
http://www.libreoffice.org/get-help/documentation/
is free but some people prefer to have a proper book perhaps as a collectors 
item. 


Regards from
Tom :)

-- 
Unsubscribe instructions: E-mail to users+h...@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

[libreoffice-users] LibreOffice: text is displayed incorrectly after being selected

[Hoang Le]

Hi everybody,

I have some problem with font displaying in LibreOffice 3.4.
Sometimes, selecting the text makes it being redrawn incorrectly (a
little bit lower than normal), so the word/sentence looks broken and
difficult to see. Doing something like "show desktop" or scroll the
document until those texts are hidden will temporarily solve the
problem for a short time. I also have this problem with previous
version.

You can see the screenshot here
https://picasaweb.google.com/lh/photo/tI3-_4OFC0ijzdgRf4xMyQ?feat=directlink

Here is some information about my system:
- Debian 6.0.2 (Squeeze)
- Gnome 2.30.2
- Compiz
- ATI Radeon HD 3450

Please help me. Thank you!
-- Hoang

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: Base record access unacceptably slow

[soumalya ray]

gr8.base users might feel betrayed now if base support is discontinued.that
will not be a good experience for them.though personally i do not use base
myself.
best wishes

On 31 July 2011 16:19, Ian Whitfield  wrote:

> Hi All
>
> I have contacted someone I know who is on the Steering Committee, and is a
> Founding Member, of 'The Document Foundation' and he has replied to me
> asking for the full details. He is not involved on the Base side of the
> project himself but I have asked him to pass the information on to the right
> person.
>
> I have sent him full details of this thread.
>
> Let's hope we get some proper feedback from TDF!!
>
> Ian Whitfield.
> 
>
>
> --
> Unsubscribe instructions: E-mail to 
> users+help@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
>
>


-- 
Dr soumalya ray   
MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: Base record access unacceptably slow

[Ian Whitfield]

Hi All

I have contacted someone I know who is on the Steering Committee, and is 
a Founding Member, of 'The Document Foundation' and he has replied to me 
asking for the full details. He is not involved on the Base side of the 
project himself but I have asked him to pass the information on to the 
right person.


I have sent him full details of this thread.

Let's hope we get some proper feedback from TDF!!

Ian Whitfield.


--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] spellcheck in calc

[Regina Henschel]

Hi Thomas,

Thomas Blasejewicz schrieb:
> Good morning
> I have noted this in the past already several times, but since this is
> not something I use frequently just ignored it.
> 
> I am trying to spellcheck in Calc.
> Set the language to German (English seems to (?) work).

Where and how do you do it?

I define a cell style, where I set the language to German in tab Ront
and in tab Numbers.

Are you sure, that the German dictionary is available?

> Start spelling.
> Speller encounters unknown term ->  instruct to "ignore once"
> For reasons unknown it hangs up here.
> Where the button "ignore once" was, now "Resume" is displayed.
> Click Resume ->  unknown term ->  instruct to "ignore once" ->  Resume

I cannot confirm this behavior. Spell check work fine here including the
"ignore" features.
> 
> 
> Once this cycle starts the speller NEVER gets out of that cell again.
> And if this happens say in the third cell of a 5,000-cell sheet ---
> it renders the spell checker completely useless.
> 
> Is there a way of telling the spell checker it has more work to do?

For me it sounds, as if the dictionary is not available.

Kind regards
Regina

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] spellcheck in calc

[Tom Davies]

Hi :)
Ok, please can you post a bug-report about the issue?
http://wiki.documentfoundation.org/BugReport
LibreOffice 'should' work for Japanese Windows aswell.  It aims at being 
multilingual so even if the problem is limited to Japanese Xp then it needs 
sorting.  

Regards from
Tom :)





From: Thomas Blasejewicz 
To: users@global.libreoffice.org
Sent: Sun, 31 July, 2011 8:09:27
Subject: Re: [libreoffice-users] spellcheck in calc

(2011/07/31 0:55), Tom Davies wrote:
> Hi ?
> Sorry but i have completely lost track.  Have you managed to solve this 
problem
> yet?
> Regards from
> Tom :)
> 
Thank you for asking, but I don't think so.
There is a whole group of things that are - put it VERY mildly - stange.
And the sum / result of all that strange behavior is, that I have to check just 
about each an every cell manually.
If I want to CHANGE anything, I have to exit the spell checker first ...

Forgive me, but that is "useless" at best.

may this be related to the fact, that my computer is running the JAPANESE 
Windows XP (and things would be different, if this were an English (or German) 
version?

-- Unsubscribe instructions: E-mail to users+h...@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

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Re: Base record access unacceptably slow

[Regina Henschel]

Hi Tom,

Tom Davies schrieb:

Hi :)

It might be time to cut Base loose.  Most versions of MS Office don't include
Access.  Gnome Office doesn't have a database program.  Perhaps Office Suites
just don't need an integrated program to do this sort of stuff.  Maybe Calc is
enough.  There are a few alternatives on the market for people that really need
a database.  To move forwards Base needs a serious commitment and a strong
vision of where it wants to get to.  If we cut it loose then LibreOffice as a
whole is freed from a lot of dependencies and stuff that the other apps don't
need.  So, lets just drop Base.


please use a new thread for such a far reaching proposal. And I think, 
disc...@documentfoundation.org would be more suitable place.


I'm strongly against the proposal, but let us discuss it in a new thread.

Kind regards
Regina

--
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] Code snippet

[Johnny Rosenberg]

2011/7/31 Andrew Douglas Pitonyak :
> I expect that you need to set this from the sheets draw page
>
> ' Gets the Shape of a Control( e. g. to reset the size or Position of the
> control
> ' Parameters:
> ' The 'oContainer' is the Document or a specific sheet of a Calc - Document
> ' 'CName' is the Name of the Control
> Function GetControlShape(oContainer as Object,CName as String)
> Dim i as integer
> Dim aShape as Object
>   For i = 0 to oContainer.DrawPage.Count-1
>      aShape = oContainer.DrawPage(i)
>      If HasUnoInterfaces(aShape, "com.sun.star.drawing.XControlShape") then
>         If ashape.Control.Name = CName then
>            GetControlShape = aShape
>            exit Function
>         End If
>      End If
>   Next
> End Function
>
> So, how do I call it?
>
> Sub gcs
>  Dim oSize
>  oSize = GetControlShape(ThisComponent.Sheets(0), "button1").Size
>  Print oSize.Height
>  Print oSize.Width
> End Sub
>
> In this example, I pass the sheet containing the button with the button name
> to the "GetControlShape" function. I forget the unit of measure. Hmm, oh
> yeas, 1" = oSize.Height / 2540
>
> But wait, your units metric. I think life just got easier for you :-), just
> set to 500 for 1/2 CM I believe.

So you mean that the size is measured in 10⁻⁵ m (1/100 000 m)? That's
kind of odd, isn't it? But on the other hand, odd doesn't necessarily
mean wrong…

So this is correct?
500 ⇨ ½ cm=5 mm (cm≠CM, by the way)
1000 ⇨ 1 cm
10 000 ⇨ 1 dm
100 000 ⇨ 1 m



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
> On 07/30/2011 07:05 PM, Bill Gradwohl wrote:
>>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> I've searched and can't figure out how to specify the height of a button
>> at execution time via a basic macro.
>>
>> If "Sheet1" contains a button name "OK", how would I specify a button
>> height of 0.5cm?
>>
>> The only examples I can find are for buttons on forms, not on a sheet
>> itself.
>>
>> - -- Bill Gradwohl
>> Roatan, Honduras
>>
>> -BEGIN PGP SIGNATURE-
>> Version: GnuPG v1.4.11 (GNU/Linux)
>> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
>>
>> iEYEARECAAYFAk40jisACgkQ7Orvev+eC8rGHQCgmq3OwAJmVey+UVF051lvj9nj
>> agYAoIiZ3ZEl5074W6+CpTowdUxilfcl
>> =U2Iw
>> -END PGP SIGNATURE-
>>
>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
>
>
> --
> Unsubscribe instructions: E-mail to users+h...@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
>
>

-- 
Unsubscribe instructions: E-mail to users+h...@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

Re: [libreoffice-users] spellcheck in calc

[Thomas Blasejewicz]

(2011/07/31 0:55), Tom Davies wrote:

Hi ?
Sorry but i have completely lost track.  Have you managed to solve this problem
yet?
Regards from
Tom :)


Thank you for asking, but I don't think so.
There is a whole group of things that are - put it VERY mildly - stange.
And the sum / result of all that strange behavior is, that I have to 
check just about each an every cell manually.

If I want to CHANGE anything, I have to exit the spell checker first ...

Forgive me, but that is "useless" at best.

may this be related to the fact, that my computer is running the 
JAPANESE Windows XP (and things would be different, if this were an 
English (or German) version?


--
Unsubscribe instructions: E-mail to users+h...@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