[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

2018-06-05 Thread william drescher
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.

[libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

2017-02-15 Thread william drescher
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

[libreoffice-users] Re: Calc: Using Tab Within a Cell

2016-12-30 Thread william drescher
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

[libreoffice-users] Re: "Today" in calc

2016-11-28 Thread william drescher
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

[libreoffice-users] today's date in calc

2016-11-27 Thread william drescher
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

[libreoffice-users] "Today" in calc

2016-11-27 Thread william drescher
(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

[libreoffice-users] Re: Can't enter 12:12:52 in calc cell

2016-11-14 Thread william drescher
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

[libreoffice-users] Re: Overly aggressive autoformatting issues in LibreOffice

2016-08-27 Thread william drescher
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

[libreoffice-users] Re: Date field in a spreadsheet

2016-07-28 Thread william drescher
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:

[libreoffice-users] Date field in a spreadsheet

2016-07-27 Thread william drescher
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?

[libreoffice-users] Re: Checkbox in table cell (inside of a frame)

2016-01-04 Thread william drescher
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

[libreoffice-users] Re: LibreOffice Download

2016-01-04 Thread william drescher
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

[libreoffice-users] Re: Checkbox in table cell (inside of a frame)

2016-01-03 Thread william drescher
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

[libreoffice-users] Checkbox in table cell (inside of a frame)

2015-12-31 Thread william drescher
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:

[libreoffice-users] Re: How to.. sort a table in 3 columns

2015-10-20 Thread william drescher
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

[libreoffice-users] Re: How to.. sort a table in 3 columns

2015-10-18 Thread william drescher
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

[libreoffice-users] Re: How to.. sort a table in 3 columns - solved

2015-10-18 Thread william drescher
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

[libreoffice-users] Re: How to.. sort a table in 3 columns

2015-10-17 Thread william drescher
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

[libreoffice-users] Re: Drawing arrows in Writer.

2015-04-17 Thread william drescher
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

[libreoffice-users] Re: Full justification

2014-05-25 Thread william drescher
On 5/24/2014 5:21 PM, Cley Faye wrote: 2014-05-24 22:25 GMT+02:00 william drescher will...@techservsys.com: 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

[libreoffice-users] Re: Full justification

2014-05-24 Thread william drescher
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,

[libreoffice-users] Re: Full justification

2014-05-23 Thread william drescher
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

[libreoffice-users] Re: table: clipping of numbers: still helpless

2014-05-01 Thread william drescher
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:

[libreoffice-users] Re: table: clipping of numbers: still helpless

2014-05-01 Thread william drescher
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.

[libreoffice-users] Re: table: clipping of numbers: still helpless

2014-04-30 Thread william drescher
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

[libreoffice-users] table: clipping of numbers

2014-04-27 Thread william drescher
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

[libreoffice-users] Re: Large fonts

2014-02-22 Thread william drescher
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?

[libreoffice-users] Re: averaging with missing values

2014-02-16 Thread william drescher
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

[libreoffice-users] averaging with missing values

2014-02-15 Thread william drescher
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

[libreoffice-users] Re: Detailed information on frame positioning Writer

2013-12-02 Thread william drescher
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.

[libreoffice-users] Re: Detailed information on frame positioning Writer

2013-12-01 Thread william drescher
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

[libreoffice-users] Re: Bug report -- Libre Ofice version 4.1.3.2

2013-11-23 Thread william drescher
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

[libreoffice-users] Re: Avery 3x5 card form, portrait/landscape problem

2013-11-02 Thread william drescher
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

[libreoffice-users] Avery 3x5 card form, portrait/landscape problem

2013-10-31 Thread william drescher
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,

[libreoffice-users] Re: Avery 3x5 card form, portrait/landscape problem

2013-10-31 Thread william drescher
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

[libreoffice-users] duplicate open buttons

2013-10-25 Thread william drescher
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:

[libreoffice-users] Re: inserting pdf into writer document

2013-10-11 Thread william drescher
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

[libreoffice-users] inserting pdf into writer document

2013-10-10 Thread william drescher
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

[libreoffice-users] 3/4/1`3 in table

2013-03-05 Thread william drescher
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

[libreoffice-users] Re: 3/4/1`3 in table - duplicate posting - sorry

2013-03-05 Thread william drescher
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

[libreoffice-users] Re: 3/4/13 in writer table

2013-03-05 Thread william drescher
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

[libreoffice-users] Re: page down in word processors - find next

2013-02-17 Thread william drescher
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

[libreoffice-users] Re: page down in word processors - find next

2013-02-16 Thread william drescher
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

[libreoffice-users] Re: Inserting a code for today's date

2012-10-20 Thread william drescher
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 snip Joel et al, Curious, I tried =TODAY() as a field

[libreoffice-users] Re: Inserting a code for today's date

2012-10-20 Thread william drescher
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

[libreoffice-users] Re: table - automatically copy text

2012-02-01 Thread william drescher
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

[libreoffice-users] Re: displaying the result of pageNum + 1

2012-01-29 Thread william drescher
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

[libreoffice-users] displaying the result of pageNum + 1

2012-01-27 Thread william drescher
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?

[libreoffice-users] Re: Endnote X4 OpenOffice Extension does not work

2011-02-27 Thread william drescher
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.

[libreoffice-users] Re: MS Office - LibreOffice (compatibility problem)

2010-11-04 Thread william drescher
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