[libreoffice-users] Displaying behaviour from old OpenOffice installation?

2011-08-08 Thread brad
Hi. I've been running OpenOffice 3.3.0 on my Slackware 12.0 Linux distribution (2.6.28.6 kernel). It's been running fine, except its formatting of Microsoft Word documents doesn't marry with Word itself. I have to run up Word if I want to make totally sure that indented columns line up, lines do

Re: [libreoffice-users] Re: Develops, bring the classic icons back, pls

2011-08-08 Thread OBUTEX/Hladůvka
No, the icons were not displayed when I used the .zip file from previous instalation LO 3.3.3 Yesterday I installed LO 2.4.2, added the .zip file from Bugzilla and it works fine. Thankyou :) Regards, Jiri Dne 9.8.2011 6:41, Tommy napsal(a): ... what do u mean? does the Classic LibO 3.4 compl

[libreoffice-users] Re: Develops, bring the classic icons back, pls

2011-08-08 Thread Tommy
On Thu, 04 Aug 2011 14:20:53 +0200, OBUTEX/Hladůvka wrote: The option "Classic style" is there missing and the default "Galaxy" I don't like. After I copied the mentioned file I can find the classic style among other options; the icons are OK but the three icons "=f(x)" , "cancel" and

Re: [libreoffice-users] new book

2011-08-08 Thread Andrew Douglas Pitonyak
On 08/08/2011 08:54 AM, webmaster for Kracked Press Productions wrote: On 08/08/2011 08:04 AM, Andrew Douglas Pitonyak wrote: On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for K

Re: [libreoffice-users] Ping Andrew Douglas Pitonyak - password macro

2011-08-08 Thread Andrew Douglas Pitonyak
On 08/08/2011 06:56 PM, NoOp wrote: Andrew, In attempting to help Bob Stia in the 'password problem' thread, I came across this macro: Interesting. I am familiar with the author. He has provided much advice to t

Re: [libreoffice-users] Re: Base and SQLite in Ubuntu 11.04

