[users] Re: How to underline a blank line of text, such that it could be typed?
On 01/05/2011 04:36 PM, Dotan Cohen wrote: On Mon, Jan 3, 2011 at 08:45, Bob Estes wrote: What you really need to do is set up an online form with fill-in fields. That sounds about right. Start with a new document and type in the necessary boilerplate. Check. Insert the fill-in fields with the desired formatting and default answers. (i.e. underlining, etc.) Here I got lost. Could you be more specific? From where does one insert the fill-in fields? Certainly not from Insert->Field, which is a completely different usage of the term "field". Thanks! Try Insert>Field>Other. Set the format. (i.e. text, general, etc.) Display (view)the field shading, select the field, and underline it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
At 02:30 06/01/2011 +0200, Dotan Cohen wrote: On Mon, Jan 3, 2011 at 00:13, Brian Barker wrote: [...] Here's another suggestion: o Put a left tab stop at the right margin (er, or perhaps right at the left, depending on your locale!). o Press Tab followed by Enter the required number of times. o Select all the lines and go to Format | Character... | Font Effects | Underlining (or right-click | Style > | Underline, or click the Underline button in the Formatting toolbar). o If the entered text is not justified, this will leave the space at the end of each line not underlined. If this matters, you can add a Tab character at the end of each line. Thanks. Assuming Left to Right (it's not, as you properly guessed, but in the interest of a useful archive let's assume that it is) then what exactly is being accomplished here? I seem to have gotten lost after the second step, I must be putting the tabs in the wrong place, but if I understand what it is that you suggest then I may be able to cope. The idea is that each line is actually a separate paragraph consisting simply of a tab character, skipping to the right margin. And it happens that if you apply the character property Underline to such paragraphs, the otherwise empty lines are indeed underlined. You then need to type any text at the beginning of such lines - before the tab character. A single line then becomes a paragraph of underlined text with the tab character at its end, and this carries the underlining to the end of the line. If the text wraps to more than one line, the underlining is continued, with the small problem that - in the case of unjustified text - any unused part of the line will not be underlined. As I mentioned, you can solve this, but only by the messy technique of putting tab characters back at the end of each line - after you have finalised your text, of course. You may think that you can do the same sort of thing using space characters instead of a single tab character. That appears to work until you type your text: then any trailing spaces cease to be underlined, so the idea fails. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Importing spreadsheet into database
On Wed, 2011-01-05 at 16:06 +0100, Andreas Säger wrote: > Am 05.01.2011 02:21, Jeffrey Needle wrote: > > It's actually pretty easy. > > > > 1. Create your database table in base. For ease of use, make sure the > > fields are in the same order as they are in the spreadsheet. > > > > 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the > > Ctrl-C, to copy the records to the clipboard. You can also use the Edit > > dropdown menus to accomplish the same thing. > > > > 3. Go back to your database, right-click on the table you've created, > > choose "Paste," and all the records are sent to the database table. > > > > A simple copy and paste -- and works wonderfully! > > > > No, it doesn't work that wonderfully. With default settings all columns > become optional VARCHAR fields of lenght 255 which renders the table > useless and bloated. > > I've had no such problems. Set field types and widths, and all is well. > - > 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] will I need to do the following . . .
On Wed, 2011-01-05 at 19:43 -0500, webmas...@krackedpress.com wrote: > On 01/05/11 16:48, RA Brown wrote: > > On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com > > wrote: > > > >> I needed to know some info about updating/upgrading OOo in Ubuntu, since > >> I no longer use the repository version and its upgrading system. > >> > >> Can I get away with just running the .deb files and not worry about > >> removing > >> and then reinstalling the desktop-integration [i.e. menus]? I had to do > >> a complete > >> uninstall, including the menus, so I did not get any errors when I > >> installed the > >> Oracle version of OOo instead of the Go-oo version in the repository. > >> > >> So can I just install the deb files and skip the desktop-integration? > >> > > > > To keep from having problems with the desktop-integration you will > > have to only install one version of OOo. I have Go-oo 3.2 from the > > Ubuntu repository and when I installed any of the OOo RCs I have the > > same problem. If your going to run the straight OOo then there should > > be no problem. I always remove the installed RC using the Package > > Manager before installing the next one. Then use the dpkg -i command > > to install the next. > > > > HTH > > > > Andy > I know that when I wanted to go from the Go-oo to the OOo version, I had > to remove the original package completely as well as the menus. It > seemed that there was something wrong if I did not remove the original > package first and completely. I even had to remove the .openoffice.org > folder as well, since something caused the default document to crash and > not repair properly. > > So that was when I installed - finally - this version of OOo. I did not > know if I would have any problems when the next version came out, such > as the menus and such. I still have not reinstalled all of the > extensions I use to use with the old Go-oo version that I started using > since I came to Ubuntu back in Feb '10 on this machine. I may have to > do a complete reinstall of Ubuntu to solve a problem with one of my > software that seemed to have lost a dependency that was not fixed by all > the other means in the terminal's options that I found. So this might > have been a mute point. > > To be fair, I also have LibreOffice 3.3.0.1 RC something installed as > well, since I wanted to see what it was all about. I may remove it > after OOo 3.3.0.x comes out of RC. Or I may just have it there as a > spare ODF suite if there is trouble with my copy of OOo, so I can finish > my work and then fix the problem. I had to install KOffice the last > time that happened and I use Ubuntu's version of GNOME instead of KDE, > so this time I will have something a little closer to OOo whenever there > is another problem that requires a reinstall and I am in the middle of a > big project and close to my deadline. If you are already using OOo from the OOo website, then your system is like mine. (Ubuntu 32 and 64 bit) I use a script to install OOo: #!/bin/sh cd /home/(user)/Downloads/OOo/OOO330_m18_native_packed-1_en-US.9556/DEBS sudo dpkg -i *.deb cd desktop-integration/ sudo dpkg -i *.deb Extract the installation files. In the second line, list the location of the OOo installation files instead of the location I use. Save these 5 lines as a text file with a meaningful name. Change the file's permission to make it executable. Open a terminal window. Run this script file. You will be asked for your user password. Enter it, and the script should install OOo and update the Office section of the Main Menu. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On 01/05/11 16:48, RA Brown wrote: > On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com > wrote: > >> I needed to know some info about updating/upgrading OOo in Ubuntu, since >> I no longer use the repository version and its upgrading system. >> >> Can I get away with just running the .deb files and not worry about >> removing >> and then reinstalling the desktop-integration [i.e. menus]? I had to do >> a complete >> uninstall, including the menus, so I did not get any errors when I >> installed the >> Oracle version of OOo instead of the Go-oo version in the repository. >> >> So can I just install the deb files and skip the desktop-integration? >> > > To keep from having problems with the desktop-integration you will > have to only install one version of OOo. I have Go-oo 3.2 from the > Ubuntu repository and when I installed any of the OOo RCs I have the > same problem. If your going to run the straight OOo then there should > be no problem. I always remove the installed RC using the Package > Manager before installing the next one. Then use the dpkg -i command > to install the next. > > HTH > > Andy I know that when I wanted to go from the Go-oo to the OOo version, I had to remove the original package completely as well as the menus. It seemed that there was something wrong if I did not remove the original package first and completely. I even had to remove the .openoffice.org folder as well, since something caused the default document to crash and not repair properly. So that was when I installed - finally - this version of OOo. I did not know if I would have any problems when the next version came out, such as the menus and such. I still have not reinstalled all of the extensions I use to use with the old Go-oo version that I started using since I came to Ubuntu back in Feb '10 on this machine. I may have to do a complete reinstall of Ubuntu to solve a problem with one of my software that seemed to have lost a dependency that was not fixed by all the other means in the terminal's options that I found. So this might have been a mute point. To be fair, I also have LibreOffice 3.3.0.1 RC something installed as well, since I wanted to see what it was all about. I may remove it after OOo 3.3.0.x comes out of RC. Or I may just have it there as a spare ODF suite if there is trouble with my copy of OOo, so I can finish my work and then fix the problem. I had to install KOffice the last time that happened and I use Ubuntu's version of GNOME instead of KDE, so this time I will have something a little closer to OOo whenever there is another problem that requires a reinstall and I am in the middle of a big project and close to my deadline. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to underline a blank line of text, such that it could be typed?
On Mon, Jan 3, 2011 at 08:45, Bob Estes wrote: > What you really need to do is set up an online form with fill-in fields. > That sounds about right. > Start with a new document and type in the necessary boilerplate. > Check. > Insert the > fill-in fields with the desired formatting and default answers. (i.e. > underlining, etc.) > Here I got lost. Could you be more specific? From where does one insert the fill-in fields? Certainly not from Insert->Field, which is a completely different usage of the term "field". Thanks! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to underline a blank line of text, such that it could be typed?
On Mon, Jan 3, 2011 at 00:13, Brian Barker wrote: > At 22:33 02/01/2011 +0200, Dotan Cohen wrote: >> >> A user is making forms for herself and other therapists. These forms will >> be printed, and to specify the place where text is to be typed there are >> lines on the page, created with four dashes and one Enter per line. >> >> This works fine, but the original author wants to type out her forms for >> herself, instead of filling in the printed ones. she has no problem typing >> on the lines created with the dashes, but when the text wraps a line the top >> line loses its underline! > > That's not surprising, since what you have created is not an underline but a > paragraph border below each paragraph. And the text that wraps is one > continuos paragraph, of course - which gets a single border after it, not > after each line. > I see, thanks. >> How can she prevent this from happening? Should she use a different type >> of line? > > Possibly. > > You could keep the original scheme, enter the text, and then go back, > putting the cursor at the end of each line in turn and pressing Enter. This > converts the passage into separate paragraphs, each of which will inherit > the style and be given a trailing border. > No! > Here's another suggestion: > o Put a left tab stop at the right margin (er, or perhaps right at the > left, depending on your locale!). > o Press Tab followed by Enter the required number of times. > o Select all the lines and go to Format | Character... | Font Effects | > Underlining (or right-click | Style > | Underline, or click the Underline > button in the Formatting toolbar). > o If the entered text is not justified, this will leave the space at the > end of each line not underlined. If this matters, you can add a Tab > character at the end of each line. > Thanks. Assuming Left to Right (it's not, as you properly guessed, but in the interest of a useful archive let's assume that it is) then what exactly is being accomplished here? I seem to have gotton lost after the second step, I must be putting the tabs in the wrong place, but if I understand what it is that you suggest then I may be able to cope. > There are probably neater methods ... > I hope so! Thanks, Brian. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On Wed Jan 05 2011 13:12:14 GMT-0800 (PST) webmas...@krackedpress.com wrote: I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? To keep from having problems with the desktop-integration you will have to only install one version of OOo. I have Go-oo 3.2 from the Ubuntu repository and when I installed any of the OOo RCs I have the same problem. If your going to run the straight OOo then there should be no problem. I always remove the installed RC using the Package Manager before installing the next one. Then use the dpkg -i command to install the next. HTH Andy - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc error
At 14:17 05/01/2011 +0530, Shabbir Shaikh wrote: We have one ods file attached which has some problem, Please check and tell how to rectify the problem. May I be bold and say that you are expecting a lot here? You shouldn't, I suggest, expect subscribers to a mailing list simply to take over when you have a problem. There is no substitute for hard work. Indeed. And there is no substitute for saying what the problem is, doing what you can with your problem file, and explaining what you did and what response you got, so that anyone trying to help doesn't have to repeat your work. In fact, although your attached file has the .ods extension, it is not a valid OpenOffice (Calc) spreadsheet document file. So it is not surprising that OpenOffice is reluctant to open it. The file contents start as if it is a Portable Document Format (PDF) file, but it also contains what appears to be parts of a Microsoft Excel document file as well as what appears to be garbage. The most likely explanation is that your disk drive has become corrupted, with the result that what appears to be your spreadsheet file is actually a mixture of parts of other files - perhaps even ones that you thought you had deleted. If this is so, the only solution is to go back to your most recent back-up copy of the spreadsheet document file and continue working from there. You will also want to run your system's disk checking software to sort out any other problems on the disk; there will almost certainly be some. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
Hi, 2011/1/5 webmas...@krackedpress.com : > On 01/05/11 11:11, Vic Dura wrote: >> On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young >> wrote Re Re: [users] will I need to do the following . . . .: >> [...] > > I would like my question answered, since I was the one that started the > thread. > > I needed to know some info about updating/upgrading OOo in Ubuntu, since > I no longer use the repository version and its upgrading system. > > Can I get away with just running the .deb files and not worry about removing > and then reinstalling the desktop-integration [i.e. menus]? I had to do > a complete > uninstall, including the menus, so I did not get any errors when I > installed the > Oracle version of OOo instead of the Go-oo version in the repository. > > So can I just install the deb files and skip the desktop-integration? I'm not sure. Disclaimer: I'm not using a .deb-based distro! I always install the desktop integration package as well. I'm not sure, if the old package finds your new installation. But to not have to run dpkg -i twice, just copy the desktop-integration package you will need into the higher up (DEBS) directory. Then start dpkg -i *.deb and let it figure out, what to install when. (For the record, I've done this in Mandriva and everything works fine.) Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
On 01/05/11 11:11, Vic Dura wrote: > On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young > wrote Re Re: [users] will I need to do the following . . . .: > >> I will give him 24 hrs then set up a filter that will auto reply to >> his personal email address for each one asking him what his question >> is. If only ten others do so as well I suspect he will stop and ask a >> real question on how to stop receiving the emails he requested. > I like that. > I would like my question answered, since I was the one that started the thread. I needed to know some info about updating/upgrading OOo in Ubuntu, since I no longer use the repository version and its upgrading system. Can I get away with just running the .deb files and not worry about removing and then reinstalling the desktop-integration [i.e. menus]? I had to do a complete uninstall, including the menus, so I did not get any errors when I installed the Oracle version of OOo instead of the Go-oo version in the repository. So can I just install the deb files and skip the desktop-integration? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office freezing
On 1/4/2011 2:30 PM, brenda wrote: Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster [Brenda (brendam...@hotmail.com) is not subscribed and probably will not see responses unless directly copied.] The timing aspect is interesting, but may not be relevant to the problem (how did you fix it so precisely? did something call your attention to the time?). If you are using a Windows system, the most common reason for a silent failure to open documents (that is, no error message) is that there is an old copy of the soffice.bin process running. If that's the case, use Task Manager to end any process of that name (which will also end any associated soffice.exe processes). OOo should then start normally. Uninstalling and reinstalling should not be necessary, though. A simple restart of your system should also work if you don't want to use the Task Manager. If this doesn't help, please tell us what operating system and version you are using, and what version of OOo, as well as any error messages you are seeing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office freezing
Have you tried restarting it? Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/ From: brenda To: users@openoffice.org Sent: Tue, 4 January, 2011 20:30:08 Subject: [users] open office freezing Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster
Re: [users] will I need to do the following . . . .
On Wed, 05 Jan 2011 07:56:18 -0500, Gene Young wrote Re Re: [users] will I need to do the following . . . .: > I will give him 24 hrs then set up a filter that will auto reply to >his personal email address for each one asking him what his question >is. If only ten others do so as well I suspect he will stop and ask a >real question on how to stop receiving the emails he requested. I like that. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Importing spreadsheet into database
Am 05.01.2011 02:21, Jeffrey Needle wrote: It's actually pretty easy. 1. Create your database table in base. For ease of use, make sure the fields are in the same order as they are in the spreadsheet. 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the Ctrl-C, to copy the records to the clipboard. You can also use the Edit dropdown menus to accomplish the same thing. 3. Go back to your database, right-click on the table you've created, choose "Paste," and all the records are sent to the database table. A simple copy and paste -- and works wonderfully! No, it doesn't work that wonderfully. With default settings all columns become optional VARCHAR fields of lenght 255 which renders the table useless and bloated. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] Importing spreadsheet into database
Thanks to all for the positive responses. I will try this soon. -Original Message- From: Jeffrey Needle [mailto:jeff.nee...@gmail.com] Sent: Tuesday, January 04, 2011 8:22 PM To: users@openoffice.org Subject: Re: [users] Importing spreadsheet into database It's actually pretty easy. 1. Create your database table in base. For ease of use, make sure the fields are in the same order as they are in the spreadsheet. 2. Go to your spreadsheet, press Ctrl-A (to select all records), and the Ctrl-C, to copy the records to the clipboard. You can also use the Edit dropdown menus to accomplish the same thing. 3. Go back to your database, right-click on the table you've created, choose "Paste," and all the records are sent to the database table. A simple copy and paste -- and works wonderfully! - Original Message - From: "Rob Hall" To: Sent: Tuesday, January 04, 2011 11:21 AM Subject: [users] Importing spreadsheet into database > Hi, I am a new user to Open Office. I am trying to import a spreadsheet > (excel format) into Database to do sorting and queries on. When I try to > load the spreadsheet it "default" loads into Calc and I can't get it into > Database. Any help or pointing in the right direction would be > appreciated. > Sorry if this doesn't get to the proper place for questions. > > > > Thanks > > > > ROB > > - 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] will I need to do the following . . . .
On 1/5/2011 5:41 AM, Sigrid Carrera wrote: codyhill, what are you trying to achieve? You're flooding all the mailing lists with mails that just repeat the original message but don't add anything. Could you please stop doing this? Thanks in advance. If you have a question of your own, just write a new email and send it to users@openoffice.org and I'm sure, the list will help you with your problem. Sigrid He is clearly receiving the messages through an email address that is subscribed and forwarding them to his codyhill email. Thus attempts to unsub do not work so he is going to punish us by sending empty replies. I will give him 24 hrs then set up a filter that will auto reply to his personal email address for each one asking him what his question is. If only ten others do so as well I suspect he will stop and ask a real question on how to stop receiving the emails he requested. -- Gene Young - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
Den 2011-01-05 11:37:12 skrev Sigrid Carrera : Hi, 2011/1/1 j art : ? Please write next time your question in the body of your mail. And some sort of greeting would be nice too. :) To answer your question: As far as I know, OpenOffice.org cannot read MS Works files. If you have a Works installation somewhere, you can open your files there and safe in in .doc format. After doing this, you can read/edit the files with OpenOffice.org. Another possibility is, that you try the go-oo-version of OpenOffice.org or LibreOffice. I think I saw somewhere, that those two versions can read Works files - but I'm not 100 % sure about this. Sigrid Yes, this is correct. I have never tried it myself, but at least the Works files are in the list of file formats in Go-oo. If your operating system is some of the well known GNU/Linux distributions, like Ubuntu, OpenSUSE, Fedora and more, Go-oo is already installed (but it appears as ”OpenOffice.org”). -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Strange problem with PDFs
webmaster @ krackedpress wrote: > Can you device the work into sections when you need to deal with > creating the PDF of it, and then use a PDF merge software to merge the > smaller file together, so that error you described will not be there? I hope I don’t have to do that. Merging PDF files is something I haven’t done before, and would have to learn how to do. Luckily, the problem document doesn’t have to be finished for some time; but if no other solution emerges I will certainly consider that. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office freezing
On 04/01/2011 20:30, brenda wrote: Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster Brenda If the problem persistes can you please let us know and include the operating system name and version and the version of open office you are working on and where you downloaded it from Thanks Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] will I need to do the following . . . .
codyhill, what are you trying to achieve? You're flooding all the mailing lists with mails that just repeat the original message but don't add anything. Could you please stop doing this? Thanks in advance. If you have a question of your own, just write a new email and send it to users@openoffice.org and I'm sure, the list will help you with your problem. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
Hi, 2011/1/1 j art : > ? Please write next time your question in the body of your mail. And some sort of greeting would be nice too. :) To answer your question: As far as I know, OpenOffice.org cannot read MS Works files. If you have a Works installation somewhere, you can open your files there and safe in in .doc format. After doing this, you can read/edit the files with OpenOffice.org. Another possibility is, that you try the go-oo-version of OpenOffice.org or LibreOffice. I think I saw somewhere, that those two versions can read Works files - but I'm not 100 % sure about this. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated]
Hi Amy, 2011/1/2 Amy Anderson : > How do I get to the tutorials? Just go to the openoffice.org website and click on "I need help with my OpenOffice.org". >From there, you can go to the specific area, that you're interested in. Hope this helps. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein Subject: Re: [users] Calc To: users@openoffice.org >Hi Joe > >use the right mousebottom - on the tabulator at the screenbuttom. Select >the in the dropdown-menue insert spreadsheet - its siimilar to excel. > >Franz > >J Halka schrieb: >> I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in >> Calc. Thanks, JoeH >> >> >> >> > > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 08:16:03 + From: Mike Scott Subject: Re: [users] draw To: users@openoffice.org Cc: Dan Armstrong >On 30/12/2010 21:55, Dan Armstrong wrote: >> If you draw a square, ect. Why is the area blue? > >It's just the default - you need to see what you're drawing! If you >right-click on it once drawn, you can pick the Line or Area property and >change colour. > >> >> How do you draw an eclipse around an object? When I do this I get an eclipse >> with a blue field blocking out the object. > >I thought that's what eclipses did :-) :-) But again, R-click and change >to transparent if that's what suits. > >Oh, don't forget you can change the stack order as well, and put a given >object 'behind' or 'in front' of another - R-click and 'Arrange'. > >Don't forget F1 brings up the help system. > >BTW you're not subscribed to this mail list, so may miss answers. >Replies to list only please (users@openoffice.org) > >-- >Mike Scott >Harlow, Essex, England > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From:
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
> Original message
>
> Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
> From: Sandro
> Subject: [users] Re: API to clone a row in a
> writer's table
> To: users@openoffice.org
>
> >Thanks Andrew,
> >
> >Andrew Douglas Pitonyak
> pitonyak.org> writes:>
> >
> >> Note that I have not tried anything that I am
> about to suggest
> >>
> >> 1. Insert the new row where you desire it to
> be.
> >>
> >> 2. Use the view cursor to select the row that
> you desire to duplicate.
> >>
> >> 3. Use a dispatch to copy row to the
clipboard.
> >>
> >> 4. Move the view cursor to the new position
and
> use a dispatch to paste
> >> the row into the new row.
> >
> >after sending this mail I did also investigate
> the solution with dispatcher,
> >but I realized I couldn't understand how to
move
> the viewcursor to the
> >correct location... moreover I mean to use it
in
> a headless environ and I
> >wasn't sure that this is the best solution.
> Anyhow this is what I did:
> >
> >
> > table = document.TextTables.getByIndex(0)
> > cell = table.getCellByPosition(0,1)
> > controller=document.getCurrentController()
> > frame=controller.getFrame()
> > view_cursor=controller.getViewCursor()
> >
> > ... how to move the cursor to the cell??
> >
> > dispatcher = context.ServiceManager.
> >
>
createInstance('com.sun.star.frame.DispatchHelper')
> >
> > dispatcher.executeDispatch(frame,
> '.uno:EntireRow', '', 0, tuple())
> > dispatcher.executeDispatch(frame, '.uno:Copy',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
'.uno:Paste',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
> '.uno:JumpToNextCell', '', 0, tuple())
> >
> >
> >
> >
> >>
> >> Note: This will likely fail with a complex
> table and special care is
> >> required for complex content (such as when a
> cell contains multiple text
> >> objects; for example, an embedded image).
> >
> >The case I'm dealing with now is simple but as
it
> is part of a template
> >system that is public I can't make assumptions
on
> how complex will the real
> >templates be.
> >
> >> I think that new provisions may exist for
> copying text content. If that is
> >> the case, you may be able to copy the text
> content in each cell to the new
> >> cell in the new row.
> >
> >Can you explain what you mean by "new
provisions
> may exist for copying text
> >content". I think this is what I was looking
for
> but I was not able to find
> >a way neather for copying text and style nor
for
> pasting it!...
> >
> >
> >thanks for your time
> >sandro
> >*:-)
> >
> >>
> >> On 12/28/2010 11:36 AM, Sandro wrote:
> >> > Hi,
> >> > I already spent many hours on this problem
> and I can't find the correct
> >> > approach. I really hope someone can help me
> or point me in the correct
> >> > direction/reading.
> >> >
> >> > I need to programmatically duplicate rows
of
> a Table in openoffice writer.
> >> >
> >> > It's not difficult to add rows via
> table.Rows.insertByIndex(idx, count),
> >> > that adds empty rows and it's easy to add
> text in that row assigning
> >> > DataArray to the CellRange. Doing this way
> you loose control on the style of
> >> > the cells and specifically if a cell has
> words with different style
> >> > (bold/italic) they get flattened to the
same
> face. What I need is to
> >> > duplicate a row in a way that preserves the
> style of each word in the
> >> > cell/row.
> >> >
> >> > This is the last step of a Python template
> system that uses openoffice
> >> > (http://oootemplate.argolinux.org). I
access
> the document via 'uno'
> >> > interface in Python but any language would
do
> to explain the logic behind
> >> > it.
> >> >
> >> > thanks in advance
> >> >
> >> >
> >> > sandro
> >> > *
> >> >
> >> >
> >> >
>
-
> >> > To unsubscribe, e-mail: users-unsubscribe
> openoffice.org
> >> > For additional commands, e-mail: users-help
> openoffice.org
> >> >
> >>
> >
> >
> >
>
>-
> >To unsubscribe, e-mail:
> users-unsubscr...@openoffice.org
> >For additional commands, e-mail:
> users-h...@openoffice.org
> >
> >
Re: [users] draw
Original message Date: Thu, 30 Dec 2010 15:55:55 -0600 From: "Dan Armstrong" Subject: [users] draw To: >If you draw a square, ect. Why is the area blue? > >How do you draw an eclipse around an object? When I do this I get an eclipse >with a blue field blocking out the object. > > > >Thanks, > > > >Dan >
Re: [users] Calc
Original message Date: Thu, 30 Dec 2010 10:53:16 -0800 (PST) From: J Halka Subject: [users] Calc To: users@openoffice.org >I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in >Calc. Thanks, JoeH > > > >
Re: [users] Re: Two questions about Impress
Original message Date: Tue, 28 Dec 2010 18:07:54 -0500 (EST) From: Subject: Re: [users] Re: Two questions about Impress To: users@openoffice.org, b...@billp.org >Please unsubscribe codyh...@comporium.net from open >office at once. I'm getting emails from people >which should be going to your email.not to me. > >Thanks >codyh...@comporium.net > > > > Original message > > Date: Tue, 28 Dec 2010 21:14:08 + > From: bill purvis > Subject: Re: [users] Re: Two questions about > Impress > To: users@openoffice.org > > >On Tuesday 28 December 2010, Gene Kohlenberg > wrote: > >> On 12/28/2010 9:25 AM, bill purvis wrote: > >> > 1: ... sorted > >> > > >> > 2: I want to include some movie clips in my > talk. My video camera > >> > produces .mov files: 1280x720 pixels, MJPEG > format PCM sound. When I try > >> > to insert (using Insert->Movie and Sound or > Tools->Media Player) it says > >> > that this format is not supported. I'm not > (yet) proficient in video > >> > formats but am willing to have a go at > converting, but can't find > >> > anything that tells me which formats are > supported. I'm running 3.2.0 at > >> > present, but I'm thinking of moving to 3.3 > pre-release if that's > >> > reasonably stable. > >> > > >> > Many thanks.., > >> > > >> > Bill > >> > >> ... > >> You will need to convert the .mov file to .avi. > Use something such as > >> RAD Video Tools to make the conversion. If you > want to change the size > >> of the video on the slide, go to > View>Toolbars>Media Playback. You can > >> use the zoom function to change the size of the > video. If you just drag > >> a corner of the video frame to change size, it > only changes the size of > >> the box that the video appears in. > >> > >I'm running under Linux, and used ffmpeg to > convert from .mov to .avi. > >The resulting file is much smaller, but shows up > OK with mediaPlayer. > >However, when I try to insert it into my Impress > file I still get > > > > The format of the selected file is not > supported. > > > >I have extracted the following details of the > file: > > > >CRM01.avi: RIFF (little-endian) data, AVI, 1280 x > 720, 30.00 fps, video: > >FFMpeg MPEG-4, audio: MPEG-1 Layer 1 or 2 > (stereo, 16000 Hz) > > > >Any suggestions as to where I go from here? > > > >Bill > >-- > >+---+ > >| Bill Purvis, Model Engineer | > >| email: b...@billp.org | > >+---+ > > > >- > >To unsubscribe, e-mail: > users-unsubscr...@openoffice.org > >For additional commands, e-mail: > users-h...@openoffice.org > > > >
Re: [users] will I need to do the following . . . .
Original message Date: Fri, 31 Dec 2010 21:59:43 -0500 From: "webmas...@krackedpress.com" Subject: [users] will I need to do the following . . . . To: "users@openoffice.org" > >I see that OOo is on RC8. When 3.3.0 comes out, will need >to do an uninstall of OOo Debian or can I just install the >version of 3.3.0 and then not use the following: > >sudo dpkg -i *.deb >cd desktop-integration > >I know that when I was switching over from Ubuntu's Go-oo in its >repository, every time I got to the desktop-integration, it gave errors >saying the "whatever" was already in the menus. > >So the question really is, will I need to re-do the desktop-integration >or will the installation of the "debs" be enough without the second >step of the desktop-integration? > >If I need to do a full re-install, how do I remove OOo from the system >and the menus so it will be a full, clean, install? > >--- >To be honest, I am running both OOo 3.2.x and a beta of LibreOffice. >I have been running OOo since it's early days before it had the ODF >file formats included. There are some aspects of who is in control of >the software project[s], that makes me look at both OOo and LO to >see what all the fuss is about and where these two development "Styles" >will actually come up with in the foreseeable future. Until then I will >be running both on my Ubuntu [64-bit] desktop and OOo on my Vista [32-bit] >laptop. The desktop is my testbed and my system I do most of my work on. >
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 08:16:03 + From: Mike Scott Subject: Re: [users] draw To: users@openoffice.org Cc: Dan Armstrong >On 30/12/2010 21:55, Dan Armstrong wrote: >> If you draw a square, ect. Why is the area blue? > >It's just the default - you need to see what you're drawing! If you >right-click on it once drawn, you can pick the Line or Area property and >change colour. > >> >> How do you draw an eclipse around an object? When I do this I get an eclipse >> with a blue field blocking out the object. > >I thought that's what eclipses did :-) :-) But again, R-click and change >to transparent if that's what suits. > >Oh, don't forget you can change the stack order as well, and put a given >object 'behind' or 'in front' of another - R-click and 'Arrange'. > >Don't forget F1 brings up the help system. > >BTW you're not subscribed to this mail list, so may miss answers. >Replies to list only please (users@openoffice.org) > >-- >Mike Scott >Harlow, Essex, England > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein Subject: Re: [users] Calc To: users@openoffice.org >Hi Joe > >use the right mousebottom - on the tabulator at the screenbuttom. Select >the in the dropdown-menue insert spreadsheet - its siimilar to excel. > >Franz > >J Halka schrieb: >> I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in >> Calc. Thanks, JoeH >> >> >> >> > > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From:
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
> Original message
>
> Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
> From: Sandro
> Subject: [users] Re: API to clone a row in a
> writer's table
> To: users@openoffice.org
>
> >Thanks Andrew,
> >
> >Andrew Douglas Pitonyak
> pitonyak.org> writes:>
> >
> >> Note that I have not tried anything that I am
> about to suggest
> >>
> >> 1. Insert the new row where you desire it to
> be.
> >>
> >> 2. Use the view cursor to select the row that
> you desire to duplicate.
> >>
> >> 3. Use a dispatch to copy row to the
clipboard.
> >>
> >> 4. Move the view cursor to the new position
and
> use a dispatch to paste
> >> the row into the new row.
> >
> >after sending this mail I did also investigate
> the solution with dispatcher,
> >but I realized I couldn't understand how to
move
> the viewcursor to the
> >correct location... moreover I mean to use it
in
> a headless environ and I
> >wasn't sure that this is the best solution.
> Anyhow this is what I did:
> >
> >
> > table = document.TextTables.getByIndex(0)
> > cell = table.getCellByPosition(0,1)
> > controller=document.getCurrentController()
> > frame=controller.getFrame()
> > view_cursor=controller.getViewCursor()
> >
> > ... how to move the cursor to the cell??
> >
> > dispatcher = context.ServiceManager.
> >
>
createInstance('com.sun.star.frame.DispatchHelper')
> >
> > dispatcher.executeDispatch(frame,
> '.uno:EntireRow', '', 0, tuple())
> > dispatcher.executeDispatch(frame, '.uno:Copy',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
'.uno:Paste',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
> '.uno:JumpToNextCell', '', 0, tuple())
> >
> >
> >
> >
> >>
> >> Note: This will likely fail with a complex
> table and special care is
> >> required for complex content (such as when a
> cell contains multiple text
> >> objects; for example, an embedded image).
> >
> >The case I'm dealing with now is simple but as
it
> is part of a template
> >system that is public I can't make assumptions
on
> how complex will the real
> >templates be.
> >
> >> I think that new provisions may exist for
> copying text content. If that is
> >> the case, you may be able to copy the text
> content in each cell to the new
> >> cell in the new row.
> >
> >Can you explain what you mean by "new
provisions
> may exist for copying text
> >content". I think this is what I was looking
for
> but I was not able to find
> >a way neather for copying text and style nor
for
> pasting it!...
> >
> >
> >thanks for your time
> >sandro
> >*:-)
> >
> >>
> >> On 12/28/2010 11:36 AM, Sandro wrote:
> >> > Hi,
> >> > I already spent many hours on this problem
> and I can't find the correct
> >> > approach. I really hope someone can help me
> or point me in the correct
> >> > direction/reading.
> >> >
> >> > I need to programmatically duplicate rows
of
> a Table in openoffice writer.
> >> >
> >> > It's not difficult to add rows via
> table.Rows.insertByIndex(idx, count),
> >> > that adds empty rows and it's easy to add
> text in that row assigning
> >> > DataArray to the CellRange. Doing this way
> you loose control on the style of
> >> > the cells and specifically if a cell has
> words with different style
> >> > (bold/italic) they get flattened to the
same
> face. What I need is to
> >> > duplicate a row in a way that preserves the
> style of each word in the
> >> > cell/row.
> >> >
> >> > This is the last step of a Python template
> system that uses openoffice
> >> > (http://oootemplate.argolinux.org). I
access
> the document via 'uno'
> >> > interface in Python but any language would
do
> to explain the logic behind
> >> > it.
> >> >
> >> > thanks in advance
> >> >
> >> >
> >> > sandro
> >> > *
> >> >
> >> >
> >> >
>
-
> >> > To unsubscribe, e-mail: users-unsubscribe
> openoffice.org
> >> > For additional commands, e-mail: users-help
> openoffice.org
> >> >
> >>
> >
> >
> >
>
>-
> >To unsubscribe, e-mail:
> users-unsubscr...@openoffice.org
> >For additional commands, e-mail:
> users-h...@openoffice.org
> >
> >
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Fri, 31 Dec 2010 07:27:51 -0500 (EST)
From:
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
> Original message
>
> Date: Fri, 31 Dec 2010 12:16:25 + (UTC)
> From: Sandro
> Subject: [users] Re: API to clone a row in a
> writer's table
> To: users@openoffice.org
>
> >Thanks Andrew,
> >
> >Andrew Douglas Pitonyak
> pitonyak.org> writes:>
> >
> >> Note that I have not tried anything that I am
> about to suggest
> >>
> >> 1. Insert the new row where you desire it to
> be.
> >>
> >> 2. Use the view cursor to select the row that
> you desire to duplicate.
> >>
> >> 3. Use a dispatch to copy row to the
clipboard.
> >>
> >> 4. Move the view cursor to the new position
and
> use a dispatch to paste
> >> the row into the new row.
> >
> >after sending this mail I did also investigate
> the solution with dispatcher,
> >but I realized I couldn't understand how to
move
> the viewcursor to the
> >correct location... moreover I mean to use it
in
> a headless environ and I
> >wasn't sure that this is the best solution.
> Anyhow this is what I did:
> >
> >
> > table = document.TextTables.getByIndex(0)
> > cell = table.getCellByPosition(0,1)
> > controller=document.getCurrentController()
> > frame=controller.getFrame()
> > view_cursor=controller.getViewCursor()
> >
> > ... how to move the cursor to the cell??
> >
> > dispatcher = context.ServiceManager.
> >
>
createInstance('com.sun.star.frame.DispatchHelper')
> >
> > dispatcher.executeDispatch(frame,
> '.uno:EntireRow', '', 0, tuple())
> > dispatcher.executeDispatch(frame, '.uno:Copy',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
'.uno:Paste',
> '', 0, tuple())
> > dispatcher.executeDispatch(frame,
> '.uno:JumpToNextCell', '', 0, tuple())
> >
> >
> >
> >
> >>
> >> Note: This will likely fail with a complex
> table and special care is
> >> required for complex content (such as when a
> cell contains multiple text
> >> objects; for example, an embedded image).
> >
> >The case I'm dealing with now is simple but as
it
> is part of a template
> >system that is public I can't make assumptions
on
> how complex will the real
> >templates be.
> >
> >> I think that new provisions may exist for
> copying text content. If that is
> >> the case, you may be able to copy the text
> content in each cell to the new
> >> cell in the new row.
> >
> >Can you explain what you mean by "new
provisions
> may exist for copying text
> >content". I think this is what I was looking
for
> but I was not able to find
> >a way neather for copying text and style nor
for
> pasting it!...
> >
> >
> >thanks for your time
> >sandro
> >*:-)
> >
> >>
> >> On 12/28/2010 11:36 AM, Sandro wrote:
> >> > Hi,
> >> > I already spent many hours on this problem
> and I can't find the correct
> >> > approach. I really hope someone can help me
> or point me in the correct
> >> > direction/reading.
> >> >
> >> > I need to programmatically duplicate rows
of
> a Table in openoffice writer.
> >> >
> >> > It's not difficult to add rows via
> table.Rows.insertByIndex(idx, count),
> >> > that adds empty rows and it's easy to add
> text in that row assigning
> >> > DataArray to the CellRange. Doing this way
> you loose control on the style of
> >> > the cells and specifically if a cell has
> words with different style
> >> > (bold/italic) they get flattened to the
same
> face. What I need is to
> >> > duplicate a row in a way that preserves the
> style of each word in the
> >> > cell/row.
> >> >
> >> > This is the last step of a Python template
> system that uses openoffice
> >> > (http://oootemplate.argolinux.org). I
access
> the document via 'uno'
> >> > interface in Python but any language would
do
> to explain the logic behind
> >> > it.
> >> >
> >> > thanks in advance
> >> >
> >> >
> >> > sandro
> >> > *
> >> >
> >> >
> >> >
>
-
> >> > To unsubscribe, e-mail: users-unsubscribe
> openoffice.org
> >> > For additional commands, e-mail: users-help
> openoffice.org
> >> >
> >>
> >
> >
> >
>
>-
> >To unsubscribe, e-mail:
> users-unsubscr...@openoffice.org
> >For additional commands, e-mail:
> users-h...@openoffice.org
> >
> >
Re: [users] draw
Original message Date: Thu, 30 Dec 2010 15:55:55 -0600 From: "Dan Armstrong" Subject: [users] draw To: >If you draw a square, ect. Why is the area blue? > >How do you draw an eclipse around an object? When I do this I get an eclipse >with a blue field blocking out the object. > > > >Thanks, > > > >Dan >
Re: [users] will I need to do the following . . . .
Original message Date: Fri, 31 Dec 2010 21:59:43 -0500 From: "webmas...@krackedpress.com" Subject: [users] will I need to do the following . . . . To: "users@openoffice.org" > >I see that OOo is on RC8. When 3.3.0 comes out, will need >to do an uninstall of OOo Debian or can I just install the >version of 3.3.0 and then not use the following: > >sudo dpkg -i *.deb >cd desktop-integration > >I know that when I was switching over from Ubuntu's Go-oo in its >repository, every time I got to the desktop-integration, it gave errors >saying the "whatever" was already in the menus. > >So the question really is, will I need to re-do the desktop-integration >or will the installation of the "debs" be enough without the second >step of the desktop-integration? > >If I need to do a full re-install, how do I remove OOo from the system >and the menus so it will be a full, clean, install? > >--- >To be honest, I am running both OOo 3.2.x and a beta of LibreOffice. >I have been running OOo since it's early days before it had the ODF >file formats included. There are some aspects of who is in control of >the software project[s], that makes me look at both OOo and LO to >see what all the fuss is about and where these two development "Styles" >will actually come up with in the foreseeable future. Until then I will >be running both on my Ubuntu [64-bit] desktop and OOo on my Vista [32-bit] >laptop. The desktop is my testbed and my system I do most of my work on. >
[users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
?
Re: [users] draw
Original message Date: Sat, 01 Jan 2011 11:33:05 +0100 From: Franz Wein Subject: Re: [users] draw To: users@openoffice.org >Hello Dan > > * Why blue: in impress and although in draw you can choose the default > color in the properties in OO. > o Menue EXTRA - Options > + select in the drop-downlist OpenOffice.org - colors > + select there your default color > * Drawing an object around an other object. > o draw your second object so as you like. > o select with the right bottom object - choose alignment in the > drop-downlist and select in more/full background - in OO3 there > is a option behind object > o select with the right bottom object - choose location/size - > + in the first tabulator in the open window there are to > squares named basic-point - select there the center > radio-bottom - do this for both objects! > + fill in the identical position - so the both objects are > centered > + if it is necessary fill in the size for width and hight for > your second object. > > >Franz > >Dan Armstrong schrieb: >> If you draw a square, ect. Why is the area blue? >> >> How do you draw an eclipse around an object? When I do this I get an eclipse >> with a blue field blocking out the object. >> >> >> >> Thanks, >> >> >> >> Dan >> >>
[users] [moderated]
How do I get to the tutorials?
Re: [users] How to underline a blank line of text, such that it could be typed?
Original message Date: Sun, 02 Jan 2011 16:54:54 -0600 From: Barbara Duprey Subject: Re: [users] How to underline a blank line of text, such that it could be typed? To: users@openoffice.org >On 1/2/2011 2:33 PM, Dotan Cohen wrote: >> A user is making forms for herself and other therapists. These forms >> will be printed, and to specify the place where text is to be typed >> there are lines on the page, created with four dashes and one Enter >> per line. >> >> This works fine, but the original author wants to type out her forms >> for herself, instead of filling in the printed ones. she has no >> problem typing on the lines created with the dashes, but when the text >> wraps a line the top line looses it's underline! How can she prevent >> this from happening? Should she use a different type of line? >> >> If I was unsuccessful in describing the situation, then here are steps >> to reproduce: >> 1) In a new document press dash three times and press enter. >> 2) Now pres upArrow, enter, enter, upArrow, upArrow. >> 3) Now type a line long enough to wrap. >> >> >> Thanks! > >I think that's because the automatically generated line isn't a line-width paragraph of underlined >characters, but an empty paragraph with a bottom border. (The behavior is controlled by the option >to "Apply borders" under AutoCorrect.) If the supplied text wraps, the border stays below the whole >paragraph. There really isn't a good way to get natural wrapping together with the border effect >(that is, the appearance of multiple full-width lines with text above them), so far as I can tell. > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Re: API to clone a row in a writer's table
Original message
Date: Mon, 03 Jan 2011 01:49:36 -0500
From: Andrew Douglas Pitonyak
Subject: Re: [users] Re: API to clone a row in a
writer's table
To: users@openoffice.org
>On 12/31/2010 07:16 AM, Sandro wrote:
>> Thanks Andrew,
>>
>> Andrew Douglas Pitonyak
pitonyak.org> writes:>
>>
>>> Note that I have not tried anything that I am
about to suggest
>>>
>>> 1. Insert the new row where you desire it to
be.
>>>
>>> 2. Use the view cursor to select the row that
you desire to duplicate.
>>>
>>> 3. Use a dispatch to copy row to the
clipboard.
>>>
>>> 4. Move the view cursor to the new position
and use a dispatch to paste
>>> the row into the new row.
>> after sending this mail I did also investigate
the solution with dispatcher,
>> but I realized I couldn't understand how to
move the viewcursor to the
>> correct location... moreover I mean to use it
in a headless environ and I
>> wasn't sure that this is the best solution.
>
>I expect that in headless mode you will likely
NOT have a view cursor.
>Unfortunately, the view cursor may be the only
way to easily select an
>entire row, but, a cell cursor may also work (I
almost never do this so
>I would need to invest a few hours to understand
it. I rarely have a
>few hours)
>
>My best guess without looking anything up
(because it is late and my
>wife told me to come to bed) is that you can use
the current controller
>to select (it should support something like this:
>"currentcontroller.select(oCell)", but, that is
just a guess.
>
>> Anyhow this is what I did:
>>
>>
>> table = document.TextTables.getByIndex(0)
>> cell = table.getCellByPosition(0,1)
>> controller=document.getCurrentController()
>> frame=controller.getFrame()
>> view_cursor=controller.getViewCursor()
>>
>> ... how to move the cursor to the cell??
>>
>> dispatcher = context.ServiceManager.
>>
createInstance('com.sun.star.frame.DispatchHelper')
>>
>> dispatcher.executeDispatch(frame,
'.uno:EntireRow', '', 0, tuple())
>> dispatcher.executeDispatch(frame, '.uno:Copy',
'', 0, tuple())
>> dispatcher.executeDispatch(frame, '.uno:Paste',
'', 0, tuple())
>> dispatcher.executeDispatch(frame,
'.uno:JumpToNextCell', '', 0, tuple())
>
>Yes, I had exactly this sort of thing in mind.
This likely fails in
>headless mode, however. May have to use a cell
cursor or similar.
>Copying arbitrary text, however, is tricky at
best.
>
>>
>>> Note: This will likely fail with a complex
table and special care is
>>> required for complex content (such as when a
cell contains multiple text
>>> objects; for example, an embedded image).
>> The case I'm dealing with now is simple but as
it is part of a template
>> system that is public I can't make assumptions
on how complex will the real
>> templates be.
>
>I disagree. There is no shame in stating that
certain things will ONLY
>work on a simple table (which is the majority
case anyway).
>
>>> I think that new provisions may exist for
copying text content. If that is
>>> the case, you may be able to copy the text
content in each cell to the new
>>> cell in the new row.
>> Can you explain what you mean by "new
provisions may exist for copying text
>> content". I think this is what I was looking
for but I was not able to find
>> a way neather for copying text and style nor
for pasting it!...
>
>In a Calc document, I can specifically say "copy
this range over there"
>without using any other special thing like the
clipboard. For all I know
>that may actually work in text tables as well
since they share many
>similarities to a Calc Sheet (again, I did not
verify). it looks
>something like this:
>
>Sub CopySpreadsheetRange
> REM Get sheet 1, the original, and 2, which will
contain the copy.
> oSheet1 = ThisComponent.Sheets.getByIndex(0)
> oSheet2 = ThisComponent.Sheets.getByIndex(1)
>
> REM Get the range to copy and the rang to copy
to.
> oRangeOrg =
oSheet1.getCellRangeByName("A1:C10").RangeAddress
> oRangeCpy =
oSheet2.getCellRangeByName("A1:C10").RangeAddress
>
> REM The insert position
> oCellCpy =
oSheet2.getCellByPosition(oRangeCpy.StartColumn,_
> oRangeCpy.StartRow).CellAddress
>
> REM Do the copy
> oSheet1.CopyRange(oCellCpy, oRangeOrg)
>End Sub
>
>This may be related to this:
>
>http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextCopy.html
>
>http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextTableCursor.html
>
>Never used the XTextCopy, never seen it used.
Perhaps you can ask on the
>d...@api.openoffice.org mailing list.
>>
>> thanks for your time
>> sandro
>> *:-)
>>
>>> On 12/28/2010 11:36 AM, Sandro wrote:
Hi,
I already spent many hours on this problem
and I can't find the correct
approach. I
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 08:43:36 -0500 From: "webmas...@krackedpress.com" Subject: Re: [users] Strange problem with PDFs To: users@openoffice.org >On 01/03/11 05:33, Séamas Ó Brógáin wrote: >> I have a strange problem with PDFs made with Openoffice on Linux (Ubuntu >> 10.10). Wherever there is an en rule (the short dash used in a span of >> numbers: Unicode 2013), in the PDF it takes the shape of (or is replaced >> with) a dash (Unicode 2014), though it retains the spacing of the >> narrower character, so that the dash runs through the following >> character. Everything is fine in the original Openoffice document: it >> happens only when it’s exported as a PDF. And the result is the same >> whether I export directly from within Openoffice or print to file as >> Postscript and then create the PDF with ps2pdf. >> >> Obviously the prime suspect would seem to be the font. So I tried with >> several different fonts, to discover that some do and some don’t. Then I >> tried the same fonts in different applications, such as Gedit, and the >> PDFs are all perfect, for all fonts. >> >> I wonder if anyone can offer any clues. >Try adding CUPs PDF as your printer of PDF files. >That is what I use for Ubuntu 10.10 64-bit. > >I do not know is it is the internal export system to PDF or not. If you >print the PDF file using the CUPs PDF printing system and you do not >get that error, then it is the exporting system internal to OOo. > >I would go to the Synaptic Package Manager and do a search for cups pdf. >That will get you started. > > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Calc shows Sort greyed-out
Original message Date: Mon, 03 Jan 2011 11:42:05 +0100 From: Uwe Fischer Subject: Re: [users] Calc shows Sort greyed-out To: users@openoffice.org >On 12/31/10 05:29, Lee wrote: >> Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether >> I select all (CTRL A), select the specific columns, or select the range of >> cells, the Sort function under Tools is greyed out. Saving the file, closing >> and reopening didn't help. >> >> Please advise; thanks much. Lee > >Hello Lee, > >Calc cannot sort with Edit->Changes->Record enabled. Temporarily disable >recording changes, sort, then enable change tracking again (if you need >that at all). > >Uwe >-- > >Uwe Fischer | Technical Writer >Oracle Office GBU > >ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg > >ORACLE Deutschland B.V. & Co. KG >Hauptverwaltung: Riesstr. 25, D-80992 München >Registergericht: Amtsgericht München, HRA 95603 > >Komplementärin: ORACLE Deutschland Verwaltung B.V. >Rijnzathe 6, 3454PV De Meern, Niederlande >Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 >Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 15:48:28 + From: Séamas Ó Brógáin Subject: Re: [users] Strange problem with PDFs To: users@openoffice.org >Many thanks for your help, krackedpress. > >I installed CUPS-PDF, and it works fine, but unfortunately the >particular problem remains. > >Anyway, I’m glad I got CUPS-PDF. It’s something I should have, and >should learn more about. > >Thanks again, and happy new year from freezing Dublin. > > > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Strange problem with PDFs
Original message Date: Mon, 03 Jan 2011 10:33:06 + From: Séamas Ó Brógáin Subject: [users] Strange problem with PDFs To: users@openoffice.org >I have a strange problem with PDFs made with Openoffice on Linux (Ubuntu >10.10). Wherever there is an en rule (the short dash used in a span of >numbers: Unicode 2013), in the PDF it takes the shape of (or is replaced >with) a dash (Unicode 2014), though it retains the spacing of the >narrower character, so that the dash runs through the following >character. Everything is fine in the original Openoffice document: it >happens only when it’s exported as a PDF. And the result is the same >whether I export directly from within Openoffice or print to file as >Postscript and then create the PDF with ps2pdf. > >Obviously the prime suspect would seem to be the font. So I tried with >several different fonts, to discover that some do and some don’t. Then I >tried the same fonts in different applications, such as Gedit, and the >PDFs are all perfect, for all fonts. > >I wonder if anyone can offer any clues. > > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
[users] Question
Good evening! I am also Marius Popa and I have a problem. I have made a portable version of OpenOffice.org 3.3 rc8 on my own with Thinstall and I see two buttons that are grayed out: "To Weblog" and "Open Weblog Entry". Why do they appear in this version and why did they not appear in the previous version? How can they be used or removed? At the same time, I cannot install the extension "Sun Weblog Publisher" because of the error "Could not create Java implementation loader". What should I do? Thanks in advance and I am looking forward for your message. -- Marius Popa
Re: [users] Importing spreadsheet into database
Original message Date: Tue, 4 Jan 2011 21:06:52 +0100 From: Sigrid Carrera Subject: Re: [users] Importing spreadsheet into database To: users@openoffice.org >Hi Rob, > >2011/1/4 Rob Hall : >> Hi, I am a new user to Open Office. I am trying to import a spreadsheet >> (excel format) into Database to do sorting and queries on. When I try to >> load the spreadsheet it "default" loads into Calc and I can't get it into >> Database. Any help or pointing in the right direction would be appreciated. >> Sorry if this doesn't get to the proper place for questions. > >I'm am not a database user myself, but as far as I know, you have to >start OOo Base and connect from there to your spreadsheet. So, it's >not just a double click on the file. But to be sure, you might want to >have a look at the documentation for base. > >Check the support website: http://support.openoffice.org/ > >I hope, this helps. > >Sigrid > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Importing spreadsheet into database
Original message Date: Tue, 4 Jan 2011 14:21:24 -0500 From: "Rob Hall" Subject: [users] Importing spreadsheet into database To: >Hi, I am a new user to Open Office. I am trying to import a spreadsheet >(excel format) into Database to do sorting and queries on. When I try to >load the spreadsheet it "default" loads into Calc and I can't get it into >Database. Any help or pointing in the right direction would be appreciated. >Sorry if this doesn't get to the proper place for questions. > > > >Thanks > > > >ROB >
Re: [users] Re: Strange problem with PDFs
Original message Date: Tue, 04 Jan 2011 15:06:35 + From: Mike Scott Subject: Re: [users] Re: Strange problem with PDFs To: users@openoffice.org >On 04/01/11 13:22, Séamas Ó Brógáin wrote: >> Well, I may have found the problem (thanks to Mike’s kind offer to look >> at samples), and it’s intriguing (and slightly embarrassing). I think >> it’s a memory problem. >> >> I’m using an oldish computer with insufficient memory. I made up a >> sample page, using a variety of fonts, including commercial fonts and >> some I made myself. I made PDFs with three different procedures (export >> directly from Openoffice, print to PS file for conversion with ps2pdf, >> and CUPS-PDF). All were perfect. >> >> Then I made a PDF of a document I am editing: about 350 pages (500 kb). >> The fault was there. Then I made a PDF just of the offending page. The >> fault is not there. >> >> It seems a strange way for Openoffice to react to insufficient memory >> (and it doesn’t do anything else strange, as far as I can tell), and yet >> this seems the only explanation of the empirical evidence. > >Offhand, I'd say that's rather unlikely. Lack of main memory may make >the system thrash wildly and run like a snail or even hang up; lack of >swap may crash some (poor) app's. I've never known wrong results like >yours though. > >> >> Thanks to all for your kind help. Time to start hinting about a new >> computer. > >(This is written on a now-dated Athlon [2.4+, I think!], with all of >768Mb main memory. Works just fine except for editing big images.) > > >-- >Mike Scott >Harlow, Essex, England > >- >To unsubscribe, e-mail: users-unsubscr...@openoffice.org >For additional commands, e-mail: users-h...@openoffice.org > >
[users] open office freezing
Hi, I have been a satisfied user of OO for three years. This week it started to freeze and I can’t open my OO documents, or make new ones. This started on Jan. 2nd at 2. pm. My friend had the same problem at the same time and uninstalled and reinstalled the OO suite. I am doing that too, and hope it works. Thank you Brenda Forster
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: "." Subject: [users] Calc- several sheets all in sync To: users@openoffice.org >I've created a Monthly Calendar Generator in Calc- you can see the >template here- > >http://templates.services.openoffice.org/en/node/4973 > >All you do is enter an Event (like your birthday) in one cell and the >date of the event in the cell next to it. The Event is automatically >entered in the appropriate calendar's date. You only enter Event data >in the sheet named January-Main > >The primary formula used for referring to sheet named January-Main is >=January-Main.cell location > >The problem is I can't figure out how to get all of the Event and dates >next to them to look exactly like the Event and dates entered in >January-Main. > >That is- if you insert a row between two of the Events I want to see >that row added in all other calendar sheets. > >Sorry for making this so confusing but any help would be appreciated. > > >signature.asc (1k bytes)
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: "." Subject: [users] Calc- several sheets all in sync To: users@openoffice.org >I've created a Monthly Calendar Generator in Calc- you can see the >template here- > >http://templates.services.openoffice.org/en/node/4973 > >All you do is enter an Event (like your birthday) in one cell and the >date of the event in the cell next to it. The Event is automatically >entered in the appropriate calendar's date. You only enter Event data >in the sheet named January-Main > >The primary formula used for referring to sheet named January-Main is >=January-Main.cell location > >The problem is I can't figure out how to get all of the Event and dates >next to them to look exactly like the Event and dates entered in >January-Main. > >That is- if you insert a row between two of the Events I want to see >that row added in all other calendar sheets. > >Sorry for making this so confusing but any help would be appreciated. > > >signature.asc (1k bytes)
[users] Calc error
Dear Sir/Madam, We have one ods file attached which has some problem, Please check and tell how to rectify the problem. Thanks& Regards. Shabbir Shaikh. > There is no substitute for hard work. Girish K.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Using list box to control text
How can I create the following structure in a text document: 1) there is a List Box containing several entries 2) there are several sections containing various text 3) sections show or hide depending on what entry I choose from the List Box It should work similarly as hiding section with a Check Box Jacek Szymona - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
