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

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

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

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

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,

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)

[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

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

[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

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

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

[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

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.

[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

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

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

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

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?

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

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}

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

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

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

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

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

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

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

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

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

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

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

[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

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

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

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

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

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

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.

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

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

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

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

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

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

[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

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.

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