2011-08-08 Thread Simon Cropper (The foss Workflow Guides)
On 09/08/11 06:27, gsward wrote: Simon, Thanks for this it did get me a good way further on but I am having problems installing the driver. ./configure runs OK but sudo make install returns an error make: *** No rule to make target `install'. Stop. I have a .odbc.ini file and have made the

[libreoffice-users] Landscape Printing Format - Problem

2011-08-08 Thread john knops
I'm having problems trying to print documents in Lanscape format. Although the text appears nrmal in the print preview in the printed version the text is stretched horizontally and the individual characters run into each other. This occurs both with Calc and Writer. Does anyone have any suggest

[libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread NoOp
On 08/08/2011 04:38 PM, Tom Davies wrote: > Hi :) > It might be a good plan to post the bug-report in both places. Here is link > to > the LO guide on bug-reporting. It's got the link in there somewhere > http://wiki.documentfoundation.org/BugReport Did you not *read* the thread? planas/Jay a

[libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread NoOp
On 08/08/2011 04:30 PM, Tom Davies wrote: > Hi :) > The headings you listed are there but there is an additional heading just > after > the first one. > > > - Help > - Open/Save dialogue boxes > - Document status > - Year (two digits) > > It might be good to try renaming your LibreOffice con

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread Tom Davies
Hi :) It might be a good plan to post the bug-report in both places. Here is link to the LO guide on bug-reporting. It's got the link in there somewhere http://wiki.documentfoundation.org/BugReport If you do post the bug in both places then it helps to give the url of the other as a 2nd comm

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread Tom Davies
Hi :) The headings you listed are there but there is an additional heading just after the first one. - Help - Open/Save dialogue boxes - Document status - Year (two digits) It might be good to try renaming your LibreOffice config/user-profile to see if that has been blocking something. On a

[libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread NoOp
On 08/08/2011 01:37 PM, Dave Howorth wrote: > On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: >> On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: >> > On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: >> > > Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try >> > > with/wit

Re: [libreoffice-users] doc-files

2011-08-08 Thread planas
Graham, On Mon, 2011-08-08 at 18:23 +0100, Graham Mullan wrote: > One area where M$ Word still scores over LO is in the use of > track-changes. I know many editors and authors who stay with M$ because > the in-text change tracking that LO (and OO) use is much trickier to use > than the in-mar

Re: [libreoffice-users] Re: Need Calc help

2011-08-08 Thread Betti Ann and Preston Smith
I have uploaded the information to the Calc Section of the OpenOffice Forum - it is titled 'Compare Two Files' Thanks again for your assistance, Preston On 8/8/2011 5:43 PM, Andreas Säger wrote: Am 08.08.2011 19:18, Betti Ann and Preston Smith wrote: Hello Andreas, Thank you for your message

[libreoffice-users] Ping Andrew Douglas Pitonyak - password macro

2011-08-08 Thread NoOp
Andrew, In attempting to help Bob Stia in the 'password problem' thread, I came across this macro: This works *if* you have the *exact* password in the password file. Unfortunately it doesn't take regex etc., so it'

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread planas
Dave, On Mon, 2011-08-08 at 21:37 +0100, Dave Howorth wrote: > On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: > > On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: > > > On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: > > > > Try: Tools|Options|LibreOffice|General|Open/Save dialogs|

Re: [libreoffice-users] need to find the link

2011-08-08 Thread Tom Davies
Hi :) For linux there is a separate package rather than an add-on or extension so install from your package manager rather than from inside either LibreOffice or Firefox mozilla-libreoffice I prefer it this way anyway, with some add-ons for FireFox i sometimes have to search for a similar add-

[libreoffice-users] Re: Need Calc help

2011-08-08 Thread Andreas Säger
Am 08.08.2011 19:18, Betti Ann and Preston Smith wrote: Hello Andreas, Thank you for your message and your patience. I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the

[libreoffice-users] Re: Older versions of LibreOffice

2011-08-08 Thread Andreas Säger
Am 08.08.2011 01:25, NoOp wrote: On 08/07/2011 01:58 PM, Andreas Säger wrote: The Address Book Wizard is the issue - see: https://bugs.freedesktop.org/show_bug.cgi?id=32948 [Address Book Data Source Wizard Doesn't Work] Ah, I see. Didn't know that. The OP did not address the problem clearly. T

[libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7

2011-08-08 Thread Andreas Säger
Am 07.08.2011 15:00, webmaster for Kracked Press Productions wrote: I remember something about Sun/Oracle older version of Java having problem with LibreOffice, but there is an open-source version that would instead. The one on my Ubuntu system states it is Sun's Java, but the file's name [fold

[libreoffice-users] Re: Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread Andreas Säger
Am 07.08.2011 16:13, Johnny Rosenberg wrote: So what does this ”Insert Copied Cells” actually do? The same as Drag&Alt+Drop -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guid

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread Dave Howorth
On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: > On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: > > On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: > > > Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try > > > with/without 'Use LibreOffie dialogs'. Uncheck uses your s

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread Dave Howorth
On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: > On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: > > Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try > > with/without 'Use LibreOffie dialogs'. Uncheck uses your system file > > manager dialog, checked uses LO's internal dialo

[libreoffice-users] Re: Base and SQLite in Ubuntu 11.04

2011-08-08 Thread gsward
Simon, Thanks for this it did get me a good way further on but I am having problems installing the driver. ./configure runs OK but sudo make install returns an error make: *** No rule to make target `install'. Stop. I have a .odbc.ini file and have made the necessary edit to point at my dat

Re: [libreoffice-users] Re: libreoffice won't open files

2011-08-08 Thread Dave Howorth
On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: > On 08/07/2011 06:49 AM, Dave Howorth wrote: > > I've had a strange experience recently - libreoffice won't open files. > > That is File/Open doesn't bring up a dialog box. File/New works and so > > does using a filename on the command line when start

Re: [libreoffice-users] Re: Virtual bold not workign when printing

2011-08-08 Thread Cor Nouws
BKh wrote (07-08-11 23:30) Apologies. I should have known better. Here goes: Windows XP service pack 3 LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 PRINTER: Samsung SCX-4x28 Series PCL 6 Thanks, The font is Akkhara Regular.ttf. It is no longer available from the original s

Re: [libreoffice-users] doc-files

2011-08-08 Thread webmaster for Kracked Press Productions
Same deal. Use the one "Microsoft Excel 97/2000/XP .xls" format, not the one that ends with "x". On 08/08/2011 01:34 PM, Aarni Järvelä wrote: Sorry guys, but I was talking about Calc/Excel spreadsheets, not Word text documents. -Aarni- On 08.08.2011 20:15, webmaster for Kracked Press Prod

Re: [libreoffice-users] need to find the link

2011-08-08 Thread webmaster for Kracked Press Productions
No that is not what I was looking for. It was an add-on for Firefox and LO/OOo that "connected" the two packages together. It gave an option in Firefox to Open Lo/OOo and pass the ODF file[s] to the office package to oven and view them. Right now, Firefox can read .odt files internally, bu

