date:20111029

On 28/10/2011, Pete Holsberg  wrote:
> Hi,
>
> I created a file with the Android app "Office Suite Pro" and I cannot
> open it with Libre Writer.
>

Does this program 'office suite pro' produce odt files?

If the answer is yes, this is the correct mailing list to report
errors with the _native_ odf formats.

If the answer is no, go to the program supplier's web site, or m$

-- 
For 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] Cannot open DOCX file

On 28/10/2011, ESChamp  wrote:
> I created a docx file with Android Office Suite Pro, and while MS Office
> 2010 can open it, LO cannot.
>
> Ideas?
>

The best idea is to create an odt document and tell us if there any errors.

If you want to create m$ formats, contact office suite pro and/or m$.

-- 
For 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] Calc: Converting Formula to Value

2011-10-29 Thread Stefan Weigel

Hi,

Am 29.10.2011 02:05, schrieb Uwe Koch Kronberg:

> Stefan means to select the area, copy it, go to another cell, choose
> edit from the menu, click on paste special and inside the menu box it
> opens unclick paste all, then unclick all the options below (text, date
> and hour, formulae, comments, formats, objects) except for numbers,
> which is the only option that should stay checked.

Hm. Not exactly. In order to "convert" a formula into its result
value, I wouldn´t go to *another* cell but paste special right in
the *same* cell --> that means overwriting the formula by its result
value. ;-)

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For 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] Calc: Converting Formula to Value

2011-10-29 Thread Stefan Weigel

Hi Rich,

Am 29.10.2011 01:50, schrieb Rich Shepard:

>   I'm not following you. Are you writing that I can highlight two
> adjacent
> cells and have their sum pasted in the same row in a third column?

No. Follow this:

(1) Select the cell that contains the formula

(2) Choose Edit | Copy

(3) Choose Edit | Paste Special

(4) Unselect "Paste all" and unselect "Formulas" and select "Numbers"

(5) Hit "OK"

Done.

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For 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] Find in 3.4.3

2011-10-29 Thread Steve Edmonds


Hi.
I am trying to find (search for) some text in some sheets.
The text appears in many formulae and also as text in cells.
I wish to exclude the formulae from the search.
In Find & Replace > More options > Search in I am able to select 
"Values" but the search still finds the text in formulae.

Am I searching wrong?
steve

--
For 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] Videos (mpeg etc) in Impress

On 24/10/2011, mikko  wrote:
> Hello,
>
> I wonder if I am missing something & if anyone else has this same problem: I
> can embed videos in Impress but I have no control on how they start (simple
> start on click would be fine), appear, leave or repeat. All the effects work
> fine for images but inserted videos just start and run once.  I am using
> Impress in Mac, Win7 and Ubuntu 11.10, and have the same problem independent
> of the OS. Apart from this, everything else works great but this is a
> crucial feature for me (and keep me using other options such as PP and
> Keynote).
>

Insert video into presentation slide

Use the menu bar options 'slide show|custom animation|misc. effects'

Add the options 'start media', 'end media' etc. and adjust timing,
order as appropriate.

-- 
For 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: OO Base will not run in LO Base


Le 29/10/2011 02:20, Brian Barker a écrit :

Brian,


I'm always puzzled by this sort of claim. The subjects of this personal
information presumably expect that it will remain confidential: that is,
not be distributed beyond the audience they anticipated when they
provided the information. If it gets to you, that expectation - that
confidence - has already been betrayed. It doesn't matter what you
promise to do or not to do with the information: if you have it, it is
no longer confidential.


Are we here to debate the notion of the word "confidential" or to try 
and help the person with the problem ? I offered my help with a 
guarantee that the information revealed to me would remain between 
myself and that person. It is not up to me to provide that information 
to others, unless I have the authorisation to do so from the initial 
discloser. That is the whole point surely ?


Alex



--
For 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] Cannot open DOCX file

Hi :)
I still think that Doc as opposed to DocX is the only format that all 3 
programs can read/write the same.  Just open the existing DocX in either 
Android or MS and then 

File (or golden orb) - "Save As ... "

and choose something like "older Word 97/2000/Xp"

I would experiment with Odt as it is a superior format, even the older 1.1, but 
using it might require changing the defaults for LibreOffice

Tools - Options - "+ Load/Save" - General

In the middle of that page you can change the ODF format to the older one and 
at the bottom you can change the defaults from ODF (Odt, Ods, Odp etc) to MS 
Office ones (Doc, Xls, Ppt).
Regards from
Tom :)

--- On Sat, 29/10/11, e-letter  wrote:

> From: e-letter 
> Subject: Re: [libreoffice-users] Cannot open DOCX file
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 10:21
> On 28/10/2011, ESChamp 
> wrote:
> > I created a docx file with Android Office Suite Pro,
> and while MS Office
> > 2010 can open it, LO cannot.
> >
> > Ideas?
> >
> 
> The best idea is to create an odt document and tell us if
> there any errors.
> 
> If you want to create m$ formats, contact office suite pro
> and/or m$.
> 
> -- 
> For 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
> 

-- 
For 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] can't print t[w]o pages on a single side of paper

Hi :)
When i want to print a web-page to file rather than to a printer i get the 
choice of exporting/printing.saving as .Pdf or .Ps.  The .Ps is the default.  
I'm on Ubuntu 10.04 (or 10.10 depending on which machine).
Regards from
Tom :)

--- On Sat, 29/10/11, Thomas Knierim  wrote:

> From: Thomas Knierim 
> Subject: Re: [libreoffice-users] can't print t[w]o pages on a single side of 
> paper
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 7:39
> already answered in the former mail
> (2:00 o'clock today)
> Am 29.10.2011 um 02:33 schrieb webmaster for Kracked Press
> Productions:
> 
> > If you go to
> > Print > Properties > Device
> > you will see the printer language option
> > I did not remember this either.
> > 
> > But I do wonder if PDF means something different
> here.
> > 
> > 
> > On 10/28/2011 07:39 PM, Brian Barker wrote:
> >> At 14:38 28/10/2011 +0200, Thomas Knierim wrote:
> >>> The problem does only appear if the printer
> language is set to PDF (the default) in LibreOffice.
> >> 
> >> PDF (Portable Document Format) is not a printer
> language but a document file format.  Is it possible
> that you mean PCL, HP's Printer Command Language?
> >> 
> >> Brian Barker
> >> 
> >> 
> > 

-- 
For 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: OO Base will not run in LO Base

2011-10-29 Thread Ian Whitfield


Thanks Alex

Sorry about the 'New Thread' thing - on another Forum I'm on I only have 
to change the Subject Line - Now I know!! (Thanks for explaining it to me!!)

A few further questions :
- does the form contain any image fields ?

- does the form contain any boolean fields ?

- is the form based on a joined query (multitable), a view, or just a
simple one table query ?
My Form has approx 70 fields of which 3 are "Picture" fields, (One plain 
graphic and two photos) although all records do not have all photos - 
some have none or just one. ALL records have a graphic, it is a visual 
identification of the Status of the person in each record.


There are no Boolean fields or Macros or anything like that and all the 
data comes out of ONE table. However I did experiment at one time by 
adding a couple of buttons to do things automatically. ie a button next 
to the eMail address to send an eMail to that person. Maybe I should 
remove these for now and see if these are causing the problem - what do 
you think??

The form saved outside of the database shouldn't contain any personal
data other than that of the user that created it (and only then if you
have filled in those details in the corresponding LO Options screen). Of
course, it will contain references to the fields of the table(s) to
which it originally linked, which you may or may not want to reveal.

If you send me the ODB file in private (alex.thurgood  gmail.com), I
can assure you it will remain confidential (I'm an attorney).


I will wait your reply on the above before I send you anything. The 
whole .odb file is large (332Mb) but the .odt Form file is much smaller 
(16.4Kb).


Regarding the comment by Brian Baker on this "Confidentiality" matter I 
must say I don't completely go along with this. Yes - the members have 
given me their details "in confidence" with the understanding that it 
will not be mis-used. _MY_ concern is that I let it get out into the 
hands of Spammers and other such people that results in the Members 
getting onto all sorts of Spam Lists and other Malware type situations 
resulting from the "loss" of information entrusted to me!! The 
information I hold here is available to all and any other member of our 
Group but is NOT for general distribution. This is what I'm protecting!!


Thanks again Alex - I really do appreciate your help!

Ian Whitfield.

--
For 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: creating a dropdown field form


Le 29/10/2011 01:00, The Wolfkin a écrit :

Hi,


I tried using the Getting Started PDF(2) but while that did help me in
creating dropdown menus. I haven't been able to populate it and in their
example it was populated with items from another table. I'm only working
with one table here. I also don't see any way to add new fields. If I wanted
to do that would I have to start over and create a new form?



If you want to add a new field to your form, then you have to open it in 
Form Edit mode. In your list of forms in the main ODB window, right 
mouse button click on your form and choose Edit (or Modify, I'm not sure 
of the exact term, my version of LibO is in French). This should open 
the form in Form Edit mode, where you can swap field control parts, add 
new fields etc.


If you are adding new fields, then they need to already exist in your 
database table first.


As for your dropdown list :
Enter Form Edit mode.
Select your control (possibly having to "Enter Group" first)
Right-mouse button click on the control and choose "Replace with"
Choose Combobox
Now right-mouse button click on your combobox control.
Choose "Control" from the context menu.
In the "List Content Type" choose SQL from the dropdown choices.
In the List Content field, enter :
SELECT "myfield" FROM "mytable", replacing "myfield" with the field you 
want the data to be selected from and "mytable" with the table name from 
which the data is taken.

Close the Control Properties window.
Save the changes to your form.
Close your form.
Double-click on your form to open it in data edit/entry mode. You should 
be able to now select pre-entered data from the dropdown list and 
additionally add new data into the same field. Just remember to save 
your changes before you close the form again (or just switch to another 
record), and the database before you close the ODB file.


Alex


--
For 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] Text highlighting in LO Impress

Hi :)
I tried writing in Writer, got individual words to have different background 
colours and copy&pasted the words into a text in Impress but all the 
backgrounds disappeared.  LO 3.3.2 still.  

