Re: [libreoffice-users] Lotus WordPro

2011-08-06 Thread John B
! Regards John B -- On 06/08/2011 23:20, Roland Hughes wrote: We have been begging for tabbed divisions from the OpenOffice/LO/Symphony community for years. It has

Re: [libreoffice-users] Compute difference

2011-07-23 Thread John B
and the answer in E4 is 21 you might want to add +1 to the E4 formula depending on if you decide the answer in E4 should be 22 I note that 1/7/2011 is the same as 01/07/2011, as is just 1/7 (as it auto inputs this year) regards John B

Re: [libreoffice-users] Writer images disappeared!

2011-07-22 Thread John B
Tony Just downloaded 3.4.2 from Filehippo, tested and at this moment cannot find any bug fixes from 3.4.1. However, the disappearing pics still happens in this version for saving in .docx format Now, I know some people are not keen on this work around, but if you paste your picture into

Re: [libreoffice-users] Writer images disappeared!

2011-07-22 Thread John B
!. I use text boxes all the time. regards John B -- On 22/07/2011 14:20, Andrew Douglas Pitonyak wrote: On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work

Re: [libreoffice-users] Writer images disappeared!

2011-07-22 Thread John B
Pitonyak [mailto:and...@pitonyak.org] Sent: Friday,22 July, 2011 13:20 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture

Re: [libreoffice-users] help recovering?

2011-07-22 Thread John B
that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE

Re: [libreoffice-users] Compute difference

2011-07-22 Thread John B
Try this b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec E4 = ((-B4+D4)/7 +(1/7) f4= Trunc(e4) g4= (+e4-F4)*7 then type in your 2 dates into b4 and d4 as in 01/07/2011 and 22/07/2011 regards John B

Re: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-18 Thread John B
Just a thought I do not know if Widows 7 has compatibility mode, but if it does, try Windows XP compatibility and see if the problem goes away. regards John B - On 17/07/2011 14:26, John B wrote

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread John B
Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread John B
- and it was far to buggy for me. I am very happy for LO to stay on course. regards John B -- On 17/07/2011 22:01, Tom Davies wrote: Hi :) My emails are just my own opinion. I'm not even a proper member

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread John B
. regards John B --- On 18/07/2011 02:03, Roland Hughes wrote: Try KOffice.or as it is now called Calligra. It will be bundled with most major distros next release. http

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-14 Thread John B
You might find this useful If say the name David is in cell C11, then type in D11 =CHAR(CODE(C11)) will return the D the 1st Character regards John B - On 12/07/2011 09:48, Dietrich

Re: [libreoffice-users] Error in Calc logical functions

2011-07-13 Thread John B
function. I have learned something today - thanks John B -- On 13/07/2011 13:24, Michael D. Setzer II wrote: How about this formula. =IF(ISNUMBER(A1),IF(A110,True,False),Non

Re: [libreoffice-users] Re: Save odt/ods files take too much time

2011-07-12 Thread John B
want to save in this format box, then the save bar does not appear, so you cannot tell on 3.4.1 how long it taking but when you add on the time it takes you to click on this extra box, it has to be longer than 4s. regards John B xp sp3 LO 3.4.1

Re: [libreoffice-users] Re: Image problems

2011-07-12 Thread John B
or else you cannot insert a new one. John B -- On 12/07/2011 16:15, Tom Davies wrote: Hi :) Brilliant! I just had this problem about a week ago. About 12 images on a single page in Writer made

Re: [libreoffice-users] Error in Calc logical functions

2011-07-12 Thread John B
)) which should work - but it doesn't. regards John B On 12/07/2011 18:05, Alejo C.S. wrote: Hi all, this is a little example to show what is going on. In A column I have a numeric list from 1 to 21

Re: [libreoffice-users] Error in Calc logical functions

2011-07-12 Thread John B
Got it Regina is correct, so:- =IF(A150,False,IF(A110,True,False)) Where 50 (or 1000) is higher than any number in your table regards John B On 12/07/2011 19:28, John B wrote: Alejo The strange

Re: [libreoffice-users] Error in Calc logical functions

2011-07-12 Thread John B
Hello Brian Its none of those, they are not comparable, Ones a text the other is an amount. Therefore A logically is not greater than 10 stands (I hope)! As stated, I used Lotus 123 as my Judge and Jury. John B Ps who is John Bonly