Re: [libreoffice-users] Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread Regina Henschel
Hi, grfried schrieb: It is not clear to me why "Insert Cut Cells" following a previous Cut and "Insert Copied Cells" following a previous Copy are not available in the right-click menu in LibreOffice Calc as they are in Microsoft Excel. I use them very frequently to re-order a set range of rows

Re: [libreoffice-users] doc-files

2011-08-08 Thread Aarni Järvelä
Sorry guys, but I was talking about Calc/Excel spreadsheets, not Word text documents. -Aarni- On 08.08.2011 20:15, webmaster for Kracked Press Productions wrote: Make sure you save the file as "Microsoft Word Win 97/2000/XP .doc format". That way you get one that should work fine. That is t

Re: [libreoffice-users] need to find the link

2011-08-08 Thread Graham Mullan
Don't know if this is what you want? http://blog.arpitnext.com/gpdf Graham -- graham.mul...@coly.org.uk 0117 9502556 or 07887 637064 (or 0844 2327803) On 08/08/2011 18:18, webmaster for Kracked Press Productions wrote: Earlier on this list, there was a thread that talked about a Firefox exte

Re: [libreoffice-users] doc-files

2011-08-08 Thread Graham Mullan
One area where M$ Word still scores over LO is in the use of track-changes. I know many editors and authors who stay with M$ because the in-text change tracking that LO (and OO) use is much trickier to use than the in-margin alternative available in the M$ version. If the latter could be added

Re: [libreoffice-users] Re: Need Calc help

2011-08-08 Thread Betti Ann and Preston Smith
Hello Andreas, Thank you for your message and your patience. I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the files involved and what I hope to see as a result H

[libreoffice-users] need to find the link

2011-08-08 Thread webmaster for Kracked Press Productions
Earlier on this list, there was a thread that talked about a Firefox extension for LibreOffice. I know that Firefox can view .odt files, but I am looking for that Firefox add-on. Can anyone tell me the name of that add-on and maybe a direct link for it? I tried to find it on th Firefox si

Re: [libreoffice-users] Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread Tim Deaton
On 8/7/2011 10:17 AM, Johnny Rosenberg wrote: 2011/8/7 Nuno J. Silva: On 2011-08-07, grfried wrote: It is not clear to me why "Insert Cut Cells" following a previous Cut and "Insert Copied Cells" following a previous Copy are not available in the right-click menu in LibreOffice Calc as they a

Re: [libreoffice-users] doc-files

2011-08-08 Thread webmaster for Kracked Press Productions
Make sure you save the file as "Microsoft Word Win 97/2000/XP .doc format". That way you get one that should work fine. That is the one I use when I have to send a Word document to people. I never had any problems with it. As other will tell you, stay clear of .docx" format. Any of the f

[libreoffice-users] Re: helper columns in Base - SQL query based on a value of a particular column of current element.

2011-08-08 Thread Andreas Säger
Am 08.08.2011 10:24, 3flight wrote: SELECT "Components - Types"."Parameter" FROM "Components", "Components - Types" WHERE "Components"."Type" = "Components - Types"."ID" It is as simple as: SELECT "Parameter","ID" FROM "Components - Types" ORDER BY "Parameter" with "Parameter" as visible fiel

Re: [libreoffice-users] Permanent state of recovery with non-existent document

2011-08-08 Thread MR ZenWiz
On Thu, Aug 4, 2011 at 3:30 AM, Sigrid Carrera wrote: > On Thu, 4 Aug 2011 00:18:16 -0700 > MR ZenWiz wrote: > >> Once, a long time ago, I tried to open a .pps file with LO, and it >> crashed LO - every single time.  I deleted the document and yet every >> time I start LO, it tries to recover thi

[libreoffice-users] Re: LibreOffice base - cannot make a convenient form to add data

2011-08-08 Thread Andreas Säger
Am 08.08.2011 09:03, 3flight wrote: But I do it manually (i.e. via form editor - right click on column - change to listbox, then go open it's options and set it to take values from a linked table's second field). Can't see where in the Form Creation Wizard there is an option to change columns to

[libreoffice-users] Re: HELP WITH CODE excel

2011-08-08 Thread Andreas Säger
Am 08.08.2011 14:08, Andrew Douglas Pitonyak wrote: =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The help would be greatly appreicated -- How can INDIRECT(CELL(ADDRESS;INDEX(...))) return anything else than INDEX(...) alone? If I recall correctl

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-08 Thread Johnny Rosenberg
2011/8/7 Joseph Da Silva : > Hi > > I was wondering if someone could help me with this code it works in excel but > not with libra office. > > =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, > The help would be greatly appreicated > -- Exactly why did