In Writer i inserted a frame and wrote in that adding different backgrounds to 
different words.  When i copyy&pasted the frame itself into impress the words 
kept their backgrounds but i ran into other problems to do with sizes and only 
a portion of the frame.

I ownder if documentation helps?
http://wiki.documentfoundation.org/Documentation/Publications
Regards from
Tom :)




--- On Sat, 29/10/11, jorge  wrote:

> From: jorge 
> Subject: Re: [libreoffice-users] Text highlighting in LO Impress
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 5:24
> Hi
> 
>     Why not try to do it in Writer and then
> copy - paste to Impress, or
> with a program to save an image of desktop you can select
> and paste as
> an image on Impress.
> 
> Regards,
> 
> Jorge Rodríguez
> ___
> 
> 
> 
> El vie, 28-10-2011 a las 23:34 +0300, v...@ukr.net
> escribió:
> > Hello!
> > 
> > On Fri, 28 Oct 2011 18:26:22 +0100 (BST)
> > Tom Davies 
> wrote:
> > 
> > > Hi :)
> > > Once you have selected the words can you
> right-click and see what
> > > options you have in there for formatting
> text?  I haven't tried it
> > > but often when programs don't let you access
> their formatting
> > > tool-bars you can still use a right-click menu
> (or keyboard
> > > short-cuts such as Ctrl B to make things bold)
> Regards from Tom :)
> > > 
> >   Yes, you are right - there is a
> possibility to tune the text options
> > via the right-click menu, but it doesn't let to change
> the background
> > of separate words.
> > 
> >   And what seems even more strange to
> me is that there is a special
> > button "text highlighting" in LO Writer, but there is
> no such button in
> > LO Impress. I thought all the LO programs use the same
> component
> > (widget) for text editing and thus should have the
> same functions, but
> > now it turns out they don't.
> >   Is it so?
> > 
> >   Regards,
> >     Vladimir
> > 
> > 
> > - 
> >  
> > 
> 
> -- 
> Atentamente,
> 
> Jorge Rodríguez
> 
> 
> -- 
> For 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
> 

-- 
For 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: How may I read the value of a cell into a macro variable?


Le 29/10/2011 00:44, David S. Crampton a écrit :

Hi David,



This question has two parts: simple and more complex:

simple: I wish to read the value of the currently selected cell (in
Calc, of course) into a variable in the macro language (Libre Basic).
Script example please. and thank you!


I can't answer your question, but if you come from the world of VBA, 
this document might be of use :


http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf




more complex: AFAIK the LibreHelp does not document the stuff like:

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args2())

I used to be pretty skilled at recording macros and then modifying them.
Where do I go to find things related to "uno:GoToCell"? Universal
Network Objects? Can't find the "starting point".


Your best bet would probably be to read the API documentation :

http://api.libreoffice.org/

or alternatively the Sun OOo Basic Programming Guide :

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide

or buy one of the books on Macro programming :
- OpenOffice.org Macros Explained by Andrew Pitonyak
- Learn Openoffice.Org Spreadsheet Macro Programming by Mark Bain



Alex


--
For 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: OO Base will not run in LO Base

Hi :)
Tech support often has to deal with confidential information.  I would trust 
Alex to not spread the info further and also to not take advantage and misuse 
the info.  There are other people here that i would also trust in this way even 
if i disagree with them on other issues.  

There is often a conflict between confidentiality/security and productivity.  
The only way to make sure stuff remains confidential is to stop using the 
database, delete it and wipe all trace of it from any system it has been on.  

Regards from
Tom :)


--- On Sat, 29/10/11, Alex Thurgood  wrote:

> From: Alex Thurgood 
> Subject: [libreoffice-users] Re: OO Base will not run in LO Base
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 13:07
> Le 29/10/2011 02:20, Brian Barker a
> écrit :
> 
> Brian,
> 
> > I'm always puzzled by this sort of claim. The subjects
> of this personal
> > information presumably expect that it will remain
> confidential: that is,
> > not be distributed beyond the audience they
> anticipated when they
> > provided the information. If it gets to you, that
> expectation - that
> > confidence - has already been betrayed. It doesn't
> matter what you
> > promise to do or not to do with the information: if
> you have it, it is
> > no longer confidential.
> 
> Are we here to debate the notion of the word "confidential"
> or to try and help the person with the problem ? I offered
> my help with a guarantee that the information revealed to me
> would remain between myself and that person. It is not up to
> me to provide that information to others, unless I have the
> authorisation to do so from the initial discloser. That is
> the whole point surely ?
> 
> Alex
> 
> 
> 
> -- For 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
> 
> 

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

Fw: Re: [libreoffice-users] Re: OO Base will not run in LO Base

Hi :)
Ok, errr, forwarding the email back to the list seems to break it out and form 
a new thread so i have just done that with this post.  The slightly messed-up 
thread is "Dictionary in LO 3.4.3 "
http://nabble.documentfoundation.org/Dictionary-in-LO-3-4-3-td3434286.html

I think we have fixed the problem now so that both threads are ok.  I guess i 
should have done this last time but i forgot [shrugs]  I guess other people did 
too ;) lol.  We get there in the end hopefully!  Now we just have to fix the 
database issue! 

Regards from
Tom :)


--- On Sat, 29/10/11, Ian Whitfield  wrote:

> From: Ian Whitfield 
> Subject: Re: [libreoffice-users] Re: OO Base will not run in LO Base
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 12:24
> Thanks Alex
> 
> Sorry about the 'New Thread' thing - on another Forum I'm
> on I only have to change the Subject Line - Now I know!!
> (Thanks for explaining it to me!!)
> > A few further questions :
> > - does the form contain any image fields ?
> > 
> > - does the form contain any boolean fields ?
> > 
> > - is the form based on a joined query (multitable), a
> view, or just a
> > simple one table query ?
> My Form has approx 70 fields of which 3 are "Picture"
> fields, (One plain graphic and two photos) although all
> records do not have all photos - some have none or just one.
> ALL records have a graphic, it is a visual identification of
> the Status of the person in each record.
> 
> There are no Boolean fields or Macros or anything like that
> and all the data comes out of ONE table. However I did
> experiment at one time by adding a couple of buttons to do
> things automatically. ie a button next to the eMail address
> to send an eMail to that person. Maybe I should remove these
> for now and see if these are causing the problem - what do
> you think??
> > The form saved outside of the database shouldn't
> contain any personal
> > data other than that of the user that created it (and
> only then if you
> > have filled in those details in the corresponding LO
> Options screen). Of
> > course, it will contain references to the fields of
> the table(s) to
> > which it originally linked, which you may or may not
> want to reveal.
> > 
> > If you send me the ODB file in private
> (alex.thurgood  gmail.com), I
> > can assure you it will remain confidential (I'm an
> attorney).
> 
> I will wait your reply on the above before I send you
> anything. The whole .odb file is large (332Mb) but the .odt
> Form file is much smaller (16.4Kb).
> 
> Regarding the comment by Brian Baker on this
> "Confidentiality" matter I must say I don't completely go
> along with this. Yes - the members have given me their
> details "in confidence" with the understanding that it will
> not be mis-used. _MY_ concern is that I let it get out into
> the hands of Spammers and other such people that results in
> the Members getting onto all sorts of Spam Lists and other
> Malware type situations resulting from the "loss" of
> information entrusted to me!! The information I hold here is
> available to all and any other member of our Group but is
> NOT for general distribution. This is what I'm protecting!!
> 
> Thanks again Alex - I really do appreciate your
> help!
> 
> Ian Whitfield.
> 
> -- For 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
> 
> 

-- 
For 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] Text highlighting in LO Impress

2011-10-29 Thread Regina Henschel


Hello Vladimir,

v...@ukr.net schrieb:

   Hello!

On Fri, 28 Oct 2011 18:26:22 +0100 (BST)
Tom Davies  wrote:


Hi :)
Once you have selected the words can you right-click and see what
options you have in there for formatting text?  I haven't tried it
but often when programs don't let you access their formatting
tool-bars you can still use a right-click menu (or keyboard
short-cuts such as Ctrl B to make things bold) Regards from Tom :)


   Yes, you are right - there is a possibility to tune the text options
via the right-click menu, but it doesn't let to change the background
of separate words.

   And what seems even more strange to me is that there is a special
button "text highlighting" in LO Writer, but there is no such button in
LO Impress. I thought all the LO programs use the same component
(widget) for text editing and thus should have the same functions, but
now it turns out they don't.
   Is it so?


Yes and no. The texts in Draw/Impress behave similar to the text box 
(drawing object with T icon) in Writer. That is different from the 
normal text in Writer. Therefore you can define a style only for the 
whole object not for single characters. Hard styling is restricted to 
font attributes of the tabs 'font' and 'font effect'. If you search in 
https://issues.apache.org/ooo/ you will find a lot of issues about the 
restriction of text in Draw/Impress.


In Draw/Impress it is no problem to group objects. So for getting a 
background, draw a colored rectangle, place it behind the word, and 
group all together. That has the additional effect, that you can animate 
this 'hightlighting'.


Kind regards
Regina

--
For 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] Calc: Converting Formula to Value

2011-10-29 Thread Rich Shepard


On Sat, 29 Oct 2011, Stefan Weigel wrote:


The trick is to copy and then paste special (Edit menu). In the dialog
check only numbers.


Stefan,

  Thank you very much.

Rich

--
For 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] can't print t[w]o pages on a single side of paper

2011-10-29 Thread Thomas Knierim


Am 29.10.2011 um 13:13 schrieb Tom Davies:

