Re: [users] Re: Microsoft to release ODF document converter
Rob, Are you sure, that isn' what the press releases say. The story they are giving is that the Open source project is funded by Microsoft and that the converter will be available to download from both the Open source site AND the Microsoft site. Graham On 03/02/07, rob [EMAIL PROTECTED] wrote: Graham and Joe I believe there are 2 different ODF converter add-ons to Word 1) There is one being prepared for the latest version of Word under Microsoft's ownership. This will not save ODF 2) There is another open source ODF add on that will save. I think that is the full picture Thanks Rob -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Joe Smith Sent: 03 February 2007 03:17 To: users@openoffice.org Subject: [users] Re: Microsoft to release ODF document converter Graham Smith wrote: Assuming we are talking about the same convertor, the one I just installed allows opening and saving ODF files from the file menu in Word 2003. Open mouth--insert foot. It says Open and Save ODF right on the SF project page. I don't know what I was thinking of. Thanks for the correction. Joe - 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]
[users] ODF converter for Word needs Office 2007 compatibility pack to work
To follow on from the other thread on this: to read and write ODF files with versions of Word older than 2007 you need to also install the Word 2007 compatibility pack. http://office.microsoft.com/en-us/products/HA101686761033.aspx Graham
Re: [users] Microsoft to release ODF document converter
The article on ZDnet states that they're going to work on Excel (ods) first and the Powerpoint(odp). Arnold Huzen John Meyer schreef: Robin Laing wrote: M Henri Day wrote: Well, with Microsoft one rarely knows whether a piece of news is good or bad - but one can always hope !... Henri Okay, now that they're doing odf, what about ods, odp, and odb? - 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]
[users] vertical text
How can I get both horizontal and vertical text on the same page? As in a flyer to post on a bulletin board, with horizontal text, and tear-off phone numbers along the bottom. Thanks, Helen, using OO on Linux, Suse
Re: [users] Re: Microsoft to release ODF document converter
On Sat, 03 Feb 2007 07:51:11 + rob wrote: Graham and Joe I believe there are 2 different ODF converter add-ons to Word 1) There is one being prepared for the latest version of Word under Microsoft's ownership. This will not save ODF 2) There is another open source ODF add on that will save. I think that is the full picture Novell and Microsoft are collaborating on a lab that will work on compatability. OpenXML - ODF is just one of the angles they will be exploring. http://www.linux-watch.com/news/NS2912974320.html I like the title, Hell Freezes Over. Is 2007 the lets play nice year or are we looking at Wolverine with the blades hidden inside the arms (X-Men reference)? Time will tell. -- Michael Those that can, do; those that can't, teach. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] vertical text
On Sat, 03 Feb 2007 03:55:58 -0500 Helen wrote: How can I get both horizontal and vertical text on the same page? As in a flyer to post on a bulletin board, with horizontal text, and tear-off phone numbers along the bottom. Thanks, Helen, using OO on Linux, Suse A table may be your easiest way. Set your text. Highlight the text you wish to rotate then Format - Character. Rotation is on one of the tabs. Sorry, can't be more specific. This old PIII is running an old version of OO.o. -- Michael Those that can, do; those that can't, teach. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Ref:[users] vertical text
How can I get both horizontal and vertical text on the same page? One word: Tables. create a table, insert the text, select the text inserted then format / char / position rotation scale and select between: 0, 90 and 270 degrees and the scale. Saludos Roberto - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Base Queries
Please can someone point me to detailed instructions on the use of queries, or resolve the following problem. I have read the Getting Started documentation and have no problem with it but it does not answer my problem. I have two large tables in a database converted from Access, A and B. Table A contains 3 fields 2 of which I am interested in , namely ID, y and z. Similarly table B also has 3 fields ID, w and x. In Table A field z I can insert a number which gives me a list of all instances for the equivalent field in field y. This field then becomes field w in table B and I wish to know all instances in field x that the output in field y (=field w) occur. Please note that the fields y and w do not have the same title. I hope this is clear, Thank you. Ron Ferguson
Re: [users] Ref:[users] vertical text
Or use text boxes. 2007/2/3, jaime . bouchan [EMAIL PROTECTED]: How can I get both horizontal and vertical text on the same page? One word: Tables. create a table, insert the text, select the text inserted then format / char / position rotation scale and select between: 0, 90 and 270 degrees and the scale. Saludos Roberto - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Microsoft to release ODF document converter
TerryJ wrote: M Henri Day wrote: OOo-users will presumably find the ZDNet article, available at http://news.zdnet.com/2100-3513_22-6155585.html?tag=nl.e622, of interest Henri The SourceForge reference is http://sourceforge.net/projects/odf-converter If the same package is available from both sites, perhaps it would be a good idea to get it from MS, so they can see how many people support ODF. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] vertical text
Helen wrote: How can I get both horizontal and vertical text on the same page? As in a flyer to post on a bulletin board, with horizontal text, and tear-off phone numbers along the bottom. Go into the help and search on rotating text for details. Essentially, you save the text as an image and then rotate the image. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Microsoft to release ODF document converter
M Henri Day wrote: OOo-users will presumably find the ZDNet article, available at http://news.zdnet.com/2100-3513_22-6155585.html?tag=nl.e622, of interest Henri Thanks a lot for the relay nikos -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Cycling through open documents using the keyboard
When I have several documents open in OOorg (ver. 2.0), is there a way to run through them (i.e. activate them) in succession with a keyboard shortcut such as e.g. the Ctrl+F6 combo in M$Win? I've looked for a way to define one in Tools-Options-Keyboard, but no joy. Must I perhaps write a macro to move from doc to doc? Or am I perhaps overlooking something? Any help will be thankfully appreciated jdh _ kubuntu 6.06 LTS on i586 w/ 512 MB
Re: [users] Cycling through open documents using the keyboard
Did you try Alt Tab ? Marc H. john d. herron a écrit : When I have several documents open in OOorg (ver. 2.0), is there a way to run through them (i.e. activate them) in succession with a keyboard shortcut such as e.g. the Ctrl+F6 combo in M$Win? I've looked for a way to define one in Tools-Options-Keyboard, but no joy. Must I perhaps write a macro to move from doc to doc? Or am I perhaps overlooking something? Any help will be thankfully appreciated jdh _ kubuntu 6.06 LTS on i586 w/ 512 MB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc function that returns the value of the current cell?
Hi, First post here. I'm a newish Open Office user and not much of an Excel user. I'm looking for a function in the library that would return the value of the current cell, much like what I see at the top in the input line. I've been searching through the docs but can't seem to spot it. I need a specific cell in my spreadsheet to essentially track where ever I place my mouse. If I have to take it in two steps by first getting the address of the current cell and then somehow getting the contents of that address that would be fine also. Thanks in advance for any help you can provide. Cheers, Mark - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc function that returns the value of the current cell?
Mark Knecht wrote: Hi, First post here. I'm a newish Open Office user and not much of an Excel user. I'm looking for a function in the library that would return the value of the current cell, much like what I see at the top in the input line. I've been searching through the docs but can't seem to spot it. I need a specific cell in my spreadsheet to essentially track where ever I place my mouse. Let me see if I understand this. For example, when you move the mouse pointer over cell E7 you want to see the contents of that cell. If that is the case, I don't think it can be done. I don't think the cells are mapped as a series of hot spots. If I have to take it in two steps by first getting the address of the current cell and then somehow getting the contents of that address that would be fine also. Thanks in advance for any help you can provide. Cheers, Mark - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Calc function that returns the value of the current cell?
Victor Chapman wrote: Let me see if I understand this. For example, when you move the mouse pointer over cell E7 you want to see the contents of that cell. If that is the case, I don't think it can be done. I don't think the cells are mapped as a series of hot spots. Well, here's an idea? How about a Macro that automatically writes the contents of which cell is selected when it is selected? Could you write a macro to trigger on that event? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] bulleted text
When I create bulleted text, it is always too far to the right. I then select the format/bullets and numbering menu and press the default button. Why aren't bullets created with the default spacing in the first place? This happens under both Windows and Linux with default builds. It is a mild pain that I finally got around to writing about. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Job search resume
I am with the website www.tutorialsforopenoffice.orgNon-profits have ask us for a tutorial to teach how to write a job search resume with OpenOffice. Does anyone know where to find such a tutorial or will someone outline such a tutorial. - Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.
Re: [users] Re: Calc function that returns the value of the current cell?
On 2/3/07, Victor Chapman [EMAIL PROTECTED] wrote: Mark Knecht wrote: Hi, First post here. I'm a newish Open Office user and not much of an Excel user. I'm looking for a function in the library that would return the value of the current cell, much like what I see at the top in the input line. I've been searching through the docs but can't seem to spot it. I need a specific cell in my spreadsheet to essentially track where ever I place my mouse. Let me see if I understand this. For example, when you move the mouse pointer over cell E7 you want to see the contents of that cell. If that is the case, I don't think it can be done. I don't think the cells are mapped as a series of hot spots. Hi Victor John, Thanks for the responses. Sorry but I see I wasn't clear enough. Let me write a bit more. I'm not looking for mouse hot spots, although that would be very cool. In my case I have completely selected the cell either using my keyboard or the mouse. At this point the 'Name Box' in the upper left shows the cell's address saying 'B1' or 'C5'. What I need is that as I move the selected cell, using the keyboard arrow keys for instance, I will go from B1 to B2 to C3 to C4 to C5. As I make each of those steps I need a specific cell in my spreadsheet to show me the value in the cell I'm at as I pass through them. Here's the setup. I have a list of 100 stocks which gets updated each week. In my spreadsheet I have built an array of each week's list residing in a column with increasing weeks going to the right. For 26 weeks I have 26 columns of 100 stocks. Elsewhere in my spreadsheet I have a cell where I can type into it an arbitrary stock symbol. Using conditional formatting the spreadsheet then highlights every occurrence of that stock's symbol in the array. This is great and helps me see how each stock has been moving in the list as the weeks progress. However, it's a bit difficult and slow since I have to always go back to that one cell to enter a stock symbol and then have to scroll up/down/left/right to see the whole array as this array continues to grow to the right week after week. What I would like to do is to select any cell in the main array of stocks and have the contents of that cell put in my main selection cell, which will then cause the main array conditional formatting to show me all the other cells with the same symbol. Maybe you can think of an easier way to do this? I hope that clarifies a bit. Thanks very much, Mark If I have to take it in two steps by first getting the address of the current cell and then somehow getting the contents of that address that would be fine also. Thanks in advance for any help you can provide. Cheers, Mark - 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] Job search resume
Walter Hildebrandt wrote: I am with the website www.tutorialsforopenoffice.orgNon-profits have ask us for a tutorial to teach how to write a job search resume with OpenOffice. Does anyone know where to find such a tutorial or will someone outline such a tutorial. I'm not so sure that this belongs here so much as it does on a general job hunting forum. Writing a resume in Writer is the same as writing it in Word. What you probably want is templates. And while we're at it, why are you with a web site for open office tutorials if you don't know the first thing about those templates in the first place? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Job search resume
John Meyer produced the following on 2/3/2007 8:24 PM: Walter Hildebrandt wrote: I am with the website www.tutorialsforopenoffice.orgNon-profits have ask us for a tutorial to teach how to write a job search resume with OpenOffice. Does anyone know where to find such a tutorial or will someone outline such a tutorial. I'm not so sure that this belongs here so much as it does on a general job hunting forum. Writing a resume in Writer is the same as writing it in Word. What you probably want is templates. Are you sure? Are resumes different from job search resumes (I assume he means something online)? And while we're at it, why are you with a web site for open office tutorials if you don't know the first thing about those templates in the first place? Maybe he's the CEO or the patron of the site. Lighten up; it's almost time for the Super Bowl! :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Job search resume
Pete Holsberg wrote: Maybe he's the CEO or the patron of the site. Lighten up; it's almost time for the Super Bowl! :-) True true. So, which super bowl commercial are you looking forward to? I want to see the Geico caveman spot? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] MS Reader
I just found some e books on line that have a .lit file label. I believe these are for MS Reader. Will open office work on these files? HJ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Job search resume
John Meyer produced the following on 2/3/2007 8:38 PM: Pete Holsberg wrote: Maybe he's the CEO or the patron of the site. Lighten up; it's almost time for the Super Bowl! :-) True true. So, which super bowl commercial are you looking forward to? I want to see the Geico caveman spot? I watched the Best Super Bowl Commercials show last night. Some where pretty good. I'm looking forward to the GM commercial, thought up by a college freshman who won their competition Georgia Katelyn Crabb of North Prairie, WI; University of Wisconsin - Milwaukee, I believe. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Job search resume
Walter Hildebrandt wrote: I am with the website www.tutorialsforopenoffice.orgNon-profits have ask us for a tutorial to teach how to write a job search resume with OpenOffice. Does anyone know where to find such a tutorial or will someone outline such a tutorial. I suspect you should be teaching how to write a resume, not just one in OO. OpenOffice is just a tool for performing the job. You may however, use the exercise to teach OpenOffice use. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [users] Disappearing Pictures
On Fri, 2007-02-02 at 15:08 +0100, Joe Grech wrote: Rt click on the pict; from the dialogue box that appears choose: anchor: to page (or to paragraph if it is more appropriate). I'm not sure what problem this is repsonse is supposed to fix! If you read what I sent, doesn't seem to apply at all. The pics have DISAPPEARED - nowhere to be found in the document. Upon further investigation if I click where the picture USED TO BE, an outline appears and I can bring up the picture panel. If I go to the picture panel it shows a thumbnail of the picture BUT THE PICTURE DOES NOT DISPLAY AT ALL (plus the caption is now at the top of the pic instead of at the bottom where it was originally). WHY would a pic inserted in a frame JUST disappear from the document? The pic was anchored to the frame. Pics disappearing from frames they are anchored to appears to happen randomly BUT OFTEN enough to be of concern. The pic is there in a way but won't display on screen or when printed or output to a pdf. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Job search resume
Pete Holsberg wrote: John Meyer produced the following on 2/3/2007 8:38 PM: Pete Holsberg wrote: Maybe he's the CEO or the patron of the site. Lighten up; it's almost time for the Super Bowl! :-) True true. So, which super bowl commercial are you looking forward to? I want to see the Geico caveman spot? I watched the Best Super Bowl Commercials show last night. Some where pretty good. I'm looking forward to the GM commercial, thought up by a college freshman who won their competition Georgia Katelyn Crabb of North Prairie, WI; University of Wisconsin - Milwaukee, I believe. I am hoping I catch the commercials. I hate football. I watched that show too and am looking forward to the GM commercial. I didn't understand why all the entries were done by teams except the one woman who won. I found that odd. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Calc function that returns the value of the current cell?
Mark Knecht wrote: On 2/3/07, Victor Chapman [EMAIL PROTECTED] wrote: Mark Knecht wrote: Hi, First post here. I'm a newish Open Office user and not much of an Excel user. I'm looking for a function in the library that would return the value of the current cell, much like what I see at the top in the input line. I've been searching through the docs but can't seem to spot it. I need a specific cell in my spreadsheet to essentially track where ever I place my mouse. Let me see if I understand this. For example, when you move the mouse pointer over cell E7 you want to see the contents of that cell. If that is the case, I don't think it can be done. I don't think the cells are mapped as a series of hot spots. Hi Victor John, Thanks for the responses. Sorry but I see I wasn't clear enough. Let me write a bit more. I'm not looking for mouse hot spots, although that would be very cool. snip. Here's the setup. I have a list of 100 stocks which gets updated each week. In my spreadsheet I have built an array of each week's list residing in a column with increasing weeks going to the right. For 26 weeks I have 26 columns of 100 stocks. Elsewhere in my spreadsheet I have a cell where I can type into it an arbitrary stock symbol. Using conditional formatting the spreadsheet then highlights every occurrence of that stock's symbol in the array. This is great and helps me see how each stock has been moving in the list as the weeks progress. However, it's a bit difficult and slow since I have to always go back to that one cell to enter a stock symbol and then have to scroll up/down/left/right to see the whole array as this array continues to grow to the right week after week. What I would like to do is to select any cell in the main array of stocks and have the contents of that cell put in my main selection cell, which will then cause the main array conditional formatting to show me all the other cells with the same symbol. Maybe you can think of an easier way to do this? I hope that clarifies a bit. Thanks very much, Mark If I have to take it in two steps by first getting the address of the current cell and then somehow getting the contents of that address that would be fine also. Thanks in advance for any help you can provide. Cheers, Mark The spreadsheet I formerly used had a function called CELLPOINTER. It could be used with the same parameters as the CELL function, similar to Calc's CELL function. It would reveal, for example, the contents of the cell currently occupied by the cell pointer (or cursor, if you prefer). There is, as far as I've been able to discover, no comparable function in Calc. It would be possible to design such a function for your own use with script but user-defined functions have severe shortcomings, unless you go the whole way and write an add-in. I use a different setup to you. I have a sheet dedicated to each stock and each day's trading summary for the stock is appended to the table of daily trading. At the end of each week, a weekly summary is extracted and appended to a table of weekly trading. The tables were originally constructed that way so that I could easily insert charts using the data. On the first sheet, I have a table which contains a row for each stock. The row contains, in the main, formulas calculating various results based on the daily table or data in that row itself. The first column contains the stock code which can act as a reference for formulas in that row. The result is that, generally speaking, I only need to look at the individual stock tables when considering a transaction. mouse hot spots, whatever they are, may be better. I suggest you think about constructing a table with formulas which reveal the information you require. HTH -- View this message in context: http://www.nabble.com/Calc-function-that-returns-the-value-of-the-current-cell--tf3167106.html#a8790601 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Disappearing Pictures
The pics have DISAPPEARED - nowhere to be found in the document. Upon further investigation if I click where the picture USED TO BE, an outline appears and I can bring up the picture panel. If I go to the picture panel it shows a thumbnail of the picture BUT THE PICTURE DOES NOT DISPLAY AT ALL (plus the caption is now at the top of the pic instead of at the bottom where it was originally). Even modifying the size % doesn't improve the situation ? If you copy the file, open it with an archive manager and look into the /Pictures folder, do you see your pics ? If not, then, bad luck. WHY would a pic inserted in a frame JUST disappear from the document? The pic was anchored to the frame. Pics disappearing from frames they are anchored to appears to happen randomly BUT OFTEN enough to be of concern. The pic is there in a way but won't display on screen or when printed or output to a pdf. For pictures, I think that the more robust method is to insert them in a table, this way, there is no wrapping/anchoring issue with text. Note that a caption automatically inserts a frame around the picture. Inserting a picture in a frame and again in another frame may lead to problems. Do you save in .odt or .doc ? There ARE problems with pictures in frames for .doc. Hagar. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] bulleted text
When I create bulleted text, it is always too far to the right. I then select the format/bullets and numbering menu and press the default button. For bullets, the best way is to use the Stylist (F11), open the Bullet/Numbered List pane (last right icon on the left of the Stylist) and then apply a style that you customize. Hagar. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]