[users] Re: Help!!
At 18:53 06/02/2012 +, Elena Vonly wrote: i don't know if you speak italian or english ... I can do English! ... and i don't know if you will read this mail..but I'm going [] crazy so i try to send it! I need a very important information: my open office program don't want to put numbers in the last two pages of my document, made of 52 pages. The first page begin with the number 3 and from number 3 to 52 there aren't problems...but the last two pages, 54 and 55, are without number! WHY? You have probably set the page number to start other than at 1 using the Offset value in the Edit Fields panel. Perversely, it seems that page numbers set this way cannot exceed the actual number of pages in the document. There are 52 pages in your document and no page number larger than 52 will be displayed. Possible workarounds: o Create two empty pages at the start of your document. o Number the pages normally. o Print only pages 3 to 54 - numbered 3 to 54. o Put the cursor at the start of your document. o Go to Insert | Manual Break... . o Select "Page break". o Under Style, select your existing page style from the drop-down list. o Tick "Change page number". o Set the value below to be "3". o Print all but the first (empty) page. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Data Base Litriture
Is there a book that I can purchase with instructions for using your data base? Brian Smith -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
At 22:31 29/01/2012 -0600, Wade Smart wrote: On Thu, Jan 26, 2012 at 20:07, Brian Barker wrote: At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99="Black";C1:C99="x") The conditions are either TRUE or FALSE. Â When interpreted as numbers, these values are 1 and 0 respectively. Â The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. Â The resulting true (=1) values are then summed. I need to add one more step to this. I have another column.. D lets say. It has a number in it. In my original example I needed to count a entry if it was active. So I have a lot of entries with Black as one indicator and some of those Black entries will have an "x" in another column. I needed to sum those up. And sumproduct() did great. Now I would like to see if there is a automated way of doing this next step: If A1=Black and C1="x", I need to sum column. AB. (Er, is that D or AB?) Easy: =SUMPRODUCT(A1:A99="Black";C1:C99="x";AB1:AB99) SUMPRODUCT() can take more than two arguments. As before, the product of the first two logical tests is either TRUE (1) or FALSE (0). Now we multiply each value in column AB by this switch and then sum the results. I trust this also helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99="Black";C1:C99="x") The conditions are either TRUE or FALSE. When interpreted as numbers, these values are 1 and 0 respectively. The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. The resulting true (=1) values are then summed. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Text effects and pictures
At 12:09 15/12/2011 +, David Hatton wrote: On a previous computer my writing system included "Insert" which when clicked gave access to a variety of text effects (decorative writing, some with coloured shadows, some in the shape of a rainbow, and others) ... In OpenOffice, this is called Fontwork. o Go to View | Toolbars > | Fontwork or View | Toolbars > | Drawing. o Click the Fontwork Gallery icon in the toolbar. ... and also to a very wide range of pictures. Clip art? No, this does not exist in OpenOffice, but there are plenty of sources for this on the web - many of them free of charge. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: FW: read immediately ~ serious
At 18:11 15/12/2011 +0200, Ian Samson wrote: The only way to protect yourself from these idiotic e-mails is to simply delete them on arrival. But instead of doing what you suggest, you sent *another copy* of the message to a mailing list which is distributed to thousands of people around the world. Hmm ... Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Help with Styles
At 16:56 15/12/2011 +, Mike Scott wrote: On 15/12/11 16:30, Sharon Plate wrote: I defined a new style which I applied to one document but I would like to be able to use this style in other documents as well. I know there must be a way to do this but I don't know where to begin. Can someone point me in the right direction? Open the stylist window - the minuscule drop-down list at the top right of it offers a 'load styles' menu entry. Select that, then 'from file' in the resulting window. That will copy /all/ styles (well, most! There seem to be a few defaults that don't copy). Which may or may not be what you need -- I know of no way to copy just one style -- short of editing the xml by hand, that is :-) There is a way to do this, in fact: o Open the destination document. o Go to File | Templates > | Organize... . o Select Documents from both drop-down menus at the bottom of the Template Management window. o Click File... and browse to and open the document which is the source of the style. (Alternatively, you can just open this document first as well.) o Double-click the source document and then the Styles icon in one panel to display its styles. o Repeat for the destination document in the other panel. o Drag individual styles between documents to move them or - more sensibly, perhaps - Ctrl+drag them to copy them. You say that you wish to use the style in "other documents" - in the plural. Note that the above technique can be used to copy styles into templates, and this may be more appropriate to your needs. Once a style is in a template, it will appear in any document based on that template, of course. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: using functions inside functions
At 06:52 22/11/2011 -0600, Wade Smart wrote: On Tue, Nov 22, 2011 at 02:02, Brian Barker wrote: > =SUM(C35:C40)-9*INT(SUM(C35:C40)/10) Brian, the values of C35 - 40 are (right now) 4,1,5,9,5,3 = 27 2 + 7 = 9 But when I used your function it produces 0 I'm not sure what you are doing wrong, but the formula does work, as you can see by following it. Using your example, the sum is 27, which is first divided by 10, giving 2.7. The INT() function then returns the whole number part of this, which is 2. This is multiplied by nine, giving 18. Finally, this is subtracted from the sum (27), giving 9 - exactly what you expect. If you get zero, you must have entered the formula wrongly or made some other mistake. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: using functions inside functions
At 19:52 21/11/2011 -0600, Wade Smart wrote: =IF(LEN(SUM(C35:C40))>1,LEFT(C56,1)+RIGHT(C56,1)) I'm summing a set of numbers into a cell. If the number is over 1 digit - and it always is, ... If it always is, you can dispense with the test. ... I want to take the left and right digit and add them together. Is the sum always two digits, not more? If so, use: =SUM(C35:C40)-9*INT(SUM(C35:C40)/10) This will also work with single-digit sums, in any case. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Writer: Changing colour of paragraph separator line
At 18:42 25/10/2011 +0200, Dotan Cohen wrote: In Writer one can add a paragraph separator by putting four dashes on a line then pressing Enter. Actually, that's at least three hyphens. However, this line is always black, no matter the colour of the text font. How does one change the colour of this line? Although you can see this as a paragraph separator, Writer sees it as a border attached to and part of the preceding paragraph. With the cursor in the preceding paragraph, go to Format | Paragraph... | Borders | Line | Color (or right-click | Paragraph... | Borders | Line | Color) and select the desired colour from the drop-down list. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Welcome page loop
At 15:19 22/10/2011 -0400, you wrote: I uninstalled OpenO; then deleted its Folders;rebooted; reinstalled. When install completed, the Welcome screen had my ID info from before; ... OpenOffice creates a profile for each user with configurations and settings. In order to preserve these settings across a repair, reinstallation, or upgrade, the profile is intentionally not affected by removing the product. ... Oo did not start. . . . and closed after [Finish]. This happened 3 times. Same result trying to open a file created before I had in uninstall. (Files would open, but could do nothing with them = program (not responding). It's likely that your problem is in the profile. If you delete that - or rename it, so that you can resurrect it if necessary - OpenOffice should create you a clean one next time you open it. Quite where it is depends on your operating system, of course - but you have kept that a secret! You appear to be using Windows 7. Try this: o Close OpenOffice and the Quickstarter. o Navigate to C:\Users\\AppData\Roaming\OpenOffice.org\3, where is the name you log in with. (Some of those folders are hidden by default.) o Rename the "user" folder within it. o Start OpenOffice to test. I trust this helps. Brian Barker - privately -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Time representation in Writer
At 23:59 22/10/2011 +1100, Bruce Lloyd wrote: I was making a timetable in a table in a document in Writer and having trouble getting time to show properly and wonder if there is a way to change the configuration. The problem is when I want to write a time as '8.30' Writer automatically truncates it to '8.3' if I use a colon then Writer automatically makes it 8:30:00 (or was it 08:30:00) which is equally unsatisfactory. The only way I could overcome the problem was make the time '8.31' or use a comma '8,30'. If I needed '8.00' it ended up as '8' unless I wrote it as '8,00' I can't see why Writer bothers with such things as removing a zero from the end of a decimal and presumably the problem/solution is in table properties or Auto Correct or Auto Complete but I could not find it. It doesn't seem to happen when 8.00 is written in text just in a table. Is there something I can change? It bothers because it thinks that when you insert values into a table you will want to treat them as values, not text, and to do calculations with them - e.g. to sum of a column of figures. In your case, values with a point are interpreted as numbers, not times (though this will be locale-dependent). As you have discovered, using a colon as separator tells Writer to interpret the values as times. As others have said, you can modify the format of numbers or times at Table | Number Format ... (or right-click | Number Format...). But I'm guessing that you don't wish to do calculations with your values at all and just wish to enter the values without their being interpreted and reformatted. If that is so, simply go to Tools | Options... | OpenOffice.org Writer | Table | Input in tables, and remove the tick from "Number recognition". Without the tick, values remain as you enter them. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Calc: Sort double columns
At 13:40 03/10/2011 +0200, Dotan Cohen wrote: I am reviewing the records of a local shop to help him convert to Open Office. I have found no problems with the simple Word documents that he uses, but he is using MS Excel where he should have a real database. [...] In this particular case, he has information that should be in a single row (record) divided into to rows, with the A column's cells merged between the two and the "sorting key" stored in that cell. He now wants to sort based on the merged cells, keeping the dual-row records intact. Example: --- 1 | Some info | More info --- 3 | Yet some more info | And more info --- 2 | Some important info | More important info --- He now needs to sort that! Does anybody know how this can be done? Trying the regular sort function returns an error that range containing merged cells can only be sorted without formats. That error is a trivial problem: when you sort, just go to the Options tab in the Sort dialogue and remove the tick from "Include formats". Example document here: http://dotancohen.com/images/examples/sort-example.ods At 12:15 07/10/2011 +0200, Dotan Cohen wrote: The issue is more of a mess than I thought! Not only does the user need to sort on double rows, but the number that he is sorting on is not unique! Therefore, simply creating a second cell with a derived sort number will not work. That's not true. Try this: o Choose a column for your sort key; I used column G. o In G2, enter: =IF(A2=0;G1;A2+ROW(A2)/1000) o Fill that formula up to G1 and down the rest of the relevant part of column G - or just copy it, select the relevant part of column G, and paste. o Select all the material to be sorted, and sort on column G (with "Include formats" unticked). Your double rows with identical keys in column A will be sorted properly and will stay - as between themselves - in the same order as they were before the sort. I'm assuming that you don't have more then 1000 rows of this data; otherwise you'd have to increase the divisor in the formula. You can either delete or hide column G afterwards if you prefer. You'll want to keep it if you'll need to sort additional data later. Why did I start with G2 instead of G1? Well, the formula in G1 makes reference to G0, but that is no problem if you start with G2. If your table started anywhere other than in row 1, you could compose the formula in the first row of the table without problem. It looks like the real choice here is to either stay with his current solution, or to move to a real database (as it was in the very beginning). Or use Calc ... I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Paragraph Styles
At 14:28 17/09/2011 -0500, Dale Erwin wrote: I have defined some custom paragraph styles in a loop so that I can enter several similar paragraphs without having to stop and format each one as I go. Some of them are normal and some of them are bold. One of them is in a larger point size and different typeface. As I type in my information, every time I press the Enter key, the next line begins the new paragraph and it is reflected in the highlighted paragraph style name in the Styles window, however, it always carries with it the same font characteristics of the previous paragraph, regardless of what is defined in the style for this paragraph. I cannot reproduce what you describe, so perhaps there is something else that you are doing. I notice that if local character-level formatting is applied to the end of one paragraph, then the new paragraph generated by pressing Enter will have the correct paragraph style applied - a different one in your case - but will also inherit the same character-level formatting. Is that what you are seeing? The way to test this would be to select the text of the new paragraph, or part of it, and then use Format | Default Formatting (or Ctrl+M) to cancel the character formatting. Do you then see the effect of your new paragraph style correctly? If I open the styles window and double click on the ALREADY HIGHLIGHTED style name, then the proper formatting will be applied to my text. Oh, I don't see that either in my scenario, so perhaps - after all - it doesn't explain your problem. I find this extremely annoying and wonder what purpose the styles serve if not to prevent this very thing. No doubt I'd find it annoying too, if it were happening to me. I trust this helps (but fear it may not). Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Numbering
At 19:59 25/08/2011 +0300, Stavros Hoia wrote: 1. How can I put continuous page numbers on top of every page, except the first? Headers - where you will put your page numbers - are a property of page styles. If you want a header on some parts of your document but not others - or headers with different contents - then you need different page styles for those parts. You could create your own styles if necessary, of course, but you may find that the standard First Page and Default page styles will suffice. o Go to Format | Styles and Formatting (or use the Styles and Formatting button in the Formatting toolbar, or press F11). o Click the Page Styles button. o With the cursor in the first page of your text, double-click the required page style - probably First Page. There are two ways that you can engineer the change from First Page on the first page to Default on later pages. Which you choose depends on the nature of your document. If your text flows naturally across from the first page to the second, you would need the change to occur at that point, wherever in the text that happened to be. You would do this by defining a Next Style on the Organizer tab of the page style - and you will see that First Page's Next Style is already set to Default, so that has been taken care of. Default's Next Style is Default, so your first page has First Page page style and all others will have Default page style. There is another method which suits different cases. Where there is a clear separation between the material that must occur on the first and second pages, you will anyway wish to insert a manual page break at this point. And you can make the change in page style explicit at that point: o Go to Insert | Manual Break... . o Under Type, select "Page break". o Under Style, select Default from the drop-down menu. If you now insert a header containing the Page Number field into the Default page style, you will see that your numbering will start at 2 on the second page. You can insert an empty header into the First Page style for easy symmetry of margins if desired. To insert the header and page number: o Go to Insert | Header > | Default. o With the cursor in the header, go to Insert | Fields > | Page Number. o Format the inserted number as required. 2. How can I put a different heading (top left and right) on each of the two columns that I have divided my page? Put the required text into the header. You could have these left and right, as you suggest, or centre each over its column. Do you perhaps want these texts at left and right along with the page number in the centre? o You will see that the header already contains helpful tab stops: a centre tab stop at the middle of the page and a right tab stop at the right text margin. o Enter your left-aligned material, a tab character, the Page Number field, another tab character, and your right-aligned material. o If you prefer the text centred over the columns, you can add additional centre tab stops suitably positioned in the header. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: divide page in half?
At 19:04 24/08/2011 -0400, Helen Etters wrote: ... when I turn the page back to Portrait, ... You can "turn the page" only after you have printed it - and then you are back to cutting or folding! Choosing an alternative orientation doesn't rotate what you have already created on your page: it just reformats what you have into the new arrangement. Pick the orientation you need and don't mess with the other: that won't help. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: divide page in half?
At 18:28 24/08/2011 -0400, Helen Etters wrote: I guess this question is too simple to be taken seriously ... Not necessarily. How can I divide a page (8.5x11 sheet) in half horizontally, landscape mode. I mean, and get it exactly right. The simplest way would be with a pair of scissors - or by folding. If that's not what you need, then you do need to say exactly what you want to do with the two halves. Here are a couple of suggestions: o Go to Format | Page... | Page, observe the Height and Top and Bottom Margins, and calculate the height of the resulting text area. o Go to Table | Insert > | Table... . o Change Columns to 1, optionally remove the tick from Border, and click OK. o With the cursor in the table, go to Table | Select > | Table to select both cells. o Go to Table | Autofit > | Row Height..., remove the tick from "Fit to size", and enter a value for Height of half the the text area height you calculated above. (You may have to choose a value very slightly less than this to allow both rows to stay on the page.) (There ought to be a way to choose the table height and then get the two rows automatically to take half each, but I don't see one. "Space Equally" and "Distribute Rows Equally" change the table size, which is not what we want here.) o Go to View | Toolbars > | Drawing, to display the Drawing toolbar. o Click on the Line symbol in the Drawing toolbar: the cursor becomes cross-hairs. o Click at the left edge of the page and drag a line across the page to the opposite edge. Take care to hold down the Shift key as you release the mouse button: this will ensure the line is exactly horizontal. o With the line you have created still selected (so it shows the two green handles), go to Format | Object > | Position and Size... | Position and Size. o Under Position, for Vertical select Center and for "to" select "Entire page" or "Page text area". I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Print questions.
At 23:36 11/08/2011 +0200, Erik P. Olsen wrote: How do I print watermarks with Oo ... Try this: o Open a new drawing (Draw) document. o Click on "T" (Text) in the Drawing toolbar and drag a text box on your document. o Type your watermark text. o Adjust the type size (you can enter sizes larger than those offered by typing in the box) and select a text colour (Gray 20%?). o With the text box selected, go to Format | Position and Size... | Rotation | Rotation angle (or right-click Position and Size... | Rotation | Rotation angle) and perhaps adjust Angle. o With the text box selected, go to Modify | Convert > | To Bitmap (or right-click | Convert > | To Bitmap). o Right-click the converted graphic, select Save as Picture..., and save the graphic in a suitable format. (You are saving just the graphic here, not the complete Draw document.) o Discard your Draw document. o Open your text (Writer) or spreadsheet (Calc) document. o For each required page style, go to Format | Page... | Background | As (or - in Writer - right-click | Page... | Background | As) and select Graphic. o Under File, browse to your saved graphic. o Under Type, probably select Position. ... and how do I specify duplex print? Go to File | Printer Settings... | Properties... . You can also set this on the fly at File | Print... | Properties... . Alternatively, you can probably set your printer to default to double-sided through your operating system's interface to the printer. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Message distribution : Authorization denied
At 09:28 15/08/2011 +1200, Paul Monly wrote: I'm guessing that the original poster (jjrig...@gmail.com) has a question that they haven't been able to get an answer to. See http://user.services.openoffice.org/en/forum/viewtopic.php?f=50&p=199482 . Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Moving table to different part of document.
At 17:18 07/08/2011 +0300, Dotan Cohen wrote: On Sat, Aug 6, 2011 at 20:42, Brian Barker wrote: In Writer, when inserting a new table it takes the width of the page. By default, yes - but that can easily be modified. How to modify that Brian. I've gone through everything* but cannot find it. Click in the table and go to Table | Table Properties... | Table (or right-click | Table... | Table) and adjust the parameters there. Or just drag the table boundaries. Tell me, what do you know about PIV systems? :) Positive infinitely variable speed control? Primate immunodeficiency virus? Peak inverse voltage? Peripheral intravenous access? Personal identity verification? Er, very little! Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Creating a double column screenplay view.
At 18:24 06/08/2011 -0400, William Case wrote: Dotage must be setting in. I wouldn't assume that. I set this up a couple of years ago with no problem, now I am having all kinds of frustration. I want to set it up myself and not rely on a template. Here is what I want. Two columns with a section split for each item across the two columns so that words can be added in each section and the section lengthened with out distorting the rest of the document. For example: Voice Visual - -- Blah blah blah blah description of wonderful blah blah blah blah things to be seen blah (some kind of section break -> Another blah blah blah description of wonderful blah blah blah blah stuff that goes with Another blah (some kind of section break -> etc. What you need is a table, with two columns and many rows. You may want the table to have no borders. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Moving table to different part of document.
At 13:54 04/08/2011 +0300, Dotan Cohen wrote: In Writer, when inserting a new table it takes the width of the page. By default, yes - but that can easily be modified. I have three different situations that I cannot make my table fit: 1) Place the table in the upper right corner of the page and have the text flow around it. 2) Place the table in the vertical-middle of the page on the right side and have the text flow around it. 1) Place the table on the bottom of the page, full width. (Er, would that be "3"?!) I think tables behave like text, so other text precedes or follows them, with the results that you see. Right clicking the table and playing around with the context menu items yields me nothing. Dragging the margins of the table prevents text from flowing around it. Putting the table in a footer leaves a newline below the table. You can avoid all your problems, I think, by putting your tables in frames. Frames can be manipulated in the ways that you need, specifically with other text wrapping around them - and indeed in variety of ways. The frame need have no border and need have no spacing from the contained table, so it can be totally invisible in the final result. And to answer the point in your subject: you can drag the completed table-within-frame around the page easily as you need. Oh, and that empty paragraph below a table: go to Format | Frame/Object... | Type | Size | Height (or right-click | Frame... | Type | Size | Height) and remove the tick from AutoSize. Now you can reduce the frame height to cover this. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Foutje in OpenOffice.org 3.3 leesmij bestand
Sorry, but I do not write Dutch. At 09:40 03/07/2011 +0200, Paul van den Berg wrote: Ik heb zojuist OpenOffice gedownload en geinstalleerd en ben direct al binnen het eerste leesmij bestand tegen een stukje tekst in het Grieks of een andere taal aangelopen. That's not Greek: it's Cyrillic script. The paragraph in Cyrillic is a direct transliteration of the previous paragraph in the Latin alphabet. And both paragraphs are part of the text which are obviously meant to appear in the Serbian version of the readme file - but probably not in the Dutch version which you presumably downloaded. I don't think anything is missing from the Dutch text you have, in fact. Omdat ik nog niet precies weet waar en bij wie ik dit precies moet melden doe ik het even via dit adres in de hoop dat jullie het doorzetten naar degene die dit aan kan passen. I hope someone else can tell you how best to report this problem. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Installation failed on dependency of libfreetype.so.6
The problems seem disappeared when I install RPMs directly under RPM directory using the following command: rpm -ivh *.rpm cd desktop-integrations rpm install one of desktop integration which fits your system. It seems the GUI installation method using "setup" script will have this prolem. Brian From: brian@hotmail.com To: users@openoffice.org Date: Fri, 24 Jun 2011 15:41:12 + Subject: [users] Installation failed on dependency of libfreetype.so.6 Hi, I'm installing OO3.3 to my redhat x86_64 machine, it failed with the following info.: error: Failed dependencies: libfreetype.so.6()(64bit) is needed by ooobasis3.3-core04-3.3.0-9567.x86_64 libgnomevfs-2.so.0()(64bit) is needed by ooobasis3.3-gnome-integration-3.3.0-9567.x86_64 libgconf-2.so.4()(64bit) is needed by ooobasis3.3-gnome-integration-3.3.0-9567.x86_64 but those 3 libraries can surely be found within my system. /usr/lib/libfreetype.so /usr/lib/libfreetype.so.6 /usr/lib/libfreetype.so.6.3.10 /usr/lib64/libfreetype.so /usr/lib64/libfreetype.so.6 /usr/lib64/libfreetype.so.6.3.10 /usr/lib64/xorg/modules/fonts/libfreetype.so /usr/lib/libgnomevfs-2.so /usr/lib/libgnomevfs-2.so.0 /usr/lib/libgnomevfs-2.so.0.1600.2 /usr/lib64/libgnomevfs-2.so /usr/lib64/libgnomevfs-2.so.0 /usr/lib64/libgnomevfs-2.so.0.1600.2 /usr/lib/libgconf-2.so.4 /usr/lib/libgconf-2.so.4.1.0 /usr/lib64/libgconf-2. so.4 /usr/lib64/libgconf-2.so.4.1.0 Can anyoen please help on this issue? My system info is as follows: "Linux localhost.localdomain 2.6.18-238.el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux" "Red Hat Enterprise Linux Server release 5.6 (Tikanga)" [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libfreetype.so no package provides libfreetype.so [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libfreetype.so.6 freetype-2.2.1-28.el5_5.1 [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libgnomevfs-2.so.0 gnome-vfs2-2.16.2-6.el5_5.1 [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libgconf-2.so.4 GConf2-2.14.0- 9.el5 Thanks, Brian -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Copy and paste from Calc to Writer
At 21:53 27/06/2011 -0700, John Jason Jordan wrote: Is there any way to punch just the formatting through from Sheet 1 to Sheets 2-12? Yes: o Copy Sheet 1. o In the new sheet, click the upper left cell (where the row and column headers meet) to select all of the sheet. o Press Backspace to remove values. o Repeat for other sheets. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Installation failed on dependency of libfreetype.so.6
Hi, I'm installing OO3.3 to my redhat x86_64 machine, it failed with the following info.: error: Failed dependencies: libfreetype.so.6()(64bit) is needed by ooobasis3.3-core04-3.3.0-9567.x86_64 libgnomevfs-2.so.0()(64bit) is needed by ooobasis3.3-gnome-integration-3.3.0-9567.x86_64 libgconf-2.so.4()(64bit) is needed by ooobasis3.3-gnome-integration-3.3.0-9567.x86_64 but those 3 libraries can surely be found within my system. /usr/lib/libfreetype.so /usr/lib/libfreetype.so.6 /usr/lib/libfreetype.so.6.3.10 /usr/lib64/libfreetype.so /usr/lib64/libfreetype.so.6 /usr/lib64/libfreetype.so.6.3.10 /usr/lib64/xorg/modules/fonts/libfreetype.so /usr/lib/libgnomevfs-2.so /usr/lib/libgnomevfs-2.so.0 /usr/lib/libgnomevfs-2.so.0.1600.2 /usr/lib64/libgnomevfs-2.so /usr/lib64/libgnomevfs-2.so.0 /usr/lib64/libgnomevfs-2.so.0.1600.2 /usr/lib/libgconf-2.so.4 /usr/lib/libgconf-2.so.4.1.0 /usr/lib64/libgconf-2.so.4 /usr/lib64/libgconf-2.so.4.1.0 Can anyoen please help on this issue? My system info is as follows: "Linux localhost.localdomain 2.6.18-238.el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux" "Red Hat Enterprise Linux Server release 5.6 (Tikanga)" [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libfreetype.so no package provides libfreetype.so [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libfreetype.so.6 freetype-2.2.1-28.el5_5.1 [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libgnomevfs-2.so.0 gnome-vfs2-2.16.2-6.el5_5.1 [brian@localhost OOO330_m20_native_packed-1_en-US.9567]$ rpm --query --whatprovides libgconf-2.so.4 GConf2-2.14.0-9.el5 Thanks, Brian -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] OOo Calc Produce a table from external data
Title: Kind regards Hi Help please I am trying to perform the function =IF(Test; ThenValue; OtherwiseDo Nothing). i.e. by do nothing I mean to leave whatever value is in the cell, - leave it untouched. Why ? (in case you ask) I have 2 columns - a date column (A) & a value column (B) I download some data from an external source which is a date & a value, say on 10/06/11 the value is 100 These go into "dummy cells", e.g. Y1 and Z1. I want to make & keep a small table of DATE and VALUE so Cell A1 is tested for being 10/06/11 & if true, Cell B1 is filled with the number 100 The next day, new data is downloaded into Y1 and Z1 so the old downloaded data is overwritten by 11/06/11 & say 120. In my "date column" I already have 11/06/11 & I want to put the new value, 120, into B2 and KEEP the previous value of 100 in B1 (The next day Y1 & Z1 will be overwritten with 12/06/11 & say 114 so I want to keep all the previous data & put 114 into B3) Any help much appreciated. Kind regards, Brian
[users] Re: corrupted file? recovered loop
At 11:12 10/06/2011 +0200, Ignasi Gispert wrote: Just when I was going to print out attached file, opennoffice just made a "loop" by "recovering" "recovery ok" & "recovery failed" and appear again the "recovering", etc etc. File can be viewed for few seconds and the "loop problem" starts again. Have 3.2 openoffice version. Windows XP. The behaviour is the same in my version, 3.1.1 for Windows XP. Any idea? Yes. I've opened it in Microsoft Word 2007, made an inconsequential change, and saved it again as .odt. It now opens safely in OpenOffice Writer. I doubt whether thousands of list subscribers want to see the result, so I'll send it to you privately. There are evident style changes, so you will have to do some work to put the document back into shape. This would have been easier if you had used styles instead of - as appears to be the case - local formatting, I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Find and replace special characters
At 14:43 28/05/2011 -0400, Ponly Jonly Honly wrote: I was given a DOC file where the writer had apparently typed Shift-Enter instead of Enter at the ends of paragraphs. How can I find and replace these with actual paragraph marks? Easy: use Find & Replace to Search for \n and replace with \n . In the Find & Replace dialogue, click More Options and enure that "Regular expressions" is ticked. How does this work? Look in the list of regular expressions in the help text: \n in the Search for text box stands for a line break that was inserted with the Shift+Enter key combination. \n in the Replace with text box stands for a paragraph break that can be entered with the Enter or Return key. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: BrOffice Writer
Sorry, but I do not write Portuguese. At 19:26 23/05/2011 +, Caio Cesar de Foggi wrote: Eu estou tendo um problema com o writer em relaçao a quando uso uma tabela nele . Aqui onde eu trabalho eu uso uns codigos que as vezes são descritos assim " 1.2.3" ex.Só que qnd vou enserir isso em uma tabela e vou mudar para outra linha o que era "1.2.3" passa a ser "01/02/03" como se eu tivesse colocando uma data . Já tentei de tudo só que continua a mesma coisa . Essa combinação de numeros só fica como eu quero quando não é possivel uma nada ex : "33.55.12" Seria alguma configuraçao que eu ainda nao achei ??? Yes. Go to Tools | Options... | OpenOffice.org Writer | Table | Input in tables, and remove the tick from "Number recognition". I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: anchor to character ???
At 14:11 16/05/2011 +0100, Mike Scott wrote: What /exactly/ is "anchor TO character" supposed to do in Writer? Naively, I would suppose a graphic (or whatever) so marked would "stick" to a given character, and move with it retaining a fixed relative position. But not so, it appears. [...] create a small ellipse ... anchor to char, ... But, if I then move the text around horizontally (space bar), the ellipse stays still. If I adjust the vertical position (enter), the ellipse follows. It's anchored to the character, but it is still positioned according to other options - and the default for horizontal appears to be to "paragraph area". If you want the graphic to move horizontally with the anchor character, go to Format | Object > | Position and Size... | Position and Size | Position | Horizontal (or right-click | Position and Size... | Position and Size | Position | Horizontal), and select Character from the drop-down menu for "to". Is 'anchor to character' just a misnomer for 'anchor to line'? I don't think of that as a misnomer. Vertically, the position of a character is simply that of the line of which it currently forms part. But as text is edited, the line in which any character appears is not a fixed quantity: you only have to add a single character, and the line you had before no longer exists. So "anchor to line" would make no sense, but vertically "anchor to character" is the same as "anchor to line of which this character from time to time forms part". I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Automatic URL recognition
At 18:12 15/05/2011 -0700, John Jason Jordan wrote: ... if there is a link in text copied and pasted into the Writer document it still underlines it and makes it clickable. That doesn't surprise me: you are pasting some hyperlinked text and whet you get is hyperlinked text. Quelle surprise! This happens even if I paste special. Er, if you use Paste Special and then select which mode of pasting? I'd expect most modes to paste the hyperlink - as they do for me. The one I'd expect not to paste the hyperlink is "Unformatted text" - and that does (in my 3.1.1 on Windows XP) what I expect. Does "Unformatted text" paste hyperlinks for you? Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Automatic URL recognition
At 10:22 15/05/2011 -0700, John Jason Jordan wrote: OOo 3.3.0 on Fedora 14, x86_64, from OOo, not from repositories. In Tools > AutoCorrect > Options I have unchecked URL Recognition, yet Writer still makes an URL underlined and clickable. Is there something else that I need to uncheck somewhere? There are two boxes against URL Recognition, one for typing and the other for modifying. Have you unticked both - or the appropriate one for your purposes? I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to turn off automatic numbering permanently?
At 19:28 14/05/2011 -0700, you wrote: ... now if I hit Enter at the end of a paragraph that is numbered Writer is assuming that I want the next paragraph numbered as well. I had this permanently turned off before, but now I can't find the setting in Tools > Options to turn it off permanently again. That's because it's not in Tools | Options... ! Can someone please point out where the setting is? Remove the tick from Tools | AutoCorrect Options... | Options | Apply numbering - symbol: *. Incidentally, a quick way to disable this if you have the option ticked but don't want it on a particular occasion is to use Edit | Undo (or Ctrl+Z) immediately it happens. This will undo the autocorrection but leave the normal effect of the keystroke which stimulated it - exactly what you want. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: draw, slide orientation
At 16:16 11/05/2011 +0100, Nobody Noname wrote: Is it possible to arrange slide 1 of a draw document as a4 landscape and slide 2 as portrait? In writer, this is normally possible via the use of styles. A workaround would be to copy the material you have created in two slides/pages in Draw and paste it into two pages with different orientation in a single text (Writer) document. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Alignment
At 20:26 02/05/2011 +1000, Bruce Lloyd wrote: [...] right text boxes (and Fontwork) are very particular where you right click on them. I had been clicking inside the boundary of one of the text boxes or clicking inside the boundary of the selection but after receiving your message I experimented more carefully and found that you have to click exactly on the boundary of one of the text boxes or objects in order to get the align menu. If you have several objects selected then these boundaries are very small/thin but if you don't have the four arrowed positioning icon showing when you right click it doesn't work. You may find another approach less fiddly. Go to View | Toolbars > and tick Align. This brings up the Align toolbar, which can float or be docked according to your choice. Its buttons will generally be greyed out but when you select a text box or Fontwork element they will become available. Selecting the relevant item in this way may well be easier than finding the right place to invoke the context menu. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: operateurs
Sorry, but I do not write French. At 23:47 22/04/2011 -0400, Michel Donais wrote: Je viens d'installer la version 3.1.1 d'OpenOffice. Dans Calc, si dans une cellule j'inscrit - ou + et que j'appuie par la suite sur une des fleches gauche - droite - haut - bas, j'ajoute a la cellule la valeur de la cellule suivante. Si par contre au lieu d'utiliser une fleche je fais retour alors j'obtiens seulement le signe - ou + dans cette cellule. This is because you can omit the equals sign at the beginning of a formula if it starts with a plus or minus sign. So Calc assumes you are starting a formula and interprets the move to another cell as your identifying the first reference in your formula. Dans la version 2 l'utilisation de la fleche donnait le meme resultat que faire retour presentement. Existe-il un moyen pour faire en sorte que l'utilisation des fleches donne le meme resultat que faire retour. You want the cell to contain just a plus or minus sign? In that case, you can indicate to Calc that you intend a text entry instead of the start of a formula by preceding your plus or minus sign by an apostrophe. If you type apostrophe-plus in a cell and then press an arrow key, you will leave just the plus sign as text in the cell. Note that the additional character needs to be a plain apostrophe, not a smart one. If you have Custom Quotes selected for single quotes at Tools | AutoCorrect Options... | Custom Quotes, you will need to use Edit | Undo (or Ctrl+Z) after typing the apostrophe to undo the autocorrection. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Find and replace issue
At 16:51 20/04/2011 -0400, Pat Brown wrote: In my Find & Replace the Whole Words Only option is grayed out. Match Case is there. Availability of this option is dependant on other options. In particular, it's disabled if you have "Regular expressions" selected. Click on More Options to display them; untick "Regular expressions" if it is ticked. Does that help? I use the option often and this is the first time I've noticed this issue. Note that the selection of "Regular expressions" sticks once you have selected it; perhaps you used it recently and have not unticked it. I trust this helps. Brian Barker - privately -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: oocalc and links - keyboard shortcut for clicking w. mouse-1?
At 16:02 05/04/2011 +0200, Anders Noname wrote: Is there a keyboard-shortcut which does the same as clicking (mouse-1) on an active link in a calc cell? My guess is that there couldn't be. There might be more than one hyperlink in any spreadsheet cell, and a single keyboard shortcut could not be used to choose between them. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Open Office "save as"
At 22:31 31/03/2011 -0600, Larry Gusaas wrote: To export as a PDF (files is redundant, that is what the F stands for) ... Not that it matters, but PDF = Portable Document Format. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: A Pointer to some doc please
At 17:34 26/03/2011 -0400, Wayne Spencer wrote: I am trying to find some doc on how to take a current document and make a template out of it. I did see this on the web, but I can not find it now. Any pointer please. Start at: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Chapters . You will see that there are many chapters available dealing with templates in different types of OpenOffice documents. But here's the quick version: o Prepare your template. If you are starting from an existing document, you will probably want to remove most or all of the text, leaving just the structure: styles, formatting, and so on. o Go to File | Templates > | Save ... . o Give the template a name. o Choose a suitable Category. o Click OK. To use the template, either click Templates... on the Welcome ("splash") screen or go to File | New... | Templates and Documents. If you prefer, you can save a template using File | Save As... and then selecting the appropriate template type under "Save as type:". If you then save the template somewhere convenient, you can simply double-click it (or a shortcut to it) in order to start OpenOffice if necessary and start a new document based on it. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: [Resetting file associations - not!]
At 13:10 21/03/2011 -0600, Larry Gusaas wrote: At 14:01 18/03/2011 -0400, Twayne Noname wrote: Or reinstall it, and this time tell it to not take over the shortcuts & file associations. There is not such option when installing OOo on a Mac. You gave a Windows specific answer for a Mac specific question. A Windows-specific answer? Really? Surely this was a no-operating-system-that's-ever-been-invented-specific answer? Once a product - in this case OpenOffice - has taken over file associations, simply reinstalling it and asking not to have them taken over for a second time is not magically going to reset them to whatever they had been before the first installation. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: printing word documents with labels or tables
At 22:07 17/03/2011 -0500, Michael Chase wrote: I have a problem printing Microsoft Word documents created before I began using OpenOffice, which have tables or labels. Nothing inside the tables or labels prints, or shows on the page preview. I can correct or modify the text inside the table, but it will still not show on the page preview or print. I am a neophyte, so not very technically-minded. OpenOffice Writer allows you to control the printing of tables globally. Go to Tools | Options... | OpenOffice.org Writer | Print | Contents, and tick the Tables box. Does that help? As you will see, there are other items that can be similarly controlled. I'm not sure what you mean by labels here - perhaps what Writer calls notes? If so, printing these can also be controlled under "Notes" at the same place. You can arrange not to print them, to print only them, or to collect them at the end of each page or of the entire document. But I notice (in my version 3.1.1) that Page Preview does not appear to show notes come what may: you need actually to print the document to see what happens. This is a situation in which it is handy to have a virtual PDF printer installed (free ones are available), since you can do a test print to that and see how any actual printout will appear - without wasting paper or toner. (Note that Writer's Export as PDF... function does not help here.) I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Mysterious Giant TABS
At 14:54 13/03/2011 -0800, Tim Johnson wrote: I am not trying to change the tab settings. You appeared to say you were: "Try as I might, I can't reduce it to .22 inches.", and your subject does refer to "Mysterious Giant TABS". You almost certainly should be changing tab settings. Crude or not sir, I just used that as a reference to illustrate the unwanted size. I was pointing out that using default tab stops instead of specific ones to suit the purpose of your paragraph or document was probably not the best way to proceed. That's general advice, not criticism. No help. Settings show as .22 inches Really? So you have tab stops at that interval at all three levels: default, paragraph style, and paragraph? That's overkill! Whoa there partner! :) I know that you are trying to be helpful, and indeed I did ask for help, but you are overwhelming me with information. You may think I was trying to solve your problem. That would be understandable, but I wasn't. I was trying to help you understand how tab stops work in Writer sufficiently that you could solve the problem for yourself. Let's keep it simple and succinct: Oh, dear: are you going to restate your problem - as if the difficulty is that I failed to understand it the first time? ;^) 1) I have set Tab stops as .22 inches. Default? In the paragraph style? In the paragraph? (Probably default.) 2) In all cases but one and only one, pressing Tab at the beginning of a paragraph inserts a Tab of .22 inches. a) Why that particular paragraph? For one of the reasons described in my earlier message - probably. b) How do I insert a Tab of .22 inches at that point *instead of the 3~ inch tab? In one of the ways described in my earlier message, depending on exactly what arrangement is creating the situation you describe. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Mysterious Giant TABS
At 13:02 13/03/2011 -0800, Tim Johnson wrote: I'm using OO 3.3 (debian install) on ubuntu 10.4. From Tools->Option->OpenOffice.org Write->General, I have set Tab stops at .22 inches. However, on occasion, inserting a Tab generates an enormous indentation of over 3 inches. Try as I might, I can't reduce it to .22 inches. How can I correct this? You've missed the important detail: what are you doing to try to change the tab setting? Tabs occur in Writer at three levels: the default for all documents, and as a property of paragraph styles and of paragraphs. The setting you describe at Tools | Options... is just the default for all documents, and sets tab stops only at regular intervals across the page. Look at the horizontal ruler at the top of the screen. You will see regular faint tick marks representing these regular tab positions. This is a rather crude - and indeed unreliable - way to space material across the page, and not to be recommended. In order to space material using tabs, you should set your own tab stops where you need them. You can insert tab stops in a paragraph style through the Styles and Formatting window; alternatively, right-click in a paragraph of that style and go to Edit Paragraph Style... | Tabs. To insert tab stops into a paragraph, go to Format | Paragraph... | Tabs (or right-click | Paragraph... | Tabs). Alternatively, just click in the horizontal ruler and then drag the resulting tab stop as necessary into position. You can also copy tab stop arrangements between paragraphs using the Format Paintbrush. If - as you imply - you have a tab stop at some position other than where your defaults are set, there is nothing mysterious about it: you have (or someone else has) set a tab stop specifically for that paragraph or paragraph style. You can move or remove these using the techniques described above. Note that you can remove a tab stop by simply dragging it off the horizontal ruler. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: OO Calc Year auto-input feature
At 23:49 09/03/2011 -0500, Robert Jackson wrote: I enjoyed the OO Calc Year auto-input feature, whereby "Mar 9 [ENTER]" becomes "Mar 9, 2011" (assumes the current year). However, after upgrading to OO 3.2.1, this feature no longer works, and "Mar 9 [ENTER]" now becomes "Mar 1, 2009". In general, mmm dd translates to 01-mmm-dd in the DDMMYY form. So the Month is retained, but the day as entered is translated to the last 2 digits of the YY and the DD becomes 01. I am using Win XP Professional Ver 5.1 SP3. Do Windows Regional and Language Options play any part in this? Very probably. In addition, there are OpenOffice's own locale settings at Tools | Options... | Language Settings | Languages. Try "9 Mar" instead of "Mar 9": that works for me (3.1.1 under Windows XP with UK settings). Also try "9/3" or "3/9" as appropriate - according to your locale. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Selecting all text in a Writer document
At 20:26 09/03/2011 -0800, Susan W. Dunn wrote: I must consolidate separate chapters into one long document. I have a great deal of trouble selecting sequential pages of the document I'm working on. The cursor will just stop somewhere. Is there some shortcut like a Select all that would select all the text and formatting with which I could cut and paste into the new, longer doc. Yes: it's called Select All! Go to Edit | Select All (or Ctrl+A). If your cursor is in a table cell, this will select only the text in that cell; just repeat the action to select the whole table and repeat it yet again to select the whole document. In other words, what would be the ideal way to concatenate these chapters in order not to have any unnecessary page breaks with the one single documents. One way is - as you are suggesting - to select the whole text of each document and copy and paste it into a single document. But here's another: o Open the first chapter. o Save it with a new name as the new (long) document. o Put the cursor at the end of the text, where you want chapter 2 to appear. o Go to Insert | File... and browse to and insert your chapter 2 document. o Repeat as necessary. If you have unwanted page breaks, you can remove them in the normal way. If they are manual breaks, put the cursor immediately after the break and press Backspace. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: How to select all the text in the document
At 09:26 25/02/2011 +0200, Dotan Cohen wrote: How does one select all the text in an OOo document? Edit -> Select All only selects the current table or table cell. With my version under Windows, Edit | Select All (or Ctrl+A) indeed selects the current table cell. But a second repeated operation selects the whole of the current table and a third selects all of the text. I cannot speak for your Linux. I trust this helps. Brian Barker -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] installing add ons on laptop.
At 16:48 16/02/2011 -0500, Robert Kingett wrote: I just want to ask anyone if they have had this issue and they know how to fix it. I have been trying to install add on on my laptop, but get this message. Could not create java implementation loader. Have you tried searching the web for that error message? What happened when you followed the suggestions at http://wiki.services.openoffice.org/wiki/Extensions_trouble_shooting and http://ubuntuforums.org/showthread.php?t=1321671 ? Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] footnotes
At 19:56 09/02/2011 -0500, Annie Lloyd wrote: I have Open Office 2, Windows XP, and Foxfire. I recommend that you discard Foxfire and install the more popular Firefox. Oh, and I have OpenOffice 3.1; I trust what I am about to suggest will be relevant. If not, you might want to update your installation. I'm doing a journal which is a large file consisting of articles within it. Two of the articles have footnotes. The first article had four footnotes and each one was numbered 1, 2, 3, 4. Now to the second article. It had seven footnotes. I wanted the footnotes to start as 1 thru 7 but it started as footnote 5 thru 12. How do you change the numbering so that the footnotes start with #1 on each article? Please let me know in layman's English. This is fairly easy if you make each of your articles separate sections. o Select each of your second and subsequent articles separately in turn. (It doesn't matter whether you do this for your first article.) o Go to Insert | Section... | Footnotes/Endnotes | Footnotes. o Tick "Collect at end of text". o Tick "Restart numbering". o Leave "Start at" set to 1. o Click Insert. You may think that "Collect at end of text" will move all the footnotes to the end of the section - in your case, of the article. But this is not so: instead, this setting merely allows you to have any remaining footnotes immediately after a section if it ends in the middle of a page. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Writer: Gradient on Line/Rectangle
At 21:05 06/02/2011 +0200, Dotan Cohen wrote: Time to spruce up the resume! I want to add to my resume a horizontal line with a horizontal gradient. I found two options, neither of the quite "work": 2) Use a Rectangle from the Drawing Toolbar. Next, I tried using a rectangle. I could get it to grade, but it stubbornly keeps a black border. How can I get rid of this border? I tried these settings: Context Menu -> Area -> Transparency -> Border -> 0% Context Menu -> Area -> Gradients -> Border -> 0% Neither worked. So how can the border be removed from a rectangle? Set Format | Object > | Line... | Line | Line properties | Style (or right-click | Line... | Line | Line properties | Style) to Invisible. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Page Numbering doesn't seem consistent (to me)
At 10:39 04/02/2011 -0900, Tim Johnson wrote: The test document is in ODF format (.odt). I want to set an arbitrary starting number for a page, starting at the second page of the document where the first page is a title page and has a different page style from the second and following pages. [...] At 10:54 05/02/2011 -0900, Tim Johnson wrote: I am looking at an ODF document where the numbering for the first page starts at 48. At the first page from the status bar on the left, I read the following: 'Page 41 1/19' '1/19' is correct and updates as I would expect, but what I am curious about is the 'Page 41' at page 1, why not 'Page 1'? The number following 'Page' increments by 1 as one moves from page to page. This is weird! One day you ask how to number pages other than naturally (from one) - starting from an arbitrary value, that is - and the next you express surprise at seeing a document in which precisely what you asked about has been achieved. OK, I'll bite! The author of your document has used one of the number of ways to achieve what you asked about: starting page numbering at some value other than one. You asked why; well, you may have to ask the author why s/he chose to do this. One obvious possibility is that the document was intended to be part of a larger work - a book chapter other than the first, perhaps, or an issue of a periodical for which page numbering continues consecutively through a number of issues constituting a single volume. At 12:12 05/02/2011 -0900, Tim Johnson wrote: Right clicked and select "Fields". "Show Page Variable" is shown under "Type" and "As Page Style" is selected under "Format" That shows one way of doing this. Somewhere - possibly immediately before this field and barely distinguishable from it, will be a "Set page variable" field, and this includes the facility to apply an offset. Position the cursor where you did before in the first such page - so that right-click | Fields... takes you to the "Show page variable" field. Press left-arrow once (to move in front of the other, almost invisible field) and repeat. Do you now see "Set page variable" and its offset? I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] My files are posted on the net
At 17:54 03/02/2011 -0800, John Jason Jordan wrote: I do not wish to post the link publicly, but I just discovered on the internet an early version of a copyrighted book that I wrote in OOo. This file never left my computer. I suspect you mean the .odt file that you attached to a submission to the Users list on Tuesday 24 March 2009. If so, it left your computer when you voluntarily sent it to the list. I also need to find someone who can remove it. I doubt you will. In any case, you would have to chase the (many?) other services which archive messages from the Users list. I trust this helps. Brian "Sherlock" Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mini-Corrector Removes Paragraph Indentation
At 14:18 03/02/2011 -0900, Tim Johnson wrote: FYI: I'm a programmer but don't use OO Writer myself, ... You are welcome to learn! We have installed the mini-corrector extension which does a good job of removing extra spaces from the body of text, but it also removes paragraph indentation - which is completely unacceptable. :( I haven't seen the extension, but my guess is that removing spaces would remove such indentation only if you had attempted to achieve the indentation by inserting consecutive spaces. That's typewriter thinking; please join this millennium and embrace word processing. In any case, if you use Find & Replace to reduce multiple spaces to single one (no extension required) you can go through them one by one, allowing the changes you want and denying the ones you don't. It's very easy: word-processor users do it all the time. I find that *if* I indent a paragraph by using the TAB key, the indentation remains, ... Good. That's better ... ... but of course a TAB is not a space. Indeed, but you don't want spaces and a tab is better. I find also, that although the specs that my wife is try to meet require *5 spaces*, ... You should laugh at whoever gave you this specification and tell them you are doing so. It makes no sense in a post-typewriter world. A typewriter space is a fixed width; in a word-processed document, it cannot be relied upon to be so. In justified text, five consecutive spaces will expand to allow the line to span the margins - just as single spaces do. If five consecutive space characters happen to occur at a natural line break, they disappear altogether! Your authority needs to understand this. I can't find a way for the TAB action to 'mimic' the 5 spaces and I doubt that there are. If you know how wide you believe five spaces to be (as I say, there is no answer to this, in fact), then you can certainly achieve what you want using tabs. Simply set a tab stop at the appropriate distance from the paragraph margin. The tab will then indent by the same amount irrespective of whether the paragraph is left aligned or justified. Better still, use the proper technique: set an appropriate indentation in the paragraph or paragraph style. Just go to Format | Paragraph... | Indents & Spacing | Indent and set a suitable value for "First line". Alternatively, go to right-click | Edit Paragraph style... | Indents & Spacing | Indent and do the same at a stroke for all paragraphs with the same style. The goal is to remove redundant spaces from within the text, but not from paragraph indentation. Just don't (mis)use spaces for this purpose. (Or use Find & Replace intelligently.) By the way, there is another lesson you can teach your authority. Indentation was necessary to indicate the start of a new paragraph in the days of handwriting on lined paper. It transferred fairly directly to typewriting, where the vertical spacing of lines was still regimented. But modern practice with printing and word processing techniques is often to space paragraphs slightly wider apart vertically than lines of the text are, and in this case paragraphs are clearly delineated and indentation serves no purpose. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Managing Spaces
At 08:01 31/01/2011 -0500, Gene Young wrote: On 1/31/2011 1:08 AM, John Jason Jordan wrote: On Mon, 31 Jan 2011 04:10:49 + Brian Barker dijo: Hmm. You're right. I never tried it until just now, but it doesn't work with spaces. To search and replace spaces you must use regular expressions and use [\x0009 ] as the search term for a space and a regular space (spacebar) for the replace with term. ie; Find; .[\x0009 ][\x0009 ] Replace with: . Note: There is a space after the dot in Replace with. This works as needed. (I tested it.) Sorry, but this is somewhat confused. First, I didn't write any of the above. Do please take care when you edit messages that you do not misattribute what was written. Second, the comment above that something didn't work with spaces was referring to AutoCorrect, not Find & Replace. Finding or editing such multiple spaces using Find & Replace had already been discussed successfully: that wasn't what didn't work. Third, your suggestion that spaces cannot be used naturally in the "Search for" field in Find & Replace is simply wrong: they can. There is no need for your complicated workaround, in fact. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Managing Spaces
At 19:55 30/01/2011 -0800, John Jason Jordan wrote: Actually, AutoCorrect is what I would use for all the issues, not just ' inc '. Typing will be faster because she won't need a notification of, e.g., a double space after a period, and then have to deal with the notification, if the 'period plus double space' is simply automatically corrected to 'period plus space.' I'd imagined that the questioner was talking about existing documents with surplus spaces, in fact, not just correcting them as they are inadvertently typed. But for what it's worth, I can't make AutoCorrect do this. Perhaps not surprisingly, entering dot-space-space for Replace and dot-space for With doesn't seem to produce the desired effect. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Problem with dislocate/change page number...
At 00:22 28/01/2011 -0300, Feitosa Gonçalves wrote: First of all, sorry for my bad english... On the contrary, it's quite clear (and much better than my Portuguese!). Hi, I'm a brazilian user and enthusiast of OpenOffice, I love the OO suite, but every time that I need to change/dislocate the number of the pages in some document, I always have the same problem: I just go in Insert>header>default; and after click in the header, I use Ctrl-F2 and insert the page number in the field, and everything works perfectly. But if I change some value in the menu Offset, to make some variation in the number of the pages, the pagination just disappear... Al the numbers, in all pages, just disappear. Same problem if I insert the number and click with the right button and select field and change the menu Offset... I don't know why OpenOffice behaves like this, but it does. In my experience, Writer is happy to change page numbers this way, but cannot cope with a number on any page which is larger than the actual number of pages in the document. Here's a workaround: o Don't set an offset where you have. o Instead, put the cursor in the first paragraph of the document. o Go to Format | Paragraph... | Text Flow | Breaks (or right-click | Paragraph... | Text Flow | Breaks). o Tick Insert and set Type to Page and Position to Before. o Tick With Page Style. o For "Page number", enter the first page number (not the offset). And here's another: o Forget the Page Number field. o Instead, go to Insert | Fields > | Other... | Variables. o Under Type, select "Set page variable". o Under Selection, select "on". o Under Offset, enter your offset. o Click Insert. o Under Type, now select "Show page variable". o Click Insert and Close. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Managing Spaces
At 16:29 30/01/2011 -0900, Tim Johnson wrote: FYI: Using OO on Linux 10.04. [...] 1) She wants to see a warning mark if there is more than one space between a punctuation mark and a following letter. There are almost no circumstances in which a properly word-processed document should have consecutive spaces. (I'd say none, but I won't labour the point. Oh, and before anyone notices: this e-mail is not word-processed but is going out as plain text, so that suggestion doesn't apply!) One thing to do, then, is simply to use Find & Replace to search for space-space and replace it with space. If you suspect more than two consecutive spaces, either simply repeat the search or else search for space-space-plus and replace with space - this time ticking "Regular expressions", which you will find hidden behind More Options. But if you really want to see what you describe, use Find & Replace, again with "Regular expressions" ticked. In Search for, enter something like [.,:;?!] + - that's a list of the punctuation marks you are concerned with, enclosed in (square) brackets, followed by two spaces and a plus sign. Now click Find All and all your occurrences will be selected (and highlighted). You can close the Find & Replace window to help you see what you have found. 2) She wants to be notified if there is a space before or after a hyphen. With "Regular expressions" ticked, search for - |- | - - that's space hyphen space pipe hyphen space pipe space hyphen. Again, click Find All. 3) She wants to treat common abbreviations such as 'Mr.', 'Mrs.', 'Ms.', 'Inc.' as known words in such a way as - for example - if she types ' inc ' (delimited by whitespace) a warning mark would be rendered and/or the Spell Checker would catch it. Use AutoCorrect. Go to Tools | AutoCorrect Options... | Replace, and add the individual cases you require. It is likely that some of these issues are already addressed by URLs that you good people might submit. That's a bit unlikely. Mind you, they might well be addressed by web pages to which such URLs lead. ;^) I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Help with Insert > Object > Formula
At 09:50 23/01/2011 -0800, John Jason Jordan wrote: At 18:55 22/01/2011 -0800, John Jason Jordan wrote: I need to create a stacked formula that looks like this (assume the braces are a single scalable brace on each side): [...] I still couldn't get the combining diacritics over the characters. They work fine in regular text in Writer, but not in the formula. That's a pity. Do persevere: they certainly worked for me (3.1.1 on Windows XP). I used the Unicode characters you mentioned, and they worked in the default Times New Roman Italic. I just have two small issues left: 1) The spacing between lines in the stack is too great. Go to Format | Spacing..., under Category select Spacing, and reduce the value for "Line spacing". Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Help with Insert > Object > Formula
At 18:55 22/01/2011 -0800, John Jason Jordan wrote: OOo 3.2.1 (from OOo) on Fedora 14, x86_64. I need to create a stacked formula that looks like this (assume the braces are a single scalable brace on each side): { OÌ } { OÌ } { UÌ } { AU } I need the diacritics over the characters and they must be added with the combining diacriticals in the font that I am using (Junicode). In case they didn't make it through the e-mail, the top O has a macron (U304), the second O and the U have short marks (U306), and the AU has no diacritics. The font does not contain these characters as combined glyphs so I must use the combining diacriticals. I cannot switch fonts. Although it doesn't appear in the e-mail, I need the stack center aligned. The best I have accomplished is this syntax: left lbrace alignc { #ï¯ Ì # O Ì # U Ì # AU } right rbrace This gives me a brace only on the bottom element, lots of ? marks, and an extra blank line in the middle. None of the combining diacriticals actually combine. Only the second element is center aligned. I hope there is someone here who understands the formula syntax, because it sure has me confused. To create the large braces, you need the "stack" instruction and one fewer hash marks: left lbrace alignc stack { aaa # b # cc # d } right rbrace (I've used simpler example elements here, so that it will come through more reliably in e-mail.) I don't see any way to insert special characters in the formula (Math) window itself. But it is perfectly possible to do so in a text (Writer) window - which I imagine you are composing in anyway - and then copy and paste them into the formula window. By doing this, I have been able to create exactly the effect and with the characters and diacritics you describe. You can change fonts at Format | Fonts... using Modify. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Shortcuts for special characters
At 16:25 22/01/2011 -0800, John Jason Jordan wrote: OOo 3.2.1 (from OOo, no the repositories) on Fedora 14 x86_64. I've searched and I can't find how to set the shortcut keys for entering characters with accents, or what shortcut keys exist by default. E.g., I wish to type á, é, ü, etc. in an English document. I do not wish to change to a different keyboard. I can enter the characters by Unicode code point, but that is a pain if you have a lot of them to do. The default shortcuts would probably suffice if I could just figure out what they are. Is http://documentation.openoffice.org/HOW_TO/various_topics/Howto_special_char.pdf any help? Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Help with Footnote Formatting Problem
At 15:12 13/01/2011 +1100, Adam Noname wrote: I'm having problems with large footnotes. When I add footnotes to a document I only see the first couple of lines of the footnote when in edit mode or Page Preview. Is there a setting somewhere to make footnotes dynamically expand as needed? Are you sure that you are not just seeing the intractable problem that occurs with large footnotes? Look at the next page: is the rest of the footnote there? When you insert a footnote, room has to be made for it at the foot of the current page. And yes: space is made available for it as necessary. That means that some of the page text that would otherwise appear on that page has to be carried over to the following page. So far, so good. But if the insertion point is near the bottom of a page or if your footnote is large (as you say yours are), there is a problem: that amount of text that needs to be carried over may include the insertion point itself. This creates an intractable dilemma: if the footnote is fitted into the current page, its reference will be carried over to the following page, but if the footnote follows it there the reference will move back to the previous page. In either case, the reference and the footnote will be on different pages. The solution to this problem is for the footnote to be split across two pages. As much as can be fitted in without carrying over its reference is placed at the foot of the original page, with the reference necessarily now being in the bottom line of text on that page. The remainder of the footnote appears at the foot of the following page, beneath the separator line but without any footnote number. This may be followed by footnotes that are referenced on that following page, of course. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
At 17:06 08/01/2011 -0800, Brewster Gillett wrote: But as it happens, that is *exactly* what I want. A blank line, every other row, demarcated by the half-tone grid I prefer. IOW a space in which to manually add new data as it arises, for later transcription. Aha! That wasn't clear anywhere ... 1. Put your spreadsheet values in alternate rows. That would have the exact effect I seek, but doing it reminds me so much of using a goose nib and an inkwell that I have a difficult time accepting it as a solution :-) Sorry, but if you want a grid with alternate rows empty, what is old-fashioned about constructing exactly that: a spreadsheet with alternate rows empty? Going back and manually inserting a row after every existing row, as in No. 1, doesn't even bear thinking about... Er, no-one suggested doing this manually. If you knew this was what you wanted, you could have entered your data this way originally, of course. If not, there will be fairly simple ways of converting what you have into what you want. Suppose, for example, you have data in consecutive cells of column A on Sheet1. In Sheet2, put into cell A1 =IF(ISODD(ROW());INDIRECT("Sheet1.A"&(ROW()+1)/2);"") Now fill this down the column. A1 on Sheet2 becomes a copy of A1 on Sheet1, A2 on Sheet2 is empty (a null string), A3 on Sheet2 is a copy of A2 on Sheet1, and so on. The ROW() function identifies the row number in which the formula appears. ISODD() distinguishes odd-numbered rows - in which a value is copied - from even-numbered ones - in which the null string is the result. (ROW()+1)/2 calculates the row number on Sheet1 from which the current value should be copied: row 1 from row 1, row 3 from row 2, row 5 from row 3, and so on. Concatenating this row number with "Sheet1.A" creates the description of the required source cell, but this is still a text string and not a cell reference. The INDIRECT() function makes this last conversion and retrieves the value you require. If you do this for a few columns and perhaps reconstruct formulae for any derivative columns, you will soon have what you need. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
At 13:14 08/01/2011 -0800, Brewster Gillett wrote: I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? First, it's not generally helpful to think of doing anything "double-space". This is typewriter thinking, where the hardware allows you to print lines only at well-regulated intervals. Computer printers are more flexible than that, and it is better to think of output from a word processor or spreadsheet as having additional spacing between lines or paragraphs or whatever. But no: I think you are right that there is no immediately obvious way to increase the spacing between rows of values. That probably makes sense, since if you are printing a grid you are unlikely to want space between neighbouring rows of the grid. There are many ways, though, of achieving what you probably want: 1. Put your spreadsheet values in alternate rows. 2. Increase the row height without changing the text size: o Go to Format | Row > | Height... (or right-click in the row headers | Row Height...) and increase the value there. o You may then wish to move the values to somewhere other than the (default) bottom of the cells (e.g. Middle), at Format | Cells... | Alignment | Text alignment | Vertical (or right-click | Format Cells... | Alignment | Text alignment | Vertical). 3. Increase the spacing above or below (or both) the text in your cells: o Go to Format | Cells... | Borders | Spacing to contents (or right-click | Format Cells... | Borders | Spacing to contents). o Untick Synchronize. o Increase the values for Top or Bottom (or both). I suggest technique no. 3 is probably the most flexible. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
At 13:12 08/01/2011 -0800, Brewster Gillett wrote: I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: "invalid sheet reference" In searching the list of error messages for Calc, I find no specific mention of "invalid sheet reference". I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Are you using OpenOffice version 3.1 as provided by/with Ubuntu? This appears to have been a bug in that version. See https://bugs.launchpad.net/openoffice-pkgs/+bug/374708 . I cannot reproduce your experience in my version 3.1.1 under Windows XP. What are you missing? Possibly the original version of OpenOffice. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
At 02:30 06/01/2011 +0200, Dotan Cohen wrote: On Mon, Jan 3, 2011 at 00:13, Brian Barker wrote: [...] Here's another suggestion: o Put a left tab stop at the right margin (er, or perhaps right at the left, depending on your locale!). o Press Tab followed by Enter the required number of times. o Select all the lines and go to Format | Character... | Font Effects | Underlining (or right-click | Style > | Underline, or click the Underline button in the Formatting toolbar). o If the entered text is not justified, this will leave the space at the end of each line not underlined. If this matters, you can add a Tab character at the end of each line. Thanks. Assuming Left to Right (it's not, as you properly guessed, but in the interest of a useful archive let's assume that it is) then what exactly is being accomplished here? I seem to have gotten lost after the second step, I must be putting the tabs in the wrong place, but if I understand what it is that you suggest then I may be able to cope. The idea is that each line is actually a separate paragraph consisting simply of a tab character, skipping to the right margin. And it happens that if you apply the character property Underline to such paragraphs, the otherwise empty lines are indeed underlined. You then need to type any text at the beginning of such lines - before the tab character. A single line then becomes a paragraph of underlined text with the tab character at its end, and this carries the underlining to the end of the line. If the text wraps to more than one line, the underlining is continued, with the small problem that - in the case of unjustified text - any unused part of the line will not be underlined. As I mentioned, you can solve this, but only by the messy technique of putting tab characters back at the end of each line - after you have finalised your text, of course. You may think that you can do the same sort of thing using space characters instead of a single tab character. That appears to work until you type your text: then any trailing spaces cease to be underlined, so the idea fails. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc error
At 14:17 05/01/2011 +0530, Shabbir Shaikh wrote: We have one ods file attached which has some problem, Please check and tell how to rectify the problem. May I be bold and say that you are expecting a lot here? You shouldn't, I suggest, expect subscribers to a mailing list simply to take over when you have a problem. There is no substitute for hard work. Indeed. And there is no substitute for saying what the problem is, doing what you can with your problem file, and explaining what you did and what response you got, so that anyone trying to help doesn't have to repeat your work. In fact, although your attached file has the .ods extension, it is not a valid OpenOffice (Calc) spreadsheet document file. So it is not surprising that OpenOffice is reluctant to open it. The file contents start as if it is a Portable Document Format (PDF) file, but it also contains what appears to be parts of a Microsoft Excel document file as well as what appears to be garbage. The most likely explanation is that your disk drive has become corrupted, with the result that what appears to be your spreadsheet file is actually a mixture of parts of other files - perhaps even ones that you thought you had deleted. If this is so, the only solution is to go back to your most recent back-up copy of the spreadsheet document file and continue working from there. You will also want to run your system's disk checking software to sort out any other problems on the disk; there will almost certainly be some. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to save multi-page spreadsheet as a single CSV file?
At 11:44 04/01/2011 +, Harold Fuchs wrote: On 4 January 2011 08:32, PJH wrote: Is there a trick to copying a whole sheet? Click in the white box to the left of the column letters (headings) and above the row numbers; edit>copy; move to new sheet; edit>paste This is - of course - a good answer to the question as posed, but it may be worth pointing out that it doesn't help with the original problem. If you select and copy an entire sheet, you are carrying to the clipboard the maximum number of rows and columns permitted in a sheet. The only place you can paste this in another sheet is in cell A1; anywhere else, and the pasted material runs off into more rows or columns (or both) than the program permits. So you cannot use this technique to assemble material into a single sheet - the original requirement. At 07:35 04/01/2011 -0500, Gene Young wrote: Select cell A1, Ctrl+Shift+End will select your data cells. [...] This evidently selects rows and columns only down to the furthest occupied cell. Copying this carries less than a complete sheet to the clipboard; in general, this can then be pasted somewhere different into another sheet to assemble material. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
At 22:33 02/01/2011 +0200, Dotan Cohen wrote: A user is making forms for herself and other therapists. These forms will be printed, and to specify the place where text is to be typed there are lines on the page, created with four dashes and one Enter per line. This works fine, but the original author wants to type out her forms for herself, instead of filling in the printed ones. she has no problem typing on the lines created with the dashes, but when the text wraps a line the top line loses its underline! That's not surprising, since what you have created is not an underline but a paragraph border below each paragraph. And the text that wraps is one continuos paragraph, of course - which gets a single border after it, not after each line. How can she prevent this from happening? Should she use a different type of line? Possibly. You could keep the original scheme, enter the text, and then go back, putting the cursor at the end of each line in turn and pressing Enter. This converts the passage into separate paragraphs, each of which will inherit the style and be given a trailing border. Here's another suggestion: o Put a left tab stop at the right margin (er, or perhaps right at the left, depending on your locale!). o Press Tab followed by Enter the required number of times. o Select all the lines and go to Format | Character... | Font Effects | Underlining (or right-click | Style > | Underline, or click the Underline button in the Formatting toolbar). o If the entered text is not justified, this will leave the space at the end of each line not underlined. If this matters, you can add a Tab character at the end of each line. There are probably neater methods ... I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to save multi-page spreadsheet as a single CSV file?
At 17:53 01/01/2011 -0500, Ponly Jonly Honly wrote: I have a spreadsheet that has 9 pages (sheets). How do I save the entire thing to a single CSV file? You do mean sheets, not pages, don't you? The number of (printed output) pages is irrelevant, of course. I think the simple answer - as you have no doubt discovered - is that you don't. But you can easily save all the material in one of two ways: o Save each sheet separately as a CSV file. Note that saving in CSV format saves the current sheet, so you can save each sheet by displaying it in turn. These CSV files are plain text files, so you can then very easily concatenate them in any text editor (even in Writer, if you like) to achieve what you probably need. o Alternatively, you could copy all the material (using copy-and-paste) into a single (new?) sheet first and then save that in CSV format. It may be simpler to use Paste Special, so that you can paste values and not formulae. It would not matter that you lose such formulae and the connections they embody, since these would not be saved in the CSV format anyway. There is no need to modify or destroy the original sheets or file, of course. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] PDF
At 23:56 22/12/2010 +0100, Martin Asterisk wrote: Please help me to find where is mistake. Open Office create PDF without colors of page. I'm not sure which colours you mean here. Do you mean text colours, highlight colours, or background colours - or something else? This is just a guess, but go to Tools | Options... | OpenOffice.org Writer | Print | Contents. You will need to have Background ticked in order to export backgrounds, and to have "Print black" not ticked in order to export text colours. I trust this helps. Brian Barker PS: The answers to your other two questions are much the same. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] converting axes
At 14:31 23/12/2010 +1000, Eihua Ling wrote: How do i change from x-axis to y-axis in the excel file?? 1 2 3 4 5 6 7 8 9 10 --->1 2 3 4 5 6 7 8 9 10 (You have come to the wrong place if you really mean that you are working in Microsoft Excel; I assume you mean that you are working in OpenOffice Calc, in fact.) As so often, Paste Special is your friend: o Select the relevant cells. o Go to Edit | Cut (or Ctrl+X). o Click the top left cell of the destination range. o Go to Edit | Paste... (or Ctrl+Shift+V). o In the Paste Special dialogue, under Options tick Transpose. o Click OK. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] User support question
At 20:17 23/12/2010 -0500, Jonathan Noname wrote: I have noticed that the Find & Replace feature of OpenOffice Writer will not detect text within fields. Example: 1. create a document that contains today's date on the first page, using Insert > Fields > Date. [...] 3. Press ctrl-f. 4. As the search key, enter the day of today's date (for example, if today is 12/23/10 then enter 23 in the search box). [...] 2. A second dialog box appears, saying: "Search key not found." Is this is a bug, or is the software working as designed? I strongly suspect that this happens by design. Inserting a field isn't simply a quick way of inserting some text - in this case, the date. Instead, the inserted field retains the ability to be updated later, and merely *displays* as you intend. The "23" isn't really there in the document: by the time I'm writing this, the displayed "23" will have become "24". In addition, note that the field can be displayed in a variety of formats; most of these will contain "23", but even some provided formats (such as "4th quarter 10") will not. Are you familiar with spreadsheets? The behaviour is similar to that with formatting dates and times in spreadsheet cells. Note that if you format the field, select it, cut it, and paste it back into place but using Edit | Paste Special... (or Ctrl+Shift+V) and selecting "Unformatted text", the field will be frozen (it will still show yesterday's date today) and will display in the format that you had chosen. Find & Replace will then find whatever text you have. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Font displayed/printed is not the font specified in paragraph style
At 17:29 20/12/2010 -0500, Ken Heard wrote: I have a template where I use two paragraph styles. The main one is called "entry" and specifies Times New Roman Normal 12 pt. The other style is called "quote". For this one I want a different font size, 88% of 12 pt, or 10.5 pt. I tried two ways to change the font size. One was in the "organizer" window of the "quote" paragraph style to link the style to "entry" and then in the "font" window or "quote" specify 88% as the font size -- as a percentage of the font size for "entry". The other was not to link the "quote" style to "entry", and specify the font size as 10.5 pt. Neither of these methods worked; the font size did not change from 12 pt. Should I file a bug report, ... Probably not. Remember that character styles take precedence over paragraph styles, and character properties take precedence over character styles. So if you have either applied either a character style that specifies 12 pt or specified 12 pt for the text directly (or both), these will maintain the font size at 12 pt regardless of the changes you make to the paragraph style. There is a difference between text that is 12 pt just because that is the text size of your current (even Default) paragraph style and text that has been set to 12 pt explicitly in one of these ways. Try: o Select all the relevant text. o Go to Format | Default Formatting (or Ctrl+M). This will remove the applied formatting but leave your paragraph style in place. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker btinternet.com> writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Link to External Data *.csv file?
At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? Yes. I have two programs which generate (hopefully) identical data in CSV format. I need to check for differences on maybe a daily basis. Doing the compare is easy once I've loaded the data into Calc but I'd rather make it a link so that all I have to do is open the Calc spreadsheet, have it read the contents of the existing files and then have it do the compare. I tried inserting a Link to External Data and putting the file name in but at that point it doesn't seem to allow me to do anything. OK never becomes active. That's because - referenced this way - the external data must be located in a table or named range. In the External Data dialogue, available names in the linked file are listed in the lower panel; if any exist, the OK button becomes active. CSV doesn't support names, I think. Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Table break between first and second rows?
At 13:37 14/12/2010 -0500, Kevin McLauchlan wrote: A table extends over several pages. How do you tell it to split/break after the first content row, so that the table can begin on a page with TONS of space? This is a problem I had before, but never solved. Encountered again in a 'new' doc. A two-column table insists on starting at top of page 20, leaving two lonely lines of body text at the top of page 19, and the rest of page 19 empty. The table has large-ish cells containing pictures, so two or three rows will fit on a page. The header row and first two content rows fit easily on page 20. This implies that the header and row 1 of content would fit easily on page 19, under the two lines of body text... and still leave empty space on that page. But the table refuses to break after the first row. I have tried Table Properties and individual cell properties, as well as properties of the text paragraphs within the cells. I can't find a way to tell my table that it is not merely OK, but actually desirable to start following the most recent body text, and to break conveniently between content row 1 and content row 2. Several reviewers have complained about the bad layout and incompetent use of page space. In general, you will want to solve this problem for future reference. But if your problem is - as you suggest - that your final copy is looking bad, there is surely a simple workaround which can be applied at the last minute before publication. Break the table into two, so that the rows that can appear on the first page are in one table and do so, and the rest are in a second table starting on the new page, as you wish. (To do this, put the cursor into the first row of what you want to be the second table and go to Table | Split Table (or right-click | Split Table).) If necessary, either put a manual page break between the two tables or else set the second's text flow to page break before. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] PDF Conversion
At 14:47 10/12/2010 -0600, Douglas Hinds wrote: OO writer can now open pdf files, but it opens them in OO Draw and each and every line is included in it's own text box so the documents flow is totally lost for the purpose of editing. It may be worth saying that this is precisely what you should expect. There is no text flow in a PDF document: each line is a separate line, with no information in the file to indicate whether the lines are separate paragraphs or parts of a single paragraph. Software has at best to guess where the paragraph breaks are, and cannot always get it right. And we are describing a pdf document created in writer and exported to pdf from there. Well, there is your answer: go back to the .odt file that you or your correspondent saved from Writer and kept for exactly this scenario - the need for further editing. Expecting to do this from a PDF version is a bit like scanning a hard copy and expecting to get a fully formed word processor document from it. But good luck in your endeavours nevertheless! I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: Fwd: Re: [users] Emailing: ScreenShot009
At 18:02 03/12/2010 +0100, Marco Fioretti wrote: On Fri, Dec 03, 2010 11:37:28 AM -0500, David B Teague wrote: Some of the folks on this list didn't think you are subscribed. If that's true, you won't have received this answer. So I have forwarded it to you. David, nothing personal, of course, but thanks for another proof of the OOo-users issues I recently summarized here: http://stop.zona-m.net/2010/11/a-proposal-for-effective-volunteer-friendly-user-support-in-libreoffice/ May I quote? 'The absolutely obvious consequences are that: [...] volunteers come and go, but only the good but clueless ones that sincerely believe that this is a sensible "strategy" remain to provide "support".' That would be us, then? ;^) Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Dates into Calc
At 13:31 28/11/2010 +, Harold Fuchs wrote: OOo 3.2.1 Vista Home Premium, Calc I have a web page showing a table of dates and associated events. The dates, all in the same year (2011) are in the style, for example "Sun Oct 23". If I copy/paste the table into Calc, the example date I just gave comes across as 01/10/2023. How do I fix this so that the dates come across "correctly"? Calc's Paste Special option doesn't seem to help. I have tried saving the table as a CSV file by copy/pasting the web table into a text editor and then opening that file in Calc but the result is the same. I don't think you can achieve what you really want: some way of pasting this that gives rise directly to correct dates. You have two pasting options, I think: with General formatting, you see a wrongly interpreted date; with cells previously formatted as Text, you will preserve the original form. In either case, you then need a little processing to form the original date that you need. o In the first case (where you see "01/10/2023"), try: =DATE(2011;MONTH(A1);MOD(YEAR(A1);100)) o In the second case (where you see "Sun Oct 23"), try: =DATEVALUE(MID(A1;9;2)&" "&MID(A1;5;3)&" 2011") In this case, you will need to format the results cell as Date to see what you need. You can either paste the results back over the originals (using Paste Special...) or hide the original values if you prefer, of course. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sections
At 16:03 28/11/2010 +, Harold Fuchs wrote: 3. When I create the new section, a faint box appears on the screen and the cursor jumps to a point *below* the bottom of this box. I perhaps missed the significance of this point the first time around. o If you have nothing selected when you insert a section, you get an empty section where the cursor is. So if you insert a section in an empty document, you get an empty section at the start, with the cursor outside the section and following it. o If you have something selected when you insert a section, the new section is created containing that material. If you start with an empty document, but then press Shift+Right Arrow or Ctrl+Shift+End, you apparently select the "nothing" that you so far have in your document. Why do I think this? If you then insert the section, the cursor appears inside the section! Perhaps this might also help ... Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sections
At 12:53 28/11/2010 -0500, Richard Detwiler wrote: I'm sure I haven't helped much. To corrupt the words of Brian Barker, "I trust this doesn't help". On the contrary, what you said makes a lot of sense. But thanks for the laugh! For example, if I want the heading for an article to span the width of the page, but the article to be in two columns, this is a perfect use for sections. Exactly so! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sections
At 16:03 28/11/2010 +, Harold Fuchs wrote: I've read some of the documentation on Sections in OOo Writer but I've decided I don't understand the thinking behind them. Perhaps some would explain it to me: If I create a new blank Writer document, type a few lines and then insert a section, a few things are puzzling: 1. The new section is named "section 1". Why not "section 2"? Why isn't the text *before* the new section considered to be Section 1? Of course, programmers prefer to count from zero ;-) but the text above the new section isn't "Section 0" either ... Because the text before the new section is not a section at all - just part of the document. You may be thinking in Word-speak, where a section is actually a section *break*, and all text is (I think) in sections, divided by these section breaks. In Writer, your newly inserted section is indeed the first. 2. The text before the new section doesn't seem to belong to any section. I don't seem to be able to format it like I can the new section. What is happening here? You are correct: it is not in a section, so you cannot use any techniques that apply to sections. But you can apply many formatting options using paragraph or - more likely - page formatting. 3. When I create the new section, a faint box appears on the screen and the cursor jumps to a point *below* the bottom of this box. But where the cursor is doesn't seen to be a section (section 2?) either. Correct: just like the material before your one and only section, anything you put here will be outside any section. 4. If I set the Navigator to select Sections then "Next section" and "Previous section" behave strangely (to my eyes): If the cursor is *inside* the new section then Next Section and Previous Section do nothing. If the cursor is in the text above the top (below the bottom) of the new section then Next (Previous) Section jumps into the new section. So the cursor can be made to jump into the new section but not out of it:-( This all makes sense if you see your document as containing one section, not three. If you are inside the section, there is no other section to move to: neither a previous nor a next one. If you are outside that section, you can indeed move to it as the next or previous (and only) section, as appropriate. 5. If I new insert a new section *inside* the one I just made then it is named Section 2 and the old Section 1 seems to have divided into two - part above and part below the new section. If I format Section 1 (say by making it into multiple columns) then both "halves" of the section acquire the new format. The two sections are nested. Section 1 is indeed divided, and any formatting applied to it should apply to all of it - both parts, that is. That's exactly what I would hope and expect. 6. If the cursor is inside Section 2 then Previous Section moves it into the top half of Section 1 but Next Section does nothing. Moving to a section appears to mean moving to the beginning of that section. If you are in Section 2, the beginning of Section 1 is another section and before it, so it makes sense for Previous Section to move there. But there is no beginning of a section later than this, so Next Section has nowhere to go. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Delete Section Break
At 15:41 28/11/2010 +, Harold Fuchs wrote: On 20/11/2010 12:42, Brian Barker wrote: At 10:29 20/11/2010 +, Harold Fuchs wrote: OOo 3.2.1 on Win XP Pro How do I delete the break between two sections? In other words, how do I combine two adjacent sections into one? Put the cursor in front of the first character in the second section and press Backspace. In my 3.1.1, this appears to combine the sections, with the new combined section inheriting the properties of the first. It's like page breaks, in other words. This doesn't work for me. The text after the cursor moves but the section itself stays. That's not particularly clear. Do you mean that the text of the second section moves into the first? If so, you simply need to delete the second section. If not, in what way does it "move"? Are the sections adjacent, or is the second actually embedded in the first? Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [calc] Date question
At 22:42 25/11/2010 -0500, Eustace Fril wrote: Is there a way to set my own day of week abbreviation? Instead of Mon Tue... I would rather have MO TU... At 15:38 26/11/2010 -0500, Eustace Fril wrote: ... I have a column with dates, that use 1999-12-31 Fri in the Format Cells - Numbers - Category:Date - Format field, with Format Code -MM-DD NN. How do I change this to 1999-12-31 FR? I guess I could change the format of the dates column to -MM-DD, the add the double-letter date abbreviations on the next column, and then merge each 2 cells on each line. But then I would have to do it for each line, which is tiresome. Is there a way to expedite the process? It may be a little easier than that: o Somewhere out of the way - perhaps even on another sheet - create a table with Sun, Mon, Tue, etc. in the first column and SU, MO, TU, etc, in the second. o Select the whole two by seven table and go to Insert | Names > | Define... and give the table a name, e.g DayNames. o Suppose your original dates are in column A. (The format of these cells doesn't matter.) In B1 enter: =TEXT(A1;"-MM-DD ")&VLOOKUP(TEXT(A1;"NN");DayNames;2;0) o Now copy or fill this down column B. o You can hide the original column A if desired. How does this work? The first TEXT() reference produces a text string of the date in -MM-DD format (but note also the trailing space in the format). The second TEXT() reference produces just the day of the week indicator - in the normal form - and the VLOOKUP() then uses this indicator to look up your preferred form from the small table. The ampersand concatenates the two parts of the date. Note that the resulting value is a text string and cannot be used in date calculations - but you have column A (even if hidden) for that. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Parts Alignment
At 18:23 21/11/2010 +0530, Anand Warik wrote: The tab seems to vanish for the next line. It won't vanish for the next line, I think - but it will apply only to the current paragraph. So if your "lines" were separated by pressing Enter, so that each line is a separate paragraph, this will indeed happen. The simple solution, of course, is to set up the tab stop before you enter the text. Even if you then press Enter, new paragraphs will inherit the tab stop from the previous one. I have so far written all the items that i want on the left hand side of the page, now when i do as you said for writing the page numbers that tab remains for only that line where my cursor was, as soon as i move to next line the tab seems to vanish. Two alternative ways around this: o Select all your material before you insert and configure the tab stop. Then it will apply to each of your selected paragraphs. o Select all the material and use Find & Replace, searching for $ and replacing it with \n . This has the effect of deleting and replacing each paragraph break in turn, so that each paragraph inherits the tab stop from the previous one. That's the same as going through line by line, deleting each paragraph break and pressing Enter to insert it again - but more easily! I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Parts Alignment
At 12:55 21/11/2010 +0530, Anand Warik wrote: I want chapter names to be aligned to the left & page numbers to the right. is there a way to do it? Is your problem arranging both left and right alignment at the same time? In Writer? o Click in the horizontal ruler (above the page) to create a tab stop. o Right-click the tab stop and select Right. o Drag the tab stop to the right text margin. o Now you can enter your left-aligned material, a tab character, and your right-aligned material. As has been suggested, you will probably want this material in a header or footer. Note that the Header and Footer paragraph styles already contain an appropriate right tab stop at the right margin (as well as a centre tab stop at the middle). So all you need to do here is to enter your left-aligned material, two tab characters, and your right-aligned material. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Parts Alignment
At 20:39 21/11/2010 +0530, Anand Warik wrote: When i select all my text then if i click on the ruler the tab which would easily be inserted earlier now doesn't seem to function. Only it gives me options to change the scale to meters, millimeters etc. That should happen only if you right-click the ruler instead of (left-)clicking it. If you are having problems, why not try this: o Cut all your relevant material. o Create the tab stop you need in an empty paragraph. o Paste the material back into the empty paragraph you have just created, using Edit | Paste Special... | Unformatted text. All your paragraphs should inherit the new arrangement. It doesn't seen to find $ in the first place & doesn't replace it with \n. Ah, that's because these are regular expressions, so you need - in Find & Replace - to click More Options and then tick "Regular expressions". Sorry I didn't mention that earlier. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] copying from calc to writer
At 16:13 20/11/2010 -0500, Andrew Douglas Pitonyak wrote: :-) Because you Mr. Brian Barker are a Calc stud I'm not sure about that ... I even saw your phone number on the wall in the public restroom "for help with Calc, call 555-B-Barker ... but thanks for the laugh of the week! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Inserting numbers down left side of text document
At 18:51 20/11/2010 +, Aonly Gonly wrote: I have to transcribe an interview and want to have a list of sequential numbers repeated for each page so that a line of text can be identified by a line number (e.g. line 17 page 3). How can I do this in OOo please? Who would know it: this is under "line numbers" in the help text! Go to Tools | Line Numbering... and tick "Show numbering". Tinker with the options if you wish. To get exactly what you ask for, you will need to tick "Restart every new page" under Count. Note that the numbers appear outside the text area of the page format, so it just may be necessary to increase the left margin to bring the line numbers within the printable area of the page. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Notes
At 20:32 20/11/2010 +0530, Anand Warik wrote: I wanted notes to get printed at the end of the page. So i have inserted a note & then in print options ticked the end of page checkbox in the notes column. But in the print preview I cannot find any note. What step am i missing? The first point is that such notes do not appear in Page Preview, but they will still be printed - apparently on separate pages inserted between the actual pages shown by Page Preview. But if you want notes printed at all, you probably want footnotes, not notes. Notes are intended for the editor, whereas footnotes (or endnotes) are intended for the eventual reader. Go to Insert | Footnote/Endnote... and select Footnote for Type. The footnotes will be visible in editing mode as well as in Page Preview. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Delete Section Break
At 10:29 20/11/2010 +, Harold Fuchs wrote: OOo 3.2.1 on Win XP Pro How do I delete the break between two sections? In other words, how do I combine two adjacent sections into one? Put the cursor in front of the first character in the second section and press Backspace. In my 3.1.1, this appears to combine the sections, with the new combined section inheriting the properties of the first. It's like page breaks, in other words. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Filters - mistake in wiki documentation?
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 operation, you will also select the invisible rows contained between the selected visible rows. Operations, such as delete, act on all of the selected rows. To avoid this problem, you must individually select each of the filtered rows using the control key. " That does not match my experience, but I'm running Go-oo on this machine rather than OOo, is this a difference in behaviour between these two versions? My copy is deleting only the visible filtered rows and values. The help text in my OpenOffice 3.1.1 for Windows XP says "When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected. This is the opposite to rows that you have hidden manually by the Format - Rows - Hide Rows command. Manually hidden rows are deleted when you delete a selection that contains them." This contradicts the web site version you quote. And yes: my version (like yours) seems to follow the help text's claims, not the web site's. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
At 12:21 14/11/2010 -0500, Twayne Noname wrote: No help to me: I use OOo's native Replace command for that. See Tabs, newlines, paragraphs \t \n $ and the following lines for how to. At 16:54 14/11/2010 -0500, Twayne Noname wrote: ... IIRC I fixed it by using the "$" expression. Take a look in Help for "replacing;tab stops (regular expressions)" and see if that table doesn't help. At 22:14 16/11/2010 +, Nobody "e-letter" Noname wrote: The original question should be solved by using regular expression, but another part of the help section is 'text documents', 'list of regular expressions' It may be a tad unhelpful to suggest that this problem can be solved in Writer using regular expressions, but to be so reserved about exactly how! Would either of you care to suggest exactly what regular expressions will solve this problem, please? Until then, there are many sceptical faces out here. 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. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] copying from calc to writer
At 13:44 17/11/2010 +0530, Anand Warik wrote: Brian Barker please solve one more problem, that of turning the object 90 degree Er, why me, please - why not another of this list's 2500 subscribers?! In fact, I'd thought of the technique later described by Thomas Lange, but I held back in case anyone found a simpler method. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] copying from calc to writer
At 10:18 17/11/2010 +0530, Anand Warik wrote: I want to paste tables & charts that i have been made on OO calc to OO writer but when i do so only the object appears. It is only in the print preview i can see the objects copied. You want to see the objects but only the objects appear? It sounds as if you have what you need! Do you mean that instead you see a frame labelled "Object 1", Object 2", and so on? Is there any way that i can see it normally on the writer. Yes: put a tick in Tools | Options... | OpenOffice.org Writer | View | Display | Graphics and objects. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
At 20:26 14/11/2010 -0500, David B Teague wrote: On 11/14/2010 12:32 PM, Johnny Rosenberg wrote: Yes, but I think there was some serious problem with that, if I recall correctly. The problem was that \n in the search field is Shift+âµ and in the replace field it is âµ, but there is no way to replace the other way around, at least not easily. If anyone gets a way around that, I want to see it. This is a recurring problem if you copy stuff from the clipboard into Writer. If you go to Tools | AutoCorrect Options... | Options and scroll down, you will see "Combine single line paragraphs if length greater than 50%". (If you select this and click Edit..., you can vary that figure of 50%.) You can use this to combine single-line paragraphs. Just go to Format | AutoCorrect > | Apply. This will apply all currently selected forms of auto-correction, and any additional changes may be unwanted. If so, try Format | AutoCorrect > | Apply and Edit Changes instead. Then click Edit Changes to reach a panel enabling you to accept or reject individual changes. You may want to paste any text into a temporary separate document before carrying out such editing, to avoid unwanted changes to the rest of your real document. The tidied-up text can then be pasted where you really want it. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Paste without formatting
At 12:51 11/11/2010 -0500, Twayne Noname wrote: In news:999379.12982...@smtp822.mail.ukl.yahoo.com, Brian Barker typed: At 19:59 08/11/2010 +0100, James Wilde wrote: Mac OSX 10.6.4 OOo 3.2.1 I have version 3.1.1 for Windows XP, so you may have to work out how all this applies to your Mac version. There is no version 3.1.1 for XP; that has to be a typo or error. It is XP Home or Pro with/without Multimedia, mostly. e.g. I have XP Pro with SP3 + all following applicable updates. Er, no error here. That preposition is _for_, not _of_. At 18:05 11/11/2010 +, Phil Hibbs wrote: I think he meant OOo version 3.1.1. Indeed he did! At 16:25 11/11/2010 -0500, Twayne Noname wrote: You might be right. I thought of that but then he had already given a different rev higher up in his post. No big deal I guess; it won't matter much which XP he's using anyway. Er, you are reading the quotes wrongly. The *questioner* said he was using OpenOffice 3.2.1; I mentioned that I had only 3.1.1 (and on Windows, not Mac OS) just in case that made any difference. But no matter ... Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Paste without formatting
At 19:59 08/11/2010 +0100, James Wilde wrote: Mac OSX 10.6.4 OOo 3.2.1 I can paste with the format applicable at the point of entry if I use Cmd+Alt+Shift+V, as opposed to Cmd+V which pastes the incoming text in the format from which it came. I'm slightly surprised by this. The Windows keyboard shortcut is Ctrl+Shift+V, so I'd imagine the Mac one would be Cmd+Shift+V - with no Alt. I'd like to make the pasting of unformatted text the default, and either reverse the system so that Cmd+Alt+Shift+V uses the formatting at the origin, ... I have version 3.1.1 for Windows XP, so you may have to work out how all this applies to your Mac version. You can change the effect of keyboard shortcuts at Tools | Customize... | Keyboard. Under Functions | Category, select Edit. Under Functions | Function, select Paste or Paste Special, as the case may be. Under "Shortcut keys", now select the key combination you wish to be assigned to this function. Click Modify to make the change. Note that at the top right of the Customize panel you can choose whether you wish the shortcut to apply to OpenOffice generally or only in Writer, Calc, and so on. (You get to see only the component for the type of document you currently have open.) You will see that Ctrl+V is defined for OpenOffice generally but that Ctrl+Shift+V is defined separately for Writer and Calc (and others?). You will have to decide exactly how you want to reconfigure this. Note also that Paste Special does not paste unformatted, but merely gives you this choice as a separate step in its dialogue box. I don't know any way to avoid that. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] printing a book
At 10:26 05/11/2010 +0100, Maria de las Mercedes wrote: I am a Openoffice user since 2007. I have not been able to find how to print a document in a book format. Could you help me please??? This is very essential in my work. Do you mean that you want OpenOffice Writer to print two pages per side and to distribute them unusually - so that you can fold the resulting stack of sheets into a booklet? OpenOffice calls these booklets "brochures", so you could look up "brochure" in the help text. See also http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Printing_a_brochure . o Set up the page format within the document (Format | Page... ) to have the actual size and orientation of the document page, not the size of paper that you will use - as if you were actually using smaller paper, that is. This may be portrait A5 (or perhaps half-Letter if you live in a non-standard country). You may want to use Mirrored page layout and a small Inner margin. When you print, you need to do two things: o Set the printer orientation to landscape and to the actual paper size - possibly A4 (or Letter). Do this either in the printer settings outside OpenOffice, or through the Properties... button in the Print dialogue. o Select the Brochure print option. Do this either at Tools | Options... | OpenOffice.org Writer | Print | Pages | Brochure, or on the fly through the Options... button in the print dialogue. If you select brochure printing in Tools | Options..., you can use Print Preview to experiment with the brochure setting to see how it works. If your printer does not do double-sided automatically, you will probably want to use the "Left pages" and "Right pages" options to print all of each side of your stack in one pass. (These options are also at Tools | Options... | OpenOffice.org Writer | Print | Pages, or can be reached on the fly through the Options... button in the print dialogue.) I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org