> Hi :)
> When i want to print a web-page to file rather than to a printer i get the 
> choice of exporting/printing.saving as .Pdf or .Ps.  The .Ps is the default.  
> I'm on Ubuntu 10.04 (or 10.10 depending on which machine).
> Regards from
> Tom :)
> 

The problem is to print two pages on one Sheet. Saving files as pdf is no 
problem.

> --- On Sat, 29/10/11, Thomas Knierim  wrote:
> 
>> From: Thomas Knierim 
>> Subject: Re: [libreoffice-users] can't print t[w]o pages on a single side of 
>> paper
>> To: users@global.libreoffice.org
>> Date: Saturday, 29 October, 2011, 7:39
>> already answered in the former mail
>> (2:00 o'clock today)
>> Am 29.10.2011 um 02:33 schrieb webmaster for Kracked Press
>> Productions:
>> 
>>> If you go to
>>> Print > Properties > Device
>>> you will see the printer language option
>>> I did not remember this either.
>>> 
>>> But I do wonder if PDF means something different
>> here.
>>> 
>>> 
>>> On 10/28/2011 07:39 PM, Brian Barker wrote:
 At 14:38 28/10/2011 +0200, Thomas Knierim wrote:
> The problem does only appear if the printer
>> language is set to PDF (the default) in LibreOffice.
 
 PDF (Portable Document Format) is not a printer
>> language but a document file format.  Is it possible
>> that you mean PCL, HP's Printer Command Language?
 
 Brian Barker
 
 
>>> 
> 
> -- 
> For 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
> 


-- 
For 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] Calc: Converting Formula to Value

2011-10-29 Thread Rich Shepard


On Fri, 28 Oct 2011, The Wolfkin wrote:


So if I'm understanding you're trying to say start out with cells..
input a formula like this
http://minus.com/lgIwyrkPUPHj7
which gives a solution like this
http://minus.com/l50sfqIxwhBlz

and then now change the contents of cell D5 from {=B5+C5} to {80}
so that you can delete the contents of B5 an C5 yet keep the 80


  I tried this but found that the cells (in your case with '80') were filled
with error messages when the source cells were removed. Changing the display
of the cell contents is easy.

Thanks,

Rich

--
For 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] can't print to pages on a single side of paper

2011-10-29 Thread Thomas Knierim

OK, that's some kind of confusing: Using Ubuntu everything works out of the 
box! Where is the difference to other distributions?

The Versions are nearly the same:

Cups:
- OpenSuse: 1.5
- Archlinux: 1.5
- ubuntu: 1.5
Ghostscript
- Opensuse: 9.00
- Archlinux: 9.04
- ubuntu: 9.04
hplip
- Opensuse: 3.11.10
- Archlinux: 3.11.10
- ubuntu: 3.11.7
libreoffice:
- Opensuse: 3.4.2 OOO340m1 (Build: 1206)
- Archlinux: 3.4.3 (build unknown since Archlinux is not installed this moment)
- ubuntu: 3.4.3 OOO340m1 (build 302)

So I go back and install archlinux again to see what happens if I install hplip 
3.11.7.


Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press Productions:

> 
> Sorry, I just say the Device option tap showing PDF as the default.  I do not 
> know what "PDF" means in this context, since my printers may have that as a 
> printer language type, as far as I remember.  My HP Inkjet is not a 
> postscript printer, but my Color Laser might be able to deal with that.  I 
> did not see Postscript as an option for the Epson inkjet.  I sure did not 
> read it having a PDF language option.  So something is not right.  Could PDF 
> here mean "Printer Defined Format" for the language used?
> 
> Can the Postscript type "level from driver" be kept as the "default" option 
> somehow?  Maybe the "Printer Administration" shown was a module of LO 3.4 [at 
> least with Ubuntu]?  I believe that module of LO was designed to set up the 
> printers to run properly with LO.
> 
> --
> 
> CUPS-PDF - no package for OpenSUSE?   I wondered what OpenSUSE uses as a 
> replacement package, so I looked it up on the site.
> 
> On the opensuse.org site, 12.1 is in RC till November 16th.  I searched the 
> packages and there are 3 rpm package files [depending on the computer] for 
> cups-pdf-2.5.1-1.1
> 
> If I read the site correctly, 12.1 is the "opensuse/factory" development 
> version since it still is in development till November 16th.  So the search 
> for the cups pdf package in that and the other version come up with a .rpm 
> file to download and install it.  So it should be in the OpenSUSE version of 
> a repository.
> 
> http://software.opensuse.org/search?q=cups+pdf&baseproject=openSUSE%3AFactory&lang=en&exclude_debug=true
> 
> I wonder why it was not part of the ISO that you downloaded to install 
> OpenSUSE?
> 
> Actually I had trouble with OpenSUSE, the one time I tried using it.  I have 
> an IBM server that originally had SUSE installed on it, so the icon tag 
> showed.  But I bought it with the OS, and everything else, wiped off the 3 
> SCSI drives that 2002 era P-4 IBM server had.  So I downloaded OpenSUSE [3 or 
> 4 years ago] and tried to install it, but it would not install.  So I ended 
> using an old copy of Win2000/pro till I ended up putting Ubuntu on it 2 years 
> ago.  So I never had any luck with OpenSUSE.  If they do not include, in 
> their ISOs, something as simple as the PDF package that is part of the CUPS 
> printer environment, I do not know what to think.  My Epson printer uses a 
> driver that uses CUPS as its backend so I can print using Linux computers.
> 
> Do not get me wrong, OpenSUSE might be a great Linux OS, since businesses are 
> what it tends to be what it is marketed towards, but I just had one bad 
> experience and did not look back.  I use Ubuntu, and other people tell me to 
> try "such-n-such" Linux distro since they think it is the best you can get.  
> We have one person on this board that is involved in developing the  
> Mandriva, which was Mandrake.  I was taught Linux using Mandrake 7.x, back 10 
> to 11 years ago [if I remember correctly, and I still have a CD of it].  That 
> one is in the top 10 of the list of distros I came across on a distro watch 
> site.  OpenSUSE is on that list as well.  Arch Linux is considered an 
> advanced user distro while OpenSUSE is a "middle-of-the-road" one. Their 
> terms, not mine.  But we each have our favorite ones.  I have mine and you 
> have yours.  That it what it should be.
> 
> 
> 
> 
> On 10/28/2011 12:04 PM, Thomas Knierim wrote:
>> Hi
>> Am 28.10.2011 um 15:36 schrieb webmaster for Kracked Press Productions:
>> 
>>> I do not know about why PDF is set as the default for that printer.  I 
>>> never saw an HP printer use PDF as a default language for the printer.
>>> 
>> The Printer Language is set by LibreOffice. If you open the print dialog, 
>> klick on the printer and then on properties you get a new window. Select the 
>> tab device and here you have the printer language PDF (don't know if the 
>> Words of the tab etc. are correct since I use a german version). Again: 
>> setting this to PostScript (Level of the Driver) resolves the problem - but 
>> that are too much clicks for a print job.
>> 
>>> Did you download and install the HP drivers for Linux?  Here is the link to 
>>> the site.
>>> http://hpli

Re: [libreoffice-users] Re: Calc: Converting Formula to Value

Hi :)
So you want a static value instead of a formula?  If any of the values that the 
formula is based on were to change then the value in the cell would not change.
eg if 
A1= 10
B1= 20
and 
C1= A1+B1
then the spreadsheet would display C1= 200 but you would still be able to see 
the formula in the top entry widget.  A printout would not show the formula, it 
would just show the value.  If you changed the value of A1 to 30 then C1 would 
now show the result as being 600.  

If you were to set the formula bar (the entry widget) to show the value of C1 
as 200 then changing A1 to 30 would have no effect on C1, it would still show 
the value 200.

In effect the formula bar / entry widget shows what some people might think of 
as coding that lays under the surface of what is being displayed

You can copy&paste an entire column or row as fixed values to another column or 
row by using "paste special" and that might be a useful way of seeing if any of 
the calculated values change over time.  
Regards from
Tom :)

--- On Sat, 29/10/11, Rich Shepard  wrote:

> From: Rich Shepard 
> Subject: Re: [libreoffice-users] Re: Calc: Converting Formula to Value
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 0:48
> On Fri, 28 Oct 2011, Tom wrote:
> 
> > It depends what Rich means by "change".
> 
>   Show the value in each cell, not the display of the
> formula. That is, when
> the cursor is on a cell the entry widget along the top
> should display the
> value, not the formula.
> 
> > There are other possibilities too, such as perhaps the
> cell has been
> > defined as text, perhaps '= blah blah in which case
> removing the ' might
> > do the trick.
> 
>   No, when the formula was defined the cell contents
> were both numeric so
> the formula value is also numeric.
> 
> > I think that between us we have answered the most
> likely reasons that
> > would give Rich formulas rather than values.
> 
>   Actually, not. I need to know how to convert the
> formula to its value.
> 
> Thanks,
> 
> Rich
> 
> 
> 
> -- For 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
> 
> 

-- 
For 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] can't print to pages on a single side of paper

2011-10-29 Thread webmaster for Kracked Press Productions

Hi :)
In your existing Arch could you just install a virtual machine and try out a 
few things in there?  Alternatively create a new partition on a hard-drive and 
use that for experimentation.

You surely don't need to trash what you do have that is almost perfect in order 
to just try something a little different!
Regards from
Tom :)


--- On Sat, 29/10/11, Thomas Knierim  wrote:

