Re: [users] Calc vs Excel
On 4/14/2006 9:50 PM Ross Johnson spoke: On Thu, 2006-04-13 at 21:03 -0400, James wrote: Someone sent me an xls attachment that opens in OOo Calc fine but an image in it shows up as a broken link in Excel. I wonder why Excel does that. Calc can also insert files as links only, instead of embedding, with presumably the same result. But it's not the default option - and possibly isn't in Excel either. It's a handy option if you want to be able to change the image (or other document or file) later, and have the linking document update automatically. But the document isn't readily transportable. A generated PDF will be, however. Ross If it is a link, why would it show up in Calc but not Excel? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc vs Excel
On Thu, 2006-04-13 at 21:03 -0400, James wrote: > Someone sent me an xls attachment that opens in OOo Calc fine but an > image in it shows up as a broken link in Excel. > I wonder why Excel does that. Calc can also insert files as links only, instead of embedding, with presumably the same result. But it's not the default option - and possibly isn't in Excel either. It's a handy option if you want to be able to change the image (or other document or file) later, and have the linking document update automatically. But the document isn't readily transportable. A generated PDF will be, however. Ross - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Linux (Gnome) and Fonts with OOo 2.0.2
On Thu, 2006-04-13 at 22:53 -0700, John Jordan wrote: > On 13 Apr 2006, at 21:06, G. Roderick Singleton wrote: > > > > If I do this, will these installed fonts also be usable in other > > > applications, or just in OOo? > > > As this is the OOo users list, I answered for OOo. If you want fonts > > under your OS, I suggest that you ask on the users list for your OS. > > I've been following this thread, hoping that someone will finally tell me how > to get OO.o to see my OpenType fonts. They are installed on my Ubuntu- > Breezy laptop. All other apps can see and use them. But OO.o does not > see them. Note that these are OpenType, not TrueType. Some are > TrueType in OpenType wrapper, and some are Type 1 in OpenType > wrapper. OO.o sees none of them. (I point that out to head off a referral to > a bogus bug report that Type 1 in OpenType wrapper is an OO.o bug -- > some of these are TrueType in OpenType wrapper and OO.o still can't see > them.) > > They were first installed in /usr/share/fonts, and later in /home/jjj/.fonts. > No > go either way. You'll need to install those fonts via OOo's spadmin tool. Run it as the 'root' user to install fonts system wide for OOo users. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Form drop down list that depends upon another field's value
On Fri, 2006-04-14 at 16:06 -0400, Matt Needles wrote: > Declan Mullen wrote: > > > Hi, > > > > I have a table called "Creatures" with fields "Animal" and "Type". The > > "Animal" field will have values like "Dog", "Cat", "Elephant". The > > "Type" field will have values that depend upon the value of the > > "Animal" field. Eg if "Animal" is "Dog", then "Type" can have values > > like "Boxer", "Poodle", "Labrador". If "Animal" is "Elephant", then > > "Type" can have values like "African", "Indian". > > > > Within my form I would like the "Type" field's combo box drop down > > list to include the relevant values based upon the "Animal" field's > > current value. Ie when "Animal" contains "Dog" then the drop down list > > only consists of "Boxer", "Poodle", "Labrador". > > > > Is this possible ? > > > > Maybe the "Type" field's combo box "List content" property can have > > SQL with an embedded variable that corresponds to the value currently > > in the record's "Animal" field ? > > > > Any tips ? > > > > Regards, > > Declan > > > In my mind, this would require a small database with linked tables. A single database table as proposed should work ok. In any case, if you really want a List box to change then I'm pretty sure you'll need to do it using a macro. If you want to display or select only relevant types without writing macros, then a sub-form linked to the main form is probably what you need. There's no reason the main and sub-forms can't be based on the same DB table - so that [say] a table (or grid) control in the subform only displays the filtered Type values for the Animal value selected in the main form. See http://www.pitonyak.org/database/ for detailed references for both options. Ross - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Start-up icon
Bill Flanagan wrote: Jack Heller wrote: Only way to open is with "soffice" from the command line. This is okay for most usage as I am really only interested in the word processor and it appears if I want to import a spreadsheet that works fine, just no way to create one in 2.0.2. Ah Well. I can create one in ver 1.x and go from there. In the word processor, you can open a blank spreadsheet from File/New/Spreadsheet. From there you can get an existing spreadsheet via File/Open. Bill Thanks Bill, File-> New-> Spreadsheet works perfectly, and I just checked and it did the same in vers. 1.1.1 -- Never looked. Please pardon tinge of red in face. Had been opening from icon in tool tray. I think that solves the pertinent problems. Jack - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to see anchors
On Monday April 10 2006 10:07 pm, Joe Marks wrote: > Dan Lewis <[EMAIL PROTECTED]> wrote: On Monday April 10 2006 03:50 pm, Joe Marks wrote: > > I opened the Navigator and clicked on the Navigation icon. The > > Navigation window opened. I clicked on the bookmark icon and its > > background turned while, however no anchors appeared in the document. > > There are anchors in the document because the hyperlinks in the TOC > > are working. > > > > Matt Needles wrote: On Sat, 2006-04-08 at 20:09 > > -0700, Joe Marks wrote: > > > If Headings are used in a text document and a Table of Contents is > > > made, hyperlinks can be added "automatically" by using the Entries > > > tab (Insert > Indexes & Tables > Indexes & Tables > Entries tab). > > > > > > You can click on a hyperlink in the TOC and the cursor will go to > > > the page in the document that has that Heading. The anchor can not > > > be seen. How can the anchor be seen or how can the name of the > > > anchor be found? > > > > Turn on the Navigator (F5), and select the appropriate icon for > > browsing by bookmarks. You'll see a list of bookmarks (anchors) > > defined in your document. Another way to turn on the Navigator (in OOo > > 2.0.2) is to double-click on the Page number field of the Status bar > > (left most field). The feature currently described in the Help text > > about this field does not work as advertised :( > > > > Matt > > What you are probably looking for is found under "Headings" rather > than "Bookmarks". This is because the hyperlinks in the TOC point to > "Headings". > > Dan > > How do i find the name of the anchors so I can use an existing anchor to > make a second hyperlink to that anchor? I have taken a few days to think about this. It seems to me that what you want to do is insert cross references. Set the reference first. (You will be giving the reference a name.) Then insert it by name in as many different places as you want. Help has enough information to get you going. (Insert > Cross-reference > Help) Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] AutoInput in Calc
Kira wrote: If nothing else, there should at least be the option to choose whether to keep the original case or not (because I can think of instances where someone might want the first letter to be a different case depending on where they're typing it). I would guess another checked option next to "AutoInput" (or a sub-item of AutoInput) would work best--something like "Keep original case", where when checked the word is entered exactly like the first instance, and when unchecked whatever case the user types, for whatever letters the user types, is kept. The workaround is, of course, to type that first letter in the case you want before pressing . A single ' before the string, allows for both "Office" and "office" and so forth in the same column. However, a RFE makes sence to me. Greetings, -- Cor Nouws www.bsooo.nl - www.nouenoff.nl Free your files - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] AutoInput in Calc
Paul Wright wrote: Kira, That sure seemed like logical reason to me. But ... I changed the two-caps autocorrect and also a setting in Options about checking capitalization and it still does the fLC thing. When you or anyone finds a solution, I would appreciate knowing. Okay. Played with it some. This might require a Request for Enhancement. It looks like what's going on is that it keeps whatever case you type when you type the first letter(s). I tested by typing "off" to see if all three letters would stay lower case, and sure enough, I got "offICE". It doesn't strike me as a bug so much as an oversight, but it should probably be brought to the attention of the developers, because as you said in your first post, logic would dictate that the original case be kept. If nothing else, there should at least be the option to choose whether to keep the original case or not (because I can think of instances where someone might want the first letter to be a different case depending on where they're typing it). I would guess another checked option next to "AutoInput" (or a sub-item of AutoInput) would work best--something like "Keep original case", where when checked the word is entered exactly like the first instance, and when unchecked whatever case the user types, for whatever letters the user types, is kept. The workaround is, of course, to type that first letter in the case you want before pressing . Kira - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Format -> Character crash
Joe Conner wrote: I get my own messages. I do not understand why you do not get your own. Daniel Klein wrote: Hmm, just checking if this came through at all. I sent it right after I signed up on the list and I never saw it nor a reply to it, but I guess we don't get copies of our own messages? I see you (Daniel) are using Gmail. I too use Gmail and it seems to be an interaction between Gmail and the list software that this mail list uses. I have several Yahoogroups that I use my Gmail account with and I do get my own messages on those, but I have this group and one or two others that I don't get my own messages on. My suspicion is that the type of mail lists that I don't get my messages on is more common than ones like Yahoogroups, but in any case, it seems to be a feature of Gmail. (I presume they know you already have a copy of the item in your Sent folder, so you don't need a new copy--saves room, and I believe the web interface does show your message in the conversation correctly, but I use Thunderbird and not the web interface so I'm not sure. Anyway, seems like a "smart" feature, and those seem to be great for half the people that use such a product and horrible for the other half.) Kira - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Linux (Gnome) and Fonts with OOo 2.0.2
On Fri, 2006-04-14 at 16:02 -0400, Matt Needles wrote: > Well, finally I have a definitive answer. Now I know that the OOo Font > install wizard only installs fonts for OOo's use, not system-wide use. > That's not what one would expect. Fonts are a system resource. Suppose > OOo installs some font and the user generates a PDF from an OOo document > using that font. The same user will not be able to see that font when > reading the PDF, because Acrobat Reader or whatever other reader used > on the system, won't know anything about that font, and will substitute > something else. I see this all the time on Linux, because I receive > PDFs that don't use the standard Adobe fonts, and the PDF doesn't look > like it should. > > This needs to be resolved. If a font is installed in Windows, it's > system-wide. There's no such thing as an application-specific font > installation. We need to do the same on all the other platforms OOo > supports. > > I'm no Linux guru; with a lot of experimentation, I might eventually get > this by trial and error, but it would be VERY helpful if OOo would do it > right for me. > > Matt If the fonts you use, that are not in the built-in set, for to generating a PDF are *NOT* being embedded then something is wrong. Please file an issue. > > G. Roderick Singleton wrote: > > >On Thu, 2006-04-13 at 23:04 -0400, Matt Needles wrote: > > > > > >>No, Gary, it has to do with OOo, because I want to know if the wizard > >>installs in such a way that the fonts are not just available to OOo. > >> > >> > > > >Huh? I think the answer is no File > Wizard > Install fonts from the > >web ... does not install fonts on a system level. Please have a look at > >the macros in the wizard and you will see that. > > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
2006/4/14, James Stickles <[EMAIL PROTECTED]>: > Thank you for your response. A was referring to that choice. I don't even > know what "JRE" is. What should I choose? You should choose "Windows (with bundled JRE)". Since you do not know about JRE (Java Runtime Environment), I bet that you haven't installed one yourself. The choice "Windows (with bundled JRE)" for "Select your operating system" means that the download is bundled with a JRE, not that your Windows version is bundled with one. I.e. This choice gives you all you need. Please keep the messages on the list. > Henrik Sundberg <[EMAIL PROTECTED]> wrote: > 2006/4/14, Dan Lewis : > > > I assume you are referring to the two choices: > > Windows (with JRE) > > Windows (without JRE). > > I find the download page confusing. With/without JRE are not different > operating systems, as indicated by the name of the field. > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Table of Contents
On 4/14/2006 3:27 PM G. Roderick Singleton spoke: On Fri, 2006-04-14 at 14:43 -0400, James wrote: On 4/14/2006 2:36 PM James spoke: I have 3 page styles. First Page Default Table Of Contents The problem may be that I didn't create pages from the insert/manual break menu. I assigned the page styles after I created the pages using the format/Styles and Formatting tool bar. I don't want any page numbers on the first page which is done. I put a roman numeral page number on the Table Of Contents. I put regular page numbers on the default page style. I didn't want the Table Of Contents to start at page 2 so I used "offset -1" in the Edit Fields dialog. I didn't want the Default pages to start at page 3 so I used "offset -2" in the Edit Fields dialog. The problem is that I created an insert/indexes and tables/indexes and tables but it uses the real page numbers instead of the Offset ones. Is there a way to fix this without recreating all the pages from the insert/manual break menu? I recreated the pages using the insert/manual break menu but it still shows the real page numbers, not what is visible. :-( Quick answer for you to try. Go the the first paragraph on each offending page and modify the style on the text flow tab and have it put the page style before. Hope this is enough to get you going. As you have found out offset does not affect the page numbering in a TOC. Yay, fixed it. I had left over Offsets and I played around with it. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Table of Contents
On 4/14/2006 3:27 PM G. Roderick Singleton spoke: On Fri, 2006-04-14 at 14:43 -0400, James wrote: On 4/14/2006 2:36 PM James spoke: I have 3 page styles. First Page Default Table Of Contents The problem may be that I didn't create pages from the insert/manual break menu. I assigned the page styles after I created the pages using the format/Styles and Formatting tool bar. I don't want any page numbers on the first page which is done. I put a roman numeral page number on the Table Of Contents. I put regular page numbers on the default page style. I didn't want the Table Of Contents to start at page 2 so I used "offset -1" in the Edit Fields dialog. I didn't want the Default pages to start at page 3 so I used "offset -2" in the Edit Fields dialog. The problem is that I created an insert/indexes and tables/indexes and tables but it uses the real page numbers instead of the Offset ones. Is there a way to fix this without recreating all the pages from the insert/manual break menu? I recreated the pages using the insert/manual break menu but it still shows the real page numbers, not what is visible. :-( Quick answer for you to try. Go the the first paragraph on each offending page and modify the style on the text flow tab and have it put the page style before. Hope this is enough to get you going. As you have found out offset does not affect the page numbering in a TOC. I created a new page right after the TOC using insert/manual break menu and setting the page numbers to start at 1 and it still displays the actual page number 3. :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] split and freeze commands question
Put your focus cell to be under and right of where you want the split first. Then, Alt-W, S works for me. A choosen command after a SPLIT seems to take priority over a SPLIT and causes the split to become the FREEZE. Joe Joe Hogan wrote: Hello, I wanted to split and freeze a spreadsheet document. But, when I went to split it, it only showed up with a horizontal split. The vertical split did not show up. How do I force this? Joe begin:vcard fn:Joseph Conner n:Conner;Joseph adr:;;20166 1st Ave NE;Poulsbo;WA;98370;USA email;internet:[EMAIL PROTECTED] title:RETIRED. note:No Spam Please. x-mozilla-html:FALSE version:2.1 end:vcard
Re: [users] Form drop down list that depends upon another field's value
Declan Mullen wrote: Hi, I have a table called "Creatures" with fields "Animal" and "Type". The "Animal" field will have values like "Dog", "Cat", "Elephant". The "Type" field will have values that depend upon the value of the "Animal" field. Eg if "Animal" is "Dog", then "Type" can have values like "Boxer", "Poodle", "Labrador". If "Animal" is "Elephant", then "Type" can have values like "African", "Indian". Within my form I would like the "Type" field's combo box drop down list to include the relevant values based upon the "Animal" field's current value. Ie when "Animal" contains "Dog" then the drop down list only consists of "Boxer", "Poodle", "Labrador". Is this possible ? Maybe the "Type" field's combo box "List content" property can have SQL with an embedded variable that corresponds to the value currently in the record's "Animal" field ? Any tips ? Regards, Declan In my mind, this would require a small database with linked tables. Matt - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Linux (Gnome) and Fonts with OOo 2.0.2
Well, finally I have a definitive answer. Now I know that the OOo Font install wizard only installs fonts for OOo's use, not system-wide use. That's not what one would expect. Fonts are a system resource. Suppose OOo installs some font and the user generates a PDF from an OOo document using that font. The same user will not be able to see that font when reading the PDF, because Acrobat Reader or whatever other reader used on the system, won't know anything about that font, and will substitute something else. I see this all the time on Linux, because I receive PDFs that don't use the standard Adobe fonts, and the PDF doesn't look like it should. This needs to be resolved. If a font is installed in Windows, it's system-wide. There's no such thing as an application-specific font installation. We need to do the same on all the other platforms OOo supports. I'm no Linux guru; with a lot of experimentation, I might eventually get this by trial and error, but it would be VERY helpful if OOo would do it right for me. Matt G. Roderick Singleton wrote: On Thu, 2006-04-13 at 23:04 -0400, Matt Needles wrote: No, Gary, it has to do with OOo, because I want to know if the wizard installs in such a way that the fonts are not just available to OOo. Huh? I think the answer is no File > Wizard > Install fonts from the web ... does not install fonts on a system level. Please have a look at the macros in the wizard and you will see that. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Table of Contents
On Fri, 2006-04-14 at 14:43 -0400, James wrote: > On 4/14/2006 2:36 PM James spoke: > > I have 3 page styles. > > First Page > > Default > > Table Of Contents > > > > The problem may be that I didn't create pages from the insert/manual > > break menu. > > I assigned the page styles after I created the pages using the > > format/Styles and Formatting tool bar. > > > > I don't want any page numbers on the first page which is done. > > I put a roman numeral page number on the Table Of Contents. > > I put regular page numbers on the default page style. > > I didn't want the Table Of Contents to start at page 2 so I used "offset > > -1" in the Edit Fields dialog. > > I didn't want the Default pages to start at page 3 so I used "offset -2" > > in the Edit Fields dialog. > > > > The problem is that I created an insert/indexes and tables/indexes and > > tables but it uses the real page numbers instead of the Offset ones. > > > > Is there a way to fix this without recreating all the pages from the > > insert/manual break menu? > > I recreated the pages using the insert/manual break menu but it still > shows the real page numbers, not what is visible. :-( > Quick answer for you to try. Go the the first paragraph on each offending page and modify the style on the text flow tab and have it put the page style before. Hope this is enough to get you going. As you have found out offset does not affect the page numbering in a TOC. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Table of Contents
On 4/14/2006 2:36 PM James spoke: I have 3 page styles. First Page Default Table Of Contents The problem may be that I didn't create pages from the insert/manual break menu. I assigned the page styles after I created the pages using the format/Styles and Formatting tool bar. I don't want any page numbers on the first page which is done. I put a roman numeral page number on the Table Of Contents. I put regular page numbers on the default page style. I didn't want the Table Of Contents to start at page 2 so I used "offset -1" in the Edit Fields dialog. I didn't want the Default pages to start at page 3 so I used "offset -2" in the Edit Fields dialog. The problem is that I created an insert/indexes and tables/indexes and tables but it uses the real page numbers instead of the Offset ones. Is there a way to fix this without recreating all the pages from the insert/manual break menu? I recreated the pages using the insert/manual break menu but it still shows the real page numbers, not what is visible. :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] split and freeze commands question
Hello, I wanted to split and freeze a spreadsheet document. But, when I went to split it, it only showed up with a horizontal split. The vertical split did not show up. How do I force this? Joe
[users] Table of Contents
I have 3 page styles. First Page Default Table Of Contents The problem may be that I didn't create pages from the insert/manual break menu. I assigned the page styles after I created the pages using the format/Styles and Formatting tool bar. I don't want any page numbers on the first page which is done. I put a roman numeral page number on the Table Of Contents. I put regular page numbers on the default page style. I didn't want the Table Of Contents to start at page 2 so I used "offset -1" in the Edit Fields dialog. I didn't want the Default pages to start at page 3 so I used "offset -2" in the Edit Fields dialog. The problem is that I created an insert/indexes and tables/indexes and tables but it uses the real page numbers instead of the Offset ones. Is there a way to fix this without recreating all the pages from the insert/manual break menu? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Lotus-Smartsuite-Files
On 4/13/2006 11:38 PM, Robert Smits wrote: Peter Krueger wrote: Hello, I'm using Open Office Org 2.0 with Windows and Linux. Before I used Lotus Smartsuite with Windows. Can you tell me if there exists any import filters for importing Lotus-1-2-3, Lotus-Freelance and Lotus-Wordpro files into Open Office Org. If there exists any would you please tell me where I can find them. Thank You. I, too have a lot of old Word Pro filesI used Lotus Smartsuite Millenium in Win XP and OS/2 versions until several months ago. If you look at this site, http://www.wordstar.org/wordstar/pages/convert_faq.htm There are filters listed for all kinds of word processors. I understand Lotus Smartsuite 9.XXX had a batch conversion filter built in, but I never have tried it yet. If you have any luck, let us know. Bob I used Lotus 1-2-3 for years and was very familiar with it, and in fact used to teach a course back in the early 90s using the DOS version! The most current version I used for the Lotus Smartsuite spreadsheet was 9.5. Those 1-2-3 spreadsheet files imported into OOo Calc without a hitch. Just open them using OOo instead of Lotus; don't need to convert them in advance. Sorry I can't help you with the other Lotus Smartsuite files. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] tracking changes in tables
Hi, Been editing with OOO 2.0 a table created by someone else, probably in WinWord (.doc format). Have "track changes" on. Twice now, in the same table, entries suddenly were marked as deleted--the first time only some of the cells, the second time all cells were marked deleted. the first time I was editing the caption; the second time was in a cell. On Linux (Linspire 5.0, on a Pentium notebook). Is this familiar? Can I avoid this problem by not tracking changes, or is it inherent in working with MS.doc files? What happens if the document is saved in ODT format? Thanks, Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Lotus-Smartsuite-Files
Peter Krueger wrote: > Hello, > > I'm using Open Office Org 2.0 with Windows and Linux. Before I used > Lotus Smartsuite with Windows. Can you tell me if there exists any > import filters for importing Lotus-1-2-3, Lotus-Freelance and > Lotus-Wordpro files into Open Office Org. If there exists any would you > please tell me where I can find them. > > Thank You. I, too have a lot of old Word Pro filesI used Lotus Smartsuite Millenium in Win XP and OS/2 versions until several months ago. If you look at this site, http://www.wordstar.org/wordstar/pages/convert_faq.htm There are filters listed for all kinds of word processors. I understand Lotus Smartsuite 9.XXX had a batch conversion filter built in, but I never have tried it yet. If you have any luck, let us know. Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Form drop down list that depends upon another field's value
Hi, I have a table called "Creatures" with fields "Animal" and "Type". The "Animal" field will have values like "Dog", "Cat", "Elephant". The "Type" field will have values that depend upon the value of the "Animal" field. Eg if "Animal" is "Dog", then "Type" can have values like "Boxer", "Poodle", "Labrador". If "Animal" is "Elephant", then "Type" can have values like "African", "Indian". Within my form I would like the "Type" field's combo box drop down list to include the relevant values based upon the "Animal" field's current value. Ie when "Animal" contains "Dog" then the drop down list only consists of "Boxer", "Poodle", "Labrador". Is this possible ? Maybe the "Type" field's combo box "List content" property can have SQL with an embedded variable that corresponds to the value currently in the record's "Animal" field ? Any tips ? Regards, Declan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Spell checker
On Fri, 2006-04-14 at 09:02 -0400, Victor Chapman wrote: > 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? > I think that http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf will get you started with creating the styles you need and Jonathon's multi-language doc is also a good resource. See http://oooauthors.org/en/members/tutorials/multilingualooo/ and do ensure the appropriate fonts and dictionaries are also installed. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - 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]
Re: [users] Korean/Chinese numbering in English OO
On Fri, 2006-04-14 at 11:59 +0530, Venky wrote: > Hi, > > I wanted to get Korean and Chinese numbering styles but I want the UI to be > English. I am on English Windows/Linux systems. That is, I want to be able > to see the Korean and Chinese numbering styles when I want to number a list > and set it to be used on the list of paragraphs. > > Is there some option by which I can install some language packs and get > Korean and Chinese features while the application still remains English > (UI). > Use character styles for numbering and paragraph styles as needed in the language you need. Languages are an attribute of styles so you can have many languages in your documents. Install the appropriate fonts and dictionaries as well. I think that http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf will get you started with creating the styles you need and Jonathon's multi-language doc is also a good resource. See http://oooauthors.org/en/members/tutorials/multilingualooo/ -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Linux (Gnome) and Fonts with OOo 2.0.2
On Thu, 2006-04-13 at 22:53 -0700, John Jordan wrote: > On 13 Apr 2006, at 21:06, G. Roderick Singleton wrote: > > > > If I do this, will these installed fonts also be usable in other > > > applications, or just in OOo? > > > As this is the OOo users list, I answered for OOo. If you want fonts > > under your OS, I suggest that you ask on the users list for your OS. > > I've been following this thread, hoping that someone will finally tell me how > to get OO.o to see my OpenType fonts. They are installed on my Ubuntu- > Breezy laptop. All other apps can see and use them. But OO.o does not > see them. Note that these are OpenType, not TrueType. Some are > TrueType in OpenType wrapper, and some are Type 1 in OpenType > wrapper. OO.o sees none of them. (I point that out to head off a referral to > a bogus bug report that Type 1 in OpenType wrapper is an OO.o bug -- > some of these are TrueType in OpenType wrapper and OO.o still can't see > them.) > > They were first installed in /usr/share/fonts, and later in /home/jjj/.fonts. > No > go either way. > I recall seeing a conversion tool/method when I searched on google. I think you have to convert them to TT. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Linux (Gnome) and Fonts with OOo 2.0.2
On Thu, 2006-04-13 at 23:04 -0400, Matt Needles wrote: > G. Roderick Singleton wrote: > > >On Thu, 2006-04-13 at 17:34 -0400, Matt Needles wrote: > > > > > >>G. Roderick Singleton wrote: > >> > >> > >> > >>>On Wed, 2006-04-12 at 20:36 -0400, Matt Needles wrote: > >>> > >>> > >>> > >>> > On Mon, 2006-04-10 at 11:45 +0300, Nicu Buculei wrote: > > > > > >Andy Pepperdine wrote: > > > > > > > > > >>AIUI OOo shows only those fonts that are available for both display and > >>printing. The X11 font directories define those for display, the > >>printing > >>fonts are elsewhere. I had a similar problem a couple of years ago. But > >>an > >>update to the system (Suse) seemed to automatically fix it so I did not > >>pursue the matter to discover exactly where they all were and how to > >>configure cups and printers to get the fonts. > >> > >> > >> > >> > >On a current desktop the easiest way for a user to install fonts and > >make them available for both display and print is to create a directory > >named ".fonts" in his home directory and copy there the font files, no > >need to touch X11 configuration at all. > >The copy of OOo which I have installed on my computer does not need > >spadmin or something else to access those fonts. > > > > > > > > > > > Okay, Nicu, but how can I do a similar thing so the fonts are available > to all users on the same machine, not just the one who installed them? > > > > > > >>>How about opening up /openoffice.org2/share/fonts so that you > >>>can use File > Wizards > Install fonts from the web into that directory? > >>> > >>> > >>> > >>> > >>> > >>If I do this, will these installed fonts also be usable in other > >>applications, or just in OOo? > >> > >> > >> > > > >As this is the OOo users list, I answered for OOo. If you want fonts > >under your OS, I suggest that you ask on the users list for your OS. > > > > > No, Gary, it has to do with OOo, because I want to know if the wizard > installs in such a way that the fonts are not just available to OOo. > Huh? I think the answer is no File > Wizard > Install fonts from the web ... does not install fonts on a system level. Please have a look at the macros in the wizard and you will see that. If you want the OOo font sets to install on your system you will have to locate the repositories, download the sets, convert and install them. Obviously this is not an OOo question so I recommend you get the fonts and then ask those who support your OS for suggestions on how to do this. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Start-up icon
Jack Heller wrote: Hope this makes the thread. A bit of confusion for first time on group. Thanks Andy for the hint about the "desktop-integration" -- Yes, the install was from RPMs and I did the install of the desktop-integration from its RPM. Nothing seems to change. Only way to open is with "soffice" from the command line. This is okay for most usage as I am really only interested in the word processor and it appears if I want to import a spreadsheet that works fine, just no way to create one in 2.0.2. Ah Well. I can create one in ver 1.x and go from there. In the word processor, you can open a blank spreadsheet from File/New/Spreadsheet. From there you can get an existing spreadsheet via File/Open. Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated]
2006/4/14, Dan Lewis <[EMAIL PROTECTED]>: > I assume you are referring to the two choices: > Windows (with JRE) > Windows (without JRE). I find the download page confusing. With/without JRE are not different operating systems, as indicated by the name of the field. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Creating labels from database - more records than fit a page
Bob wrote: On 4/12/2006 11:16 AM, [EMAIL PROTECTED] wrote: Bob: Very intriguing. It certainly sounds like you and I are doing the exact same thing, but getting different results. I'm hoping that someone will have some idea why. Ideas anyone? Dick PROBLEM SOLVED. Turns out the Calc spreadsheet had a single character within the database structure at row 65535! I don't know how it got there, but there it was. The data source assumed (correctly) that there were 65535 rows/records of data, even though 99.99% were blank rows/records. Great!! Glad you solved it. What I'm wondering though is how this character got into your NEW spreadsheet that you tried? I was wondering if it might be something like that, until you said you created a new spreadsheet and put in 34 lines of data. I could see a possible stray character getting put in once by accident somewhat, but seems very odd that it happened again when you created a new spreadsheet. Anyway, I'm glad the problem is solved! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Labels question
Steve Magoon wrote: I'm trying to print labels with a hidden line. I attempted to follow the instructions according to http://documentation.openoffice.org/manuals/oooauthors2/ but the result is not what I'm looking for. Here's what I'm doing: I highlighted and used Insert>Section... >Hide With Condition: Address2 EQ "" Then I followed the instructions to Mail Merge and skip to Page 8. When I go to print the labels, I use Ctrl P, answer yes and select "All". The result: All Address2 are hidden, regardless of whether there's something in that line or not. And at the last page of labels, the remaining addresses are printed with a empty line (not a hidden line) where Address2 is, even if there is no data in Address2. What am I doing wrong? Your condition is logical, but... Try using the following instead: ![Address2] If you want an alternative to Hidden Sections you could use Hidden Paragraphs (in OOo 2.0.2, or later). See the tutorial at : http://www.hbsys.co.uk/openoffice/ Peter HB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]