Re: [users] Fw: Missing 1st letters in surnames
James thank you for your reply. When I copy and pasted these areas of missing letters to a blank page in OO they did not show up. Also, there is no blank space where the letters are missing, as there would be if they the same color as the back ground. DeWayne McCarty Member of Columbiana County Chapter of Ohio Genealogical Society From: James Wilde james.wi...@sunde-wilde.com To: users@openoffice.org Sent: Fri, October 22, 2010 3:39:28 AM Subject: Re: [users] Fw: Missing 1st letters in surnames On Oct 22, 2010, at 04:14 , DeWayne McCarty wrote: Windows 7; Open Office.org 3.2.1 (build 9502) I am proofing a 800+page book. This book contains abstracts of newspaper articles. All names are indexed. On 3 of the pages, there are a few names in the articles where the Surnames are missing the 1st letter. (These entries are indexed and the index has the complete spelling so the letters were there when they were indexed. ) [e.g. The letters in red are example of missing letters. On my computer there are no red letters in your post, possibly since I have my mail reader set to text only (I think!). But since you mention colour for the initial letters, can it possibly be that these have been changed to invisible, e.g. white on a white background? ... I have copied these paragraphs and pasted them into note pad. The letters are missing there. I must admit that you're having pasted them into Notepad and their still being missing would presumably invalidate my hypothesis. As far as I am aware, Notepad does not support coloured letters. //James
Re: [users] Fw: Missing 1st letters in surnames
On 22/10/10 03:14, DeWayne McCarty wrote: Windows 7; Open Office.org 3.2.1 (build 9502) I am proofing a 800+page book. This book contains abstracts of newspaper articles. All names are indexed. On 3 of the pages, there are a few names in the articles where the Surnames are missing the 1st letter. (These entries are indexed and the index has the complete spelling so the letters were there when they were indexed. ) [e.g. The letters in red are example of missing letters. SAMPLE PARAGRAPH: Mrs. Bell leaves five children: Mrs. Edna Vanskiver, Winter Haven, Fla.; Mrs. Ethel E. Haas, Columbiana; Ernest K. Bell, Leetonia; Herschel M. Bell near Rogers; Rolland O. Bell, Green Cove, Fla. She also leaves one great granddaughter, one sister, Mrs. Tirzah Lane, Dresden, O.; two brothers, George McGinnis, Springfield and John McGinnis, of Zanesville. I have copied these paragraphs and pasted them into note pad. The letters are missing there. Any help would be appreciated. No solution so far, I see. You don't say where the document came from. It probably makes a difference if you made it with OOo, or imported it from somewhere else. If it's imported (from Word maybe??), it's probably worth checking back to whatever other versions you have to see if you can spot when the characters were dropped. From your other email, it does sound as though the letters in this version are lost, which isn't hopeful. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Fw: Missing 1st letters in surnames
Mike thank you for your response. Some back ground: This document is part of a book written in OO, as are 2 previous ones written over the past 3 years. After writing, editing, etc. over 2,700 pages, This problem is really Weird. OO writer has been an excellent tool after that other Word Processor. In these books, the index contains only full names (i.e.: Surname, Given name, title). Why are only a few names are in error out of hundreds? Why do these errors only occur on a couple of pages? Why isn't ever name in the paragraphs missing 1st letters? I guess I have offended the Indexing God? DeWayne McCarty Member of Columbiana County Chapter of Ohio Genealogical Society From: Mike Scott m...@scottsonline.org.uk To: users@openoffice.org Sent: Sat, October 23, 2010 10:37:41 AM Subject: Re: [users] Fw: Missing 1st letters in surnames On 22/10/10 03:14, DeWayne McCarty wrote: Windows 7; Open Office.org 3.2.1 (build 9502) I am proofing a 800+page book. This book contains abstracts of newspaper articles. All names are indexed. On 3 of the pages, there are a few names in the articles where the Surnames are missing the 1st letter. (These entries are indexed and the index has the complete spelling so the letters were there when they were indexed. ) [e.g. The letters in red are example of missing letters. SAMPLE PARAGRAPH: Mrs. Bell leaves five children: Mrs. Edna Vanskiver, Winter Haven, Fla.; Mrs. Ethel E. Haas, Columbiana; Ernest K. Bell, Leetonia; Herschel M. Bell near Rogers; Rolland O. Bell, Green Cove, Fla. She also leaves one great granddaughter, one sister, Mrs. Tirzah Lane, Dresden, O.; two brothers, George McGinnis, Springfield and John McGinnis, of Zanesville. I have copied these paragraphs and pasted them into note pad. The letters are missing there. Any help would be appreciated. No solution so far, I see. You don't say where the document came from. It probably makes a difference if you made it with OOo, or imported it from somewhere else. If it's imported (from Word maybe??), it's probably worth checking back to whatever other versions you have to see if you can spot when the characters were dropped. From your other email, it does sound as though the letters in this version are lost, which isn't hopeful. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] User defined date field in Base not enforcing format
Hey all Question about Base. In table I defined a field date to take year only (I don't want days or months) for article publications. I selected user defined in the field properties and stipulated . The example shows up as 1903 and the format field shows 1900. Now into the user form input, I enter 1991 into the date field and tab to the next field and the date converts into today's date with the format 23/10/10. How do I stop Base doing what it wants to do and make it to do what I want it to do? Thanks AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? Thanks for help on both or either of these two issues. AG 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
AG wrote: On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 23/10/10 20:01, Richard Detwiler wrote: AG wrote: On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. Nice one! Thanks Richard. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] User defined date field in Base not enforcing format
On Sunday 24 October 2010 06:59, AG wrote: Question about Base. In table I defined a field date to take year only (I don't want days or months) for article publications. I selected user defined in the field properties and stipulated . The example shows up as 1903 and the format field shows 1900. Now into the user form input, I enter 1991 into the date field and tab to the next field and the date converts into today's date with the format 23/10/10. How do I stop Base doing what it wants to do and make it to do what I want it to do? Irrespective of the format it is viewed in, a date is stored in full format. You have two options: * format your input field. * store the year as a number (Integer). HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] User defined date field in Base not enforcing format
Michael Adams wrote: On Sunday 24 October 2010 06:59, AG wrote: Question about Base. In table I defined a field date to take year only (I don't want days or months) for article publications. I selected user defined in the field properties and stipulated . The example shows up as 1903 and the format field shows 1900. Now into the user form input, I enter 1991 into the date field and tab to the next field and the date converts into today's date with the format 23/10/10. How do I stop Base doing what it wants to do and make it to do what I want it to do? Irrespective of the format it is viewed in, a date is stored in full format. You have two options: * format your input field. * store the year as a number (Integer). HTH Most likely you only have one option: * store the year as an Integer. The properties dialog (Properties: Date Field) controls how dates are displayed in a Base Form. There are thirteen formats to choose from, but is not one of them. My conclusion: a date field cannot display a date in the format. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Fw: Missing 1st letters in surnames
In news:72863.89240...@web81601.mail.mud.yahoo.com, DeWayne McCarty clark...@sbcglobal.net typed: Mike thank you for your response. Some back ground: This document is part of a book written in OO, as are 2 previous ones written over the past 3 years. After writing, editing, etc. over 2,700 pages, This problem is really Weird. OO writer has been an excellent tool after that other Word Processor. In these books, the index contains only full names (i.e.: Surname, Given name, title). Why are only a few names are in error out of hundreds? Why do these errors only occur on a couple of pages? Why isn't ever name in the paragraphs missing 1st letters? I guess I have offended the Indexing God? DeWayne McCarty Member of Columbiana County Chapter of Ohio Genealogical Society I thought you said the first letters were missing on the pages, too, not just in the index? If a selection area only covers part of a column, that column won't be picked up by the operation. Either way it sounds like the Copy process failed to get the first column of data from those pages; easy to do if done manually, harder to happen if done by macro, but you left out a lot of useful data. HTH, Twayne` From: Mike Scott m...@scottsonline.org.uk To: users@openoffice.org Sent: Sat, October 23, 2010 10:37:41 AM Subject: Re: [users] Fw: Missing 1st letters in surnames On 22/10/10 03:14, DeWayne McCarty wrote: Windows 7; Open Office.org 3.2.1 (build 9502) I am proofing a 800+page book. This book contains abstracts of newspaper articles. All names are indexed. On 3 of the pages, there are a few names in the articles where the Surnames are missing the 1st letter. (These entries are indexed and the index has the complete spelling so the letters were there when they were indexed. ) [e.g. The letters in red are example of missing letters. SAMPLE PARAGRAPH: Mrs. Bell leaves five children: Mrs. Edna Vanskiver, Winter Haven, Fla.; Mrs. Ethel E. Haas, Columbiana; Ernest K. Bell, Leetonia; Herschel M. Bell near Rogers; Rolland O. Bell, Green Cove, Fla. She also leaves one great granddaughter, one sister, Mrs. Tirzah Lane, Dresden, O.; two brothers, George McGinnis, Springfield and John McGinnis, of Zanesville. I have copied these paragraphs and pasted them into note pad. The letters are missing there. Any help would be appreciated. No solution so far, I see. You don't say where the document came from. It probably makes a difference if you made it with OOo, or imported it from somewhere else. If it's imported (from Word maybe??), it's probably worth checking back to whatever other versions you have to see if you can spot when the characters were dropped. From your other email, it does sound as though the letters in this version are lost, which isn't hopeful. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Fw: Missing 1st letters in surnames
Twayne, thank you for your replay. Clarification: The 1st letter is missing on names in the document that have been indexed. These same names listed in the INDEX have the 1st letters. DeWayne McCarty From: Twayne twa...@twaynesdomain.com To: users@openoffice.org Sent: Sat, October 23, 2010 7:48:15 PM Subject: [users] Re: Fw: Missing 1st letters in surnames In news:72863.89240...@web81601.mail.mud.yahoo.com, DeWayne McCarty clark...@sbcglobal.net typed: Mike thank you for your response. Some back ground: This document is part of a book written in OO, as are 2 previous ones written over the past 3 years. After writing, editing, etc. over 2,700 pages, This problem is really Weird. OO writer has been an excellent tool after that other Word Processor. In these books, the index contains only full names (i.e.: Surname, Given name, title). Why are only a few names are in error out of hundreds? Why do these errors only occur on a couple of pages? Why isn't ever name in the paragraphs missing 1st letters? I guess I have offended the Indexing God? DeWayne McCarty Member of Columbiana County Chapter of Ohio Genealogical Society I thought you said the first letters were missing on the pages, too, not just in the index? If a selection area only covers part of a column, that column won't be picked up by the operation. Either way it sounds like the Copy process failed to get the first column of data from those pages; easy to do if done manually, harder to happen if done by macro, but you left out a lot of useful data. HTH, Twayne` From: Mike Scott m...@scottsonline.org.uk To: users@openoffice.org Sent: Sat, October 23, 2010 10:37:41 AM Subject: Re: [users] Fw: Missing 1st letters in surnames On 22/10/10 03:14, DeWayne McCarty wrote: Windows 7; Open Office.org 3.2.1 (build 9502) I am proofing a 800+page book. This book contains abstracts of newspaper articles. All names are indexed. On 3 of the pages, there are a few names in the articles where the Surnames are missing the 1st letter. (These entries are indexed and the index has the complete spelling so the letters were there when they were indexed. ) [e.g. The letters in red are example of missing letters. SAMPLE PARAGRAPH: Mrs. Bell leaves five children: Mrs. Edna Vanskiver, Winter Haven, Fla.; Mrs. Ethel E. Haas, Columbiana; Ernest K. Bell, Leetonia; Herschel M. Bell near Rogers; Rolland O. Bell, Green Cove, Fla. She also leaves one great granddaughter, one sister, Mrs. Tirzah Lane, Dresden, O.; two brothers, George McGinnis, Springfield and John McGinnis, of Zanesville. I have copied these paragraphs and pasted them into note pad. The letters are missing there. Any help would be appreciated. No solution so far, I see. You don't say where the document came from. It probably makes a difference if you made it with OOo, or imported it from somewhere else. If it's imported (from Word maybe??), it's probably worth checking back to whatever other versions you have to see if you can spot when the characters were dropped. From your other email, it does sound as though the letters in this version are lost, which isn't hopeful. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org