> From: Thomas Knierim 
> Subject: Re: [libreoffice-users] can't print to pages on a single side of 
> paper
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 15:24
> OK, that's some kind of confusing:
> Using Ubuntu everything works out of the box! Where is the
> difference to other distributions?
> 
> The Versions are nearly the same:
> 
> Cups:
> - OpenSuse: 1.5
> - Archlinux: 1.5
> - ubuntu: 1.5
> Ghostscript
> - Opensuse: 9.00
> - Archlinux: 9.04
> - ubuntu: 9.04
> hplip
> - Opensuse: 3.11.10
> - Archlinux: 3.11.10
> - ubuntu: 3.11.7
> libreoffice:
> - Opensuse: 3.4.2 OOO340m1 (Build: 1206)
> - Archlinux: 3.4.3 (build unknown since Archlinux is not
> installed this moment)
> - ubuntu: 3.4.3 OOO340m1 (build 302)
> 
> So I go back and install archlinux again to see what
> happens if I install hplip 3.11.7.
> 
> 
> Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press
> Productions:
> 
> > 
> > Sorry, I just say the Device option tap showing PDF as
> the default.  I do not know what "PDF" means in this
> context, since my printers may have that as a printer
> language type, as far as I remember.  My HP Inkjet is
> not a postscript printer, but my Color Laser might be able
> to deal with that.  I did not see Postscript as an
> option for the Epson inkjet.  I sure did not read it
> having a PDF language option.  So something is not
> right.  Could PDF here mean "Printer Defined Format"
> for the language used?
> > 
> > Can the Postscript type "level from driver" be kept as
> the "default" option somehow?  Maybe the "Printer
> Administration" shown was a module of LO 3.4 [at least with
> Ubuntu]?  I believe that module of LO was designed to
> set up the printers to run properly with LO.
> > 
> > --
> > 
> > CUPS-PDF - no package for OpenSUSE?   I
> wondered what OpenSUSE uses as a replacement package, so I
> looked it up on the site.
> > 
> > On the opensuse.org site, 12.1 is in RC till November
> 16th.  I searched the packages and there are 3 rpm
> package files [depending on the computer] for
> cups-pdf-2.5.1-1.1
> > 
> > If I read the site correctly, 12.1 is the
> "opensuse/factory" development version since it still is in
> development till November 16th.  So the search for the
> cups pdf package in that and the other version come up with
> a .rpm file to download and install it.  So it should
> be in the OpenSUSE version of a repository.
> > 
> > http://software.opensuse.org/search?q=cups+pdf&baseproject=openSUSE%3AFactory〈=en&exclude_debug=true
> > 
> > I wonder why it was not part of the ISO that you
> downloaded to install OpenSUSE?
> > 
> > Actually I had trouble with OpenSUSE, the one time I
> tried using it.  I have an IBM server that originally
> had SUSE installed on it, so the icon tag showed.  But
> I bought it with the OS, and everything else, wiped off the
> 3 SCSI drives that 2002 era P-4 IBM server had.  So I
> downloaded OpenSUSE [3 or 4 years ago] and tried to install
> it, but it would not install.  So I ended using an old
> copy of Win2000/pro till I ended up putting Ubuntu on it 2
> years ago.  So I never had any luck with
> OpenSUSE.  If they do not include, in their ISOs,
> something as simple as the PDF package that is part of the
> CUPS printer environment, I do not know what to think. 
> My Epson printer uses a driver that uses CUPS as its backend
> so I can print using Linux computers.
> > 
> > Do not get me wrong, OpenSUSE might be a great Linux
> OS, since businesses are what it tends to be what it is
> marketed towards, but I just had one bad experience and did
> not look back.  I use Ubuntu, and other people tell me
> to try "such-n-such" Linux distro since they think it is the
> best you can get.  We have one person on this board
> that is involved in developing the  Mandriva, which was
> Mandrake.  I was taught Linux using Mandrake 7.x, back
> 10 to 11 years ago [if I remember correctly, and I still
> have a CD of it].  That one is in the top 10 of the
> list of distros I came across on a distro watch site. 
> OpenSUSE is on that list as well.  Arch Linux is
> considered an advanced user distro while OpenSUSE is a
> "middle-of-the-road" one. Their terms, not mine.  But
> we each have our favorite ones.  I have mine and you
> have yours.  That it what it should be.
> > 
> > 
> > 
> > 
> > On 10/28/2011 12:04 PM, Thomas Knierim wrote:
> >> Hi
> >> Am 28.10.2011 um 15:36 schrieb webmaster for
> Kracked Press Productions:
> >> 
> >>> I do not know about why PD

Re: [libreoffice-users] can't print to pages on a single side of paper



The two pages per sheet issue.  You want to have them printed side by 
side? Or one page on one side and the second page on the other side of 
the sheet?  Side by side printed out on a landscape orientation works 
well, but it is a printer option.  Having the pages printed one on each 
side of the sheet is a duplexing issue.  I have been having the same 
problem with duplexing as well as others.


side by side printing
Print > Page Layout > Pages per sheet.
2 will print two page side by side.
IT works fine for me.  I prefer to have the option of bordering the 
pages, since it looks better to me.


For duplex printing, I have to print it out as a PDF document and print 
it with the document viewer with the duplex option, instead of printing 
it directly through LO.  LO just does not "see" or adjust the duplex 
option on my Epson Artisan printer properly.



On 10/29/2011 10:47 AM, Tom Davies wrote:

Hi :)
In your existing Arch could you just install a virtual machine and try out a 
few things in there?  Alternatively create a new partition on a hard-drive and 
use that for experimentation.

You surely don't need to trash what you do have that is almost perfect in order 
to just try something a little different!
Regards from
Tom :)


--- On Sat, 29/10/11, Thomas Knierim  wrote:


From: Thomas Knierim
Subject: Re: [libreoffice-users] can't print to pages on a single side of paper
To: users@global.libreoffice.org
Date: Saturday, 29 October, 2011, 15:24
OK, that's some kind of confusing:
Using Ubuntu everything works out of the box! Where is the
difference to other distributions?

The Versions are nearly the same:

Cups:
- OpenSuse: 1.5
- Archlinux: 1.5
- ubuntu: 1.5
Ghostscript
- Opensuse: 9.00
- Archlinux: 9.04
- ubuntu: 9.04
hplip
- Opensuse: 3.11.10
- Archlinux: 3.11.10
- ubuntu: 3.11.7
libreoffice:
- Opensuse: 3.4.2 OOO340m1 (Build: 1206)
- Archlinux: 3.4.3 (build unknown since Archlinux is not
installed this moment)
- ubuntu: 3.4.3 OOO340m1 (build 302)

So I go back and install archlinux again to see what
happens if I install hplip 3.11.7.


Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press
Productions:


Sorry, I just say the Device option tap showing PDF as

the default.  I do not know what "PDF" means in this
context, since my printers may have that as a printer
language type, as far as I remember.  My HP Inkjet is
not a postscript printer, but my Color Laser might be able
to deal with that.  I did not see Postscript as an
option for the Epson inkjet.  I sure did not read it
having a PDF language option.  So something is not
right.  Could PDF here mean "Printer Defined Format"
for the language used?

Can the Postscript type "level from driver" be kept as

the "default" option somehow?  Maybe the "Printer
Administration" shown was a module of LO 3.4 [at least with
Ubuntu]?  I believe that module of LO was designed to
set up the printers to run properly with LO.

--

CUPS-PDF - no package for OpenSUSE?   I

wondered what OpenSUSE uses as a replacement package, so I
looked it up on the site.

On the opensuse.org site, 12.1 is in RC till November

16th.  I searched the packages and there are 3 rpm
package files [depending on the computer] for
cups-pdf-2.5.1-1.1

If I read the site correctly, 12.1 is the

"opensuse/factory" development version since it still is in
development till November 16th.  So the search for the
cups pdf package in that and the other version come up with
a .rpm file to download and install it.  So it should
be in the OpenSUSE version of a repository.

http://software.opensuse.org/search?q=cups+pdf&baseproject=openSUSE%3AFactory〈=en&exclude_debug=true

I wonder why it was not part of the ISO that you

downloaded to install OpenSUSE?

Actually I had trouble with OpenSUSE, the one time I

tried using it.  I have an IBM server that originally
had SUSE installed on it, so the icon tag showed.  But
I bought it with the OS, and everything else, wiped off the
3 SCSI drives that 2002 era P-4 IBM server had.  So I
downloaded OpenSUSE [3 or 4 years ago] and tried to install
it, but it would not install.  So I ended using an old
copy of Win2000/pro till I ended up putting Ubuntu on it 2
years ago.  So I never had any luck with
OpenSUSE.  If they do not include, in their ISOs,
something as simple as the PDF package that is part of the
CUPS printer environment, I do not know what to think. 
My Epson printer uses a driver that uses CUPS as its backend

so I can print using Linux computers.

Do not get me wrong, OpenSUSE might be a great Linux

OS, since businesses are what it tends to be what it is
marketed towards, but I just had one bad experience and did
not look back.  I use Ubuntu, and other people tell me
to try "such-n-such" Linux distro since they think it is the
best you can get.  We have one person on this board
that is involved in developing the  Mandriva, which was

Re: [libreoffice-users] can't print to pages on a single side of paper

2011-10-29 Thread Winston C. Yang


On 10/29/2011 02:38 AM, Thomas Knierim wrote:

Offtopic - anyway: I'm often trying different distros (just for fun and) to see 
how they develop. Every distro has it's own pros and cons. (I haven't found a 
perfect distro for me). I'm going to check ubuntu again (last time was a year 
ago). But ubuntu is somehow proprietary which I dislike. And since I set up 
some computers for friends I'm always looking for a distro with actual software 
and long and good support - which is opensuse (do you know another?)



Thomas,

Have you heard of the Linux distribution called Trisquel? I use it.

Below are some excerpts from web pages, with my comments in brackets:

