[users] Re: Delete Lines
On 10/27/2011 7:29 PM, Ariel Constenla-Haile wrote: Hi Bruce, On Fri, Oct 28, 2011 at 10:07:31AM +1100, Bruce Lloyd wrote: I created a line using --- which worked fine but it was too close to the preceding paragraph for me which raised two problems: 1) I could not find out how to delete it 2) if I tried to move it down the page by entering a paragraph I ended up with two lines one in the original place and another one a paragraph further down. I could delete the second line by selecting it with the blank para but was still unable to delete the original line. Any advise please? Ctrl + M Default Formatting() on the paragraph above the line Or alternatively (to just get rid of the line but keep other paragraph formatting intact): Click in the paragraph immediately above the line. (This is actually the paragraph that the line is contained in, as a bottom border.) Go to Format Paragraph. Click on the Borders tab. Under Line Style, select None, then click OK. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org
major snip But my benefit and any other less well informed readers, what does ANN refer to? And how does that relate to OOo? (I'm sure it does, I just don't know how.) -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org
Sorry for the typo, I meant to say: FOR (not but) my benefit and any other less well informed readers, what does ANN refer to? And how does that relate to OOo? (I'm sure it does, I just don't know how.) On 9/3/2011 12:38 PM, Richard Detwiler wrote: major snip But my benefit and any other less well informed readers, what does ANN refer to? And how does that relate to OOo? (I'm sure it does, I just don't know how.) -- - 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
On 6/27/2011 5:57 PM, John Jason Jordan wrote: I finished 1996 and there are 35 rows. I tried to use Sheet 2 for 1997, but couldn't figure out how to transfer the row and column formatting from Sheet 1 (1996), so I gave up and decided just to use Writer tables. It took me a lot of work to format the cells in Sheet 1 and I was trying to avoid having to duplicate the effort for Sheet 2. The easiest way to do what you had tried to do in Calc would be to copy Sheet1 (1996) to a new sheet. Two ways to do this are: 1. Right click on the Sheet1 tab and select Move/Copy Sheet ... Check (tick) the box Copy. Show where you want the sheet to appear in the spreadsheet (although it can easily be moved around if you get it in the wrong place). Then click OK. or 2. Click (left click this time) the Sheet1 tab, hold down the Ctrl key, and drag it slightly to the right. A copy will be created, with the name Sheet1_2 (if the original name was Sheet1). -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Inserting a page before a table
On 5/14/2011 11:01 AM, william drescher wrote: I have a form that consists of one table. The table starts at the very beginning of the page. I can not figure out how to insert a new page before the table. I can't get the cursor outside of the table at the top. How ? Thanks in advance. Bill I'm using OOo version 3.1.1 (not the newest, I realize). I just tried it and found it to be simple: I put the insertion point to the left of the first character in the upper left hand cell of the table, and press Enter, and it moves the table down one line and puts the insertion point at the top of the page, outside of the table. In some earlier version, I remember struggling to do that task, though. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Saving one sheet as a separate file in Calc.
On 3/18/2011 3:10 PM, William Case wrote: Hi; This may just be a brain cramp, but I can't see anything in help. If it is in help could you tell me under which topic I should be looking. I have a big spreadsheet in Calc with several sheets. I simply want to save one sheet to a new file (.xls). The data and calculations on this sheet are Independent of all other sheets. Is there a way to do this without coping the entire sheet to a brand new Calc file? Using OOO 3.3.0 Right click on the sheet of interest. Select Move/Copy. In the To Document dropdown, select New document. If you want to MOVE the sheet (that is, no longer have it in the original document), then leave the Copy checkbox blank. If you want to COPY the sheet, then obviously check the Copy checkbox. -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] Dates into Calc
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. Have you tried pre-formatting the Calc cells (that you want to paste the data into) as Text, and then do a Paste Special, as Unformatted text? When I try that, Sun Oct 23 comes in as Sun Oct 23. It will, of course, just be text, and not recognized by Calc as a date -- which could certainly be a problem depending on what you want to do with the information -- like sort by date, for example (which would not work properly if Sun Oct 23 is text). - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sections
Hi Harold, I've used sections quite a bit and I think I understand how they work for the most part, although I also haven't thought about things quite as deeply as you obviously have! :) Comments in line ... 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 ... A section doesn't exist unless you specifically create one. There probably could have been different terminology used instead of the word section, although I can't think of a better term at the moment. So when you create a section after typing a few lines, the section you create is indeed the first section, or section 1. What you typed before isn't a section. Might not make sense but that's the way it is ... 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? Well, because it isn't a section. If you want to format that text like a section, you need to highlight it and then choose Insert Section. 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. That's correct; kind of unusual/unexpected behaviour in my opinion. But to type text in Section 1, which you just created, just click in the faint box and you'll be in Section 1. 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:-( I usually don't use the Navigator so I can't shed any insight into this observation. 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. Yes -- this seems unexpected as well. I can see that formatting Section 1 might affect Section 2, because Section 2 was created as a sort of subset of Section 1. But I also tried formatting section 2 as 4 columns, while Section 1 was already formatted as 2 columns. Formatting Section 2 changed the number of columns in Section 1. I can experiment with this some more, but it's more like they're a single section rather than two sections. 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. There's obviously a fundamental something which I'm misunderstanding. Please ... I'm sure I haven't helped much. To corrupt the words of Brian Barker, I trust this doesn't help. But if it's any consolation, I do find sections extremely useful, if a little mysterious. I edit the newsletter for our local orienteering club, and I make very extensive use of sections. 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. There are many other uses also. As I've said, I haven't thought about their peculiarities nearly as deeply as you have! When I find something that seems a bit unexpected, I just accept it and roll with it. - 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.
Mike Scott wrote: On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse pasted from a non-OOo source I find usually has line ends marked as paragraph breaks. These should really be changed to the equivalent of shift-return so each verse counts as a single paragraph for formatting purposes, while 'end of paragraph' should correspond to end of verse. At present I go through the hard way with 'delete'. Tedious. The problem always being that each time this crops up, it's quicker to do it the hard way rather than hunt for a better method ready for next time. I've encountered this situation twice in the last couple of days, when taking text that someone submitted to me for a newsletter, and putting it into newsletter form. A search on Help for the term Removing line breaks did the trick. Here is the process (from Help): --- Use the AutoCorrect feature to remove line breaks that occur within sentences. Unwanted line breaks can occur when you copy text from another source and paste it into a text document. This AutoCorrect feature only works on text that is formatted with the Default paragraph style. 1.Choose Tools - AutoCorrect Options . 2.On the Options tab, ensure that Combine single line paragraphs if length greater than 50% is selected. To change the minimum percentage for the line length, double-click the option in the list, and then enter a new percentage. 3.Click OK. 4.Select the text containing the line breaks that you want to remove. 5.In the Apply Style box on the Formatting bar, choose Default. 6.Choose Format - AutoCorrect - Apply. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Partly off-topic question on web site design
I'm looking into software for web page design. I have heard that OpenOffice.org is NOT a particularly good tool. (What are the reasons for this? I'm not very knowledgeable about web sites.) What would be some better applications for this task? (Preferably free ones, but I'm willing to pay a modest amount if that's what it takes.) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
AG wrote: On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Automatic updates
Stan Goodman wrote: For the first few days after I installed v11.3, there were momentary popup notifications that new updates were ready. Unlike the drill under kde3, I was not asked to confirm. I have no way to know whether the updates were executed or not, but I doubt it. I am sure (or rather, I hope) that the system s not intentionally keeping me n the dark, so presumably something is wrong. Does this sound like I omitted something I was supposed to do? Is it a recognizablefault somewhere? v 11.3??? That can't be OpenOffice -- what is it a version of? And does it have anything to do with OpenOffice? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open-office writer improvements
Tony Carr wrote: I'm using OpenOffice 3.2 and Windows 7 on an HP530 laptop. Two small irritations have bugged me for most of a decade - maybe there is a workaround? Or maybe it's all Bill Gates' fault? .. 2: When I click the Font-size drop-down tab, the menu only shows LARGER font sizes. So exactly half the time I have to laboriously scroll up to find the size I want. Why not have the menu put the current font-size in the centre? Then almost every desirable font-size would be immediately visible. I agree with #2! (I don't have much of an opinion about #1.) I also find this annoying (although mildly so), and would certainly prefer that the current font size is in the center of the drop-down list that is visible, not at the very top. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] question
Tracey Vetter wrote: I have a question about working within spreadsheets: How do I rename a new tab or sheet within a spreadsheet file/document? Thanks much Right click on the tab of the sheet you want to rename, and select Rename Sheet . Then just type in the new name you want. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mass edit in calc field - help!
Brewster Gillett wrote: Adam Tauno Williams wrote: Insert a column enter =DATEVALUE($THEDATECELL) copy-and-paste that one cell to the rest of the column copy the date value column paste as values over the old column delete the column you created Richard Detwiler wrote: Is there any way you can send a small portion of the file with any confidential information removed or altered? (or post it on a web site) I'm not able to recreate the problem you're having, which I suspect is because I don't have the same type of CSV file that the data originated from. bg: I guess that's possible, although I am working with it saved as an Open Office .ods file, not in the originally received .csv version. All I ever do with the .csv versions is strip off the unneeded columns to make them conform to my template - all further work on them is then done in the saved-as-.ods version. I'm attaching a stripped-down 200 rows or so of it as a sample. 200 rows gives a fair range of the dates, and of course displays the evidence that the column is *not* being sorted by date, but as text numerical data :-) It's only 22K, so shouldn't have any difficulty getting through... ...thanks for your efforts. Brewster Brewster: I opened your file, went to cell D2, and entered the formula =DATEVALUE(C2). It gave me an integer number, 40198, which I knew was encouraging. Then when I formatted the cell as a date (choosing the 12/31/99 option), it gave me the date 01/20/99, which is what it should be. Then it's a simple matter of copying cell D2 down through as many rows as you need.
Re: [users] Mass edit in calc field - help!
Brewster Gillett wrote: I'm attaching a stripped-down 200 rows or so of it as a sample. 200 rows gives a fair range of the dates, and of course displays the evidence that the column is *not* being sorted by date, but as text numerical data :-) It's only 22K, so shouldn't have any difficulty getting through... ...thanks for your efforts. Brewster On Thu, 2010-09-23 at 13:16 -0400, Richard Detwiler wrote: Brewster: I opened your file, went to cell D2, and entered the formula =DATEVALUE(C2). It gave me an integer number, 40198, which I knew was encouraging. Then when I formatted the cell as a date (choosing the 12/31/99 option), it gave me the date 01/20/99, which is what it should be. Then it's a simple matter of copying cell D2 down through as many rows as you need. bg: It all works just as you describe, but with a terminal flaw; once having done all that, and admiring the shiny new date-formatted column, absent the apostrophes, I essay to perform an ascending-order sort on it. Alas, Evo's sort is apparently *not* reading it as a real live date, because instead of parsing it as YY (or - I tried it both ways)then MM then DD, the sort function is reading the two leading digits, and ignoring the rest. This of course is exactly what the sort function was doing when the column still was in text rather than date format :-( It would appear, maybe, that the sort function is lacking an appreciation of the distinction between a straight text number and a date. Either that, or the FORMAT,CELL process produces something that has the appearance of a date, but not the reality ?? Appreciate all the help - I am running out of ideas. I will go try some of the other combinations that have been suggested. I'm not sure what you mean by Evo's sort. When I do this, everything sorts fine. See attached file. To explain something about dates, which might help grasping the situation, dates are stored as numbers, with 12/31/1899 being 1, 1/1/1900 being 2, 1/1/2000 being 36526, etc. All the formating does is take those numbers and put them into a date that humans can recognize as a date. You can choose multiple ways of displaying the date, but it doesn't change the underlying number. It is the underlying number that is used in sorting. So I'm not sure why, when you convert the text dates into real dates that Calc can use, things don't sort. Maybe you should send your file again, this time after you've converted the text dates to real dates. sampleCalcOOusersRD.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mass edit in calc field - help!
Brewster Gillett wrote: Adam Tauno Williams wrote: =DATEVALUE($CELL) will convert a text representation of a date to a date value. bg: Sounds workable, but where and under what screen am I going to enter it in order to apply it to all 678 rows in that column? I tried entering it in the edit window on the first one, and got #NAME? as a response. Adam Tauno Williams wrote: Insert a column enter =DATEVALUE($THEDATECELL) copy-and-paste that one cell to the rest of the column copy the date value column paste as values over the old column delete the column you created bg: Doesn't work. Whether I enter it as =DATEVALUE($CELL) or as =DATEVALUE($THEDATECELL) it still echoes #NAME? all the way through to the final paste. What am I doing wrong? Brewster Is there any way you can send a small portion of the file with any confidential information removed or altered? (or post it on a web site) I'm not able to recreate the problem you're having, which I suspect is because I don't have the same type of CSV file that the data originated from. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Sam Warren wrote: I have a OOoo Calc file that looks fine on the screen but when I preview it, the page is blank. When I try to print it, I only get one blank page. Check to see if you have a print range set, on any of the sheets in the file. If you've set a print range on any sheet in the file, there is no long a default print range for other sheets. To remedy this, manually set a print range for the sheet you're trying to print. You can do this by highlighting the range you wish to print, and then selecting Format Print Ranges Define. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] =Sum not returning correct value?
Ted Trobaugh wrote: Greetings, I am using Ooo 3.2.1; Build 9502 OSX 10.6.4 There is a simple Sum formula that is not returning the value I think it should be returning. Why isn't the Sum formula in cell Y96 giving me the right value? It should be adding all the numbers from Y2 to Y93. If I add the values by hand, the answer is 9, but the formula =Sum(Y2:Y93) is returning 11. All the cells in the range Y2 to Y93 contain formulas. Any insights? Thanks for your time. Ted Ted: The situation is that you have a number of rows that are hidden. When those rows are revealed, then the sum, manually calculated, is in fact 11, not 9. So the formula is giving the correct answer of 11 as the sum of Y2:Y93. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] function as cell reference
James wrote: On 07/31/10 17:26, Johnny Rosenberg wrote: 2010/7/31 James bjloc...@lockie.ca: On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))* I have to say that I really don't understand what you are doing here and why. I thought that you wanted to calculate the average value of all the (non empty) cells in column C starting at C3. That's obviously =AVERAGE(C3:C65536). Your formula, =AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3))), if COUNT(C3:C51)+3) = 15, will calculate =AVERAGE(C3:C15), which is not the whole C column. Also, the size of the range will change if you change something in C3:C51. What are you actually trying to accomplish here? 51 is an arbitrary row. The =average function seems to treat empty cells as 0. ??? I just did a check on this, and the average function does NOT treat empty cells as 0. I entered the following in column A, starting in row 1: 2, 2, blank, blank, 2, 2. Then I entered the function =average(A1:A6), and the answer was 2, as expected. It would not have been 2 if the function treated blank cells as zeros.
Re: [users] Writer: Erasing triple-dash lines after paragraphs
Dotan Cohen wrote: How does one erase triple-dash lines that are placed after paragraphs? To test, type this text in Writer: test --- Now try to erase the line created by the dashes. Is this really expected behaviour, or is it a bug? What the triple dash does is apply a paragraph format to the paragraph above the line, specifically by applying a lower border to the paragraph. To remove the line, go to Format Paragraph, click the Border tab, and under Line Style, select None. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] I forgot how to do page numbering?
Linda L. Hull wrote: Can someone help? I have Open Office 3.0.1. on Ubuntu 9.04. Insert Footer click default. Click in the footer, then Format Paragraph thing for numbers? ? I don't see it? Can't figure this out. I'm so tired, have deadlines. Linda Linda: You're on the right track! Insert Footer click default is the right first step (this assumes you have one page style, Default, which you want page numbers on) then click in the footer as you did then select Insert Fields Page Number Now you have the pages numbered. You may choose to enhance the numbers by typing in, for example, Page before you insert the page number field. Or else possibly Page then insert the page number field, then of and then Insert Fields Page Count. This would give you, for example, Page 1 of 8. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Plotter
Bob Estes wrote: I have my plotter, but I now need to get it hooked up as it didn't come with any cables. I have a power cable, but the data cable is a special RS-232 NULL modem cable. (See the attached file HP-17255D Cable.pdf.) I found various new and used cables on the internet for prices ranging from around $35 to $75, but it has a 25 pin connector on each end, and my computer has a 9 pin serial port. Also, the factory cable is too short for my installation. This leaves me with three options: 1. Buy the HP cable, a RS-232 extension cable, and a 25 pin to 9 pin adapter. This would be an expensive kluge, and it would be my last choice. 2. Buy a custom made cable that includes all of the features of the three items in choice one. (See the attached file HP7475A Interconnect Cable.pdf.) I found a company on the internet that will build a ten foot cable for about $35. 3. Buy the components and assemble the cable myself. The same company that would build the cable for option two (Showmecables.com) has real good prices on components. I can get all of the components including a 100 foot spool of cable for about $35. Buying just 10 feet of cable would reduce the price to about $17. The cable is a lot more expensive by the foot instead of by the spool. Right now I'm leaning toward option three. Of course, I would also need to buy a couple of tools which I have been wanting for some time anyway. One of the tools is a Panavise #381 (http://www.panavise.com/index.html?pageID=1page=full--eqskudatarq=6) which I have already ordered. The other tool is a heat gun (http://www.harborfreight.com/cpi/ctaf/displayitem.taf?Itemnumber=66098) which is an excellent tool for shrinking heat shrink tubing. I'm also leaning toward the 100 foot spool of cable. This would leave me about 90 feet of cable for some other project. I can't order anything more until May, but I think I'll have enough to get everything. Bob: Did you send this to the wrong list by mistake? It doesn't seem to have anything to do with OpenOffice. (Unless I'm really missing something.) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Help needed
Tanstaafl wrote: On 2010-03-13 7:23 AM, Daniel Lewis wrote: When you save a document for the first time, the Save As window opens. At the bottom near the middle is a check box. It is labeled Automatic file name extension. This should be checked. Normally, it is, but if you accidentally unchecked it, it will remain unchecked until you save a document and check the box. Just be sure to look at this check box when you save a file for the first time. To correct the files which have this problem, open them in OpenOffice.org and use Save As. To do this, click File to open the File menu. Click Save As. This time make sure that this check box is checked when you save the file. Which begs the question - why is that checkbox even there? All it does is cause this problem (our users have been bit by it a lot too)... Good question -- not sure why anyone would ever have the need or desire to save a file w/o the file name extension. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Compression of documents
James Knott wrote: Richard Detwiler wrote: Dave and Anna Whitehouse wrote: Hi We are about to use Open Office, for the first time whilst overseas for a few months, where it will be our only text/imaging programme. We are wanting to keep the kids informed about our travels and send Open Office documents, including photos, as attachments to emails. In 'ms Word' - my usual day-to-day software - we can create a text doc ., add images, and then compress that whole page for easy and small-size attachment to an email. I can't seem to do the same thing in Open Office. I guess I have missed something.. Can anyone enlighten me? Many thanks Dave I would recommend exporting as a pdf file. When doing that, you can set the compression to the desired value. An important additional advantage is that essentially anyone can read the file, whether they have OpenOffice installed or not. ODF already compresses documents. I've found that documents that contain a lot of pictures (like a newsletter I edit for a local club) can get quite large in file size. When converting such a document to pdf, depending on the settings that are chosen in the pdf export, a pdf file that is quite a bit smaller than the .odt file is possible, while maintaining reasonable image quality. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Compression of documents
James Knott wrote: Richard Detwiler wrote: ODF already compresses documents. I've found that documents that contain a lot of pictures (like a newsletter I edit for a local club) can get quite large in file size. When converting such a document to pdf, depending on the settings that are chosen in the pdf export, a pdf file that is quite a bit smaller than the .odt file is possible, while maintaining reasonable image quality. Now you're getting into the area of trade offs. Many image formats are already compressed. With PDFs you're trading image quality for smaller file size. Since the OP is sending photos, he might be concerned about image quality. I totally agree; there are certainly trade offs between file size and image quality. I'm also concerned about image quality for the pdf's that I create, as they are put on our club's web site for people to view. I always scrutinize the image quality of the pdf I create to make sure it still looks decent when viewed on a screen. I'll even blow it up to 200% or so to see things that might not be apparent at 100%. My general experience is that a pdf can be created that is quite a bit smaller than the .odt file with perfectly acceptable image quality for on-screen viewing (which I think is what the OP needed). I also send a pdf to a printing firm, in which case I use very a high quality (thus large size) pdf process, which gives a file size roughly equivalent to the original .odt file. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Compression of documents
Dave and Anna Whitehouse wrote: Hi We are about to use Open Office, for the first time whilst overseas for a few months, where it will be our only text/imaging programme. We are wanting to keep the kids informed about our travels and send Open Office documents, including photos, as attachments to emails. In 'ms Word' - my usual day-to-day software - we can create a text doc ., add images, and then compress that whole page for easy and small-size attachment to an email. I can't seem to do the same thing in Open Office. I guess I have missed something.. Can anyone enlighten me? Many thanks Dave I would recommend exporting as a pdf file. When doing that, you can set the compression to the desired value. An important additional advantage is that essentially anyone can read the file, whether they have OpenOffice installed or not. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Vector Graphics PDFs.?
James Elliott wrote: Hi Lars Thanks for that helpful information. In fact yours and one other were the only on-topic replies I received. Someone called Heinz and a Barbara Duprey have started a movement to unsubscribe me, which I think is a bit draconian when all I did was to ask a perfectly ordinary question in polite English. James, you've totally misinterpreted the whole exchange involving Heinz. He took the thread (and other threads) totally off topic by asking to be unsubscribed (in German). Barbara has, for quite a while, been extremely gracious as far as working with people who want to be unsubscribed, to help them get off of the list (thanks Barbara!). It was Heinz, not you, that she was trying to help get unsubscribed. I'm really not at all sure how you could have interpreted that whole exchange as being targeted at you, but just to clarify, it wasn't ... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Inserting page numbers
t...@seedfield.co.uk wrote: Dear Sir/Madame, I'm currently writing a document for work using vista which is the only programme on my lap top which was highly recommended to me by the company who sold me the lap top. However it appears to make a lot of very simple tasks extremely unnecessarily complicated which costs a lot of my time which I do not need. All I want to do is to pres insert page number and then I expect each page to have its number on the bottom. This is what happened in Word xp but not in Vista. Why is this? I am having great difficulty inserting page numbers in numerical order due to the fact that even when I insert a footer and then go to insert page number it only inserts one page number on one page - what is the point of that? So I individualy tried to do it by hand but when I do that it automatically changes it so that 4 is before 3 etc. Its very annoying. If there is a way you could sort it please could you let me know. A job that should take one second is taking me an hour of wasted time. I would appreciate your help. Sorry if this email sounds short. Kind regards, Tia Danning. Tia: Barbara gave excellent advice on how to do page numbering in OpenOffice Writer. (Basically two steps, like she said: Insert Footer Default; and then Insert Fields Page Number.) I, and I suspect others, however, are a bit puzzled by your note. In no place do you mention that you're using OpenOffice. You say that you're writing a document using Vista, but Vista is not a word processor, it is an operating system. Vista, along with most Windows systems, generally comes with two fairly basic word processors, WordPad and Notepad. I'm wondering if there is some chance that you're using one of these to compose your document, rather than OpenOffice? If so, the instructions that Barbara gave you wouldn't apply. It would be helpful if you could write back (to the list at users@openoffice.org, not to me personally; that way, many others, far more knowledgeable than I am, can assist) and explain further specifically what you're using for a word processor. (Reminder: Vista, that you mentioned, is not a word processor, but is an operating system.) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated]
Programmer In Training wrote: On 1/2/2010 9:37 PM, John Meyer wrote: snip And you can alweays go with something like Paint.NET, Gimp, or Picasa (all of which are excellent choices). I would just like to mention, anything with .NET in it probably sucks (to recommend such is an abomination IMO) What? Anything with .net probably sucks? How so? FWIW, I use Paint.net as my main photo editing software, and I'm pleased with it. Not nearly as full featured as Gimp but to me that's a positive rather than a negative. It's faster and easier to use. When I have the rare situation where I need Gimp, then I'll use it. I wouldn't be so quick to conclude that Paint.net sucks, especially since it sounds from your wording that you've never tried it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Want date of last modification in Calc
bill purvis wrote: On Friday 27 November 2009, Andreas Saeger wrote: bill purvis wrote: I am working on a multi-sheet parts list spreadsheet and it would be really useful if I could automatically insert the date of the most change at the bottom of each sheet. I can see that I can enter the 'current' date, but I'd really like the date at which any of the sheets were last modified. At present I have a hidden field on sheet1 and copy this to all the relevant cells, but then I have to unhide the cell, update the content, and re-hide it each time I change something. Is there such a function - I couldn't see it in the help list. Bill Type the address or name of the cell into the name box left of the formula bar. Then type into the formula bar: =NOW() F9 Enter Enter No good! I want to be able to open the spreadsheet and see when it was last modified - NOW() gets updated when you load a SS, otherwise it would be the answer. Thanks anyway! Bill Bill: Did you actually try his suggestion? I just did, and it does NOT update when you save and then re-open the file. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Variable page headlines
Barbara Duprey wrote: Séamas Ó Brógáin wrote: In a layout for publishing (Openoffice 3.1.1, Debian GNU/Linux) I need to have page headlines that are different on every page. I have inserted headers in left-hand and right-hand page styles, and set an appropriate paragraph style for the content; but when I type a page headline on any page it is copied to all left-hand pages (or all right-hand pages, as the case may be). I hope I’m overlooking some simple setting. Any help appreciated. What do you need to have be different in each header? Generally speaking, what you need is to click in the header and use Insert Fields to select the content you want. Maybe there's some confusion in terminology? The OP uses two terms, headlines and headers. I'm not sure if Seamas is using those interchangeably or not -- they certainly are not at all equivalent. If headers is really what is meant by headlines, I'm not sure I understand the objective of having headers that are different on every page. Isn't the point of a header that there is basically the same thing on all pages of that style? (With possible differences being, for example, the page number.) So maybe headlines is really more what is meant, and the OP is confusing headers with a way of achieving headlines? So I think we need some clarification from the OP as to what the goal is. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: [OT] The Unsubscribe Dialog
Twayne wrote: The real surprise would be that anyone would actually bother to figure out what it was about. Not worth the effort. Tis worth the effort to report as abuse though. Regards, Twayne` I'm sorry -- what's the above comment refer to? I'm unclear of the context. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] turning off tracked changes
McLauchlan, Kevin wrote: Can somebody quickly remind me what track changes is called in OOo, so I can either accept changes or kill the display of two chapters of struck-out text and graphics? Sorry, I have the Word terminology in my head, but that's what people use around here. I've never had the opportunity to use any sharing or collaborating or reviewing functions in OOo, because nobody else here uses OOo. The help won't help me because it has none of the terms that I recognize. Halp? - Kevin I think what you want is Edit Changes Accept or Reject Also, you should be able to right click on any changes that are tracked, and accept or reject from the context menu. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Goodbye, OpenOffice.Org. I'm going back to MS Office
Fred A. Miller wrote: Goodbye, OpenOffice.Org. I'm going back to MS Office http://ct.zdnet.com/clicks?t=440183855-f09aff1f3240c763b781087d83996fa3-bfbrand=ZDNETs=5 For the last three years, I've been using a version of OpenOffice.org on all of my systems. I'm sad to say that I'm going to move back to Office 2007 on Windows XP and Office 2008 on Mac OS X this week. My main reaction: Don't feed the troll. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Adding to dates
Walter Hildebrandt wrote: How is the following done? Cell A1 has a date Cell B1 is to have the date that is in A1 but the date in B1 is three days latter that the date in A1 Cell C1 is to have the date that is in B1 but the date in C1 is eight days latter that the date in B1 All the cells are formatted as Dec 31, 99 Entering either *=A1+3* or =*A1+3* in Cell B1 produces Jan 2, 00 but the date in A1 is a September date Walter Denver Colorado I don't understand what the asterisks are for in your formulas. When I enter today's date (9/29/09) in A1, and the enter the formula =A1+3 in B1, the result is 10/02/09, like it should be. And when I enter =A1+8 in cell C1, the result is 10/07/09, like it should be. Have you tried entering the formulas without the asterisks? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Adding to dates
Can you attach a file that shows an example of what you're seeing? Or else send it to me directly? Like I said, the formula seems to work fine when I started up a new Calc file and entered the information. So it might be helpful to see your actual file (take out anything that might be confidential before sending it, of course, or else just start up a new file and put in what you're talking about in cells A1, B1, and C1. Walter Hildebrandt wrote: I do not have an asterisks in the formula. Somehow the asterisks was added to what I said in the Email. When I enter =A1+3 in Cell B1, I get Jan 02, 00 On Tue, Sep 29, 2009 at 9:51 AM, Richard Detwiler rlsha...@aol.com wrote: Walter Hildebrandt wrote: How is the following done? Cell A1 has a date Cell B1 is to have the date that is in A1 but the date in B1 is three days latter that the date in A1 Cell C1 is to have the date that is in B1 but the date in C1 is eight days latter that the date in B1 All the cells are formatted as Dec 31, 99 Entering either *=A1+3* or =*A1+3* in Cell B1 produces Jan 2, 00 but the date in A1 is a September date Walter Denver Colorado I don't understand what the asterisks are for in your formulas. When I enter today's date (9/29/09) in A1, and the enter the formula =A1+3 in B1, the result is 10/02/09, like it should be. And when I enter =A1+8 in cell C1, the result is 10/07/09, like it should be. Have you tried entering the formulas without the asterisks? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Paragraph with enclosed list
John Kaufmann wrote: A few days ago I asked how, in the OO worldview, one should properly separate paragraphs (Newline between paragraphs - the answer was No). After thinking about the consequences, I followed with a thread (Line break and justification withing paragraph?} that tried to ask a practical question [that is holding up a paper I'm writing]. That question received no answers, probably because I (a) asked it poorly and (b) embedded it in a (verbose) question about design philosophy. May I try again? [My paper is waiting. ;-)] This is a common issue, seen all the time, especially in procedural documents like service manuals: A paragraph with an embedded list. The first few sentences of the paragraph describe the list, and then the elements are listed. One would like to treat this, spatially and conceptually, as a single paragraph. For such purposes Writer provides the intra-paragraph line break (Shift+Enter), which breaks the line without invoking the inter-paragraph spacing. But there is (at least) one problem: It can't be used with Justified paragraph alignment. How can this be handled? John I do what you describe a lot, but I don't feel any need to make the list items a single paragraph, and specifically to have the list items be the same paragraph as what is used to describe the list. I use a separate paragraph style for the list items (I think I just call it List), with the main difference between the list style and the main paragraph style being much less space between paragraphs. I usually bulletize the list, which is then very important to have each list item be a different paragraph (otherwise each one wouldn't get a bullet). Works for me anyway ... but I'm guessing there is something fundamental that I'm missing, if this is something holding up your paper. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] um...
Frankyne Mouton wrote: Please remove me from your mailing list. Thank you. Ummm ... are you sure you're subscribed? If so, you don't appear to be subscribed from franky...@msn.com as it is showing as a non-subscribed address. If you are subscribed, but from a different address, you need to unsubscribe (by sending an e-mail to users-unsubscr...@openoffice.org FROM THE ADDRESS that you're subscribed at, and then replying to the confirmation e-mail that you'll receive). None of the users on this list have the ability to unsubscribe you. (Note: I'm sending you a cc at the address you sent your note from, in case that is the only address you check, and since it appears to be unsubscribed. Please direct any additional correspondence to users@openoffice.org, and not to me personally.) Date: Wed, 23 Sep 2009 18:54:58 -0500 From: b...@onr.com To: users@openoffice.org; micha...@sjnumurkah.catholic.edu.au Subject: Re: [users] um... michael phillips wrote: dose this sevice contane mail reader? Openoffice.org is a productivity suite that can work with documents of various types (such as text documents, spreadsheets, presentations, databases, and drawings). It doesn't include an e-mail client; many who use OOo also use Thunderbird or Seamonkey (both open source projects from www.mozilla.org). - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org =
Re: [users] Replacing Tabs.?
James Elliott wrote: I have a list I have copied from the Internet and pasted into a Write document (I used Notepad to remove Internet formatting on the way through). Each line of the list starts with a tab - I want to get rid of the tabs. How can I use Search Replace to do this? If I try and enter tab in the Look for field, all it does is to reposition the cursor in the Replace with field box. How can I tell Search Replace that is the hidden character tab I am actually looking for, and want replaced? Many thanks, James In addition to the excellent suggestion to use regular expressions, you might try another approach. Since it's a list you're copying, try putting it into a Calc spreadsheet, by doing Paste Special Unformatted text. It will ask for separator options, with Separated by Tabs being suggested. Accept that suggestion, and the list should come into the spreadsheet nice and neatly (depending, of course, on how the list was formatted on the internet site). I've had very good success with this. Then, you'll probably see column A as being blank, so just delete it. If you eventually want it in an Writer document, it's no problem to copy from Calc and Paste Special Unformatted text into Writer, which will have the columns separated by tabs. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] headers
John Kaufmann wrote: In a message dated 2009.09.18 18:40 -0500, Barbara Duprey wrote: ... I can make a running header with page numbers, but I do not want the page number to show on the first page. ... That is described here: http://openoffice.blogs.com/openoffice/2009/07/the-simplest-approach-to-the-most-reliable-way-to-have-no-page-number-on-the-first-page-in-openoffic.html That approach, using different page styles for first page and subsequent pages, requires the writer to (a) identify the start of the second page, (b) insert a page break at that point, and (c) change the page style at that point - which violates the principle of letting the word processor manage text flow. For example, if the first page content is increased, moving the manual page break, what happens to that page style insertion point? FWIW, though, a slight variation on this seems to work OK: After getting more than a page worth of content, go back to the top of the first page, and *then* select a First Page style for that page. Since each page style can say which one should follow it, it should flow with no problem if the First page style says to go to Default next (or an even to odd to even sequence, for that matter). No prediction or after the fact manipulations seems to be necessary. Barbara, I'm not sure what you are suggesting. Did I not correctly identify the steps in the cited article [(a) identify the start of the second page; (b) insert a page break at that point; (c) change the page style at that point]. Was my concern about the requirement for a manual page break not valid? Was the suggested alternative not valid? Sorry to be dense, John The reference you cited seems to be incomplete in its explanation. Actually, one thing the reference says is (There are two easier ways, but with those ways, you lose the formatting if you save the document in .doc Word format, then close and reopen. This one works when you save in Word format.). So it appears that Solveig Haugland, who is a master OOo instructor and knows way more than I ever will, wasn't being incomplete at all, but was just describing one way of doing this, and one that would be robust when the document is saved in Word format. As Barbara said, if you create a page style called First page, and when defining the style, under Organizer, for Next Style, choose Default (or whatever page style you want for the bulk of your document). There is then no need to insert a manual page break. When the page break occurs automatically (by text or other content filling the first page, and then needing a page break), the second page will be the Default style. (As long as you set it up so that the Next Style is Default.) I just tried it and confirmed that it works like Barbara and I explained it. Give it a try, and get back with any questions if it doesn't seem to be working (because it should, and does, work). - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Petition against OOo Renaissance
Tommy27 wrote: no one of the 347 signers (you see, any time i post here the number is always higher...) has complained about scam sites because no one of them is so dumb to be fooled by those advertosing. A number of people have complained (on this very list) about the scam site links. Just take people's advice and set up a new petition with no scam sites, that way you won't have your cause sullied by any association with the scams. It certainly makes one question (properly) the motives of someone setting up a petition when it's loaded with links to scam sites. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Petition against OOo Renaissance
Tommy27 wrote: stay tuned, signature 400 is getting closer... i will alert you when it comes... you don't wanna miss that event, right buddy? Please, spare us all ... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Not possible to unsubscribe me
Phyllis Kahn wrote: I've done that 3 times Harold please don't think I'm an idiot ;You're patronizing again ! yours truly, _ Phyllis M. Kahn Phyllis: As others have pointed out, the address you're sending this from is NOT subscribed. Do you have a different e-mail address that postings from this list are coming to? If so, you need to unsubscribe from that address (from the address that is indeed subscribed). If you have been attempting to unsubscribe from kjoephyl...@msn.com then it will not work, again because kjoephyl...@msn.com is not subscribed. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Writer: Creating Plain Vanilla Document
Don Daugherty wrote: I have what seemingly should be the default, or at least a trivial task. Creating a document with simple formatting, i.e. one with a some standard font and point size, left alignment, and no other features that I do not explicitly invoke. I have tried the folllowing: 1. Use Ctrl+N to create a new text document 2. On line one type Title followed by a two carriage-returns. 3. On line 3 type 1. followed by Tab, followed by Item 1 and a carriage-return. What immediately happens is that line 3 is indented by 0.25 inch (which appears to be about half the distance to the first tab-stop in the ruler bar), and 2. automatically appears in line 4, indented so that it lies directly underneath the 1. It seems that the program knows that I want some outline type of numbering introduced. The program is WRONG! I want and need to set my own document style, which does not match this apparently default behavior. Thinking that the default document template simply needed to be changed, I followed the instructions in Help to create a new template and set it as the default. This was not successful. Either the unwanted Bullets and Numbering behavior is hidden in my supposedly clean new template, or the behavior is indemic to the program itself. Help! To avoid all autoformatting that you refer to: Click on Format (menu item) Point to Autoformat -- you should see that there is a check mark next to While Typing Click on While Typing which will make the check mark go away After you've done this, things should be as you want them to be. (No auto-formatting) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Unsubscribe (was: [users] Calc MySQL macro to insert into)
It's not quite clear what your question is. If you're saying you want to unsubscribe but can't (which is NOT what you said, so I'm just guessing here), it looks to me like you ARE in fact unsubscribed, from this e-mail address anyway, because this came to the list as if you were an unsubscribed address. If it's something else, please get back to the list and clarify. Phyllis Kahn wrote: I have already unsubscribed from this list; please do so. Thank you. yours truly, _ Phyllis M. Kahn - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to set a printing area
Dotan Cohen wrote: In MS Office a user can set a printing area of selected cells, do a print preview, then print only that area. In OOo Calc 3.1 it appears that one can select cells and then print, however, there does not seem to be any way to preview the print beforehand. Is this possible, short of printing to an image file/pdf as a stopgap measure? This is an important feature for a recent OOo convert, possibly a deal breaker (she is encouraging me to add that). Thanks! My response won't be particularly helpful, but there have been times when I wanted to do exactly what you describe, and could not find a way to do it. So unless there is some non-obvious work-around, I don't think it's possible. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to set a printing area
Keith Clark wrote: On Tue, 2 Jun 2009 16:43:25 +0300, Dotan Cohen dotanco...@gmail.com wrote: In MS Office a user can set a printing area of selected cells, do a print preview, then print only that area. In OOo Calc 3.1 it appears that one can select cells and then print, however, there does not seem to be any way to preview the print beforehand. Is this possible, short of printing to an image file/pdf as a stopgap measure? This is an important feature for a recent OOo convert, possibly a deal breaker (she is encouraging me to add that). Thanks! FormatPrint RangeDefine Range FilePage Preview This works for me. Keith That certainly does work well, but it doesn't sound like quite what Dotan was asking, which was to be able to highlight some cells (without setting it as a print range) and just print those cells. Which of course can be done, but it doesn't seem like there is any way to do a page preview when printing a range in that manner. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice 3.1 not compatible with Windows 7?
James R. Liebert wrote: I don't buy this argument for a second. Uncountable collaborations are proceeding toward completion. All life is a collaboration. You are suggesting that the Australian rudder for the Boeing 777 proceeded independently to final design and manufacture while the American tail assembly was designed and manufactured. Pardon the language, but WTF is this about??? And how does it relate to OOo? The difference between the 777 and your next Windows OS is that 777.0.0.0 had to land. What did you say was the name of your employer? James Liebert Akron, Ohio McLauchlan, Kevin wrote: To ALL: Why bother even getting Win 7, if Win 8 is following right behind? NOT only that but some one is working on a Open Source version of Windows which will be totally FREE! Please access the SeaMonkey support site and ask about that program, you may be pleasantly surprised! :-) Um, why bother getting the next three versions of Ubuntu or SuSE, since the version-after-that will be coming along just six months after (insert number of any previous version? Same argument. Windows is big. It's commercial. It needs to be developed, tested, and integrated with a lot of stuff that's: a) out there in the world b) coming (around the time of the new release, such as new hardware and drivers that are in other major companies' planning stages right now and will need instant, out-of-the-box compatibility. So it's completely unsurprising that multiple multi-year projects would be in various stages of conception, development, testing, release, and ongoing maintenance. My own employer... in fact my own small division of my employer... does exactly that for our various products. The release of a product/project is still in QA testing (before final release) while the next two releases are in the pipeline, and earlier releases are in maintenance or being readied for end-of-sales or end-of-life. I would be surprised to encounter a major company with a widely-used product line that did NOT do that kind of planning and scheduling. You were saying? - Kevin The information contained in this electronic mail transmission may be privileged and confidential, and therefore, protected from disclosure. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer without copying or disclosing it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: OT: MS Support for ODF [Fwd: OpenOffice.org Ninja]
Larry Gusaas wrote: This thread, which has nothing to do with giving support to users is now 57 posts long. No wonder people complain about the number of emails they receive from this list. Shouldn't this type of discussion take place on the discuss list disc...@openoffice.org or even on the social list soc...@openoffice.org ? +1 Can't this discussion be moved to another list?? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Strange feature/Travers/Barker
bg wrote: At 21:37 30/04/2009 -0700, Brewster Gillett wrote: Space bar is on strike. In both Calc and Writer, it will give me one space, and one only, then no response from the space bar to subsequent requests. Am I caught in some kind of Template Warp? Should I ask Scotty to beam me up? Brian Barker wrote: What could cause such a thing is that you've discovered the office suite of the future! Multiple spaces are a typewriter artifice, of course, and totally out of place in a word processor, where formatting should be achieved with tabs, margins, table cells, justification, paragraph and character spacing, and so on. Any number of consecutive presses of the space bar should indicate a word break and nothing more. The amount of space this creates - if any - should depend on the context. Allowing multiple spaces is a sop to the typewriter brigade. Brewster replies: Good one! You got me pegged, as a member of the typewriter brigade. I will only observe that there is no way this typewriter brigadier will ever fully adapt to ceding control to that extent to the software until his word processor has the most useful feature of the old Word Perfect; REVEAL CODES. I really despise flying blind, and trusting to some programmer's concept of how word processing should work. Give me REVEAL CODES and I will eventually adapt, yea, even unto (gasp!) the dreaded templates - because a properly implemented REVEAL CODES provides us with a safety net, and abolishes guesswork almost entirely. I am not especially enamored of an office of the future where I have to painstakingly create a set of option decisions to format my work, then trust entirely to the finished appearance to inform me whether my formatting decisions are functioning as intended. That works fine up until some element of it *doesn't*, and which point the lucky user gets to fish around in endless optioning submenus trying to remember which obscure one is causing his text to resemble a corn maze Thanks for the tip, BTW. I don't know how that option got changed, but I have a suspicion, as I have had a couple of guests use the software just recently :-) Brewster Brewster, I'm curious as to what you currently use multiple spaces for, that you couldn't use things like tabs for, without the requirement of the reveal code functionality? For tab stops, as an example, it's quite easy to see what they're doing (where they are located, etc.) with no reveal code. Also, if what you're doing would lend itself to tables instead of tabs, same thing -- I'm not sure why this reveal code option would be needed. But I don't have any understanding of what you're trying to do when you use multiple spaces, so maybe you could explain that.
Re: [users] Differences between the OpenDocument Text (.odt) format and the Word (.docx) format
Robert Holtzman wrote: On Sun, 26 Apr 2009, Dotan Cohen wrote: I found this terrific document onf the microsoft site which answers a rather FAQ regarding ODTsuitability: http://office.microsoft.com/en-us/word/HA102835631033.aspx Note that this document compares ODT with DOCX, not OOo with MSO. After the site scans your computer to see if you have MSO installed you get to the part that says You have arrived at this page because you selected an item that is available only if you have a 2007 Microsoft Office suite or other 2007 Microsoft Office System program installed. I think I'll pass. I didn't get any message like that. I'm using Seamonkey on Windows Vista. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] MY COMPUTER IS OVER LOADED!!!!!!!
Howard Coles Jr. wrote: On Thursday 02 April 2009 11:46:10 am lelia1...@bellsouth.net wrote: I desperately need to delete my open office. My computer is very overloaded. The program will not let me delete it.What do I do? Thanks for any help. Jane Fleming Un-install MS OFFICE instead, you'll get back more space, and you'll be left with a better office suite. There was no indication from the OP that MS Office WAS installed on her computer. Why make that assumption? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] MY COMPUTER IS OVER LOADED!!!!!!!
lelia1...@bellsouth.net wrote: I desperately need to delete my open office. My computer is very overloaded. The program will not let me delete it.What do I do? Thanks for any help. Jane Fleming Could the problem be that the Quickstarter is running? That would be an icon on the lower right corner of the computer screen. I never have mine running so I can't verify exactly what it looks like. If you do have the OpenOffice Quickstarter running, then right click on it, and one of the options should be something like Exit Quickstarter. Once you're done that, try again to uninstall. Also, it might be helpful if you told us what steps you were taking when you attempted to delete the program. Are you using the Uninstall feature of the computer? And if you're doing that, what response do you get from the computer, when it doesn't allow you to delete it? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Multiple page styles or formats in one document?
John Kaufmann wrote: How does one have multiple page formats in a Writer (or other OO) document - either with or without use of Page styles? [Example: a page without columns (that is, 1 column) followed by a page with two columns, followed by a page without columns.] I have tried: - Formatting one page, then inserting a page break, then formatting the next page. - Setting a page style for one page, then inserting a page break, then setting a page style for the next page. Either way it breaks: whenever the page format is changed, or a new page style is invoked, it seems to apply to the whole document. This seems like a common problem, and thus pretty basic requirement, for a word processor, but I've wasted a lot of time looking for an answer. The Wiki http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Working_with_page_styles spuriously touches on this topic - in the context of a cover page followed by default pages - and then dithers into an irrelevant discussion of how to set page style. [One might infer that the only way it even contemplates using multiple styles per page is in that context of a cover page and later pages.] It never returns to the question of how to invoke multiple styles in a document. I can't believe this is not possible. Anyone know the secret? John I do this all the time for a newsletter than I'm the editor of. There may be other ways, but here is what I do, which works well. You can change column formats (from single column to two column for example) within a page. I use sections. Each section can be configured with however many columns you like. To do this, go to Insert Section, and then click on the Columns tab in the section dialog. Let me know if you need any more specific guidance. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Firefox 3.0.8 security release
Manfred J. Krause wrote: Hi, Firefox 3.0.8 security release now available http://blog.mozilla.com/blog/2009/03/27/firefox-308-security-release-now-available/ Manfred Does this relate in some way to OOo? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to override format defaults(?) in Calc
Dick Hoffman wrote: This looks so simple I'm obviously overlooking something but I can't figure out what's happening. In OO-Calc V 3.0.0, I'm trying to type the string DMoines (without the enclosing quotes)into a cell but it keeps getting changed into Dmoines, i.e. I can't capitalize the 'M'. I tried some other things and find that if I type aBCd into a cell and then try to type ABCd into the cell below it, it keeps getting changed to aBCd and if I type EFGh into a cell and then try to type EFGH into the cell below it gets changed to EFGh. What is causing all this, what's the rationale behind it and how do I get around it? You have two related but somewhat separate issues here. 1. To avoid DMoines being changed into Dmoines: Go to Tools Autocorrect Options, and uncheck Correct two initial capitals 2. To avoid the second situation (typing ABCd and having it changed to aBCd if you had previously entered aBCd in that column): Go to Tools Cell Contents, and click on Autoinput to remove the check mark by it. Hope this helps. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] an empty cell in Calc
Walter Hildebrandt wrote: Using 3.1 with WindowsXP If cell A1 is empty and =IF(A1;) is in B1, B1 will have the word FALSE. What can be entered in B1 to get an empty B1 cell? You don't say what you want in B1 if A1 is not empty. If you want B1 to be equal to A1 when A1 is not empty, then try: =IF(A1=;;A1) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] USING OPEN OFFICE
James Knott wrote: John Jason Jordan wrote: On Thu, 26 Feb 2009 08:15:15 + david alistair baines sunnyandrain...@gmail.com dijo: I have just install the full suite of Open Office. I wanted to find an alternative to MS. Power Point in Open Office but I cannot find it? Also other MS. alternatives, such as Word, Excel, etc. Word = Writer Excel = Calc Powerpoint = Impress Access = Base Having said that, while OOo has just about all the features of MS Office, plus a few extras, you will find that all the buttons are in different places and have different names. In the short run you will be frustrated trying to figure out how OOo works, but people on this list will help. Even dumb questions are welcome. And in the long run, you'll be glad you made the switch. Why would he be frustrated? I've introduced a few people to OpenOffice and I don't recall them being frustrated. It may depend on the computer literacy of the people converting from MS Office to OpenOffice. I had a part-time job for about a year, training people, who had done things in MS Office, how to use OpenOffice. The people in general were not extremely computer literate. Very good at their main jobs, just not real computer savvy. There was indeed quite a bit of frustration, which is in fact why I was hired, to minimize the frustration (and I feel that I did the reasonably well). But without some instruction/handholding, their level of frustration would have persisted, in many cases to the point of not wanting anything to do with OpenOffice.
[users] Can we stop putting down other OS's?
Here were two responses to the recent thread: Autosave STILL NOT WORKING(And I acknowledge that the OP may have been a troll ...) In this case, I'd be temped to blame the OS. Just like when you pull the power, a reboot during a file save can cause corruption. Incidentally, a proper shutdown should cause all files to close properly. You've just had an example of why Windows should not be used. Headers show he's using T'Bird on Winders to post to the list. Nuff said. So basically these responses are saying My OS is better than your OS. Is this really helpful, to the OP or anyone else on the list? For one thing, this particular problem, if real at all, is by no means a common or chronic problem with Windows OS, as nothing similar is typically reported. Second, other OS's have specific issues. There have been lots of posts from Mac users with questions about installation problems that are specific to that OS, and some other issues specific to Macs. Would it be helpful to respond, essentially, ha ha, well that's what you get for using a Mac, what else do you expect? Also, there is currently a very long thread about issues specific to a Linux OS. So is that any reason for a Windows or Mac user to take shots at that OS?
Re: [users] Autosave STILL NOT WORKING!!!!
Richard wrote: I have just had an incident where the OS decided to reboot DURING AN OOo AUTO SAVE PROCEDURE and after reboot I HAVE LOST MY DOCUMENT. What is wrong with the developers cant they fix this damn problem, they do not have a chance in hell of getting ms word people to change, with this type of instability, this really sucks, literally hours of work down the drain AGAIN (note no swearing this time so as not to upset or sensitive users). It sounds like the root cause is your OS deciding to reboot. I take it that you have Windows. I also do; for a long time I used Windows XP, now I'm on Windows Vista with a new computer. In spite of all the negative chatter about Windows OS on this list, I haven't experienced the problem that you just described (nor, really, any other chronic or severe issues). So it sounds to me like something is amiss, but not with OpenOffice, rather with your setup. I'm not enough of a computer expert to know what to suggest, but this doesn't sound like an OpenOffice problem. A question about your practices of saving documents -- you state that you had literally hours of work down the drain AGAIN. How often do you save your work? I usually save what I'm doing, when I'm actively working on something and making progress, every 5 minutes or so. Just hit Ctrl+S, it takes about half a second. Then, if there is a crash (or my OS decides to reboot, which never happens to me), I haven't lost more than 5 minutes of work. Not hours of work that you seem to lose, not just once, but multiple times. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated] Vista 64 bit
James Knott wrote: Tom Williamson wrote: Dear Sirs Does Open Office work with Vista Home Premium 64 bit ??? It certainly works with Vista, though I haven't tried it on 64 bit Vista. Since OpenOffice is a free download from www.openoffice.org, why not just give it a try and see what happens? If you have any issues etc., please feel free to ask here again. I am running 64 bit Vista, and I can confirm that OOo 2.4 and 3.0 both run fine on it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: Insert 25 blank lines
Dotan Cohen wrote: Here's an interesting question: how can a user insert 25 blank lines in one step in Calc? This user is still on OOo 2.3 but I can upgrade her to 2.4 or 3.0 if necessary. Select 25 rows (by clicking and dragging in the row numbers at the left edge of the spreadsheet) below where you want the 25 new blank rows inserted. Then choose Insert Rows (or right click and choose Insert). I am pretty sure that will work in 2.3. I verified that it works in 3.0. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: Insert 25 blank lines
Dotan Cohen wrote: 2009/2/1 Richard Detwiler rlsha...@aol.com: Select 25 rows (by clicking and dragging in the row numbers at the left edge of the spreadsheet) below where you want the 25 new blank rows inserted. Then choose Insert Rows (or right click and choose Insert). I am pretty sure that will work in 2.3. I verified that it works in 3.0. I'm here now, and she does have 3.0! Her roommate installed it. The problem is that to get to 25 blank lines, she would have to scroll down about 400 lines and growing. Calc is a bit of a dog with this many lines so that is quite a feat. I need to insert those lines without copy-paste. I'm puzzled. Maybe you misunderstood. You don't have to find where 25 blank rows are. Just select 25 rows (they can have content), then select Insert Rows. No need to scroll down 400 lines. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc and comments
Cardnut Sports Memorabilia wrote: To All - In Excel you can enter comments for a cell and then, when you pass your cursor over the cell, the comments are displayed. Can you do the same for CALC? Steve Yes you can. In Calc, the term is Note instead of Comment. Click once in the cell that you want the note to appear in, then select Insert Note. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Formatting a poem
emf wrote: OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. But then between stanzas one wants to leave a space like between paragraphs. One could use Default style for all the lines and add an empty line between stanzas. Or else, one could use the Default style for other lines and Text body style (that inserts a space after the paragraph) for the last line of a stanza, thus controlling the space between the stanzas. It works but it doesn't seem right. After all, all the lines of the stanza constitute one paragraph... Is there a better way? Eustace Use the keyboard combination Shift + Enter. That will insert a line break w/o inserting a paragraph break. Then at the end of the stanza, press Enter to create a paragraph break. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Disabling number to date conversion
Dotan Cohen wrote: In OOo 2.4 I managed to disable automatic number to date conversion. I cannot for the life of me find out how in OOo 3.0, and from searching the web it seems that this cannot be done?!? I do _not_ want to create a default template. I want to configure Calc so that I can open a document, enter 8.5 into a cell, and not have it turned into a date or anything else. I repeat that for this use case a new default template is _not_ the answer, and neither is defining each cell as text. Thanks. I'm a bit confused by the issue as described. When I open a new Calc file in OOo 3.0, with no special template or formatting, and enter 8.5, it does not get turned into a date, or anything else. It just goes in as 8.5. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Margin measurements in decimals and fractions
Pu Taang Zomi wrote: * Margin measurements in decimals and fractions* *I use OpenOffice.org 3.0 for Windows Vista Home. When I go to Format--Page--Margins, I find that 0.79 inch is the default measurement. 1. How can set the measurement to more than two decimal places, for example, 0.7525 inch? I don't believe (at least I have not been able to find) that there is any way to obtain more precision that two decimal points, when working in inches. Thus, the example of 0.7525 does not appear possible, as far as I can tell. More precision is available if you work in mm, because then you can get down to the nearest 0.01 mm (instead of 0.01 inches). So your example of 0.7525 inches would be approximately 19.11 mm. (19.11 mm = 0.75236 inches, so it doesn't exactly give 0.7525 inches, but it comes much closer than rounding to 0.75 inches would). It is also possible to work in points (1 point = 1/72 inch), and you can specify down to 0.1 points (or 0.00139 inches), so that is another way of achieving higher precision. However, if you're used to working in inches, then working in either mm or points would require some getting used to. 2. How can I set it to fractions, for example 3/32 inch? * I don't believe this is possible either. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Is there a way to copy tabs?
Robert Peirce wrote: In article 21610.7586784803$1230706...@news.gmane.org, Brian Barker b.m.bar...@btinternet.com wrote: At 23:24 30/12/2008 -0500, Robert Peirce wrote: I often need to copy tabbed tables from one doc to another. It would be helpful if I could take the tab stops along, but I can't figure out how to do it. I also can't figure out how, for example, to stick a line in a table and have it use the same tab stop as the other lines. I'm guessing that by tabbed tables you mean those created not using what OpenOffice calls a table, but just aligning material in columns using tabs. And you are talking about a text (Writer) document - right? I find tabs normally being carried over, in fact. But I think I see one problem. Tabs are a paragraph (and paragraph style) property, not a character property. Yes, the tabbed tables are created by aligning data in columns, and you provided the clue to solve the problem. Format-Paragraph-Tabs lists all the tabs and their type. Writing this information down for the correct lines and creating a new list for the full table aligns everything properly. It is a bit tedious but only has to be done once. There's a much easier way to copy tab stops and other paragraph formatting from one paragraph to another. Go to where you want to copy the tabs (and other formatting) from. Click on the Format Paintbrush icon on the toolbar (in my fairly standard configuration, it is near the middle of the top toolbar; it looks like a paintbrush). Then go to where you want to copy the formatting to, and click anywhere in that paragraph. That should do it! (I just verified on my system that it works as described.)
Re: [users] Unwanted hyphenation
I have Vista, and can confirm that what Harold describes is correct. Some additional information: - Make sure that when you right click, it is not on a word that is shown as mis-spelled; otherwise, you get a different context menu, and you won't have Edit Paragraph Style as a choice. - Once you click on Edit Paragraph Style, click on the tab that says Text Flow and see if the box under hyphenation that says Automatically is checked (or ticked, depending on what term you use). If it is checked, then click it to uncheck it. That is most likely the cause of the problem. Harold Fuchs wrote: Top post to keep this thread sane On Win XP Pro if you select a paragraph and *right* click you get a menu. The 12th item is Edit Paragraph Style. Vista may be different in this respect; stranger things have happened ;-) Harold Fuchs London, England On 15/12/2008 18:29, thomas steel wrote: I'm so sorry: there's no such tenth choice on my system. Is the problem perhaps that I'm on Windows Vista? Can I make it clear that what I'm trying to do is not edit a particular paragraph, but to find the place in OO which has suddenly started commanding automatic hyphenation everywhere? TS - Original Message - From: Gene Young n2...@cfl.rr.com To: users@openoffice.org Sent: Monday, December 15, 2008 6:04 PM Subject: Re: [users] Unwanted hyphenation thomas steel wrote: My problems opening docs with OO with uncommanded changes of font have somehow gone away (no more idea how than I have how they occurred). I am also clear how to remove automatic hyphenation for a paragraph. I have installed OO 3. Thank you very much. But I cannot fathom Brian's instructions about disabling automatic hyphenation for a 'paragraph style'. I cannot find 'Edit paragraph style' anywhere in the right-click route. I want to prevent automatic hyphenation happening ever, anywhere in my work. What am I missing, please? TS Right click in the paragraph you wish to edit. About the tenth choice down is Edit Paragraph Style -- Gene Y. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Unwanted hyphenation
Both Harold and I gave you advice on finding the Edit paragraph style selection. Without knowing a little more, it's tough to say why you can't find this. Let's try this -- when you right click on a word (making sure it is not a word flagged as being misspelled), what menu choices do you see? When I do it, the first 3 menu choices are Default formatting, Font, and Size. Is that what you see? If not, then what do you see? If you see these as the first 3 menu choices, if you keep moving down the list, do you see Edit paragraph style as a selection? If not, how many menu items do you have when you right click on a word in a paragraph? Although it might not make perfect sense to you if you don't have a good concept of styles, Brian's advice is correct -- if you're getting hyphenation happening automatically in all paragraphs, that sounds like a paragraph style issue. Get back to us and let us know what happens when you try the above. thomas steel wrote: My problems opening docs with OO with uncommanded changes of font have somehow gone away (no more idea how than I have how they occurred). I am also clear how to remove automatic hyphenation for a paragraph. I have installed OO 3. Thank you very much. But I cannot fathom Brian's instructions about disabling automatic hyphenation for a 'paragraph style'. I cannot find 'Edit paragraph style' anywhere in the right-click route. I want to prevent automatic hyphenation happening ever, anywhere in my work. What am I missing, please? TS - Original Message - From: Brian Barker b.m.bar...@btinternet.com To: users@openoffice.org Sent: Sunday, December 14, 2008 8:31 PM Subject: Re: [users] Unwanted hyphenation At 18:22 14/12/2008 +, Thomas Steel wrote: Another try! Is this the right variant of the OO address to get help? Yup. My system has suddenly started hyphenating words at the ends of lines I cannot find the way to stop it. Can anyone explain the problem simply? Automatic hyphenation is a paragraph property as well as a paragraph style property. You may (unwittingly) have selected automatic hyphenation for the paragraph style that you are using. Alternatively, you may just have selected this property for a single paragraph. Note that, in this case, if you press Enter to start a new paragraph, this will inherit the properties of the previous paragraph; in this way, you may have created a number of consecutive paragraphs separately formatted for automatic hyphenation. o To disable automatic hyphenation for a paragraph or paragraphs, go to Format | Paragraph... | Text Flow | Hyphenation (or right-click | Paragraph... | Text Flow | Hyphenation) and remove the tick from Automatically. o To disable automatic hyphenation for a paragraph style, go to right-click | Edit Paragraph Style... | Text Flow | Hyphenation and remove the tick from Automatically. You may need to try both these techniques, depending on exactly which unwanted setting has become ticked. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Impress: Playing videos on Linux
Laurent Duperval wrote: Hi, Is there any way to play videos on Linux (64 bit). Any format I try (flv, avi, mpg, mp4) I get an error saying the format is not supported. Any help welcome, Am I missing something, or does this have nothing to do with OpenOffice? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calculator shortcut replaced by Open Office Calc
Harold Fuchs wrote: 2008/12/11 Barbara Duprey [EMAIL PROTECTED] Victor Svedberg wrote: Howdy! I would like to change back so whenever i typ Calc in the serachfield on Start Menu in Windows Vista 64Bit SP1 the Calculator starts instead of Open Office Calc. All help appriciated Best regards, Victor Svedberg When I do this on Vista Home Premium, it offers me a choice of the two programs -- nothing actually starts unless I hit Enter, and then it's Calc because it's the first thing listed. I don't know how the order is determined (maybe alphabetic by path name?), but if you click on Calculator that's what will start. Close enough? Or you can try calcu as the search term and then Enter. (Thanks, by the way -- I'd never tried this!) Instead of all this typing and searching, why not just create a shortcut to the calculator and put it on the quick launch bar or whatever it's called in Vista? That way you only have to make a single click to start the calculator. Or if the OP really likes the search method for opening the calculator (as opposed to OpenOffice Calc), he only needs to type one additional letter. Do a search for Calcu instead of Calc, and then the calculator will be the only thing found by the search. (I have Vista and verified that this indeed does work.)
Re: [users] Urgent need - how to convert newer Microsoft docx files
Stephan G wrote: Hello. I am starting to get, more or more frequently, new Microsoft Office file formats where the extension ends in x. So files like my-word-file.docx or my-excel-file.xlsx. These files seem to be created by the newest versions of Microsoft Word, possibly on Macintosh computers, and my OpenOffice on my Windows Vista machine seems unable to open them. I have tried the following: Rename the .docx file to .doc, but it doesn't open. Force open them from the OO File menu, but then I get a huge list of filters. Closest filter I can find is Microsoft Word 97/XP/2000, but it doesn't work. Any further suggestions out there? -stephan golux I don't have any docx documents to verify this on, but my version of OOo 3.0 (on Windows) has docx as an option for opening and saving documents. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Test
I haven't received any mail from this list in a couple of days, and I'm wondering if I was somehow unsubscribed for some reason. Just testing ... sorry for the noise. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] *.pub
CHENMIKE wrote: Hi Manager, Can Openoffice open *.pub files, which originaly from Microsoft Office Publisher. thanks! Mike No it can't. My understanding is that nothing except for Publisher can open .pub files. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bad Bug in 3.0 windoze
The Beaver wrote: In Calc when I type in a number like a part number, it automatically destroys my entry and makes it a date. I tried changing the format to number and it still ruins the spreadsheet by making the part number a date. It seems to work correctly if I format the part number column as text, but if Calc automatically turns all numbers to a date, it will have no useful value as a program. I never had this problem with 2.4 Floyd Floyd -- As Brian said, it would help greatly in understanding what is going on if you could give examples of the part number being changed to a date. Calc certainly doesn't turn all numbers into dates, like you claimed. If your version really does do that, there is clearly something amiss. And as was stated, it sounds like you've identified the solution -- format the part number column as text. Part numbers should be treated as text anyway. It wouldn't make any sense to perform numerical computations on them (like adding up a column of part numbers, or multiplying the part number by 2, etc.). Kind of like phone numbers -- other than being composed of numbers, there is no real numerical meaning to them. You wouldn't multiply two of them together, divide one by the other, add 10 to one of them, etc. and expect them to have any meaning as a phone number any more. So it would help if you replied to the list and gave examples of the part numbers that are being changed. Although it sounds like your problem is solved (format as text), so assuming that continues to prevent your problem, there may be no more need to give any specifics. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc Sheets
Brian Barker wrote: At 17:20 07/10/2008 -0700, David Lowe wrote: I've bumped into a oddity in printing from Calc. Here's the background: for my Physics class, i've put the raw data for distance an object moved in free fall, along with a graph showing position versus time. Since that's already two printable pages, i go and put my 'cooked' data for velocity calculations on Sheet 2. Now i go to print these, and OO tells me There is nothing to print. The selected sheet or range is empty. If i print all sheets, i only get the two pages of Sheet 1. If you define a print range on one sheet only, nothing on other sheets will ever print, since it is not included in the print range. In other words, if you need to define a print range anywhere, you need to define other print ranges on every other sheet that you want ever to print. ... ... i would like to know if this is a known bug, something i've entered in error, or what. As the saying goes: it's not a bug, it's a feature! What Brian describes is certainly the situation, and I view it as a bug! I find in incredibly annoying that if I have a multi sheet Calc file, and I'm very happy with the default range on all sheets except for one, but for that one sheet, I need to define a print range, that now the default range disappears from every other sheet in the file. I know this is how it is, it just doesn't seem logical. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Groklaw - The Microsoft-Stacked SC 34 Committee Makes a Move
Fred A. Miller wrote: Why do I say Microsoft, when this is SC 34? Look at this, will you? It has a list of participants in the July meeting in Japan of the SC 34 committee. The committee membership is so tilted by Microsoft employees and such, if it were a boat, it would capsize. In fact, I'd say it already has. Of the 19 attendees, 8 are outright Microsoft employees or consultants, and 2 of them are Ecma TC45 members. So 10 out of 19 are directly controlled by Microsoft/Ecma. Any questions? http://www.groklaw.net/article.php?story=20080825162905645 And what does this have to do with this OpenOffice users list?? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Convert typed all caps to small caps
David Trimboli wrote: Barbara Duprey wrote: If you just want the caps to be smaller in those cases, couldn't you just set up your special character style to use a smaller point size than your normal text? Yeccch! That's not small caps! Every dead typographer is rolling over in his or her grave right about now. :) Maybe you need to educate us non-typographers by what you mean by small caps then ... or explain what you're trying to achieve, what appearance you want, etc. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] stop automatic space insertions?
Helen wrote: I'm writing a newsletter, and want to prevent some formatting that seems to be happening automatically. 1) When I hit the return key to begin a new paragraph, I get a double space that I don't want. This is the biggest frustration. Helen: I suspect that this is due to the style that you are using for the paragraph being set up for a certain amount of space before and/or after each paragraph. Generally, this is good, to have some separation between paragraphs, but usually something less than the double space that you describe is better. I also do a newsletter, and I have the paragraph style set to give approximately half of the height of a regular line of type. This is easy to change. Go to one of the paragraphs that you're talking about, right click anywhere in the paragraphs (as long as it isn't on a word that is shown as being misspelled), and select Edit paragraph style. Click on the Indents Spacing tab. Where it says Spacing Above paragraph and Below paragraph, change the distances to whatever you'd like. If you really want no spacing at all, set both values to zero. Hope this helps. I'm not familiar with your second problem, so someone else will need to give advice on that. 2) Also, a minor thing: I'm putting a table into a frame, and the frame insists on leaving a large amount of white space above and below the table, taking up more room. I have gone to Tools Options and changed everything that I thought might be causing this, but can't seem to make it stop. Item 1) is especially important, and I'd appreciate some help. Thanks, - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Problems with Open Office
Johnny Rosenberg wrote: I think that most of those who wants icons on the desktop are beginners, while we who want a clean desktop are more experienced users. Since we are experience, we can easily remove or just move the desktop icons to where ever we want while those who are not so experienced maybe are grateful for having them served right at fron of them. So I don't think that would be a big problem, but that's maybe only what I think. I agree totally. I think the default should be to put an icon on the desktop, with a choice not to. As Johnny says, novice users have come to expect that a new program will have an icon on the desktop once it installs. It can be confusing when there isn't even an option to have that done. Experienced users, who don't want icons, can easily delete them. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] dialogue
You can solve the problem for yourself by simply adding dialogue to the dictionary on your computer. Just right-click on the word dialogue in an OpenOffice document, and tell it to add the word to the dictionary. For what it's worth, the spell checker in Thunderbird, which I'm typing this in, also knows the word as dialog rather than dialogue. I'm cc-ing you because you appear to be unsubscribed; please address any additional responses to the list, and not to my personal e-mail address. Benjamin Chasnov wrote: While using Open Office, I noticed that the word dialogue is not known by the spell checker; instead, it knows the less common dialog. I just thought you might want to know if you would like to change this in the future. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Default saved name now Documents?
Mark Hull-Richter wrote: I have noticed since installing OOo 2.4.1 that whenever I open a new text document and then go to save it, there is now a default title of Documents pre-supplied for me. This not only wrong, it is irritating. Any thoughts? mhr Is it the title of the document? Or the filename? I'm using Windows XP, OOo version 2.3.0 (different than yours, I realize). Assuming you're talking about filename and not title: When I go to save a new document, the filename field is blank (which I'm guessing is what you'd like it to be). However, there are other applications I've used that put in a default filename (something like Untitled or something like that), and at least I don't find it any big deal at all to just type in my own filename. So I may be totally misunderstanding your situation, and if so, I apologize. But maybe a little more clarification (like are you talking about title or filename, or document path, etc.) would be helpful. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] If I wanted to be told how to think I'd use Microsoft!
Phil Morgan-Ellis wrote: Excuse me for the exasperation...but I really HATE having a piece of software telling me how to think. I need to put together a worksheet for my class. I'm using the OO Spreadsheet so I can get nice columns. Eight columns each containing the chord for the corresponding measure. Something like: a a a e E E E7 A Not really that hard. (a = a minor -- A=a major -- two *_different_* chords.) However because the first time an a chord is used it's minor the auto correct feature insists that ALL a cords must be minor (what lunacy!). The result is: a a a e e e e7 a (please note that these two are NOT the same.) I've NEVER been able to turn this off, in spite of the help instructions. Placing a quote mark before the A and the quote prints. It's like trying to create a list of words using the spreadsheet or word processor. SOME words begin with capital letters, some don't. Changing that either makes the word wrong or changes the meaning. Why is this NOT understood... Similarly I have a budget spreadsheet using OO. I have a column for my Health Savings Account (HSA). Of course the spreadsheet makes me use HAS. May *I* be permitted to decide what information goes in the cellsplease? Exasportated in Seattle, pHIL First of all, as a fellow musician, I fully appreciate the difference between E7 and e7! Try the following: Go to Tools Cell Content You'll probably see that the selection Autoinput is checked. Click on it, to uncheck it. That should take care of your problem. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Personal information in e-mails
jonathon wrote: On Fri, Aug 22, 2008 at 02:21, Rob Clement wrote: First of all it is not wise to send your personal information over the web to this address as the e-mails are all stored in various places for searching. How wise it is, depends upon the legal jurisdiction one is in, and where one is sending the email from. For _some_ jurisdictions, in specific situations, failure to include that information in an email is a violation of civil law. xan jonathon What jurisdictions and what specific situations would this be?
Re: [users] A bug?
Jerry Nissen wrote: read below remove my name from your damned list. I am sick of it... just a few of the 100 messages I have received. jerry Nissen [EMAIL PROTECTED] [EMAIL PROTECTED] Profanity doesn't help getting you unsubscribed. :) See instructions that are at the bottom of most messages: To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] You need to unsubscribe from the address which is subscribed. The address you sent this note from is shown as being an unsubscribed address. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Comment out?
Xiang Liu wrote: But the notes are simple, it could not contain complex objects such as formula. Best Regards, Xiang Liu ?? In your original post, you said some words should not appear in the final result. The notes will handle words. So you're really after things more complex than words I take it? On Sun, Aug 10, 2008 at 11:07 PM, Brian Barker [EMAIL PROTECTED]wrote: At 17:22 10/08/2008 +0800, Xiang Liu wrote: I am writing a paper, some words should not appear in the final result. But these words should be kept ... You need Notes. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] how to open a spreadsheet file with password
[EMAIL PROTECTED] wrote: i have a file that i have not used for a long time, in which there is a contact no. for a long term client of mine. i cannot open the file. can i email it to someone who can open it? thanks reuben You need the password to open it. Without the password, there isn't any realistic way to open it. It may go without saying, but that's the purpose of password-protecting a file -- that it can't be opened w/o the password. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] how to open a spreadsheet file with password
[EMAIL PROTECTED] wrote: obviously i do not recall the password Obviously not -- but also obviously, w/o the password, no one else can open it either. (Please respond to the list (users@openoffice.org) and not to me personally, in the future.) - Original Message - From: Richard Detwiler [EMAIL PROTECTED] To: users@openoffice.org Cc: [EMAIL PROTECTED] Sent: Saturday, August 09, 2008 1:16 PM Subject: Re: [users] how to open a spreadsheet file with password [EMAIL PROTECTED] wrote: i have a file that i have not used for a long time, in which there is a contact no. for a long term client of mine. i cannot open the file. can i email it to someone who can open it? thanks reuben You need the password to open it. Without the password, there isn't any realistic way to open it. It may go without saying, but that's the purpose of password-protecting a file -- that it can't be opened w/o the password. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] newsletters
Barbara Duprey wrote: Nate Jen SMITH wrote: I had another gentleman email and say that it could do it but it doesn't have the layout tools like Publisher (microsoft office) has. But I'm going to go ahead and give it a try. Thank you! God Bless, Jennifer - Original Message - From: James Knottmailto:[EMAIL PROTECTED] To: users@openoffice.orgmailto:users@openoffice.org ; [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2008 4:24 PM Subject: Re: [users] newsletters Nate Jen SMITH wrote: Does Openoffice have a tool for making newsletters? Yes, the word processor, called Writer can do that. Do you have any specific requirements you're looking for? The help topics most likely to be of interest to you for a newsletter deal with page formats, sections, and frames. Among them, they give you a great deal of control over what goes where in the output. You may also be interested in Fontwork, and in the Draw application within OOo, for more graphics capabilities. Good luck, and come back to the list with questions any time! Jennifer, For what it's worth, I'm the editor of a newsletter for our local orienteering club. I've been using OpenOffice Writer for the newsletter, for something like 4 years now, and find that it meets my needs very well. The page layout of our newsletter is not extremely simple, so it can handle things beyond real basic stuff. I have to say, though, that I have no experience with a page-layout application like Publisher or Scribus. So I can't say whether Writer is the best tool for the job I'm doing or not -- only that it works, and I'm familiar with Writer so I don't need to learn something totally new. I did make a (somewhat feeble) attempt to learn Scribus, but didn't meet with any immediate success and didn't persevere, deciding to stick to Writer. The Help topics that Barbara mentions are all very good ones. I use all of those in doing the page layout for the newsletter that I do. I would add to that list: styles (page styles and paragraph styles, in particular). I use those extensively. For what I do, I haven't used Fontwork nor the Draw application that Barbara mentioned; not to say these wouldn't be useful to you, just that I haven't needed them. If you have any specific questions, please don't hesitate to reply back to the list (or to me directly, for that matter), and I'll be glad to help as much as I can. Or if you'd like to see an example of our newsletter, I'd be glad to send that along. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Fwd: confirm unsubscribe from users@openoffice.org
mike scott wrote: On 1 Aug 2008 at 18:59, Mark Knecht wrote: Get a threaded email client like GMail. Whatever number of messages there were today I hod only 3 threads to delete. No big deal. Heck, I get almost 300 a day on average from the Linux Kernel mailing list so this was just noise... ;-) Cheers, Mark I've had 8 copies of this one so far (msg id [EMAIL PROTECTED]) and 7 of one from NoOp ([EMAIL PROTECTED]) also about Terrance. Nothing else seems to be repeated. Anyone else seeing this? Yes, I saw the same thing. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Re: Terrance
wgallagher1 wrote: what the hell are you talking about you sent to the wrong person ;I am a police officer What does that have to do with this discussion? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
Jason Cipriani wrote: On Fri, Jul 25, 2008 at 3:54 PM, Richard Detwiler [EMAIL PROTECTED] wrote: Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Jason -- can you be more specific about what you're trying to do? And what specifically you're typing, with the hyphen? I can't replicate a problem in this regard, so I assume I must be doing something differently than you are. What I tried is typing - test (without the quotes) in a cell. Your test is not what I was trying to do. I am only typing a hyphen, nothing else. The solution is to press enter before moving to another cell (although enter moves the cursor down one cell). The reason I'm clicking on other cells is because I'm quickly entering data into various places in a spreadsheet, and sometimes I want to move to another cell, so I click on it. Jason Interesting -- I still can't duplicate what you're seeing. When I type just a hyphen in a cell, then press an arrow key or click in another cell, it simply enters the hyphen as typed, and doesn't try to make it into a formula. Possibly it's a version difference -- I'm using OOo 2.3.0, on Windows XP. I've always taught (and been taught) in Excel that to make a formula, it always always has to start with an equal sign. And I had assumed (and found) that to be true in Calc as well. But possibly a more recent version of Calc enables starting formulas with + or - signs as well? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Thanks, Jason Jason -- can you be more specific about what you're trying to do? And what specifically you're typing, with the hyphen? I can't replicate a problem in this regard, so I assume I must be doing something differently than you are. What I tried is typing - test (without the quotes) in a cell. Whether I pressed Enter, or used an arrow key, or clicked in another cell, the text went in exactly as I typed it. Also, it's not clear to me why, if you're in the middle of typing something into a cell, you'd want to click in another cell. Please get back with more specifics. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Reading PDF Files
[EMAIL PROTECTED] wrote: Hello! I am about to start proofreading for another organization. I am used to receiving my articles in Word Files and want to update my creaky Word 97. The new group sent me PDF files and I don't have Adobe.? Can OpenOffice read/edit PDF files? Please answer ASAP. Thanx. Helene O'Neill You must be one of the only people on the planet that doesn't have Adobe Reader! My suggestion would be to download it from Adobe -- it's free (the Reader application, that is). It won't let you edit PDF files, but you can at least read them. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Installing OO.o on PCLinuxOS
Daniel Sears wrote: OK whats going on? Why am I reading other peoples Email Questions? You must have subscribed to this mailing list (OpenOffice users' list). If you want, you can unsubscribe. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
Whenever you download something, you're given a choice of where it goes -- where did you put it? If you have no idea, then start downloading something again, and see what the default location is (the location where the computer puts it if you don't tell it to put it somewhere else). John B Pace wrote: I downloaded OpenOffice but could not find it! much less start using it. Where did it go in my computer?? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] turn off autoformatting?
Helen wrote: OO insists that I should have an outline when I don't want one. I want several paragraphs under item 1, and then several under item 2, and OO will not let me! It insists that if I type a 1, and then hit return, the next thing I type must be 2! I've tried many times to turn off the auto-formatting, but, other than unchecking the check, which does no good, I don't see any way to stop it. How how I tell OO that I do not want help with formatting? Thanks, There are two ways to do this. If you want to turn off all auto-formatting, then: Format Autoformat While typing (click on it to remove the check mark) If you want to turn off specific features, like in your case, auto-numbering: Tools Autocorrect, then click the Options tab, and uncheck the box marked Apply numbering - symbol - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]