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

2011-10-29 Thread Thomas Knierim
No, I mean PDF. I think LibreOffice sends a PDF formated page to the printer 
driver. Maybe the page is malformed or the printer driver isn't working correct.

You can see the printer language 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.

Am 29.10.2011 um 01:39 schrieb Brian Barker:

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

2011-10-29 Thread Thomas Knierim

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?

... but in context with PS - I don't think that printer defined format is being 
used. In Linux printing works like this (I think) cups (common unix printing 
system) gets the data, converts them to PS, sends them to the rip and then to 
the Printer Driver (more on 
http://www.samba.org/samba/docs/man/Samba-HOWTO-Collection/CUPS-printing.html#cups1).

 
 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.

I've searched around and found nothing. The only thing I found is to set a new 
Standard document where the printer Language is set to PS. But that effects 
only new document - not the old.

 
 --
 
 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+pdfbaseproject=openSUSE%3AFactorylang=enexclude_debug=true
 http://software.opensuse.org/search?q=cups+pdfbaseproject=openSUSE%3AFactorylang=enexclude_debug=true
 I wonder why it was not part of the ISO that you downloaded to install 
 OpenSUSE?

No it isn't. But as far as I know package cups-pdf does only give me a 
pdf-printer.

 
 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.

Printing from all other programs, for example from the preview, works fine. I 
could create a pdf document from LibreOffice and print it - two pages on a 
sheet - with preview!

 
 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.

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?)

 
 
 
 
 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 

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

2011-10-29 Thread Hladůvka Jiří

Copy the cells and paste as unformatted text
(use the icon for pasting and select unformatted text)

:)



Dne 29.10.2011 1:28, Stefan Weigel napsal(a):

Hi Tom,

Am 29.10.2011 01:21, schrieb Tom Davies:


Tools - Options - LibreOffice Calc - View

and then UNtick the Formulas tick box in the Display section at the top of 
the 2nd column.


This does not *convert* formula to value. It only changes the
display. ;-)

Stefan




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

2011-10-29 Thread e-letter
On 28/10/2011, ESChamp esch...@gmail.com 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

2011-10-29 Thread e-letter
On 24/10/2011, mikko mekar...@gmail.com 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

2011-10-29 Thread Alex Thurgood

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

2011-10-29 Thread Tom Davies
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 inp...@gmail.com wrote:

 From: e-letter inp...@gmail.com
 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 esch...@gmail.com
 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

2011-10-29 Thread 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 :)

--- On Sat, 29/10/11, Thomas Knierim tknie...@web.de wrote:

 From: Thomas Knierim tknie...@web.de
 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



[libreoffice-users] Re: Base: creating a dropdown field form

2011-10-29 Thread Alex Thurgood

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

2011-10-29 Thread Tom Davies
Hi :)
I tried writing in Writer, got individual words to have different background 
colours and copypasted 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 copyypasted 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 jrodrigue...@cpcecr.com wrote:

 From: jorge jrodrigue...@cpcecr.com
 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 tomdavie...@yahoo.co.uk
 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
  
  
  - 
   v...@ukr.net
  
 
 -- 
 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?

2011-10-29 Thread Alex Thurgood

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

2011-10-29 Thread Tom Davies
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 alex.thurg...@gmail.com wrote:

 From: Alex Thurgood alex.thurg...@gmail.com
 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

2011-10-29 Thread Tom Davies
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 whitfi...@telkomsa.net wrote:

 From: Ian Whitfield whitfi...@telkomsa.net
 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.thurgoodat  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 Daviestomdavie...@yahoo.co.uk  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 tknie...@web.de wrote:
 
 From: Thomas Knierim tknie...@web.de
 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 Tom Davies
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 tknie...@web.de wrote:

 From: Thomas Knierim tknie...@web.de
 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+pdfbaseproject=openSUSE%3AFactory〈=enexclude_debug=true
  http://software.opensuse.org/search?q=cups+pdfbaseproject=openSUSE%3AFactory〈=enexclude_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 

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 http://www.gnu.org//Linux 
http://www.fsfla.org/svnwiki/selibre/linux-libre/ based operating 
system. It is derived from Ubuntu, but includes only free software 
http://www.gnu.org/philosophy/free-sw.html.
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 
http://trisquel.info/presentacion on April 2005 with the presence and 
support of Richard Stallman, founder of the Free Software Foundation 
http://fsf.org.


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 http://www.fsf.org/associate/card, 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



[libreoffice-users] frame positioning

2011-10-29 Thread e-letter
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

2011-10-29 Thread Dennis E. Hamilton
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

2011-10-29 Thread Dennis E. Hamilton
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,  http://nfoWorks.org/
   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

2011-10-29 Thread ESChamp
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

2011-10-29 Thread ESChamp
e-letter has written on 10/29/2011 5:21 AM:
 On 28/10/2011, ESChamp esch...@gmail.com 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

2011-10-29 Thread ESChamp
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 inp...@gmail.com wrote:

  From: e-letter inp...@gmail.com
  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 esch...@gmail.com
  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] Calc: Converting Formula to Value

2011-10-29 Thread Dennis E. Hamilton
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


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 rshep...@appl-ecosys.comwrote:

 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

2011-10-29 Thread Tom Davies
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 esch...@gmail.com wrote:

 From: ESChamp esch...@gmail.com
 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.
...

http://www.wilderssecurity.com/showthread.php?p=1963586
[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

2011-10-29 Thread Tom Davies
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 esch...@gmail.com wrote:

 From: ESChamp esch...@gmail.com
 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 esch...@gmail.com
 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

2011-10-29 Thread Dennis E. Hamilton
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,  http://nfoWorks.org/
   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,  http://nfoWorks.org/
   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

2011-10-29 Thread Tom Davies
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 esch...@gmail.com wrote:

 From: ESChamp esch...@gmail.com
 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 esch...@gmail.com
 wrote:
 
   From: ESChamp esch...@gmail.com
   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 esch...@gmail.com
   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

2011-10-29 Thread Tom Davies
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 dennis.hamil...@acm.org wrote:

 From: Dennis E. Hamilton dennis.hamil...@acm.org
 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

2011-10-29 Thread Tom Davies
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 b.m.bar...@btinternet.com wrote:

 From: Brian Barker b.m.bar...@btinternet.com
 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] 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



[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:

http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4130
and in particular:
http://permalink.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4359
http://permalink.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4360

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] 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:
ToolsOptionsGeneralClick 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