1. http://trisquel.info/en/wiki
Trisquel is a fully free (as in *"free speech"*, not merely as in "free 
of charge") GNU /Linux 
 based operating 
system. It is derived from Ubuntu, but includes only free software 
.
Trisquel has several editions, designed for different uses: ["Home", 
Edu, Pro, and Mini]

Long Term Support versions have several editions, [...]

2. http://trisquel.info/en/faq
It [the Trisquel project] was officially presented 
 on April 2005 with the presence and 
support of Richard Stallman, founder of the Free Software Foundation 
.


3. http://www.fsf.org/associate/benefits
*Here are just some of the benefits of being an associate member of the 
Free Software Foundation...*
You will receive an ultra slim, credit-card-sized, 2GB card loaded with 
Trisquel Live , a fully free 
GNU/Linux distribution.


Winston

--
For 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: Calc: Converting Formula to Value

2011-10-29 Thread Brian Barker


At 15:43 29/10/2011 +0100, Tom Davies wrote:

A1= 10
B1= 20
and
C1= A1+B1
then the spreadsheet would display C1= 200 ...


Is this perhaps what's known as the "new math"?

Brian Barker


--
For 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] frame positioning

Readers,

An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).

When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a column, not to a page or paragraph?

Thanks.

-- 
For 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] LO Conflicts with OOo

It makes perfect sense that OOo and LO could be installed side by side and also 
run at the same time.  

The problem is that they all lay claim to the same program names, library 
names, and probably registry settings.  

(The use of the same program names is why Windows, for example, can't have Open 
With ... for both
LO, and OOo on the association of programs with file extensions, such as .odt 
and .ods.  (But one can
add Open With ... Microsoft Word, WinZip, etc.  Different versions of the same 
product are harder for Windows to distinguish with Open With ..., absent some 
creative work on the part of the producers of those product versions.)

Now that there are different lineages progressing from a common OO.o 3.2-or-so 
base, there needs to be a way to avoid collisions with parallel efforts and the 
common past versions.

For users, all of their choices should work.  Running a portable version should 
work.  Having user accounts with different versions should work, etc.  I 
suspect that these cases have simply not been dealt with systematically, 
although clearly there has been some attention to it. And if it is by design to 
not all concurrent operation, I would expect gentle handling when an user 
violates that constraint.

(I have no recommendation on what installs are on top of what previous versions 
of the same product. It may be a little too course-grained that any LO 3.y will 
replace any LO 3.x where x < y, although that is a second-order problem.  It is 
good that LO 3.y does not replace OOo 3.x, and vice versa.)

 - Dennis

-Original Message-
From: Stephan Zietsman [mailto:szi...@gmail.com] 
Sent: Thursday, October 27, 2011 05:44
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] LO Conflicts with OOo

Harold Fuchs wrote:
[ ... ]

I may be mistaken but as far as I know, LO and OOo are not expected to
run at the same time (so I don't think it is a bug).  But if they are
both installed on the same computer, they should both work (though not
at the same time).  Same would apply to the portable version(s).

> Why should I not be able to run LO and OOo at the same time on the same 
> machine?

Anyone care to comment?

Regards
Stephan

-- 
For 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] DOCX file from Android Office Suite will not open

Hi Pete,

When LO/OOo pops up a text filter it is usually because the format of the 
incoming file is not recognizable, no matter how it happens to be named 
(.docx, etc.).

This happens if an incoming .docx file is encrypted, for example.

If you send the file to me, I can look at its innards to see why it isn't 
being recognized properly.

 - Dennis E. Hamilton
   tools for document interoperability,  
   dennis.hamil...@acm.org  gsm: +1-206-779-9430  @orcmid

-Original Message-
From: Pete Holsberg [mailto:pj...@pobox.com]
Sent: Friday, October 28, 2011 09:53
To: users@global.libreoffice.org
Subject: [libreoffice-users] DOCX file from Android Office Suite will not open

Hi,

I created a file with the Android app "Office Suite Pro" and I cannot
open it with Libre Writer.

It pops up a "filter" menu with types of files in randow order (can I
file a bug report or a fix request on that?) and none of them are
"Windows Office 2010 docx file".

FWIW, the first 10 bytes of the file are the same as other docx files
that LO is able to open.

Any ideas (other than asking on an Office Suite mailing list)?

Thanks.



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

-- 
For 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] Cannot open DOCX file

Tom Davies has written on 10/28/2011 8:30 PM:
> Hi :)
> Ahh, i am not sure.  Tbh i was hoping that there might be something 
> immediately obvious and easy to fix or that it would stuggle to open and 
> fixing that would fix the problem.  

I don't know enough about the internals.

> LibreOffice 3.4.x branch tends to be better at opening docX than the 3.3.x 
> branch but really the MS Office implementation of docX is sufficiently 
> off-standards that other programs often have trouble with it.  

I have 3.4.* I think the problem is with the MobiSystems implementation,
not MS.

> Looking at 
> http://www.mobisystems.com/android_office/
> it seems that Android's Office can't handle Odt yet but that seems very 
> unlikely.  I think try saving as an Odt in Word and then try opening on the 
> Android.  

MobisSystems OfficeSuite cannot open ODT.

Thanks.

-- 
For 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] Cannot open DOCX file

e-letter has written on 10/29/2011 5:21 AM:
> On 28/10/2011, ESChamp  wrote:
> > I created a docx file with Android Office Suite Pro, and while MS Office
> > 2010 can open it, LO cannot.
> >
> > Ideas?
> >
>
> The best idea is to create an odt document and tell us if there any errors.

"No applications can perform this action" appears when I try to open an
ODT file with OfficeSuite.

-- 
For 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] Cannot open DOCX file

Thanks, Tom, but that's not the point. I created a DOCX file on my phone
and could not open it with LO 3.4.3. I can open it with MS Word 2010.

Not looking for a work-around but I will take the advice of using DOC
instead.

Tom Davies has written on 10/29/2011 7:08 AM:
> Hi :)
> I still think that Doc as opposed to DocX is the only format that all 3 
> programs can read/write the same.  Just open the existing DocX in either 
> Android or MS and then 
>
> File (or golden orb) - "Save As ... "
>
> and choose something like "older Word 97/2000/Xp"
>
> I would experiment with Odt as it is a superior format, even the older 1.1, 
> but using it might require changing the defaults for LibreOffice
>
> Tools - Options - "+ Load/Save" - General
>
> In the middle of that page you can change the ODF format to the older one and 
> at the bottom you can change the defaults from ODF (Odt, Ods, Odp etc) to MS 
> Office ones (Doc, Xls, Ppt).
> Regards from
> Tom :)
>
> --- On Sat, 29/10/11, e-letter  wrote:
>
> > From: e-letter 
> > Subject: Re: [libreoffice-users] Cannot open DOCX file
> > To: users@global.libreoffice.org
> > Date: Saturday, 29 October, 2011, 10:21
> > On 28/10/2011, ESChamp 
> > wrote:
> > > I created a docx file with Android Office Suite Pro,
> > and while MS Office
> > > 2010 can open it, LO cannot.
> > >
> > > Ideas?
> > >
> > 
> > The best idea is to create an odt document and tell us if
> > there any errors.
> > 
> > If you want to create m$ formats, contact office suite pro
> > and/or m$.
> > 
> > -- 
> > For 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
> > 
>



-- 
For 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] DOCX file from Android Office Suite will not open

e-letter has written on 10/29/2011 5:08 AM:
> On 28/10/2011, Pete Holsberg  wrote:
> > Hi,
> >
> > I created a file with the Android app "Office Suite Pro" and I cannot
> > open it with Libre Writer.
> >
>
> Does this program 'office suite pro' produce odt files?

NO.

> If the answer is yes, this is the correct mailing list to report
> errors with the _native_ odf formats.

Is DOCX a "native ODF format"?

> If the answer is no, go to the program supplier's web site, or m$

Did that. Waiting for a response.


-- 
For 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] Find in 3.4.3

2011-10-29 Thread jorge

Hi

I used LO 3.4.2 (Ubuntu 10.04 LTS) and it runs good.

Regards,

Jorge Rodríguez
___


El sáb, 29-10-2011 a las 22:55 +1300, Steve Edmonds escribió:
> Hi.
> I am trying to find (search for) some text in some sheets.
> The text appears in many formulae and also as text in cells.
> I wish to exclude the formulae from the search.
> In Find & Replace > More options > Search in I am able to select 
> "Values" but the search still finds the text in formulae.
> Am I searching wrong?
> steve
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
For 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] Calc: Converting Formula to Value

Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back. 
That will leave the values and strip the formulas from the cells [;<).  It 
might work to save as .xslx and then reopen it in LO too, but I haven't tried 
that case.

-Original Message-
From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org]
Sent: Friday, October 28, 2011 16:26
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Calc: Converting Formula to Value

Hi,

Am 29.10.2011 01:14, schrieb Rich Shepard:
>   I have a column where the cells display the sum of two other
> columns. I
> want to change the contents from formula to value but cannot find the
> relevant information in the help pages. Please point me to
> instructions on
> how to do this.

The trick is to copy and then paste special (Edit menu). In the
dialog check only numbers.

Stefan




-- 
LibreOffice - Die Freiheit nehm' ich mir!

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

-- 
For 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: Videos (mpeg etc) in Impress

2011-10-29 Thread mikko


As said in my original post, none of the controls work (under any operating
system [Linux, OSX, Win7] & I also tried different versions of LibreOffice
with no luck). In other words, the options 'start media', 'end media' etc.
and adjusting timing have no effect. They work ok for simple jpegs and other
pics, but have no effect on movies.


> Insert video into presentation slide
>
> Use the menu bar options 'slide show|custom animation|misc. effects'
>
> Add the options 'start media', 'end media' etc. and adjust timing,
> order as appropriate.



--
View this message in context: 
http://nabble.documentfoundation.org/Videos-mpeg-etc-in-Impress-tp3449375p3463372.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For 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: creating a dropdown field form

2011-10-29 Thread The Wolfkin

On Sat, Oct 29, 2011 at 8:37 AM, Alex Thurgood wrote:

> As for your dropdown list :
> Enter Form Edit mode.
> Select your control (possibly having to "Enter Group" first)
> Right-mouse button click on the control and choose "Replace with"
> Choose Combobox
> Now right-mouse button click on your combobox control.
>

At this point I'm following along perfectly fine.