Re: [libreoffice-users] Help with formatting footnotes...

2011-07-08 Thread John B
as if in both, so if you must then you can manually edit file.doc to file.docx, MS and LO will open it - perfectly. regards John B On 06/07/2011 20:33, gena_hill wrote: Hi

Re: [libreoffice-users] problem in impress

2011-07-04 Thread John B
(123...) that maybe the problem regards John B - On 04/07/2011 12:06, Nawfel wrote: I am using ubuntu 11.04 ... LibreOffice 3.3.2 LibreOffice language=French My document

Re: [libreoffice-users] Re: problem in impress

2011-07-04 Thread John B
Dear Nawfel In your quest for enlightenment born usually from hours of frustration, you will always find bugs and with LO many many bugs. Hence, I really hope that you persevere with bugzilla yourself. regards John B

Re: [libreoffice-users][windows] Review on 3.4.1 Mail Merge

2011-07-03 Thread John B
data can now be pasted into the *csv file - if you so desire! Summary:- Other than a few minor niggles and only the one (easy to get around) bug, that I could find, it's getting there, but most importantly :- its usable. John B -- Unsubscribe instructions: E-mail to users+h

Re: [libreoffice-users][windows] 3.4.1 Click here Place holders for Lotus Wordpro

2011-07-03 Thread John B
this facility in the first place (a shame for forms that need to be completed - you just cannot tab to the next box), you have to move click your mouse instead. Maybe in 3.4.2? Now if only LO would do Wordpro Document Tabs (divisions) - I have a dream!. regards John B xp pro sp3 LO 3.4.1

[libreoffice-users] [LibraOffice-Users] - DONT use Reply to for a new thread

2011-07-03 Thread John B
Dear Hal I had no Idea this happened, I thought just by putting in a new subject changed the thread. I will make up a template for use for new subjects from now on. John B John, You've written two posts by hitting Reply

[libreoffice-users] [LibraOffice-Users] - DONT use Reply to for a new thread

2011-07-03 Thread John B
will ever use it myself. regards John B --- On 03/07/2011 23:45, Nuno J. Silva wrote: On 2011-07-03, Larry Gusaas wrote: On 2011/07/03 3:26 PM Tom Davies wrote: Sorry, i didn't

Re: [libreoffice-users] Re: SubForms and Photographs in LO Base

2011-06-30 Thread John B
Its easy The adopter with the triangle is in the vessel with the pestle and the stable which is able is the program that is true. Please Please forgive me! John B --- On 30/06/2011 17:18

Re: [libreoffice-users][windows] Calc: Text numbers

2011-06-29 Thread John B
or below it, say at E7 the number 8, the whole of 8,000 btus (or 2.34kw) Machines appears. I would like to turn this feature off. regards John B xp pro sp3 LO 3.3.3 (3.3.3.1) -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write

Re: [libreoffice-users][windows] Calc: Text numbers

2011-06-29 Thread John B
) I was hoping that I could just format the cell in some way so the spreadsheet could be used be anyone and not say OMG when they inadvertently enter a number and text appears (as I did). I suppose the only answer is to re-design the form (unless you know better). regards John B

Re: [libreoffice-users][windows] Calc: Text numbers

