[libreoffice-users] Re: Style of unnumbered paragraph in a list
Regina: That works if I use the original numbering format. The problem seems to be when I change the numbering format. I change the Position format on Level 1 to Numbering followed by Space, Aligned at 0.50, and Indent at 0.00. I'm thinking this must force the unnumbered paragraph to align at the margin and not indent. Any ideas? Thanks, Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/Style-of-unnumbered-paragraph-in-a-list-tp4133019p4133088.html Sent from the Users mailing list archive at Nabble.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] Style of unnumbered paragraph in a list
In Writer I'm inserting an unnumbered paragraph in a list. My default paragraph style (and default numbering style) indents the first line .5. However, the unnumbered paragraph doesn't indent. It's flush with the margin. I have to indent using Tab. Even if I set the paragraph style for the specific paragraph to indent .5 on the first line that's ignored. How can I automatically set the paragraph style to indent on an unnumbered paragraph in a list? Thanks, Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/Style-of-unnumbered-paragraph-in-a-list-tp4133019.html Sent from the Users mailing list archive at Nabble.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] What's the best way to convert a .pdf form to .odt
I have a .pdf form I would like to use as a mail merge form. I see there's no way to do merge in Draw.I opened the .pdf in Draw and cut and pasted from the .pdf to a new .odt document. This only put images in the new document that I couldn't edit. I opened the .pdf in Reader and did the same. It copied all the text, but the formatting was poor. Is there a better way to do this so I don't have to retype the whole thing? Thanks, Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/What-s-the-best-way-to-convert-a-pdf-form-to-odt-tp4103644.html Sent from the Users mailing list archive at Nabble.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] Re: Writer - Tables - problem
Brian: That was some help. I turned off the alignment in the Input in Tables (under Options). Now it doesn't change the format. Thanks. I still have problems with the number format. I set the cell to currency format with a default $0.00 in the cell. When I attempt to insert additional numerals it changes the format to text. I can change it back to currency but it has no effect. In other words it doesn't insert commas. I turned number recognition on and off, but this had no effect. Today I discovered that if I completely erase the original cell content then insert new numerals it will properly format it. Go figure. It looks like I'll just have to leave blank cells in the form. I appreciate your ideas. Paul -- View this message in context: http://nabble.documentfoundation.org/Writer-Tables-problem-tp4089049p4089554.html Sent from the Users mailing list archive at Nabble.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] Writer - Tables - problem
In writer in a table I have numerical data entered in a column. I set the column to be right justified and the numeric format to currency. Occasionally I'll enter a number and it will not format correctly and will shift to the left. I can force it to right justify the cell contents, but I can't force it to apply currency numeric format. What am I doing wrong? Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/Writer-Tables-problem-tp4089049.html Sent from the Users mailing list archive at Nabble.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] Calc - How do I preserve number format for printing?
When I print a spreadsheet the number format isn't preserved. I use a format that shows two decimal places. When I print integers they have no .00 and formulas have a long string past the decimal. It appears correct inside the spreadsheet. Thanks, Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/Calc-How-do-I-preserve-number-format-for-printing-tp4048088.html Sent from the Users mailing list archive at Nabble.com. -- 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] How do I change the case of a field in writer?
I'm using writer to import data from a database. Can I set the format on the field so some entries will be all caps and some will only capitalize the first letter of a word? I want to insert names from the database. Most entries I want to have only the first letter of the name capitalized, but some entries I want the name to be all caps. Thanks, Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/How-do-I-change-the-case-of-a-field-in-writer-tp4035156.html Sent from the Users mailing list archive at Nabble.com. -- 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: Links in a writer document
Tom: Thanks. That's what I tried. My idea for the form was to allow the user to fill in data in a Writer table cell. Then, inside the spreadsheet I wanted to insert a DDE link to the cell in a Writer table. The spreadsheet would do the calculations for the form and generate the result. Ideally I could also link the output of the spreadsheet back to a cell in the Writer table. The problem with doing it this way is that the the spreadsheet doesn't refresh when I enter data in the Writer table cell. I tried creating the OLE object as a new Calc file, but it doesn't refresh. I tried creating the OLE object from an existing Calc file. I got some of the cells in the existing Calc file to refresh pretty well, but it didn't refresh the OLE object embedded in the Writer document. In any event, I would prefer not having two files. I would like to distribute this form. I expect potential users would be unfamiliar with LO. I expect it would be to hard for them to use it because both the files would need to be in the same directory and all the links between the files made to work. I can send you a draft of the form I'm working on to see if you might have some suggestions. Paul Whitehurst -- View this message in context: http://nabble.documentfoundation.org/Links-in-a-writer-document-tp4017587p4017745.html Sent from the Users mailing list archive at Nabble.com. -- 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] Links in a writer document
I'm working on forms that calculates child support. In Wordperfect I was able to lay it out in tables and use the table functions to do the calculations. In Writer the table functions are very limited. For example it doesn't have a function that tells when a cell is blank or one to look up an entry in a table. All those functions are in Calc. In order to be able to use the formatting from Writer it's necessary to link data from my Writer table cells to Calc and then link it back into Writer. This is quite a headache. In order to simplify this I tried embedding the spreadsheet into the Writer document as an OLE object with DDE links inside it to table cells in the Writer document. I need the spreadsheet to update automatically when data in the table cells change. To date I've had poor results being able to do this. I suppose I could write the forms in Calc, but I'm not nearly as familiar with document formatting for Calc as I am with Writer. I believe the learning curve would be steep. Can you suggest how I can make these forms work? Thanks, Paul Whitehurst -- View this message in context: http://nabble.documentfoundation.org/Links-in-a-writer-document-tp4017587.html Sent from the Users mailing list archive at Nabble.com. -- 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
Thanks folks. I think the solution is in the use of fields. I confess I have little understanding of them, and the help resources frankly aren't very helpful. Can someone suggest how I can set up a field where the output is copied to the same field in other places of the document? Paul. -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3710321.html Sent from the Users mailing list archive at Nabble.com. -- 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
I've figured out how to use cross-references fields. That seems to do what I need. Thanks again, Paul. -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3711089.html Sent from the Users mailing list archive at Nabble.com. -- 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] Refencing calc results in writer
I'm trying to do some calculations in writer that are more complex than the formulas that are provided in the tables. I'm forced to resort to calc for those formulas. I'm trying to figure out how to incorporate the results into a table in writer. So far all I've been able to figure out is how to display the results, that is the cell in calc with the formula results, in the writer table. I would like to be able to reference the results in my table in writer. For example to include the results of the calculation in a total in another cell of the table. So far all I'm able to do is to get an image of the calc cell, but it won't let me reference it in my table. Any ideas? Thanks, Paul -- View this message in context: http://nabble.documentfoundation.org/Refencing-calc-results-in-writer-tp376p376.html Sent from the Users mailing list archive at Nabble.com. -- 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] table - automatically copy text
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. -- 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: Need simple find replace macro
Andrew: The first one seems to work perfect. I didn't try the second one. Thanks for everything. I spent many weeks racking my brain over this. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3683281.html Sent from the Users mailing list archive at Nabble.com. -- 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: Need simple find replace macro
Andrew: Thank you for your work. I used your last two and both of them worked fine. The one that searches for the next } is more useful to me. I would like to figure out how to make it ask to go to the top to continue the search if it gets to the end of the document, or just stop the macro without opening the macro editor window. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3675782.html Sent from the Users mailing list archive at Nabble.com. -- 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] Need simple find replace macro
I want to migrate my law office from WordPerfect to Libreoffice. My forms have the } character that I use where I want to input text. I created a macro in WordPerfect that searches for that character, deletes it, and leaves the cursor at the position. I've assigned the macro to a key so I can quickly go through documents. I'm having difficulty learning how to duplicate this in Libreoffice. Likewise, I'm having difficulty finding one that already does this. Help please. Thanks. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3672651.html Sent from the Users mailing list archive at Nabble.com. -- 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: Need simple find replace macro
Tom: Thanks for the response. Don't overthink this. I'm not trying to convert anything from WordPerfect. Rather, I'm trying to just write one for use in Libreoffice (or purloin one someone else has written). The Libreoffice documents will have the } character. I want a macro to find that character, delete it, and leave the cursor at that position. It needs to be one I can assign to a key. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3673123.html Sent from the Users mailing list archive at Nabble.com. -- 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: Need simple find replace macro
Calvin: I've done it like that. I have a problem if there are no more } characters in the document. It deletes the next character whatever it is. I'm looking for something that would notify me if the search finds nothing or would ask to resume the search at the top. In WordPerfect I could simply replace the } with nothing rather than using deleting the text. I haven't been able to effectively do that in LibreOffice. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3673519.html Sent from the Users mailing list archive at Nabble.com. -- 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: Need simple find replace macro
Doug: My ultimate goal is to migrate from Windows to Linux. Before I do that I need to assure myself that software running under Linux can do what I've been doing in the past with various Windows programs. I'm very comfortable with WordPerfect having used it for almost 25 years. Nevertheless, like much software I only use a small fraction of its capabilities. From what I can see LibreOffice is more than capable of matching everything WordPerfect does. I expect I won't use nearly all of its capabilities. The real challenge is making myself learn how to use it. I have a lot of forms in WordPerfect that were tedious to create, such as bankruptcy and child support pleadings. I'm not crazy about redoing those in LibreOffice. Yet, if I get them like I want them I'll have mastered enough of the program that I can make a smooth migration. Change is inevitable. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3673689.html Sent from the Users mailing list archive at Nabble.com. -- 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