> Choose "Control" from the context menu.
> In the "List Content Type" choose SQL from the dropdown choices.
> In the List Content field, enter :
> SELECT "myfield" FROM "mytable", replacing "myfield" with the field you
> want the data to be selected from and "mytable" with the table name from
> which the data is taken.
>

Here is where I think we're getting mixed up. The contents of the combobox.
I want the contents of the ComboBox to be "Singstar 80s", "Singstar 90s",
"Singstar Amped" that's it. I don't want to fill it is the contents of
another table or field. I just want to enter in a choices literally. This is
the problem I'm having. Very simple situation.

Is my only option to create a new table with the list of discs and then
populate the dropdown using that? There has to be a way to just type in the
items I want in the dropdown.

> Close the Control Properties window.
> Save the changes to your form.
> Close your form.
> Double-click on your form to open it in data edit/entry mode. You should be
> able to now select pre-entered data from the dropdown list and additionally
> add new data into the same field. Just remember to save your changes before
> you close the form again (or just switch to another record), and the
> database before you close the ODB file.
>
> Alex

-- 
For 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] Calc: Converting Formula to Value

2011-10-29 Thread The Wolfkin

That was actually more of a restatement of your problem then an attempt at a
solution. But the previous supplied answer of "Paste Special" with only
"Numbers" checked did work. If you do that you can delete B5 and C5 and keep
the 80.

if you're still having trouble perhaps a screenshot would help assuming this
isn't confidential work?

-- 
I love gmail. Do you?
The Wolfkin


On Sat, Oct 29, 2011 at 9:20 AM, Rich Shepard wrote:

> On Fri, 28 Oct 2011, The Wolfkin wrote:
>
>  So if I'm understanding you're trying to say start out with cells..
>> input a formula like this
>> http://minus.com/lgIwyrkPUPHj7
>> which gives a solution like this
>> http://minus.com/l50sfqIxwhBlz
>>
>> and then now change the contents of cell D5 from {=B5+C5} to {80}
>> so that you can delete the contents of B5 an C5 yet keep the 80
>>
>
>  I tried this but found that the cells (in your case with '80') were filled
> with error messages when the source cells were removed. Changing the
> display
> of the cell contents is easy.
>
> Thanks,
>
>
> Rich
>

-- 
For 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] Cannot open DOCX file

Hi :)
Ahh, cool.  In that case perhaps filing a bug-report would be good even tho i 
haven't been any help in getting it down to a specific issue.
http://wiki.documentfoundation.org/BugReport
Regards from
Tom :)


--- On Sat, 29/10/11, ESChamp  wrote:

> From: ESChamp 
> Subject: Re: [libreoffice-users] Cannot open DOCX file
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 19:19
> Thanks, Tom, but that's not the
> point. I created a DOCX file on my phone
> and could not open it with LO 3.4.3. I can open it with MS
> Word 2010.
> 
> Not looking for a work-around but I will take the advice of
> using DOC
> instead.
> 

-- 
For 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: False Positive Virus detection my MSE for 3.4.3 installer.

2011-10-29 Thread NoOp

On 10/24/2011 08:00 PM, windyweather wrote:
> http://www.windyweather.net/wp/2011/10/24/false-positive-in-libreoffice-3-4-3-from-mse/
> 
> Details of false positive [I assume] virus detection by up to date Microsoft
> Security Essentials.
> Win 86 install of 3.4.3 on Windows 7.
> Not sure if  you will notify Microsoft so they can fix definitions or change
> LibreOffice to avoid false positive.
...


[MSE says Office 2007 sp3 is infected]
:-)



-- 
For 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] Frame positioning

2011-10-29 Thread Brian Barker


At 18:17 29/10/2011 +0100, Nobody Noname wrote:
An a4 page is formatted to landscape with two columns (in effect 
creating a5 columns). When creating a frame, how to specify using 
the dialogue window that the frame should appear in the centre (with 
respect to vertical and horizontal) of a column, not to a page or paragraph?


o Go to Format | Frame/Object... | Type | Position (or right-click | 
Frame... | Type | Position).

o For Horizontal, select "Center to Paragraph area".
o For Vertical, select "Center to Page text area".

I trust this helps.

Brian Barker


--
For 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] frame positioning

2011-10-29 Thread Calvin Kim



On 10/29/2011 1:17 PM, e-letter wrote:

Readers,

An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).

When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a column, not to a page or paragraph?

Thanks.



Anchor your frame to paragraph, or to character.
Horizontal position to center, and to paragraph area
Vertical position to center, and to entire page


--
For 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] Find in 3.4.3

2011-10-29 Thread Steve Edmonds


Hi. Does this mean that if you fill a bit of a column with
=IF(E615="PMT TO Lex",G615,0)

Then you can Find (search) for "Lex" so that you do not find it in the 
formulae.

steve

On 30/10/11 7:37 AM, jorge wrote:

Hi

I used LO 3.4.2 (Ubuntu 10.04 LTS) and it runs good.

Regards,

Jorge Rodríguez
___


El sáb, 29-10-2011 a las 22:55 +1300, Steve Edmonds escribió:

Hi.
I am trying to find (search for) some text in some sheets.
The text appears in many formulae and also as text in cells.
I wish to exclude the formulae from the search.
In Find&  Replace>  More options>  Search in I am able to select
"Values" but the search still finds the text in formulae.
Am I searching wrong?
steve



--
For 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: Printing in reverse order so page one ends up on top

2011-10-29 Thread NoOp

On 10/26/2011 08:32 AM, webmaster for Kracked Press Productions wrote:
...
> Actually, it may be that your printer might not work with all its 
> options withing LO.  My Epson has a duplex feature, but LO seems not to 
> be able to set that feature's control to turn it on.
...

Printer Properties: Duplex On

I've found it easier to set up different printer profiles for the same
printer. Example:

WorkForce635BW - Black & White mode (default printer to save color ink)
WorkForce635BWDuplex - as above but with duplex turned on
WorkForce635Color - standard color mode
WorkForce635Photo - color mode w/photo options set




-- 
For 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] frame positioning

2011-10-29 Thread Cor Nouws


Hi,

e-letter wrote (29-10-11 19:17)


An a4 page is formatted to landscape with two columns (in effect
creating a5 columns).

When creating a frame, how to specify using the dialogue window that
the frame should appear in the centre (with respect to vertical and
horizontal) of a column, not to a page or paragraph?


If I understand your question correct, I would say tab Type, position 
Horizontal: Middle to Paragraph area and Vertical: Centred to text area.


Is that your wish?

Cheers,

--
 - Cor
 - http://nl.libreoffice.org


--
For 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] Cannot open DOCX file

Hi :)
Hmm, interesting.  On a desktop OS you can usually right-click on a file, go 
down to properties and use that to change which program opens that type of 
file.  Hopefully Android OfficeSuite would be in the list.  I don't know if 
Android allows you to configure things in a similar way.  
Regards from
Tom :)


--- On Sat, 29/10/11, ESChamp  wrote:

> From: ESChamp 
> Subject: Re: [libreoffice-users] Cannot open DOCX file
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 19:17
> e-letter has written on 10/29/2011
> 5:21 AM:
> > On 28/10/2011, ESChamp 
> wrote:
> > > I created a docx file with Android Office Suite
> Pro, and while MS Office
> > > 2010 can open it, LO cannot.
> > >
> > > Ideas?
> > >
> >
> > The best idea is to create an odt document and tell us
> if there any errors.
> 
> "No applications can perform this action" appears when I
> try to open an
> ODT file with OfficeSuite.
> 
> -- 
> For 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
> 
> 

-- 
For 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] frame positioning

2011-10-29 Thread Cor Nouws



Cor Nouws wrote (29-10-11 22:01)

If I understand your question correct, I would say tab Type, position
[..]


(hmm, that's the disadvantage of working though 178 mails - by the time 
I reply on some of the lasts, others have already done too ;-) )



--
 - Cor
 - http://nl.libreoffice.org


--
For 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] DOCX file from Android Office Suite will not open

First, rough-screening test results:

The newtext.docx file that was produced with the Mobi Office Suite works as 
follows:
  LO 3.3.2 fails to open it, reporting a general input-output error.
  Word 2010 opens it just fine.

I modified the document in Word 2010 by adding a sentence to it and saving that 
as a new file.
  LO 3.3.2 opens the modified document just fine.

Inspection of Zip structure of the two documents reveals that the version saved 
by Word 2010 has two more files, a docProps/app.xml file and a 
word/StylesWithEffects.xml file.

There is no obvious difference at this high level to indicate how the document 
failed to be recognized as an OOXML WordDocumentML document by LO.  

It is also possible that the difference is in the Zip encoding in some way in 
which Word 2010 is forgiving and LO is not.  The failure to recognize what the 
document is appears to happen at a very immediate level in LO access to the 
file.

More detailed examination is required.


 - Dennis E. Hamilton
   tools for document interoperability,  
   dennis.hamil...@acm.org  gsm: +1-206-779-9430  @orcmid




-Original Message-
From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] 
Sent: Saturday, October 29, 2011 10:18
To: users@global.libreoffice.org
Subject: RE: [libreoffice-users] DOCX file from Android Office Suite will not 
open

Hi Pete,

When LO/OOo pops up a text filter it is usually because the format of the 
incoming file is not recognizable, no matter how it happens to be named 
(.docx, etc.).

This happens if an incoming .docx file is encrypted, for example.

If you send the file to me, I can look at its innards to see why it isn't 
being recognized properly.

 - Dennis E. Hamilton
   tools for document interoperability,  
   dennis.hamil...@acm.org  gsm: +1-206-779-9430  @orcmid

-Original Message-
From: Pete Holsberg [mailto:pj...@pobox.com]
Sent: Friday, October 28, 2011 09:53
To: users@global.libreoffice.org
Subject: [libreoffice-users] DOCX file from Android Office Suite will not open

