[libreoffice-users] 3/4/1`3 in table
I have a table in a writer document that has the first col formatted as date (MM/DD/YY), but when I enter 3/4/13 the 3/4 is converted in a smaller 3/4 = three fourths. Yes I can undo the auto correct, but shouldn't writer be smart enough to not do this in a date format cell ? Thoughts or suggestions ? bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: 3/4/1`3 in table - duplicate posting - sorry
On 3/5/2013 6:31 AM, william drescher wrote: I have a table in a writer document that has the first col formatted as date (MM/DD/YY), but when I enter 3/4/13 the 3/4 is converted in a smaller 3/4 = three fourths. Yes I can undo the auto correct, but shouldn't writer be smart enough to not do this in a date format cell ? Thoughts or suggestions ? bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: 3/4/13 in writer table
On 3/4/2013 12:01 PM, upscope wrote: On Monday, March 04, 2013 10:09:52 AM bill wrote: I have a writer document with a table. The first col is formatted as date, but when I enter today ( 3/4/13 ) the 3/4 is formatted as a small 3/4th. I checked the col formatting and it really is date (MM/DD/YY) Any thoughts or suggestions ? Is it a col. or a table. it is a column in a table in a writer document. Are you using Table-->Number Format -->Date to select the format of the date? yes bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Inserting a code for today's date
On 10/19/2012 1:29 PM, Girvin R. Herr wrote: Joel Madero wrote: Ah, yes my mistake for assuming what you were using. I'll have to look into writer. I just tried inserting a table (1x1) and putting the formula, no good. Regards, Joel Joel et al, Curious, I tried "=TODAY()" as a field variable formula and it doesn't work, with or without the "=". Inserting a table is a brute force method, but as you say, it doesn't seem to work either. Writer's tables are a subset of Calc tables and "=TODAY()" may not be a supported formula. A better approach might be to: 1. Place the cursor where you want the date. 2. Select Insert -> Fields -> Other 3. Select the "Document" tab 4. Select "Date" for "Type" 5. Select "Date" for "Select" 6. Choose your date format under "Format". 7. Click on "Insert". If in step #5 you select "Date (Fixed)", I think that will insert today's date but it will not update in future edits. Even this procedure may not work in a template. More investigation is needed. Hope this helps. Girvin Herr works, thanks bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Inserting a code for today's date
On 10/19/2012 11:20 PM, Brian Barker wrote: At 10:26 19/10/2012 -0400, Bill Drescher wrote: Is there any way I can insert code so that when I open a template the date is the date that the document is opened rather than the date it was created ? When you open the template, both these dates are the same! Templates are used only to create new documents, so the document is created at the point that the template is opened. But I think I see what you mean. You want a template containing a date field such that any document created from that template will, after it is saved and reopened, show the date that the document was reopened (and then reopened and reopened) and not initially created from the template. As has already been suggested by others, you can do that at Insert | Fields > | Other... | Document. Under Type select Date and under Select select Date - not "Date (fixed)". One point of confusion is that at Insert | Fields > you will see a Date entry - but this is actually the "Date (fixed)" variety, not the (variable) Date that you need. So ignore that and proceed to Other... . I trust this helps. Brian Barker Yup, that works. Thanks bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: page down in word processors - find next
On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes "continue search forward" and the page up becomes "continue search backwards." That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: page down in word processors - find next
On 2/16/2013 8:05 AM, Dan Lewis wrote: On 02/16/2013 07:41 AM, william drescher wrote: On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes "continue search forward" and the page up becomes "continue search backwards." That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill For some time, this has been used for navigation. PageUp/PageDown and SearchUp/SearchDown are only 2 of 20 functions. What about the other 18 functions? I think we can even give this a name: Navigation tool. --Dan I'm not talking about the center button (which opens the navigation menu), but about the up and down buttons. bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] inserting pdf into writer document
I have a pdf file that is 233 pages long. Some is native pdf, other pages are apparently images scanned into the document. Is there any way I can take pages from the pdf and insert them into writer ? win 7 bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: inserting pdf into writer document
On 10/10/2013 2:22 PM, Steve Edmonds wrote: Hi. Sometimes I do this by opening the PDF in LO draw and then copying relavent parts to writer documnet. Not all PDFs open perfectly in draw. Opening in Draw workes a treat ! As I only need about 20 of the 233 pages this is quick and easy and formatting is preserved just fine. Many thanks -- Bill Drescher william {at} TechServSys {dot} com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] duplicate open buttons
I just upgraded to Version 4.0.5.2 (Build ID: 5464147a081647a250913f19c0715bca595af2f) Now I have duplicate "open" buttons on the standard toolbar. Both have tooltips that say "Open (ctrl + O)" not a problem for me, just wondered bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: duplicate open buttons
On 10/25/2013 3:02 PM, william drescher wrote: I just upgraded to Version 4.0.5.2 (Build ID: 5464147a081647a250913f19c0715bca595af2f) Now I have duplicate "open" buttons on the standard toolbar. Both have tooltips that say "Open (ctrl + O)" not a problem for me, just wondered bill OS: win7 source: libreoffice website prev vers 3.5.6 (I think) bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Avery 3x5 card form, portrait/landscape problem
I need to print some 3x5 inch cards across the narrow side. This would be "portrait" on each card. The Avery Letter Size 5386 label has 3 cards stacked on top of each other: eg the cards are landscape on a page that is portrait. When I load the template and switch the page to landscape, instead of just rotating the page and template, LO rotates the page but leaves the template as is. The result is that I have 2 - 3x5 cards on the first page, and 1 on the next page, all in landscape orientation. I know I could just rotate the text 90 degrees, but that is a bit hard to read :-) I can build my own template, but does anyone have other suggestions ? bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Avery 3x5 card form, portrait/landscape problem
On 10/31/2013 8:14 AM, william drescher wrote: I need to print some 3x5 inch cards across the narrow side. This would be "portrait" on each card. The Avery Letter Size 5386 label has 3 cards stacked on top of each other: eg the cards are landscape on a page that is portrait. When I load the template and switch the page to landscape, instead of just rotating the page and template, LO rotates the page but leaves the template as is. The result is that I have 2 - 3x5 cards on the first page, and 1 on the next page, all in landscape orientation. I know I could just rotate the text 90 degrees, but that is a bit hard to read :-) I can build my own template, but does anyone have other suggestions ? bill If I use Avery 5388 (without the rolodex cutouts), when I shift to landscape, the template again does not rotate, I get 1 1/2 cards (in landscape) on the page. (The rest disappear). bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Avery 3x5 card form, portrait/landscape problem
On 10/31/2013 8:14 AM, william drescher wrote: I need to print some 3x5 inch cards across the narrow side. This would be "portrait" on each card. The Avery Letter Size 5386 label has 3 cards stacked on top of each other: eg the cards are landscape on a page that is portrait. When I load the template and switch the page to landscape, instead of just rotating the page and template, LO rotates the page but leaves the template as is. The result is that I have 2 - 3x5 cards on the first page, and 1 on the next page, all in landscape orientation. I know I could just rotate the text 90 degrees, but that is a bit hard to read :-) I can build my own template, but does anyone have other suggestions ? bill Thanks everybody. To get the task done I created a page with 3 frames. I tried a table, but the table auto-adjusted the bottom when I typed in too much and I did not notice. With the frame I get the red arrow that lets me know. I tried columns, but the text should NOT flow from 1 to the next. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Bug report -- Libre Ofice version 4.1.3.2
On 11/23/2013 12:50 AM, Robert Baker wrote: 1) There is no way (that I have found) to insert the date and time as text; the only option is to insert them as a field, meaning that the next time the document is opened, the date and time shown would be when it was re-opened, rather than when it was last edited which is what I want. I had to take the file back into MS Word just to add the date and time, but I want to be rid of Word. The simple way of adding a date: Insert->fields->date will add a date that does not change. You have to go through a few more steps to get a date that is current when the file is opened. So, no problem with this one. I will leave the other questions to those that are more expert. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Detailed information on frame positioning Writer
On 12/1/2013 6:09 AM, Tom Davies wrote: Hi :) Have you tried documentation https://wiki.documentfoundation.org/Documentation/Publications and the Faq? https://wiki.documentfoundation.org/Faq Regards from Tom :) Tom, I looked through the TOC and did a search for "frame" and "frames" and did not find any information on frame positioning. Now, it is entirely possible that I am blind, but a reference link would be appreciated. bill On 1 December 2013 01:38, Kevin O'Brien wrote: Is there a source for detailed information on frame positioning in Writer? Thanks, -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Detailed information on frame positioning Writer
On 12/1/2013 3:48 PM, Andrew Douglas Pitonyak wrote: On 11/30/2013 08:38 PM, Kevin O'Brien wrote: Is there a source for detailed information on frame positioning in Writer? Thanks, Let me provide some context around Mr. O'Brien. 1. He is very smart. 2. He is well versed with OpenOffice. Sufficiently well versed, that I have seen him (in person) teach detailed classes on OpenOffice. In other words, I assume that he has looked in the obvious places. That said, and because Mr. Drescher asked, consider this link: https://wiki.documentfoundation.org/images/9/96/WG40-WriterGuideLO.odt Thanks Andrew bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] averaging with missing values
I have a table of systolic bloop pressures: 4 rows (weeks) x 21 cols (days) eg: week 1 130 133 140 ... (representing morning, noon, night of day 1 - followed by morning, noon and night of day 2..7) I want to compute the average pressure for the week. In a perfect world I would just use the average function. However, in this world I find that each row has between 3 and 10 missing values. To get the average now I sum the row's values and then divide by the number of values in the row. Can anyone suggest a way of getting the average without needing to manually count the values ? Thanks, -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: averaging with missing values
On 2/15/2014 11:49 AM, Regina Henschel wrote: Hi William, william drescher schrieb: I have a table of systolic bloop pressures: 4 rows (weeks) x 21 cols (days) eg: week 1 130 133 140 ... (representing morning, noon, night of day 1 - followed by morning, noon and night of day 2..7) I want to compute the average pressure for the week. In a perfect world I would just use the average function. However, in this world I find that each row has between 3 and 10 missing values. To get the average now I sum the row's values and then divide by the number of values in the row. Can anyone suggest a way of getting the average without needing to manually count the values ? If the cells are really empty or have a function call that results in a text, then such cells will not be counted by the AVERAGE function. If the cells contain a formula, which results in 0, then you can use AVERAGEIF(range;"<>0"). Kind regards Regina Thank you for the information - couldn't be easier --bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Large fonts
LO 4.5.0.2 - Windows 7 I agree with Brad: clicking back into the document resets the font hitting return after typing in the big font size does not reset the font. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] table: clipping of numbers
Medicare, in its infinite wisdom (NOT) released a new (and required) Health Insurance Claim Form. I have a table that I use as a template to fill in the forms (using openTBS it fills in automagically). The problem is that when they revised the section for diagnoses, they put the lines to close to together (vertically) that when I make the rows fit, the (required) 12 pitch numbers are clipped on the bottom. If I make the row height big enough (.021") to not clip, the rows do not line up. Back in the days of WordPerfect, I would use "advance to" and then could slightly overlap the fields. Anyone have any suggestions of how to approach this? (form requires 12 pitch (pica) letters) bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: table: clipping of numbers: still helpless
On 4/27/2014 11:49 AM, william drescher wrote: Medicare, in its infinite wisdom (NOT) released a new (and required) Health Insurance Claim Form. I have a table that I use as a template to fill in the forms (using openTBS it fills in automagically). The problem is that when they revised the section for diagnoses, they put the lines to close to together (vertically) that when I make the rows fit, the (required) 12 pitch numbers are clipped on the bottom. If I make the row height big enough (.021") to not clip, the rows do not line up. Back in the days of WordPerfect, I would use "advance to" and then could slightly overlap the fields. Anyone have any suggestions of how to approach this? (form requires 12 pitch (pica) letters) bill Reposting as I am still stuck -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: table: clipping of numbers: still helpless
On 4/30/2014 4:49 PM, James E Lang wrote: Does the silly form get submitted electronically or on paper? On paper. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: table: clipping of numbers: still helpless
On 5/1/2014 9:02 AM, Tom Davies wrote: Hi :) Does anyone know if there is some sort of buffer-zone between the edges of the cells and the contents of that cell? In Writer i went to Table - Properties - Borders and found the "Spacing to contents" defaulted to 0.1cm. mine defaulted to 0.04 inches. William, i guess you might have tried that already but if not then does that help at all? Errr, i am assuming you are using Writer rather than Draw. With Draw it might be a steep learning curve but you can have over-lapping text-boxes there. I am just not any good at linking them so i'd have to use the mouse to click into each new box rather than using the tab key (or shift tab to go backwards). Sorry no-one has been able to help at all with this so far ! Apols and regards from Tom :) That is EXACTLY what I needed. Perfect. Thanks very much. Very Much. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Full justification
On 5/23/2014 5:19 AM, Ian Graham wrote: The first WP I really knew back to front was WP 6.1. In that, there was a text orientation setting/button which I remember as being called 'justify'. Whatever it was called, it spread the text equally across the page, giving hard edges at both left and right. In my current Libre Office Version: 4.1.3.2, there are four (text orientation ) buttons on the tool bar - but so far as I can see, the fourth, called Justify, seems to format exactly the same as the first, Align Left. Have I got a glitch, or am I missing something ? Ian Graham Wales UK please don't reply to a message and then change the subject. That is called "hijacking the thread" and really messes up those of us that thread our messages by subject. Having said that, what you want is to change to alignment to justify. There are buttons for that or you can find it on the Format menu. It works for me, even with sparse lines (which turn out ugly on the screen). If this doesn't help, please start a new thread. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Full justification
On 5/23/2014 12:09 PM, Doug wrote: On 05/23/2014 05:19 AM, Ian Graham wrote: The first WP I really knew back to front was WP 6.1. In that, there was a text orientation setting/button which I remember as being called 'justify'. Whatever it was called, it spread the text equally across the page, giving hard edges at both left and right. In my current Libre Office Version: 4.1.3.2, there are four (text orientation ) buttons on the tool bar - but so far as I can see, the fourth, called Justify, seems to format exactly the same as the first, Align Left. Have I got a glitch, or am I missing something ? Ian Graham Wales UK You're missing something. On the third line from the top--the one with the font size on it, there is a set of icons after the font size number, B i U then four icons with parallel horizontal lines: ragged right, centered, ragged left, fully justified. They also bring up a keyboard shortcut if you don't want to use the icons. these are, respectively, align left (ctrl+L), centered (ctrl+E), align right (ctrl+R), justified (ctrl+J). After these, there are more icons for other things. --doug I forgot to mention: if you have already typed the text you want justified, you have to highlight it when clicking on the justify button. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Full justification
On 5/24/2014 5:21 PM, Cley Faye wrote: 2014-05-24 22:25 GMT+02:00 william drescher : I forgot to mention: if you have already typed the text you want justified, you have to highlight it when clicking on the justify button. Technically, it should work by just having the cursor in the paragraph, as the justification is a paragraph property. If it doesn't apply the justification to other lines, then indeed your lines are not part of the same paragraph (e.g. the return key was used somewhere). right you are. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Drawing arrows in Writer.
On 4/16/2015 11:57 AM, V Stuart Foote wrote: @Henri, The group selectors for Draw/Impress "Lines and Arrows" and "Connectors" are not currently exposed to Writer. If that piece gets done, then the choice of exposing it on Writer's Drawing toolbar by default or hiding it is negligible. But take your point about exposing by default on the Drawing toolbar for simplicity of use for those not comfortable with doing toolbar customization. Stuart +1 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to.. sort a table in 3 columns
I have a list that has two fields: aisle and item. I need to maintain the list sorted by item, but print a pick list by aisle. This would be simple except, when I print the list for marking I need to print it in item order, in 3 columns. When I print the pick list I again need to print it in 3 columns, sorted by item, Right now I am sorting the list by aisle and manually cutting and pasting it into 3 columns. I currently have the data in a spreadsheet. I tried using frames set for 3 columns, but when past the sorted list into the frames it does not spill over onto the 2nd and 3rd columns. I would appreciate suggestions. Thanks, bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to.. sort a table in 3 columns
On 10/16/2015 4:13 PM, Gary Dale wrote: On 16/10/15 04:02 PM, william drescher wrote: I have a list that has two fields: aisle and item. I need to maintain the list sorted by item, but print a pick list by aisle. This would be simple except, when I print the list for marking I need to print it in item order, in 3 columns. When I print the pick list I again need to print it in 3 columns, sorted by item, Right now I am sorting the list by aisle and manually cutting and pasting it into 3 columns. I currently have the data in a spreadsheet. I tried using frames set for 3 columns, but when past the sorted list into the frames it does not spill over onto the 2nd and 3rd columns. I would appreciate suggestions. Thanks, bill 1) Create a custom Writer document with the fields you want printed. 2) attach the spreadsheet to Base. Create a query that meets your sort/selection requirements. 3) print the document as a form letter. I have never used the form letter generator. Will it allow 1..n rows? bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to.. sort a table in 3 columns
On 10/17/2015 10:37 AM, Andreas Säger wrote: Am 16.10.2015 um 22:02 schrieb william drescher: I have a list that has two fields: aisle and item. I need to maintain the list sorted by item, but print a pick list by aisle. This would be simple except, when I print the list for marking I need to print it in item order, in 3 columns. When I print the pick list I again need to print it in 3 columns, sorted by item, Right now I am sorting the list by aisle and manually cutting and pasting it into 3 columns. I currently have the data in a spreadsheet. I tried using frames set for 3 columns, but when past the sorted list into the frames it does not spill over onto the 2nd and 3rd columns. I would appreciate suggestions. Thanks, bill Operating system? Windows 7 Office version? Office component? Writer? Calc? Base? I'll use whatever I need File format? doc, docx, odt, ods, xls, odb? odt or ods I don't understand how you want to dump 2 fields into 3 columns? Locationitem locationitem location item 1 widget 9 vebelfetzer 13 nails, 10p 1 screws, 8x1 10L. widget 24 nailsm 16p The term "pick list" is unclear. Listbox? Writer field of type "input list"? a pick list is a lit of items to be picked and packed for an order bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to.. sort a table in 3 columns - solved
On 10/16/2015 4:02 PM, william drescher wrote: I have a list that has two fields: aisle and item. I need to maintain the list sorted by item, but print a pick list by aisle. This would be simple except, when I print the list for marking I need to print it in item order, in 3 columns. When I print the pick list I again need to print it in 3 columns, sorted by item, Right now I am sorting the list by aisle and manually cutting and pasting it into 3 columns. I currently have the data in a spreadsheet. I tried using frames set for 3 columns, but when past the sorted list into the frames it does not spill over onto the 2nd and 3rd columns. I would appreciate suggestions. Thanks, bill Solution: 3 linked frames rather than 1 3-col frame. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to.. sort a table in 3 columns
On 10/18/2015 8:02 AM, Andreas Säger wrote: Am 18.10.2015 um 12:36 schrieb william drescher: Operating system? Windows 7 Office version? Office component? Writer? Calc? Base? I'll use whatever I need File format? doc, docx, odt, ods, xls, odb? odt or ods I don't understand how you want to dump 2 fields into 3 columns? Locationitem locationitem location item 1 widget 9 vebelfetzer 13nails, 10p 1 screws, 8x1 10L. widget 24 nailsm 16p The term "pick list" is unclear. Listbox? Writer field of type "input list"? a pick list is a lit of items to be picked and packed for an order bill 1) Store your list data in some kind of simple database: Having the 2-column list in a text file (*.csv or *.txt), open the file with Calc. Having the 2-column list in a spreadsheet, make sure that the A1 and B1 contain the words "Location" and "Item" as column labels and that all locations are numbers (Ctrl+F8 highlights numbers in blue). Save the spreadsheet in a separate directory as a dBase file: menu:File>SaveAs... Navigate to your preferred directory, add a new directory, visit the new directory menu:File Type:dBase(*.dbf) This file format gives various advantages for every day use. -- 2) Connect your database to the office suite: File>New>Database... [x] Connect to existing database Type: dBase Point to the directory [X] Yes, register the database Save the database document (*.odb) in that directory or elsewhere. --- 3) Generate a dynamic report in columnar layout: Click the tables container. Right-click the table therein, call the report wizard and create a tabular report with a 3-column layout and the right sort order. -- What is this "database document"? Your database table is a _link_ to your dBase file. The database document (*.odb) does not store any data. It represents the contents of the dBase files in the given directory as a collection of database tables. Your data are in the dBase file or any additional dBase files stored in that directory. Since you registered this data source you have quick access to your list without opening anything. Just hit F4 in Writer or Calc. The report is a Writer document embedded in that database file. It is filled with table data every time you open the report. You can store snapshots of this report at any time simply saving the embedded Writer document as a stand-alone document or as PDF. Thank you. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Checkbox in table cell (inside of a frame)
I have a three col table inside of 3 linked frames. I would like to add a Checkbox in table cell I followed the help instructions, but the checkbox icon does not drag from the form toolbar to the table. I suspect that I am missing a step. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Checkbox in table cell (inside of a frame)
On 12/31/2015 8:15 AM, william drescher wrote: I have a three col table inside of 3 linked frames. I would like to add a Checkbox in table cell I followed the help instructions, but the checkbox icon does not drag from the form toolbar to the table. I suspect that I am missing a step. bill no reply - so reposting -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Checkbox in table cell (inside of a frame)
On 12/31/2015 8:15 AM, william drescher wrote: I have a three col table inside of 3 linked frames. I would like to add a Checkbox in table cell I followed the help instructions, but the checkbox icon does not drag from the form toolbar to the table. I suspect that I am missing a step. bill Thanks Sigrid and Brian Brian's original post never did show up in my newsgroup feed (gmane). -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Download
On 1/4/2016 6:11 AM, Shakir, Salman (External) wrote: Dear Sir/Madam, I want to ask about the downloading procedure. Is it necessary to download it with Torrent because in some countries use of Torrent is not allowed. So kindly help me in this regard. Best Regards Salman Shakir you can download directly from http://www.libreoffice.org/download/libreoffice-fresh/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Date field in a spreadsheet
I have version Version: 5.0.5.2 In writer I can insert a field that shows the current date whenever the document is opened. I can't figure out how to do that in a spreadsheet. Help please. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Date field in a spreadsheet
On 7/27/2016 2:27 PM, Joe Conner wrote: In a spreadsheet cell insert without the quotes "=now()" or "=date()" depending upon whether or not you want the time to display. Thanks to all who told me how to put the date into a cell. bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Overly aggressive autoformatting issues in LibreOffice
On 8/26/2016 12:18 PM, M Henri Day wrote: ttps://www.washingtonpost.com /news/wonk/wp/2016/08/26/an-alarming-number-of-scientific- papers-contain-excel-errors/ Unless things have changed a lot since I did research, the data in the spreadsheet was not typed by the researcher. It was probably typed by an undergraduate work-study student or, at best, a harried departmental secretary. Brian, love the umbrella metaphor. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Can't enter 12:12:52 in calc cell
On 11/13/2016 8:09 PM, James wrote: I make a new spreadsheet, formatted A1 as hh:mm:ss, tried to type "12:12:52". After the second colon, the contents change to 12 (the one is overlapped by another character). Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1 OS: lubuntu 4.4 Win10 Version: 5.0.5.2 no problem -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] "Today" in calc
(2nd posting, it appears the first disappeared in cyberia) When I update the data in a spreadsheet I need to also update the one of two cells "date data sent" or "date data received." I can't figure out a way of doing that automagically so I have a field in the header set to TODAY() and I copy and paste that into the row. Plain pasting doesn't work as that will paste the function, not the value. Paste Special works but is a lot of clicks. Can anyone think of a better way to do this. -- -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] today's date in calc
As I work I need to paste today's date into a cell every time I update a row. My first approach is to put the today() function into a cell and then copy/paste it. That doesn't work as I don't want to past the function. I can paste special which works but is cumbersome. I am telling myself that there MUST be a simpler way. Can anyone suggest one ? -- -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: "Today" in calc
On 11/27/2016 8:11 PM, Remy Gauthier wrote: Hello, You could also refer to this post: https://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=30071 I believe it describes a way to do what you are looking for. Basically they describe a way to trigger a macro that monitors a range of cells and that performs a specific operation when something is changed. Rémy Gauthier. Thank you Rémy Le dimanche 27 novembre 2016 à 23:57 +, Brian Barker a écrit : At 07:04 27/11/2016 -0500, William Drescher wrote: (2nd posting, it appears the first disappeared in cyberia) Both messages presumably awaited moderation. Your first arrived 47 seconds after your second. When I update the data in a spreadsheet I need to also update the one of two cells "date data sent" or "date data received." I can't figure out a way of doing that automagically so I have a field in the header set to TODAY() and I copy and paste that into the row. Plain pasting doesn't work as that will paste the function, not the value. Paste Special works but is a lot of clicks. Can anyone think of a better way to do this. Right-click | Paste Only > | Number? If you prefer, you can find Paste Only under Edit in Tools | Customise... | Keyboard and bind it to an unused keyboard shortcut. I trust this helps. Brian Barker Thanks Brian. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Using Tab Within a Cell
On 12/29/2016 8:11 PM, MindFork wrote: I do a lot of data entry, where the cell contents may be one of a few different options for that particular column. (think: entering short answers for a test question, where many people will write similar things). In Excel and OpenOffice, once I start typing, the first option with that beginning shows up. If there are two or more options with the same beginning, I can press the tab key to move to the next option. The right arrow moves to the next cell. In LibreOffice, I don't see this particular function. Everytime I enter data in the cell, I have to type the entire entry. As you can imagine, this gets old with long entries. Is there something I'm missing that would do this? A setting somewhere or a plugin/extension? If LibreOffice doesn't offer this functionality/feature, I'll have to go back to OpenOffice. (I'm not opposed to this, but LibreOffice came pre-installed with my Linux distro.) ctrl-tab works the way you want it to. HTH bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: about libreoffice online which is introduced in version 5.3
On 2/14/2017 5:20 PM, anne-ology wrote: what would you do if the power grid went out, leaving you with no access to your data? Summer: I would mix a big gin and tonic and relax while contemplating what would happen to civilization. Winter: I would mix a big mulled wine and sit in front of the fireplace while contemplating what would happen to civilization. If you lost the entire power grid, working on a computer is the least of your problems. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: One more question before I give up for the night. I thought the table was set to not split cells when it went to the next page, but that's not happening. I've looked for a way
On 6/4/2018 10:51 PM, Peggy wrote: I couldn't get the return to work. Sorry this text is spreading so far across the page! Starting with the early Xerox machines, all technology contains a hidden anxiety detector. When your anxiety goes up it makes the machine more likely to malfunction. This has been demonstrated by generations of students working on their projects/papers at the last minute. I understand that this seems inconceivable, but, if you don't believe it propose another theory that explains why the more you need the technology the less likely it is to work correctly. -bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: MS Office -> LibreOffice (compatibility problem)
On 11/3/2010 4:11 AM, Arda Tunccekic wrote: Hi people. Is this the place to get support for LibreOffice? I work in a company that have more than 200 computers and I am trying to migrate from MS Office to LibreOffice + Thunderbird. Uninstalling MS Office and installing LibreOffice is fun but sometimes there are problems that I can't find a solution (yet). I have a document (.docx) that cannot be displayed properly with LibreOffice and because of this MS Office fans in my company say that we need MS Office, we cannot do business without MS Office.. I've installed odf-converter-integrator-0.2.3, but still I can't see the graphic inside. Where can I get support for this? Thank you I am going through the same process in a much smaller office. Once my users find LibreOffice they prefer to not go back to MS. bill -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Endnote X4 OpenOffice Extension does not work
On 2/27/2011 12:23 AM, Rogerio Luz Coelho wrote: Firtstly this is a Documentation list, your question should be posted on the user or dev list, please visit Actually, this is the users list http://www.libreoffice.org/get-help/mailing-lists/#Local_Regional_Lists for more information. Rogerio 2011/2/27 Sam Hi, Upon trying to add the "Cite While You Write" Endnote OpenOffice Extension to the latest LibreOffice an error is displayed: "The extension 'Endonte Cite While You Write' does not work on this computer". I have contacted the support team for Endnote to explain the existence of LibreOffice and the need for compatibility but am wondering if there's anything I can do in the mean time to get the OpenOffice extension to work? Thanks, Sam -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] displaying the result of pageNum + 1
In the footer of a faxed document I want to display: This fax continues on page x where x is to be the current page number + 1 Can I do this, how ? Thanks in advance, bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: displaying the result of pageNum + 1
On 1/27/2012 9:47 PM, Dan Lewis wrote: On Fri, 2012-01-27 at 10:31 -0500, william drescher wrote: In the footer of a faxed document I want to display: This fax continues on page x where x is to be the current page number + 1 Can I do this, how ? Thanks in advance, bill In the footer, enter the text you want: "This fax continues on page " without the quotes. Please note that there is a space after the word "page". Then use the Control+F2 key combination to open the Fields dialog. Click the Document tab. Click "Page" in the Type list. Then click "Page numbers" in the Select list. Select "Arabic (1 2 3)". Now enter the number 1 in the Offset box. Click Insert, and then click Close. --Dan brilliant -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: table - automatically copy text
On 2/1/2012 2:30 AM, Steve Edmonds wrote: Hi. If I understand you correctly, you can create fields and then have them displayed in other locations. I.e. entered in one place and displayed in many. steve On 2012-02-01 11:19, paulwhitehurst wrote: I'm using tables in swriter that have text in them. I would like to insert text and have the text copied to other cells automatically. I know I can enter numbers and insert a formula that copies the number from one cell into another. The same formula doesn't seem to work with text. Any help would be appreciated. Paul. -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3704908.html Sent from the Users mailing list archive at Nabble.com. I entered abcd into cell a1 and then in cell b1 entered =A1 and the text was copied without error to cell b1. Is that what you are looking for ? bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted