[users] Re: Chart data labels -the hard way?
Harold Fuchs wrote: Victor Chapman wrote: I have a data set that has positive and negative numbers. I want to apply a power regression curve fit to my data. In order to do that I have to transpose the numbers so that all of the data are 0 or a positive number. My question is how do I plot the graph so that I show the original data labels before the transformation? TIA - 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] I haven't played with this so I may be talking through the top of my head but can't you generate a *separate* set of numbers transposed as necessary and graph *it* but using the original set as data labels? This is what I would like to do, but if there is a way of doing this I can't figure out what it is. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Chart data labels
I have a data set that has positive and negative numbers. I want to apply a power regression curve fit to my data. In order to do that I have to transpose the numbers so that all of the data are 0 or a positive number. My question is how do I plot the graph so that I show the original data labels before the transformation? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Text file import to Calc
I have a text file that is columnized (is that a word!) by spaces not commas or tabs. The first row has the column headings. How do I import this file into calc (or base). TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Text file import to Calc
Anthony Chilco wrote:
Hi Victor,
If you change the extension to CSV, you'll get a text import dialogue
when you open the file ('file / open' or drag and drop). Click the
'Fixed Width' radio button, then set the columns by clicking on the ruler.
tc
Thank you. I did figure this out although I took a different approach.
In calc, Insert Insert from file leads to the same import dialogue.
Victor Chapman wrote:
I have a text file that is columnized (is that a word!) by spaces not
commas or tabs. The first row has the column headings. How do I import
this file into calc (or base).
TIA
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Change dictionary in Linux
I run a dual boot system, Windows XP and openSUSE 10.3. On the windows side it is easy to select the English (Canada) dictionary. I would like to be able to do the same thing while using openSUSE. However, there is no wizard for the dictionary in openSUSE. So the question is, how do implement the English (Canada) dictionary using the Linux version of openoffice? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Printing, how do I ....
I may use the wrong terminology here, but. I have workbook with several pages (tabs). What I would like to do is to is to define a single print page using data from several of the tabbed pages. In spite of my best efforts I can't figure out how to do this. Help will be appreciated. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Printing, how do I ....
Brian Barker wrote: At 15:26 17/01/2008 -0500, Victor Chapman wrote: I may use the wrong terminology here, but. I have workbook with several pages (tabs). What I would like to do is to is to define a single print page using data from several of the tabbed pages. In spite of my best efforts I can't figure out how to do this. I don't think it is possible to combine information from more than one (tabbed) sheet of a spreadsheet on one page of printout, in fact. (Perhaps someone will know better.) The simplest way to do what you need is merely to copy all the information you require into a region of one sheet - even, perhaps, an extra sheet constructed for this purpose. When pasting into the area you are going to print, use Edit | Paste Special... (or right-click | Paste Special..., or Ctrl+Shift+V) instead of ordinary Paste, and then tick Link under Options. This will mean that your new cells will have references back to your source cells and will change when those cells change. Use Format | Print Ranges | Define to restrict what you then need to print. I trust this helps. Brian Barker Thank you. I had discovered this work around. However, I was hoping that there might be a more elegant solution! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Link to External Data
This is my second post on this topic. Does anyone use the Link to External Data found in calc. Are there any examples or tutorials out there on how this feature is supposed to work. I am trying to pull data from a web site using this feature and find that it like trying to grasp a handful of fog. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Envelope Printing -- Disappearing Address
Maybe this is a bug, but I'll try here first. I have followed the instructions here: http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Printing_envelopes to setup and print an envelope. I insert the envelope and look at it in the print preview and it looks great. However, when I print the envelope, the return address appears, but the destination address does not appear! I have always believed in WYSIWYG, but that doesn't seem to apply here. There must be an easy answer to this, but I don't know what it is. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Envelope Printing -- Disappearing Address
Peter Hillier-Brook wrote: Victor Chapman wrote: Maybe this is a bug, but I'll try here first. I have followed the instructions here: http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Printing_envelopes to setup and print an envelope. I insert the envelope and look at it in the print preview and it looks great. However, when I print the envelope, the return address appears, but the destination address does not appear! I have always believed in WYSIWYG, but that doesn't seem to apply here. There must be an easy answer to this, but I don't know what it is. You have described the classic situation where the envelope orientation in relation to your printer is not correctly set up. This is done via the Printer tab when you insert the envelope. One way to check this is to print your envelope on to a normal sheet of paper - is that A4 in Canada? - and inspect the results in relation to the printer's envelope feed position. Peter HB Do I need to start over again to fix this? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Envelope Printing -- Disappearing Address
Peter Hillier-Brook wrote: Victor Chapman wrote: [snip] You have described the classic situation where the envelope orientation in relation to your printer is not correctly set up. This is done via the Printer tab when you insert the envelope. One way to check this is to print your envelope on to a normal sheet of paper - is that A4 in Canada? - and inspect the results in relation to the printer's envelope feed position. Peter HB Do I need to start over again to fix this? You *may* do it the hard way by tinkering with the page format, but I would strongly suggest starting again. It's only 20 seconds from your life, after all and the hard way would take longer. :-) Peter HB Works great. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] External Data in Calc
Are there any good examples of how to use the Link to External Data function in Calc. I would be particularly interested in pulling data from a web site that continuously updates weather or stock market data. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Outlines in Writer
NoOp wrote: On 12/20/2007 01:44 PM, Victor Chapman wrote: [snip thread hijack] Huh! Is this a new post? Doesn't appear to be an answer to my font question. Sigh... I only hope that amongst all of the nonsense that you've gotten your answer. Further to my last; I've found that you can be rather creative with shadows also use proper fonts if you open a text box first from the fontwork menu (AI icon), insert your text in the font style you want, select arc, font color, and shadow color. Makes a rather nice Merry Christmas using green letters red shadow :-) Gary Thank you for this. I have used this before and you can do some nice things as you suggest. I have just found that working with fontwork is a little more time consuming (and less friendly) than working with regular fonts. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Font fill -- how to
There is a function to enable the outline of a font. How do I fill the font with a different colour than its outline? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Outlines in Writer
Joseph (Ragweed) wrote: I use outlines quite a lot, but I find the OO Outlines rather frustrating. When I use them, I like it set up as follows: I. A. 1. a. i. * However, I can set them to this, but they will [apparently] default back to the original settings which I don't care for. Also, when I don't want to use outlines, I can't seem to get it shut off. I try, but if I make a list of things and use numbers for each, it will again default back to using its outline format. How can I get it to do what I want it to do??? Joseph Huh! Is this a new post? Doesn't appear to be an answer to my font question. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Fonts
Where does oo put the fonts in a Linux install? What is a good source for additional fonts? TIA. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Business Cards -- Personal (Private)
Can someone provide me with a step by step set of instruction of how I do this using the Business Card wizard. Please don't provide me with the theory of how this is done, I would like to hear from someone who has actually done it! TIA. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Business Cards -- Personal (Private)
Guy Voets wrote: I just went through the process: passing from one tag to the next, left to right, I choose from all the possible options, and in the end clicked on New Document. Do you have specific questions? Let me replay how I think this should work. I do the following first: Tools Options OpenOffice.org User Data Address and I fill in the form leaving the Company and Title/Position blank. Then I go to File New Business Cards Private. I fill in another name. Then I click on New Document. At that point it fails. I only get one name and no phone number or email address in the business card. So what am I doing wrong? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Fonts
Joe Conner wrote: From a prior poster: QUOTE there is a package of Microsoft True Type core fonts available for Linux at http://corefonts.sourceforge.net I am usually pretty good at following instructions, but the above URL and the information found there is too much of a jungle for me! Is there a more user friendly plan B? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Insert Header at Page 2
Dave Barton wrote: Original Message From: Victor Chapman [EMAIL PROTECTED] Date: Mon 27 Aug 2007 12:03:42 EST I have created a document. Now I want to insert a header at page 2 that will not appear on page 1 and have it carry the same heading for the rest of the document. I also want to have the page number as part of this header. How do I do this? You need to use styles. Open the help file and search for: First Page page style HTH Dave Thank you for this. Here is where I am at now. The style for Page 1 has no header and that works. I created a new style called Page 1. It follows page 1 and turns the header on for subsequent pages. Then in the header on page 2, I created a two column, one row table and entered my text and the automatic page number. The problem that I now have is that the text and page number doesn't carry on into the header area on subsequent pages. So my next question is how do I make that happen. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Insert Header at Page 2
Michele wrote: On 8/27/07, Victor Chapman [EMAIL PROTECTED] wrote: Dave Barton wrote: Original Message From: Victor Chapman [EMAIL PROTECTED] Date: Mon 27 Aug 2007 12:03:42 EST I have created a document. Now I want to insert a header at page 2 that will not appear on page 1 and have it carry the same heading for the rest of the document. I also want to have the page number as part of this header. How do I do this? You need to use styles. Open the help file and search for: First Page page style HTH Dave Thank you for this. Here is where I am at now. The style for Page 1 has no header and that works. I created a new style called Page 1. It follows page 1 and turns the header on for subsequent pages. Then in the header on page 2, I created a two column, one row table and entered my text and the automatic page number. The problem that I now have is that the text and page number doesn't carry on into the header area on subsequent pages. So my next question is how do I make that happen. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Since you started with an already written document, make sure that the pages 2 have the correct page style rather than Default. The following suggestion is based on the guess that you currently have all pages set as default style apart from 2 which is set for your customized style. You may be much better off customizing the style First page, apply to the first page and then activate the header for the default page style. Cheers, Michele Thank you for this. I have finally figured this out. I think that I have some variant on what you are suggesting. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Insert Header at Page 2
I have created a document. Now I want to insert a header at page 2 that will not appear on page 1 and have it carry the same heading for the rest of the document. I also want to have the page number as part of this header. How do I do this? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Personal Business Card
Gary Dale wrote: Try filling in the information on the business tab. :) This doesn't really solve the problem. So I have posted a defect report on the oo web site. I will see what comes of that. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Personal Business Card
I am trying to develop a personal or home business card from the Business Card template. I have filled in the information found in the Private tab. However, when I go to the Business Card tab, I do not get Business Cards, Home under the AutoText - Section. I have the same problem under both Windows and Linux. I think that I must be missing something, but I am not sure what that is. Help will be appreciated. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Table Row Height
I have a table with 5 columns. Some of the columns have 1 row and some have 2. I want to split one of the cells that is a single row into two rows and then adjust the height of the divider border. For example, the column is 7 inches high. After I split the cell, I want a 6 inch row and a one inch row. My attempts at doing this changes the height of the whole table! As a second possible method of doing this, when you have the cursor at the point where you would like to split the cell, is there a method of say split the cell here or insert the border here? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Table Row Height
JosephK wrote: If I understand your question correctly I think that what you require is to merge cells, although I am not sure what you mean by splitting one of the cells. One cell should hold a discrete item of data and not be able to be split. Please clarify and if possible give an example. I have a cell that is 2 x 7. I want to modify the cell/column so it now has 2 rows, 2 x 6 2 x 1. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spell checker doesn't work
Dan Lewis wrote: Comment in-line If there is no dictionary, OpenOffice simply doesn't find anything to complain about and says everything's OK! That's entirely possible! Well this becomes more interesting all of the time. I cannot find a copy of the English Canada dictionary with the Suse 10.2 distribution that I use. There is one for Great Britain, but not for Canada. I can't find one for the Windows distribution either. Where do I go looking? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spell checker doesn't work
Russell Butler wrote: Victor Chapman wrote: Dan Lewis wrote: Comment in-line If there is no dictionary, OpenOffice simply doesn't find anything to complain about and says everything's OK! That's entirely possible! Well this becomes more interesting all of the time. I cannot find a copy of the English Canada dictionary with the Suse 10.2 distribution that I use. There is one for Great Britain, but not for Canada. I can't find one for the Windows distribution either. Where do I go looking? Hi Victor Does the File-Wizards-Install new dictionaries not work for you? I don't even have that as a menu item. I just tried it and it showed English Canada in the list for me. I presume that it need Java available, though I ma not sure of that. How do I know if Java is properly installed? HTH Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Spell checker doesn't work
I am running writer 2.0.4 under Suse 10.2. For some reason the spell checker is not working for me. There must be a button that I can't find. Help! TIA - 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]
[users] Import PDF table
I receive a number of PDF documents that contain tables. Is there anyway to import a table directly into Writer or Calc? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Import Microsoft Access Database
I am running oo on a Windows XP machine. I have a database in mdb format that was created under Access 2003 (I think). How do import that database into oo Database? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] New Style Page
How do I create a new style page. I can't get this to work under 2.0.3. I can't replace the word default with my new style. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: New Style Page
Billy Reid wrote: Victor Chapman wrote: How do I create a new style page. I can't get this to work under 2.0.3. I can't replace the word default with my new style. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Hi Victor I've just changed the default style in 2.0.3 Win XP - to make sure it wasn't broken. Open Styles and Formatting. (Icon at top left of Formatting toolbar, F11 or in Format drop down menu) Choose Page Style Click on a style name and right mouse click - New Make your new Style File... Templates... Save and give it a meaningful name. Click Organiser... Commands... Save as Default See if this works Bill Got it. Thanks. Vic - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Install ooo 2.0.2 under Suse Linux 10.1
Dave Barton wrote: On Wed, 2006-07-19 at 19:22 -0400, Victor Chapman wrote: What is the correct process to upgrade from ver. 2.0.2 to 2.0.3. I have tried this a couple of times and end up with a hybrid the old and the new. Yes, that's exactly what happened. I resulted in some interesting bugs that I reported unknowingly. I am guessing that you installed ver. 2.0.2 that came with SuSE 10.1 and then tried to upgrade with the official ver. 2.0.3 from the OOo website. This will not result in an upgrade, without some tweaking, because the SuSE version installs in /usr and the official version installs in /opt by default. Yup! If this is the case, I would suggest that you use Yast to remove the 2.0.2 components. I did. If you wish, you can leave the SuSE version of quickstarter installed and change it's configuration to work with the official 2.0.3 version. After lots of flailing away I now have ver 2.0.3 installed and running correctly, I think. What is the suse version of quickstarter? Thanks for your response. Hope this helps. Dave Regards, Vic Chapman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Install ooo 2.0.2 under Suse Linux 10.1
Dave Barton wrote: On Thu, 2006-07-20 at 19:15 -0400, Victor Chapman wrote: What is the suse version of quickstarter? If you are familiar with the Windows version of OOo, you will know that it includes the quickstarter component. This component loads part of OOo at startup and provides an icon in the taskbar tray, from which you can start any of the OOo apps. The concept being that it should reduce the loading time when an OOo app is first started. Quickstarter is not part of the official Linux edition of OOo, but SuSE include a variant of it in their version. If you look at ToolsOptionsOpenOffice.orgMemory you will find the OpenOffice.org Quickstarter. If you check the box, you will get the quickstarter in the tray at the bottom of the screen. You will find it on the 10.1 disk(s). Dave Regards, Vic Chapman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Install ooo 2.0.2 under Suse Linux 10.1
What is the correct process to upgrade from ver. 2.0.2 to 2.0.3. I have tried this a couple of times and end up with a hybrid the old and the new. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Install ooo 2.0.3 under Suse Linux 10.1
Victor Chapman wrote: What is the correct process to upgrade from ver. 2.0.2 to 2.0.3. I have tried this a couple of times and end up with a hybrid the old and the new. Note, I am trying to install 2.0.3 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc Add-In
Is there an add-in for calc that might be similar to the Excel lastprice() or MSNStockQuote() function? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spell checker
Victor Chapman wrote: I am sorry to be repetitive, but I can't get my spell checker to work. I am running OO 2.0.2 on a Windows 2000 machine. I have tried to invoke the Canadian English dictionary. The spell checker does not find any errors when the page I have just keyed contains several! I thought that I had been through this once before several months ago and had fixed everything, but now I am back at it again without a working spell checker. TIA. Just to close the loop on this. I discovered that my dictionary.lst file was incomplete. It did not have entries for en CA. It now has and I can use my English(Canada) dictionary for spell checking. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spell checker
Cor Nouws wrote: Hello Victor, Victor Chapman wrote: I am sorry to be repetitive, but I can't get my spell checker to work. I am running OO 2.0.2 on a Windows 2000 machine. I have tried to invoke the Canadian English dictionary. The spell checker does not find any errors when the page I have just keyed contains several! I thought that I had been through this once before several months ago and had fixed everything, but now I am back at it again without a working spell checker. TIA. Have you made sure that the language of your style is set properly? Greetings, Cor How do I do that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Spell checker
I am sorry to be repetitive, but I can't get my spell checker to work. I am running OO 2.0.2 on a Windows 2000 machine. I have tried to invoke the Canadian English dictionary. The spell checker does not find any errors when the page I have just keyed contains several! I thought that I had been through this once before several months ago and had fixed everything, but now I am back at it again without a working spell checker. TIA. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: calc -- Date Sort
G. Roderick Singleton wrote: On Wed, 2006-02-08 at 16:46 -0500, Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. Which version of OOo are you using and what OS? I ask because I cannot reproduce your problem. 2.0.2 (what ever the latest is) and Windows 2000 sp4
[users] calc -- Date Sort
I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: calc -- Date Sort
Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. TIA The original column of dates was imported as text. I think that I need to format the column as containing dates, but I also need to go through a conversion, perhaps of the original text dates to give them a date value. I don't know how to do this. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Default Font Size in Calc
How do I change the default font and font size in calc. I can't locate the answer to this in the help system. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Default Font Size in Calc
Victor Chapman wrote: How do I change the default font and font size in calc. I can't locate the answer to this in the help system. TIA I figured it out! Open the Styles and Formatting window. Right click on Default. Select Modify and Font. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Impress Media Player
I have a music clip that I want to embed in a slide show. If I embed the clip in the second slide, it stops when the third slide appears. How do I get the music to continue until the the last slide has finished being displayed? TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc -- No Help Pages
Wangshanpo wrote: Hello Victor Happy New Year There is a link given on that discussion (although I couldn't use it) and the issue has been recognized by OOo developers etc. However try this First close Openoffice Then visit the following website and download the four files, scalc.db scalc.ht scalc.jar scalc.key http://web.mit.edu/ooffice_v2.0/distrib/i386_rhel4/openoffice.org2.0/help/en/ When downloaded put them into C:\Program Files\OpenOffice.org 2.0\help\en (using the default directory location) Happy New Year to you too. This problem is discussed in Issue 59499. I followed the advice given there and downloaded the Linux files. This has restored the Help system. I may, however, download and install the Windows Help files in your reference, above. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Calc -- No Help Pages
Wangshanpo wrote: You might find the necessary guidance here http://www.oooforum.org/forum/viewtopic.phtml?t=28931 WSP Thank you for this reference. It indicates that others have the same problem, but it really doesn't help me out. I am running Win2k on two different machines. The download for those machines was separate. The calc help pages are missing in both cases. There needs to be some recognition that the calc help system is missing from the Windows distribution of oo2.0.1. I have yet to discover a web site that would facilitate the downloading of this missing piece. Victor Chapman wrote: I have just downloaded OO2.0.1 for the second time. The help pages for the spreadsheet (calc) are not available. I get the following error message: Help ID: text%2Fscalc%2Fmain.xhp What is my next step? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] OOo 2.0.1 – SeaMonkey 1.5a/1.0b (nightlies...) - Win XP sp2 == http://www.answersingenesis.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc -- No Help Pages
I have just downloaded OO2.0.1 for the second time. The help pages for the spreadsheet (calc) are not available. I get the following error message: Help ID: text%2Fscalc%2Fmain.xhp What is my next step? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Impress -- Sound
I have some .wav files that I am trying to play in the transition option for some slides. These files work in a PowerPoint slide, but fail to work in an Impress slide. Two questions: 1. Is there a master switch of some kind that turns the sound on for an oo document? 2. What sound file types can be used in oo. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Impress -- Sound
I have discovered a possible answer to my question, but it still raises more questions. It seems that I can embed the media player object into a slide. It will play whatever sound it is playing when embedded when the slide appears. The sound that is playing in the media player object is not the same as the sound selected in the transition menu. New question: How do I hide the media player icon when I embed it into a slide? The original question of how to play the sound selected in the transition menu still exists. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Impress -- Sound
I have just downloaded oo 2.0.2rc5. The problem that I had encountered with the transition sound in Impress seems to have resolved itself. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