Hi,

I created a file with the Android app "Office Suite Pro" and I cannot
open it with Libre Writer.

It pops up a "filter" menu with types of files in randow order (can I
file a bug report or a fix request on that?) and none of them are
"Windows Office 2010 docx file".

FWIW, the first 10 bytes of the file are the same as other docx files
that LO is able to open.

Any ideas (other than asking on an Office Suite mailing list)?

Thanks.



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

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


-- 
For 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] Cannot open DOCX file

I may have confused you.

I've opened OfficeSuite (technically it's MobiSystems OfficeSuite Pro on
an Android phone) and I see a list of files. I select the ODT one. I get
the error message below.

If I use a file manager, I select the ODT file and get "File type ODT
not found".

Tom Davies has written on 10/29/2011 4:08 PM:
> Hi :)
> Hmm, interesting.  On a desktop OS you can usually right-click on a file, go 
> down to properties and use that to change which program opens that type of 
> file.  Hopefully Android OfficeSuite would be in the list.  I don't know if 
> Android allows you to configure things in a similar way.  
> Regards from
> Tom :)
>
>
> --- On Sat, 29/10/11, ESChamp  wrote:
>
> > From: ESChamp 
> > Subject: Re: [libreoffice-users] Cannot open DOCX file
> > To: users@global.libreoffice.org
> > Date: Saturday, 29 October, 2011, 19:17
> > e-letter has written on 10/29/2011
> > 5:21 AM:
> > > On 28/10/2011, ESChamp 
> > wrote:
> > > > I created a docx file with Android Office Suite Pro, and while MS Office
> > > > 2010 can open it, LO cannot.
> > > >
> > > > Ideas?
> > > >
> > >
> > > The best idea is to create an odt document and tell us
> > if there any errors.
> > 
> > "No applications can perform this action" appears when I
> > try to open an ODT file with OfficeSuite.
>

-- 
For 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] Cannot open DOCX file

Hi :)
I am easily confused so don't worry.  Yes, it's pretty clear that MobiSystems 
OfficeSuite Pro doesn't support Odt yet.  At a guess they might add support 
later but it's not likely to be soon.
Regards from
Tom :)


--- On Sat, 29/10/11, ESChamp  wrote:

> From: ESChamp 
> Subject: Re: [libreoffice-users] Cannot open DOCX file
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 21:23
> I may have confused you.
> 
> I've opened OfficeSuite (technically it's MobiSystems
> OfficeSuite Pro on
> an Android phone) and I see a list of files. I select the
> ODT one. I get
> the error message below.
> 
> If I use a file manager, I select the ODT file and get
> "File type ODT
> not found".
> 
> Tom Davies has written on 10/29/2011 4:08 PM:
> > Hi :)
> > Hmm, interesting.  On a desktop OS you can
> usually right-click on a file, go down to properties and use
> that to change which program opens that type of file. 
> Hopefully Android OfficeSuite would be in the list.  I
> don't know if Android allows you to configure things in a
> similar way.  
> > Regards from
> > Tom :)
> >
> >
> > --- On Sat, 29/10/11, ESChamp 
> wrote:
> >
> > > From: ESChamp 
> > > Subject: Re: [libreoffice-users] Cannot open DOCX
> file
> > > To: users@global.libreoffice.org
> > > Date: Saturday, 29 October, 2011, 19:17
> > > e-letter has written on 10/29/2011
> > > 5:21 AM:
> > > > On 28/10/2011, ESChamp 
> > > wrote:
> > > > > I created a docx file with Android
> Office Suite Pro, and while MS Office
> > > > > 2010 can open it, LO cannot.
> > > > >
> > > > > Ideas?
> > > > >
> > > >
> > > > The best idea is to create an odt document
> and tell us
> > > if there any errors.
> > > 
> > > "No applications can perform this action" appears
> when I
> > > try to open an ODT file with OfficeSuite.
> >
> 
> -- 
> For 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
> 
> 

-- 
For 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] LO Conflicts with OOo

Hi :)
There is a guide to help avoid the usual conflicts
http://wiki.documentfoundation.org/Installing_in_parallel

I think the problems are mostly when both version are open at the same time, 
for example if one is permanently kinda open by having it's QuickLauncher on.  
Regards from
Tom :)


--- On Sat, 29/10/11, Dennis E. Hamilton  wrote:

> From: Dennis E. Hamilton 
> Subject: RE: [libreoffice-users] LO Conflicts with OOo
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 18:18
> It makes perfect sense that OOo and
> LO could be installed side by side and also run at the same
> time.  
> 
> The problem is that they all lay claim to the same program
> names, library names, and probably registry settings. 
> 
> 
> (The use of the same program names is why Windows, for
> example, can't have Open With ... for both
> LO, and OOo on the association of programs with file
> extensions, such as .odt and .ods.  (But one can
> add Open With ... Microsoft Word, WinZip, etc. 
> Different versions of the same product are harder for
> Windows to distinguish with Open With ..., absent some
> creative work on the part of the producers of those product
> versions.)
> 
> Now that there are different lineages progressing from a
> common OO.o 3.2-or-so base, there needs to be a way to avoid
> collisions with parallel efforts and the common past
> versions.
> 
> For users, all of their choices should work.  Running
> a portable version should work.  Having user accounts
> with different versions should work, etc.  I suspect
> that these cases have simply not been dealt with
> systematically, although clearly there has been some
> attention to it. And if it is by design to not all
> concurrent operation, I would expect gentle handling when an
> user violates that constraint.
> 
> (I have no recommendation on what installs are on top of
> what previous versions of the same product. It may be a
> little too course-grained that any LO 3.y will replace any
> LO 3.x where x < y, although that is a second-order
> problem.  It is good that LO 3.y does not replace OOo
> 3.x, and vice versa.)
> 
>  - Dennis
> 
> -Original Message-
> From: Stephan Zietsman [mailto:szi...@gmail.com]
> 
> Sent: Thursday, October 27, 2011 05:44
> To: users@global.libreoffice.org
> Subject: Re: [libreoffice-users] LO Conflicts with OOo
> 
> Harold Fuchs wrote:
> [ ... ]
> 
> I may be mistaken but as far as I know, LO and OOo are not
> expected to
> run at the same time (so I don't think it is a bug). 
> But if they are
> both installed on the same computer, they should both work
> (though not
> at the same time).  Same would apply to the portable
> version(s).
> 
> > Why should I not be able to run LO and OOo at the same
> time on the same machine?
> 
> Anyone care to comment?
> 
> Regards
> Stephan
> 
> 
> 
> -- 
> For 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
> 

-- 
For 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: Calc: Converting Formula to Value

Hi :)
Ooops.  Yep i made a few mistakes there.  Using x as multiplication confuses 
some people and * confuses others so i went back to make it a simple addition 
but really was not concentrating at all lol.  Hopefully it gets the point 
across tho.  
Many apols for the blunders and regards from
Tom :)



--- On Sat, 29/10/11, Brian Barker  wrote:

> From: Brian Barker 
> Subject: Re: [libreoffice-users] Re: Calc: Converting Formula to Value
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 16:38
> At 15:43 29/10/2011 +0100, Tom Davies
> wrote:
> >A1= 10
> >B1= 20
> >and
> >C1= A1+B1
> >then the spreadsheet would display C1= 200 ...
> 
> Is this perhaps what's known as the "new math"?
> 
> Brian Barker
> 
> 
> -- 
> For 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
> 
> 

-- 
For 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] LO Conflicts with OOo

2011-10-29 Thread Regina Henschel


Hi,

Tom Davies schrieb:

Hi :) There is a guide to help avoid the usual conflicts
http://wiki.documentfoundation.org/Installing_in_parallel

I think the problems are mostly when both version are open at the
same time, for example if one is permanently kinda open by having
it's QuickLauncher on. Regards from Tom :)


You can run the programs the same time, if each instance uses a 
different folder for the user settings. Also the other way round is 
possible, running one application with different users settings at the 
same time, again different folders for the user settings are needed.


Only the association between document type and program is unique.

Kind regards
Regina


--
For 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] Base: creating a dropdown field form

2011-10-29 Thread Mark Stanton

> Here is where I think we're getting mixed up. The contents of the combobox.
> I want the contents of the ComboBox to be "Singstar 80s", "Singstar 90s",
> "Singstar Amped" that's it. I don't want to fill it is the contents of
> another table or field. I just want to enter in a choices literally. This is
> the problem I'm having. Very simple situation.

If the contents of the combobox isn't a property of your list of 
tracks/discs/whatever, what use is it?  If it's something to do with your data, 
then it's got to be in your data.  If it's in your data, pull it out and 
populate the combobox with it.  If it isn't in your data, even if you type it 
in 
manually, how are you going to use it?

At a wild guess, you've got codes in your data representing these categories.  
If that's the case, create a lookup table and put your code/text 
correspondences 
in there.

Or have I guessed wrong?

Mark Stanton
One small step for mankind...



-- 
For 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] Cannot open DOCX file

Tom Davies has written on 10/29/2011 4:41 PM:
> Hi :)
> I am easily confused so don't worry.  Yes, it's pretty clear that MobiSystems 
> OfficeSuite Pro doesn't support Odt yet.  At a guess they might add support 
> later but it's not likely to be soon.
>

Do you know something I don't about Mobi? :-)

-- 
For 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] Problem LO Calc not copying formulae LMDE X64

2011-10-29 Thread Steve Fisher

Enter "X" in B1, then enter following formula in A1 then copy formula to A2
=if(b1="X","AAA","BBB"), it copies the value "AAA" and not the formula
=if(b2="X","AAA","BBB").

LibreOffice 3.4.3 OOO340m1 (Build:302).

Steve

-- 
For 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: creating a dropdown field form

2011-10-29 Thread webmaster for Kracked Press Productions


Le 29/10/2011 20:23, The Wolfkin a écrit :

Hi,


