Re: [users] Re: Removing line breaks in Open Office writer, etc.

2010-11-18 Thread Mike Scott
On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse pasted from a

[users] Calc: How to see list of sheets

2010-11-18 Thread L Duperval
Hi, In Excel 2K3, you can right-click on the sheet navigation arrows and have a list of all the sheets in the current workbook, so you can click on the one you need and go there directly. It makes it easier to navigate from one sheet to the other. What's the equivalent in Calc? Thanks, L

Re: [users] Calc: How to see list of sheets

2010-11-18 Thread Laurent Godard
Hi try the navigator press F5 key HTH Laurent - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] Filters - mistake in wiki documentation?

2010-11-18 Thread Phil Hibbs
Can someone please confirm if this is correct: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Filters After applying a filter, some rows are visible and some rows are not. If you select multiple rows in one operation, you will also select the invisible rows

[users] Re: Calc: How to see list of sheets

2010-11-18 Thread L Duperval
On Thu, 18 Nov 2010 14:24:31 +0100, Laurent Godard wrote: Hi try the navigator press F5 key HTH Laurent D'oh! Yes, I'd never thought of using it in Calc. Thanks, L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker

[users] Help with form input

2010-11-18 Thread Gordon Burgess-Parker
I have need to construct a database-type form (it needn't BE in Base - Calc would do) such that when a future date is inserted in a particular field, it generates a calendar reminder (say) 10 days before the date in the field. I suspect that that may be relatively easy using something like

Re: [users] Calc: How to see list of sheets

2010-11-18 Thread Bruce_Martin
Dear Laurent: I create this easily on a regular basis in Calc, However it is not just 1 click. I add an extra sheet at the beginning (leftmost tab) then add hyperlinks to each of the sheets in Column B or C. Column A is a sequence number (or a priority number) so that I can sort by

Re: [users] Calc: How to see list of sheets

2010-11-18 Thread Johnny Rosenberg
Den 2010-11-18 14:22:19 skrev L Duperval lduper...@yahoo.com: Hi, In Excel 2K3 Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. -- Kind regards Johnny Rosenberg

[users] JPG format

2010-11-18 Thread mansoor
  Hi, I have downloaded openoffice and now using it, 2 questions pls   1-in the  spreadsheet printing  I can not see options as those are in the MS office such as print area,page layout ,. 2-How can I change  ods and XL format to JPG.   thanks for your advice  

[users] Cross references in an index?

2010-11-18 Thread John Jason Jordan
Using OOo 3.2.1 on Fedora 13, x86_64. I am trying to learn how to generate an index. I've pretty much figured out how to create index entries, but what if I want to create an index entry that just says See or See also followed by another index entry? For some reason the GUI confuses the heck out

Re: [users] JPG format

2010-11-18 Thread RA Brown
On Thu Nov 18 2010 09:34:14 GMT-0800 (PST) mansoor wrote: Hi, I have downloaded openoffice and now using it, 2 questions pls 1-in the spreadsheet printing I can not see options as those are in the MS office such as print area,page layout ,. Most of the settings that deal with page

Re: [users] Re: Removing line breaks in Open Office writer, etc.

2010-11-18 Thread Hagar de l'Est
See also that topic, there is a link to a nice macro: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=2585 Hagar Le jeu. 18 nov. 2010 08:08:21 CET, Mike Scott m...@scottsonline.org.uk a écrit : On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to

Re: [users] JPG format

2010-11-18 Thread Mike Scott
On 18/11/2010 19:28, RA Brown wrote: 2-How can I change ods and XL format to JPG. thanks for your advice Not quite sure what you looking for here but I see no way to save as or export images from Calc. That being said charts and data can be copy and pasted into either Draw, and saved as

Re: [users] Re: Removing line breaks in Open Office writer, etc.

2010-11-18 Thread Mike Scott
On 18/11/2010 19:45, Hagar de l'Est wrote: See also that topic, there is a link to a nice macro: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=2585 Thanks for the reference. Looks long - I'll take a proper look later. -- Mike Scott Harlow, Essex, England

Re: [users] Re: Removing line breaks in Open Office writer, etc.

2010-11-18 Thread Richard Detwiler
Mike Scott wrote: On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse

[users] Re: Calc: How to see list of sheets

2010-11-18 Thread L Duperval
On Thu, 18 Nov 2010 16:45:23 +0100, Johnny Rosenberg wrote: Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. Well, you learn something new every day. ;) L -- Get free public speaking and

Re: [users] Filters - mistake in wiki documentation?

2010-11-18 Thread Brian Barker
At 13:32 18/11/2010 +, Phil Hibbs wrote: Can someone please confirm if this is correct: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Filters After applying a filter, some rows are visible and some rows are not. If you select multiple rows in one

[users] Re: Re: Writer problem

2010-11-18 Thread Maurice Batey
On Wed, 17 Nov 2010 16:17:43 +, Harold Fuchs wrote: Page1 is in a section on its own so it can have its own page characteristics - size, orientation etc. It has my sender info in the place (and tiny font) I prefer and an empty text box into which I paste the name address of the

Re: [users] JPG format

2010-11-18 Thread Bruce Martin
Dear Mansoor: Why you want to export a spreadsheet to a bitmap format is puzzling, however... There are many ways to skin a cat: In Windows, you could print it to a number of different apps that accept input as a virtual printer driver. This includes .PDF Creator and However, you will

[users] Re: JPG format

2010-11-18 Thread Bob Long
Bruce Martin wrote, Dear Mansoor: Why you want to export a spreadsheet to a bitmap format is puzzling, however... There are many ways to skin a cat: In Windows, you could print it to a number of different apps that accept input as a virtual printer driver. This includes .PDF Creator and