Re: [libreoffice-users] Re: Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread Johnny Rosenberg
2011/8/8 grfried : > Here is the explanation for "insert cut cells" and "insert copied cells" as > you requested. > > If I cut a range of cells (usually one or more rows or columns), select a > similarly shaped range of cells (again usually one or more row or columns), > the cut cells are insert

Re: [libreoffice-users] doc-files

2011-08-08 Thread Cor Nouws
Hi Heinrich, Heinrich Stoellinger wrote (08-08-11 15:02) I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? No

Re: [libreoffice-users] doc-files

2011-08-08 Thread soumalya ray
for me,no problem with doc but sometimes faced problem with docx.avoiding it now On 8 August 2011 19:32, Tom Davies wrote: > Hi :) > Perhaps give them the link to download LibreOffice and let them know it > reads a > wider range of formats and is more compatible with a wider range of other > pro

[libreoffice-users] [base] BaseTools Extension

2011-08-08 Thread rogerio dandrea
BaseTools Extension works in libreoffice 3.4.2? I have a problem with filter in base , I need an example of form filter macro 1 and 2 dont work Sub New_Search(Event As Object) GlobalScope.BasicLibraries.LoadLibrary("BaseTools") Dim Form As object Dim Control As Object Dim nome,fnome As String I

Re: [libreoffice-users] doc-files

2011-08-08 Thread Tom Davies
Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX?

[libreoffice-users] Re: Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread grfried
Here is the explanation for "insert cut cells" and "insert copied cells" as you requested. If I cut a range of cells (usually one or more rows or columns), select a similarly shaped range of cells (again usually one or more row or columns), the cut cells are inserted at the selection and the cu

Re: [libreoffice-users] doc-files

2011-08-08 Thread Graham Mullan
On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards

[libreoffice-users] doc-files

2011-08-08 Thread Heinrich Stoellinger
Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. -- Erstellt mit Operas revolutionärem E-Mai

Re: [libreoffice-users] new book

2011-08-08 Thread webmaster for Kracked Press Productions
On 08/08/2011 08:04 AM, Andrew Douglas Pitonyak wrote: On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-08 Thread Andrew Douglas Pitonyak
On 08/07/2011 12:00 AM, nvrk wrote: On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silva wrote: Hi I was wondering if someone could help me with this code it works in excel but not with libra office. =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The

Re: [libreoffice-users] new book

2011-08-08 Thread Andrew Douglas Pitonyak
On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt

[libreoffice-users] Re: Extending selection in Calc (LibreOffice 3.4.2, Linux)

2011-08-08 Thread chimak111
Cor, Thank you for taking the time to explain. I have modified my spreadsheet accordingly. All the best to you and the /Libre/Office team! -- View this message in context: http://nabble.documentfoundation.org/Extending-selection-in-Calc-LibreOffice-3-4-2-Linux-tp3230960p3235268.html Sent from t

[libreoffice-users] Re: helper columns in Base - SQL query based on a value of a particular column of current element.

2011-08-08 Thread Tom
Hi :) It is a valid way of solving problems because it often takes a while before questions get answers. So, ask first, then hunt for HowTo and if you get the answer first then post back to say how you solved it. It might even help other people that run into a similar problem later if they serach

[libreoffice-users] Re: helper columns in Base - SQL query based on a value of a particular column of current element.

2011-08-08 Thread 3flight
Oh again I'm too impatient to ask, finally I figured this out too. Should have selected listbox and used the relevant field (Type in my case), plus SQL query like: SELECT "Parameter 1","ID" FROM "Components-Types". Works fine! -- View this message in context: http://nabble.documentfoundation.org/

[libreoffice-users] helper columns in Base - SQL query based on a value of a particular column of current element.

2011-08-08 Thread 3flight
Can't figure this one out. I want to have "helper" columns in my form, which show text relevant to a value selected in a particular field for each element. EXAMPLE: Components ID--TypeParameter-Parameter-value INTIN

[libreoffice-users] Re: LibreOffice base - cannot make a convenient form to add data

2011-08-08 Thread 3flight
Ok I figured it out - manual setting doesn't do what it is supposed to, so I should use SQL and write smth like SELECT "Location", "ID" FROM "Locations" - this works the way I want it to if column is listbox. I can also type in to quickly select items. Still couldn't find how to add a grid object i

[libreoffice-users] Re: LibreOffice base - cannot make a convenient form to add data

2011-08-08 Thread 3flight
tomcloyd wrote: > > Base won't do this with combo boxes. > I want a combobox to be able to quickly select needed field by typing. Can I do this with listbox? tomcloyd wrote: > > So, replace combo box with list box, and see if that doesn't work. > It doesn't work. See screenshots 1 & 2. http:/