2011-06-29 Thread John B
calc again, autoinput remained off (that's good), then changed the autoinput to the default On, then opened my calculator - and the problem returns regards John B

Re: [libreoffice-users][windows] Calc: Text numbers

2011-06-29 Thread John B
works as it should, I then saved it and closed LO as well. Open LO calc again, autoinput remained off (that's good), then changed the autoinput to the default On, then opened my calculator - and the problem returns regards John B

Re: [libreoffice-users] Mail merge

2011-06-27 Thread John B
comes next in the pecking order. One good thing - I know how to access the bug list before I explore LO further. thanks John B -- On 26/06/2011 22:10, Alexander Thurgood wrote: Le 26/06

Re: [libreoffice-users] Re: using fields in a text document

2011-06-26 Thread John B
assume then if you had a database of 1 names you would have a file with 1 letters (to big). John B Xp Pro sp3 LO 3.4, 3.3.3 3.2 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas

Re: [libreoffice-users][windows] Page Format

2011-06-25 Thread John B
on organise but I could find no way to open it - which is the 2nd problem if you want to open it this way, you will always have to use Recent Documents John B - On 25/06/2011 04:42

Re: [libreoffice-users] Page Format

2011-06-25 Thread John B
Planas has a much better Idea than mine And it sorts out the default saving problems (it auto defaults to .odt) in Commands, You can even click on your named template and a new field appears as set as default template And - don't be afraid, as a new click field in commands also appears

Re: [libreoffice-users] Re: using fields in a text document

2011-06-25 Thread John B
on the file name, then OK on the window box (which took a few clicks to appear - minor bug) Then nothing - the Finish button is still greyed out - Big Bug regards John B -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas

Re: [libreoffice-users][windows]General Help and Guidence

2011-06-24 Thread John B
an email such as this! - but I do understand if you are giving out the same advice, time after time. oh and for us newbies to LO tutorials (the help files are well... lets say basic and need updating). regards John B

Re: [libreoffice-users] using fields in a text document

2011-06-24 Thread John B
Hi Lee Its called mailmerge you will love it. Tools Mailmerge regards John - On 24/06/2011 14:13, lee wrote: Hi, I have a text document with mostly static data, and since it's kind

[libreoffice-users] using fields in a text document

2011-06-24 Thread John B
were universal and I am just not looking hard enough. regards John B PS - I am trained in all circumstances to be on top! -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines

[libreoffice-users][windows]General Help and Guidence

2011-06-24 Thread John B
or a work around. I would hate an email such as this! - but I do understand if you are giving out the same advice, time after time. oh and for us newbies to LO tutorials (the help files are well... lets say basic and need updating). regards John B

Re: [libreoffice-users] using fields in a text document

2011-06-24 Thread John B
form design I would be so pleased to know if you get this to work. regards John B - On 24/06/2011 14:56, lee wrote: John Bjo...@email2.me writes

Re: [libreoffice-users] using fields in a text document

2011-06-24 Thread John B
you really like bottom postings, I will try not to do it again regards John B --- -- Unsubscribe instructions: E-mail to users+h

Re: [libreoffice-users] using fields in a text document

2011-06-24 Thread John B
you really like bottom postings, I will try not to do it again regards John B --- -- Unsubscribe instructions: E-mail to users+h

Re: [libreoffice-users][windows] list boxes not stable

2011-06-23 Thread John B
simple that I have to wonder if somehow I completely misunderstood your question. If so, please try me again.) / Help!, I take up your offer - that's why I need a step by step walk through to make my 1st (movable) field box. regards John B MS XP pro sp3 LO 3.3.3.1 3.4

[libreoffice-users][windows] Re: Mac people

2011-06-23 Thread John B
opportunity , with so many other interesting and apt emails. Just a thought! John B XP Pro sp3 On 23/06/2011 15:27, Alexander Thurgood wrote: Le 23/06/11 16:00, Ernest Kurtz a écrit : Thank you, Alex. Is there any possibility of having an LO Mac list? This list is deluging my

[libreoffice-users][windows] Re: Side by side install of LibO and OOo

2011-06-22 Thread John B
in the end was to deep remove OOo using Revo-Uninstall and just hope that in the future I don't need it !!. If you want to keep LO as the default, then you need to deep clean both LO OOo, then re-install LO first, because for some reason OOo does not overwrite LO. John B xp pro sp3 LO 3.3.3.1

[libreoffice-users][windows] default type and setting for pasting

2011-06-21 Thread John B
John B ms xp pro sp3 LO 3.4.0 On 21/06/2011 16:04, Roxy Robinson wrote: Even with that, there´s still the problem that the text would be inserted where the mouse pointer happens to be rather than where

Re: [libreoffice-users] Tutorial for Base Design Forms

2011-06-20 Thread John B
. However, when I open the Design form in LO (3.3.3 3.4) it is blank and it has defeated me so far, as to how you load in all the field names. The LO Design Form is a quite complex (powerful!) in any case (even Radio buttons), is there a tutorial on LO Base Design Forms? thanks John B Windows

Re: [libreoffice-users] Re: Tutorial for Base Design Forms

2011-06-20 Thread John B
databases, on attempting to load, the software froze (repeatable), the cure is to delete soffice.exe (Ctrl-Alt-Del) and away it goes (it unfreezes) - I was so surprised. Gr John B --- On 20/06/2011 09:58, Alexander

[libreoffice-users] Feature request - Lotus Wordpro tabs

2011-06-20 Thread John B
to your bug reports? So - Any Volunteers? Regards John B https://bugs.freedesktop.org/show_bug.cgi?id=38401 --- Comment #1 from Michael Meeksmichael.me...@novell.com 2011-06-20 07:36:10 PDT --- IMHO implementing the tab feature would take quite some work here, instead it might be good

[libreoffice-users] default type and setting for pasting

2011-06-20 Thread John B
John B LO 3.3.3 On 20/06/2011 01:06, lee wrote: Hi, how do I set a default pasting type so that when pasting, only the text itself is pasted and not the formatting with it? How do I make it so that text, when pasted

Re: [libreoffice-users] default type and setting for pasting

2011-06-20 Thread John B
macros. I thought it was some way of programming a key to type yours faithfully at the bottom of letters for slow typists - obviously not! So:- from copy ctrl + V gives formatted ctrl+shift+v, then ok gives unformatted with only text numbers ticked regards John B

Re: [libreoffice-users] default type and setting for pasting

2011-06-20 Thread John B
Lee I am so sorry - I know Please read my later posting on this - and then ignore it anyway as Roxy has come up with a better idea. regards John B - On 20/06/2011 22:43, lee wrote: John Bjo...@email2.me

[libreoffice-users] Re: How can I reset all settings?

2011-06-18 Thread John B
in Options), change the rulers in Write to inches and the background colour to blue(chart12), you will find that 4 files are changed in this directory. I have absolutely no idea what does what and will probably never need to know. All the best John B On 17/06/2011 21:22, NoOp wrote