I want the contents of the ComboBox to be "Singstar 80s", "Singstar 90s",
"Singstar Amped" that's it. I don't want to fill it is the contents of
another table or field. I just want to enter in a choices literally. This is
the problem I'm having. Very simple situation.




Is my only option to create a new table with the list of discs and then
populate the dropdown using that? There has to be a way to just type in the
items I want in the dropdown.



OK, I hear you. Replace the Combobox by a list box.
In the properties of the control, on the first tab, you should see an 
entry callled List Entries.
Enter your list, typing each one and then pressing Shift+Return to move 
to the next line of your list. When you click outside of the property 
field, you will notice that the list has been created with each entry 
between double quotes, separated by a semi-colon.


Close the properties window and save your form. When you open it up in 
edit mode, you will see the list that you had entered as a dropdown 
list, choosing one of the entries will select it, and this will be 
written to the underlying table when you either save the record or move 
to next one.



Alex


--
For 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] Writer Thesaurus

2011-10-29 Thread pattyboy123

Writer Thesaurus 

Just up graded to 11.04 and seem the thesauruses is grayed out.  Any one
know who to activated/ turn on this feature?

--
View this message in context: 
http://nabble.documentfoundation.org/Writer-Thesaurus-tp3464533p3464533.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For 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: creating a dropdown field form

2011-10-29 Thread The Wolfkin

Perfect. That's exactly what I was looking for. Thanks Alex.

-- 
I love gmail. Do you?
The Wolfkin


On Sat, Oct 29, 2011 at 6:48 PM, Alex Thurgood wrote:

> Le 29/10/2011 20:23, The Wolfkin a écrit :
>
> Hi,
>
> OK, I hear you. Replace the Combobox by a list box.
> In the properties of the control, on the first tab, you should see an entry
> callled List Entries.
> Enter your list, typing each one and then pressing Shift+Return to move to
> the next line of your list. When you click outside of the property field,
> you will notice that the list has been created with each entry between
> double quotes, separated by a semi-colon.
>
> Close the properties window and save your form. When you open it up in edit
> mode, you will see the list that you had entered as a dropdown list,
> choosing one of the entries will select it, and this will be written to the
> underlying table when you either save the record or move to next one.
>
>
>
> Alex
>

-- 
For 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] Writer Thesaurus

2011-10-29 Thread Mirosław Zalewski

On 29/10/2011 at 23:39, pattyboy123  wrote:
 
> Just up graded to 11.04 and seem the thesauruses is grayed out.  Any one
> know who to activated/ turn on this feature?

Do you have mythes-* (e.g. mythes-en-us) package installed? You can install it 
using your package manager (I believe that in Ubuntu, which you are probably 
using, it is called software-center).
-- 
Best regards
Mirosław Zalewski

-- 
For 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] Problem LO Calc not copying formulae LMDE X64

2011-10-29 Thread jorge

Hi

I suggest you to do like this:

1) Copy A1
2) Paste Special (Un check Paste All -first line-, text- second line-
and Numbers-third line-)
3) Paste (Ok) in A2

Regards,


El sáb, 29-10-2011 a las 22:34 +0100, Steve Fisher escribió:
> Enter "X" in B1, then enter following formula in A1 then copy formula to A2
> =if(b1="X","AAA","BBB"), it copies the value "AAA" and not the formula
> =if(b2="X","AAA","BBB").
> 
> LibreOffice 3.4.3 OOO340m1 (Build:302).
> 
> Steve
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
For 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] Writer Thesaurus

2011-10-29 Thread Libre User

Tools>>Options>>General>>Click box at bottom of window that says 
"Enable experimental (unstable) features


Jerry

At 02:39 PM 10/29/2011, you wrote:

Writer Thesaurus

Just up graded to 11.04 and seem the thesauruses is grayed out.  Any one
know who to activated/ turn on this feature?

--
View this message in context: 
http://nabble.documentfoundation.org/Writer-Thesaurus-tp3464533p3464533.html

Sent from the Users mailing list archive at Nabble.com.

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


--
For 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: LO Conflicts with OOo

2011-10-29 Thread NoOp

On 10/29/2011 02:17 PM, Regina Henschel wrote:
> Hi,
> 
> Tom Davies schrieb:
>> Hi :) There is a guide to help avoid the usual conflicts
>> http://wiki.documentfoundation.org/Installing_in_parallel
>>
>> I think the problems are mostly when both version are open at the
>> same time, for example if one is permanently kinda open by having
>> it's QuickLauncher on. Regards from Tom :)
> 
> You can run the programs the same time, if each instance uses a 
> different folder for the user settings. Also the other way round is 
> possible, running one application with different users settings at the 
> same time, again different folders for the user settings are needed.
> 
> Only the association between document type and program is unique.

That is still a *serious* issue. Please see:


and in particular:



You can of course find the thread in the .dev list under "Change
executable/sh names".

The issue seems to have fallen on deaf ears following that thread. Seems
to me that with all the thousands of lines of code 'clean-up' reported
by TDF dev, the actual program .exe's could have been renamed from
swriter to lowriter et al or similar by now.






-- 
For 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: Printing in reverse order so page one ends up on top



No matter how I try to set the options, I cannot get my Epson Artisan to 
print duplex withing LO.  It just does not want to do it.  Right now I 
am having head clogging issues which may be a hardware malfunction, so 
solving the duplex printing issues is the least of my worries.  I may 
have to ship it back to Epson for head replacement.


I use to create several version of my printers when I was using Win XP.  
Color vs B&W vs Draft mode.  I do not do that with Ubuntu right now.  
Maybe later. I already have Artisan - network, Artisan - USB, HP 
PSC1410, HP Color laserjet 2600n, and the Generic-CUPS-PDF-printer 
[default].  Plus "print to file" which I never have used before using 
Linux OS.  I once an awhile click on the Artisan - USB printer instead 
of the network version.  I do not use the USB version except when I have 
a really large file [heavy in graphics] to print.  I have to do that 
with the color laser, but I have not plugged it into the Ubuntu desktop 
system "yet" since I re-installed the OS from scratch when I needed to 
re-partition my 1-TB drive to wipe out the other boot-partitions on it, 
when I finally added a 2-TB data drive and could save all the 
files/data/email-"stuff"/etc. to the new data drive.  I kept "adding 
partitions" every time I had to re-install Ubuntu when I had boot issues 
with 11.04 and other issues that crashed the Ubuntu install I was 
using.  I had to split the drive into more partitions so I could save 
the data from my old install when I reinstalled the OS.  Now I have a 
2-TB data drive, I do not need to do that.  Actually I have 1.5 TB used 
on that data drive and 300 GB used on the 1-TB main drive. [Plus my 1-TB 
external stuffed with less than 50 GB left. ]


Well that ended up way off topic.



On 10/29/2011 04:00 PM, NoOp wrote:

On 10/26/2011 08:32 AM, webmaster for Kracked Press Productions wrote:
...

Actually, it may be that your printer might not work with all its
options withing LO.  My Epson has a duplex feature, but LO seems not to
be able to set that feature's control to turn it on.

...

Printer Properties: Duplex On

I've found it easier to set up different printer profiles for the same
printer. Example:

WorkForce635BW - Black&  White mode (default printer to save color ink)
WorkForce635BWDuplex - as above but with duplex turned on
WorkForce635Color - standard color mode
WorkForce635Photo - color mode w/photo options set







--
For 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] Writer Thesaurus

2011-10-29 Thread webmaster for Kracked Press Productions

Thesaurus is grayed out where? In LO? or the external one?
Artha is a good external Thesaurus and Dictionary that I am running on
Ubuntu 10.04.

Install this dictionary/hyphen/thesaurus .oxt file.

http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/English_dict__with_fixed_dash_handling2010-03-15.oxt

Also try this Language Tool. Actually it is not the newest one.
http://libreoffice-na.us/English-3.4-installs/add-ons-extensions/LanguageTool-1.2.oxt
This tool helps with dictionary and thesaurus functions, but you need to
have Java installed to use it.

If you have installed both .oxt files and you still have the Thesaurus
option grayed out, then there is something wrong with the LO install, or
somehow 11.xx has some problems with their internal dictionary system;
or so I have been told that LO might use the MySpell/Hunspell, or other
internal dictionary system. I have hunspell for en-US, but myspell for
-en-gb, en-au, -en-za, and a few others. I also have the
"libreoffice3-dict-en", libreoffice3.4-dict-en" packages installed. It
seems I have a lot of packages names with both 3.3 and 3.4 version. I
wonder if you installed the "openoffice.org-thesaurus-en-us" package [if
it is shown in the Synaptic Package Manager for 11.xx] would help at all?

To be honest, there have been some weird issues with the
dictionary/thesaurus running LO 3.4.x on Ubuntu 11.xx and the default
Unity desktop manager.

On 10/29/2011 05:39 PM, pattyboy123 wrote:

Writer Thesaurus

Just up graded to 11.04 and seem the thesauruses is grayed out. Any one
know who to activated/ turn on this feature?

--
View this message in context:
http://nabble.documentfoundation.org/Writer-Thesaurus-tp3464533p3464533.html
Sent from the Users mailing list archive at Nabble.com.

--
For 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] Writer Thesaurus

2011-10-29 Thread webmaster for Kracked Press Productions



I do not have that option checked and I have the Thesaurus running.

On 10/29/2011 07:11 PM, Libre User wrote:
Tools>>Options>>General>>Click box at bottom of window that says 
"Enable experimental (unstable) features


Jerry

At 02:39 PM 10/29/2011, you wrote:

Writer Thesaurus

Just up graded to 11.04 and seem the thesauruses is grayed out.  Any one
know who to activated/ turn on this feature?

--
View this message in context: 
http://nabble.documentfoundation.org/Writer-Thesaurus-tp3464533p3464533.html

Sent from the Users mailing list archive at Nabble.com.

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





--
For 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: LO Conflicts with OOo