Re: [libreoffice-users] search does not find (

2011-06-18 Thread John B
Dear Thomas Whilst I am not suggesting you try LibraOffice 3.4, but it works on my computer using 3.4 It was not an exhaustive test but it found ( ) * # [ % - until I got fed up John B On 18/06/2011 03:07, Thomas

[libreoffice-users] *dbf files open in Calc not Base

2011-06-18 Thread John B
Open lists:- dBase(.dbf) is listed in Calc and it is absent from Base Is this a bug - have I missed something ? regards John B Windows XP Pro Sp3 LibreOffice 3.4 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas

Re: [libreoffice-users] Feature request - Lotus Wordpro tabs

2011-06-17 Thread John B
!) Regards from Tom :) From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Fri, 10 June, 2011 12:20:01 Subject: [libreoffice-users] Feature request - area? Is there an area where Feature Requests are posted? John B -- Unsubscribe instructions: E

Re: [libreoffice-users] Feature request - Lotus Wordpro tabs

2011-06-17 Thread John B
to think up new file names each time you send a new letter such a fred_blogs_fax_17_06_11_reply_London_office. I am assuming the they you refer to, is IBM thanks John B -- On 17

[libreoffice-users] Feature request - Lotus Wordpro tabs

2011-06-17 Thread John B
architecture. I don't have problems finding client documents which are 20 years old. I create a directory for each client. If I don't do any billable work for that client in 6 years, I simply delete the directory during the next OS/machine upgrade. On Fri, 2011-06-17 at 16:17 +0100, John B wrote

Re: [libreoffice-users] Windows Open with - reprise - Call for a cleaner

2011-06-13 Thread John B
and pathways, I suppose it will remain like this until one or the other changes the names - maybe soffice.exe will become Loffice.exe. What I do not understand is that Lotus Symphony also uses a soffice.exe and it works fine. so thanks and all hail to LibreOffice-users John B

[libreoffice-users] Windows Open with - the answer - Call for a cleaner

2011-06-11 Thread John B
. regards John B - On 10/06/2011 21:15, Tom Davies wrote: Hi :) Un-installing OpenOffice often cures weird and unlikely problems especially in Windows. There is still often a clash between OpenOffice

[libreoffice-users] How can I make long words stay on their starting line?

2011-06-10 Thread John B
in the mean time. John B --- On 10/06/2011 08:49, Stephan Zietsman wrote: never punctual wrote: Thanks for the suggestions so far. I guess hyphenation could

[libreoffice-users] Feature request - area?

2011-06-10 Thread John B
Is there an area where Feature Requests are posted? John B -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Windows Open with

2011-06-10 Thread John B
(applications), its ignored and the system jumps back to the browsing list. Also Libra Office does not appear in the recommended programs list, whilst OpenOffice does and works fine. Windows XP pro sp3 Libre Office 3.3 3.4 John B -- Unsubscribe instructions: E-mail to users+h