[libreoffice-users] adding page numbers to document
Please tell me how to add page numbers to my document. -- 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] LO spreadsheet format row
Is there a way, in L.O. spreadsheet, to lock the rows so that a row cannot take more than one line? So that all rows have the same height. Freeze doens't seem to do that. Thank you, -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] [OT] Operating Environment Survey
I am not young (as someone suggested early on that Linux users usually are). I have Linux lxle on one desktop, opensuse on another desktop, and ubuntu on a very very old laptop. No windows products. Android tablet. On Sat, Jul 18, 2015 at 9:43 PM, James Knott wrote: > On 07/18/2015 09:25 PM, James E Lang wrote: > > The big discussion of Linux over the past 24+ hours has me wondering: > What operating environment(s) do other members of this list use at home and > at work? What factors influence the choice? > > > > Personal: > All computers run openSUSE 13.1 > ThinkPad E520 came with Windows 7 and can dual boot > Run Windows 10 in VirtualBox > Google Nexus 5 phone and Nexus 7 tablet > > Work: (I didn't choose either of these.) > ThinkPad X131e running Windows 8.1 > iPhone 6 > > > I like Linux, ThinkPads and Android. > > -- > 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 > -- Helen Etters using Linux, suse12.3 -- 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] Spreadsheet q
How can I tell LO spreadsheet that in this particular cell, I want to write "January 2014" and that's what I want it to say- don't change it to date format, just leave that text. Thanks,, -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.
I clicked the link, it took me to home page. I click Download Gnumeric and it takes me back to the home page. I've tried all the variations I can find -- how do I download it? On Sat, Apr 5, 2014 at 4:12 AM, Tom Davies wrote: > Hi :) > Try Gnumeric; > http://www.gnumeric.org/download.html > > It's a dedicated spreadsheet program with a tiny footprint that uses > minimal resources, so it's faster, lighter and more robust than Excel > or Calc. Many people find Gnumeric to be better than Calc or Excel > for serious or hefty spreadsheets and/or for handling many more > spreadsheets in a shorter time-frame. > > It can be installed alongside LibreOffice and/or MS Office. It uses > the same format as LibreOffice natively so most spreadsheets can be > bounced between the 2 programs quite happily. > > Part of the advantage of LibreOffice is that it fits well into a wider > eco-system and co-operates well with a wider range of programs and > suites allowing you to tailor individual machines to specific > use-cases and yet still retain the ability to share files between > different machines and different people using different OSes and > programs. > > Regards from > Tom ) > > > > > On 5 April 2014 06:43, Andrew Douglas Pitonyak > wrote: > > On 04/04/2014 07:44 PM, andrewH wrote: > >> > >> I am working with a data set that keeps causing my LibreOffice to > freeze. > >> I > >> am pretty sure that this is only because it is big. It is a > pipe-separated > >> text from the US Economic Census imported into Calc, about 30 columns > and > >> around a million rows. (The actual data set is bigger, but Calc quits > at a > >> million-odd. The complete file is about 0.8 gig.) I suspect but can not > >> prove that this is related to file handling somehow, e.g. breaking down > >> during auto-saving. The first time I saved the data as a Calc file it > took > >> nearly an hour with the "soffice.bin *32" process running at 25 percent > of > >> CPU time and using about 825 meg of memory the entire time. (Not sure > why > >> this is showing up as a 32-bit version). And when Calc freezes, all the > >> LibreOffice programs freeze. So I can't just switch to another file and > >> noodle away while waiting. > > > > > > It looks to me as though Calc cannot handle more than 1048576 rows of > data, > > > > Do you have more rows than that? If yes, then I think that you cannot > open > > the file. > > > > If you have less than that, and, if you think that you are simply running > > out of memory if you can figure out how to get the data to me, I can > run > > a test on a 64 bit version (running on Linux). My machine has 32 GB of > > RAM... > > > > > > -- > > Andrew Pitonyak > > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > > Info: http://www.pitonyak.org/oo.php > > > > > > > > -- > > 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 > > -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] LO text
>o Alternatively, if you simply want to disable these attempts by Writer to be helpful, go to Tools | AutoCorrect >Options... | Options and remove the tick from "Apply numbering - symbol: *". >I trust this helps Exactly, yes! That worked. Thanks to all for the good help. On Mon, Nov 18, 2013 at 12:34 PM, Brian Barker wrote: > At 09:02 18/11/2013 -0500, Helen Etters wrote: > >> I have five items that I want to number. LO insists upon giving me a >> number I don't want every time I hit "return" and it also insists upon >> indent in places I don't want. I backspace to remove the indent and it >> then won't let me have a return-line space. >> > > Are you happy with Writer's attempts at numbering the five items but are > merely having difficulty terminating the process? If so, when you see the > automatic "6." which is one too many, just press backspace *twice* to get > back to the normal structure. (Incidentally, you shouldn't think in terms > of a "return-line space": that's typewriter thinking. Instead, use > vertical spacing applied to the paragraph or the paragraph style.) > > How can I turn off all automatic formatting? >> > > You may indeed want to suppress Writer's automatic numbering and handle > everything yourself. There are two ways to do this, and it is useful to be > aware of both. > > o You can leave the automatic facility on but disable it locally when it > happens. The automatic formatting is applied when you press Enter to > terminate the first numbered paragraph. (It is a paragraph if it is > terminated by Enter, even if it is only one line.) Immediately you see the > change, go to Edit | Undo (or Ctrl+Z). This undoes the automatic effect > whilst leaving the paragraph break you wanted. > > o Alternatively, if you simply want to disable these attempts by Writer to > be helpful, go to Tools | AutoCorrect Options... | Options and remove the > tick from "Apply numbering - symbol: *". > > I trust this helps. > > Brian Barker > > > -- > 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 > > -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] LO text
Thank you, yes, I have never defined a style and felt discouraged to read that I can't just turn that feature off -- I don't know how to define a style that has no automatic formatting. On Mon, Nov 18, 2013 at 9:35 AM, Kracked_P_P---webmaster < webmas...@krackedpress.com> wrote: > On 11/18/2013 09:13 AM, Krunoslav Šebetić wrote: > >> On 11/18/2013 03:02 PM, Helen wrote: >> >>> L) frustration -- trying to write a letter for the national office of an >>> organization. I have five items that I want to number. LO insists upon >>> giving me a number I don't want every time I hit "return" and it also >>> insists upon indent in places I don't want. I backspace to remove the >>> indent and it then won't let me have a return-line space. How can I >>> turn >>> off all automatic formatting? >>> >>> >>> >>> Define two styles - one with numeration, other without. Make both look >> the same, except one has numeration, other don't. When you wont numbers - >> apply that style, when you don't apply that other style. You can make that >> style without numbers stars automatically after numbered on pressing return. >> >> Kruno >> >> > Maybe you should walk this poster through "design a style". > > I have been using LO since "day one" but never designed a style and really > never looked into it. > > > > -- > 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 > -- Helen Etters using Linux, suse12.3 -- 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] LO text
L) frustration -- trying to write a letter for the national office of an organization. I have five items that I want to number. LO insists upon giving me a number I don't want every time I hit "return" and it also insists upon indent in places I don't want. I backspace to remove the indent and it then won't let me have a return-line space. How can I turn off all automatic formatting? -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] random # in calc
Actually Brian's idea worked very well. But as I said in my Q, it's a rather trivial need. Usually, at Thanksgiving, we toss handwritten names on paper scraps into a real hat, and everyone draws a name. Some people have said they don't like to wait that late to do their shopping, so the virtual hat occurred to me. As I look at Brian's "IF" code, I understand what the script is doing, so I've learned something useful, and hope others on the list have as well. On Thu, Nov 14, 2013 at 10:49 AM, Tom Davies wrote: > Hi :) > Computers don't usually do "random" very well. > > Prolly better to wait until everyone is together (or at least enough > of you that no-one is going to feel the results were "fixed") and then > draw names from a hat. Print the names on slips of paper and then > make a big show of pulling out a name at random. A twist is for the > 1st winner to pick the 2nd name and then the 2nd winner picks the 3rd > slip. This twist further minimises accusations of it being "fixed". > > You might be able to buy a 20 sided dice from a games shop such as > "Games and Puzzles" (if they still exist) or find one in a box of > "Dungeons and Dragons" or "Runequest" or some-such. > Regards from > Tom :) > > > > > > > On 14 November 2013 09:05, Brian Barker wrote: > > At 10:17 11/11/2013 -0500, Helen Etters wrote: > >> > >> A LO calc question. It's a bit trivial, but I'm sure it can be done. > >> Names of about 20 people. Draw names for Christmas gifts. > > > > > > Have you wondered why you have got little in the way of replies? Er, > > perhaps "Draw names for Christmas gifts" is not a clear definition of a > > problem! You have three presents to give away and you just want pick > three > > names as gold, silver, and bronze winners - right? Oh, - or you want to > > divide the twenty into two groups, ten givers and ten receivers - right? > > No? > > > >> We can wait until we're all together in a couple of weeks, and that will > >> work, ... > > > > > > I'm finding it difficult to understand how the subjects' physical > presence > > will simplify your task. Are you going to give them random numbers on > > pieces of paper and ask them to do a dance to arrange themselves in > order by > > value? Is that called Musical Numbers? That's a sort of Christmas party > > I'm not familiar with. > > > >> ... but can we do this by running a random number generator in calc? > > > > > > Very probably. > > > > > >> Type 20 names into column one, then the same names again in column 2, > then > >> run a random number generator to match them up? > > > > > > Ah, so you are somehow matching twenty with the same twenty. What does > that > > hint to us about your actual needs? Hmm, let's see now. Perhaps you > want > > each of the twenty to give a gift to another of the twenty - and to > > randomise the results. Is that it? > > > > Well, if you randomise the order of one column, as you are perhaps > > suggesting, it is possible (quite likely?) that someone will be selected > to > > give their gift to themselves; is that OK? Perhaps not. Let's try to > avoid > > that and get everyone giving to someone else. But now we may have > another > > problem. In general, each person will give to and receive from different > > people, but it may happen that the same people are chosen both ways - so > > that one pair of individuals simply exchange presents both ways. Does > that > > matter? Do you see your problem needs more careful specification? > > > > > >> I did something similar to this about a year ago (for a church dinner) > but > >> for the life of me I just can't remember how I did it, and the > instructions > >> I get by googling don't work. (When I follow those instructions, the > >> function returns #NAME? in the cell.) > > > > > > It's not much help to know that unless you explain what the instructions > > were. > > > > There ought to be a neat way to do this, but I don't immediately see one. > > Try this slightly messy one: > > > > o Enter the names into column A. I'm assuming there are twenty. > > > > o Copy these into column B. (Don't retype or you may create > differences.) > > > > o In C1, enter =RAND() and fill this down column C. > > > > o In D1, enter =IF(A1=B1;"Themself!"
Re: [libreoffice-users] random # in calc
How very clever! Yes, this worked! I did get three "each other" responses and I will study the code and try to figure out how it works. Thank you so much! On Thu, Nov 14, 2013 at 4:05 AM, Brian Barker wrote: > At 10:17 11/11/2013 -0500, Helen Etters wrote: > >> A LO calc question. It's a bit trivial, but I'm sure it can be done. >> Names of about 20 people. Draw names for Christmas gifts. >> > > Have you wondered why you have got little in the way of replies? Er, > perhaps "Draw names for Christmas gifts" is not a clear definition of a > problem! You have three presents to give away and you just want pick three > names as gold, silver, and bronze winners - right? Oh, - or you want to > divide the twenty into two groups, ten givers and ten receivers - right? > No? > > We can wait until we're all together in a couple of weeks, and that will >> work, ... >> > > I'm finding it difficult to understand how the subjects' physical presence > will simplify your task. Are you going to give them random numbers on > pieces of paper and ask them to do a dance to arrange themselves in order > by value? Is that called Musical Numbers? That's a sort of Christmas > party I'm not familiar with. > > ... but can we do this by running a random number generator in calc? >> > > Very probably. > > Type 20 names into column one, then the same names again in column 2, >> then run a random number generator to match them up? >> > > Ah, so you are somehow matching twenty with the same twenty. What does > that hint to us about your actual needs? Hmm, let's see now. Perhaps you > want each of the twenty to give a gift to another of the twenty - and to > randomise the results. Is that it? > > Well, if you randomise the order of one column, as you are perhaps > suggesting, it is possible (quite likely?) that someone will be selected to > give their gift to themselves; is that OK? Perhaps not. Let's try to > avoid that and get everyone giving to someone else. But now we may have > another problem. In general, each person will give to and receive from > different people, but it may happen that the same people are chosen both > ways - so that one pair of individuals simply exchange presents both ways. > Does that matter? Do you see your problem needs more careful > specification? > > I did something similar to this about a year ago (for a church dinner) >> but for the life of me I just can't remember how I did it, and the >> instructions I get by googling don't work. (When I follow those >> instructions, the function returns #NAME? in the cell.) >> > > It's not much help to know that unless you explain what the instructions > were. > > There ought to be a neat way to do this, but I don't immediately see one. > Try this slightly messy one: > > o Enter the names into column A. I'm assuming there are twenty. > > o Copy these into column B. (Don't retype or you may create differences.) > > o In C1, enter =RAND() and fill this down column C. > > o In D1, enter =IF(A1=B1;"Themself!";IF(VLOOKUP(B1;A$1:B$20;2;0)=A1;"Each > other!";"")) and fill this down column D. > > o Select the data in columns B and C, i.e. the range B1 to C20. > > o Go to Data | Sort... . For "Sort by", select "Column C". (It doesn't > matter whether you choose Ascending or Descending.) > > o Click OK. > > o The names in column B have now been randomised, but you will probably > find that column D shows either some people selected to give to themself or > some selected to give to each other. If so, go to Data | Sort... | OK > repeatedly until column D is blank and shows no problems. Each time you > sort, the random numbers are recalculated and the order in column B > changes. For twenty names, you may need a few sorts to clear errors but > you should get there fairly quickly. > > o Print columns A and B. (Set a print range for convenience.) > > If you need too many sorts to achieve a result, lose some friends. > > I trust this helps. > > Brian Barker > > > -- > 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 > > -- Helen Etters using Linux, suse12.3 -- 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] random # in calc
A LO calc question. It's a bit trivial, but I'm sure it can be done. Names of about 20 people. Draw names for Christmas gifts. We can wait until we're all together in a couple of weeks, and that will work, but can we do this by running a random number generator in calc? Type 20 names into column one, then the same names again in column 2, then run a random number generator to match them up? I did something similar to this about a year ago (for a church dinner) but for the life of me I just can't remember how I did it, and the instructions I get by googling don't work. (When I follow those instructions, the function returns #NAME? in the cell.) Thanks for any pointers, -- Helen using Linux, suse12.3 -- 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
Re: [libreoffice-users] .odt to .rtf ?
On Fri, Jul 12, 2013 at 9:59 PM, Helen wrote: > thank you -- Two things here. > 1). I did manage to get this into rtf by using the commandodt2rtf > Waves_edited.odt > and I did this on a number of files. So, the urgency of the problem is > solved, or at least > is no longer urgent, but the theoretical issue is still interesting (to > me). > 2). Since this is a literary journal, albeit a small local one, and the > original works are not mine, > I don't fee free to upload any of the plays/poems/etc. > Someone else mentioned that LO has the "save as" rtf. I don't understand > why, but here's > another puzzle: we have two computers running suse 12.3. This one that > I'm using right now > has that "save as" option. The other computer does not, and the other > computer is the one with > the files on it. Of course I could move the files from that computer to > this one, but I didn't realize > that this one had that option until someone here (Tim?) suggested it, so > I went to the other compter > (this one) and looked. Both machines are running suse 12.3 with LO > Version 3.6:build-304 > so I have no idea why one shows .rtf option and the other does not. > Thanks for the responses. > > > > > On Thu, Jul 11, 2013 at 10:48 PM, Tom Davies wrote: > >> Hi :) >> Could you email me the doc and an odt version? I might be able to have a >> look on a few different machines tomorrow and maybe see what's up. Hmm, it >> might be better to use Nabble to upload it so everyone can see it as i >> might forget or run out of time, or just not wake up until the day after! >> I am curious tho. >> Regards from >> Tom :) >> >> >> -- >> *From:* Helen >> *To:* users@global.libreoffice.org >> *Sent:* Friday, 12 July 2013, 2:18 >> *Subject:* [libreoffice-users] .odt to .rtf ? >> >> I agreed to edit (one time only) a local literary magazine comeing out >> soon. >> I have saved each of the documents (plays, poetry, etc.) and edited in >> LibreOffice. >> Before sending the files to the publisher, I've been saving them to .doc. >> The publisher emails to say that all the documents have weird formatting >> and >> strange characters. He wants to know if I can send the files to him in >> .rft (rich text) format. I don't see that as an option in the "save as" >> menu. >> Is there a way I can do this -- convert the .odt files to .rtf? Using >> LibreOffice >> on Suse Linux. >> >> >> Thanks all, >> >> >> -- >> Helen Etters >> using Linux, suse12.3 >> >> -- >> 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 >> >> >> > > > -- > Helen Etters > using Linux, suse12.3 > -- Helen Etters using Linux, suse12.3 -- 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] .odt to .rtf ?
I agreed to edit (one time only) a local literary magazine comeing out soon. I have saved each of the documents (plays, poetry, etc.) and edited in LibreOffice. Before sending the files to the publisher, I've been saving them to .doc. The publisher emails to say that all the documents have weird formatting and strange characters. He wants to know if I can send the files to him in .rft (rich text) format. I don't see that as an option in the "save as" menu. Is there a way I can do this -- convert the .odt files to .rtf? Using LibreOffice on Suse Linux. Thanks all, -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] Re: styles for plays?
Stuart, Fred, Brian, Steve -- thank you for great ideas. I've learned a lot of useful things that I'll make notes on here. Thanks! On Wed, Jun 26, 2013 at 12:05 PM, V Stuart Foote wrote: > Helen, > > Interesting issue. The manual centering is simply multiple tabs ,\t, or > multiple characters. Replace the multiple occurrences with > nothing > to remove it and bring all text to left margin. Get all the formatting > removed so you are left with just the text. > > The key to your effort is to remove the direct styling from the text, and > apply document wide styling to paragraphs. Choose from existing styles, > or > create new style sto apply against paragraphs, fonts, pages of each play as > you'd like. > > If you are comfortable extracting the XML text component--content.xml-- > from > the .odt container you can flush it through the stream editor--sed. Or > gawk, or perl, or python, etc. to make editing corrections (removing white > space and joining actor to their lines with a colon). Then return the > edited > content.xml back to the .odt container, and then apply consistent styles > from LibreOffice. > > However, working within Writer--you can accomplish much of the text clean > up > using the find-replace GUI widget. Open the + other options panel, and > select the regular expression checkbox. > > LibreOffice regular expressions are described here: > https://help.libreoffice.org/Common/List_of_Regular_Expressions > > with a bit more detailed instruction here (panels are a bit different > between LibreOffice and OpenOffice): > > http://wiki.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer > > The other approach, would be to open the document and copy all contents out > to a text file, then edit that with sed, gawk, perl or python--and insert > the now consistent text into a new LibreOffice document and then apply > styles to the text. > > Stuart > > > > > > > > -- > View this message in context: > http://nabble.documentfoundation.org/styles-for-plays-tp4063106p4063138.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 > > -- Helen Etters using Linux, suse12.3 -- 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] styles for plays?
I've volunteered to edit a one-time publication of a collection of plays. The plays came to me in different styles -- three of the plays came to me with all the characters's speaking lines centered -- the characters's names centered a line above. Some of the writers seem to have centered the names with a centering code -- I can highlight the name and use the "left margin" code to move the name to left margin. Others seem to have centered by spacing over! (yes) and I have to backspace until I get the name to the left margin. None used a colon after the speaker, and the publisher wants it. I've made some progress with Search & Replace -- Search for all incidents of TOM and replace with TOM colon space. But the most tedious part is moving TOM from center to left and bring his speaking lines up to begin on the same line. Is there any way I can put these plays into a style sheet and save this work, or would creating the style sheet take as long as what I'm doing? I've never used styles. And this is a one-time job so if I have to do it all by hand, at least it's only once. Thanks for any advice, -- Helen Etters using Linux, suse12.3 -- 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
Re: [libreoffice-users] Re: colour printing bug in Writer?
Yes, I have Epson 1400 printer, and I have to do that each time as well. It's a bug. On Mon, May 13, 2013 at 1:09 AM, Marc Paré wrote: > Le 11/05/13 04:17 PM, Steve Edmonds a écrit : > >> >> On 2013-05-12 07:18, Marc Paré wrote: >> >>> Le 05/05/13 07:04 PM, Steve Edmonds a écrit : >>> >>> Do you see controls for Landscape? What does it do if you choose it >>>>> >>>> It is some dicky issue with the Brother driver and LO on Linux. I have >>>> seen some discussion and it is just as easy to print to PDF and print >>>> that. >>>> >>>> >>> Actually, I also have a Brother printer and the same fix is to choose >>> the correct device drive with through LibreOffice. >>> >>> Print->Properties->Device and choose PostScript Level 3. This fixes >>> the problem. >>> >>> Cheers, >>> >>> Marc >>> >> Thanks. It does too. But I can't set this permanently. The settings in >> spadmin won't stick. >> Steve >> >> >> > Yes, Tim and I are not sure if this is a problem with LibreOffice or with > our systems. The device sticks until you exit out of LibreOffice. If you > open LibreOffice again, you have to change the device again. I wonder if > anyone else has this problem where the device defaults to the wrong one and > you have to manually change it each time you open a fresh version of > LibreOffice. > > Cheers, > > Marc > > -- > Marc Paré > m...@marcpare.com > http://www.parEntreprise.com > parEntreprise.com Supports OpenDocument Formats (ODF) > parEntreprise.com Supports http://www.LibreOffice.org > > > -- > To unsubscribe e-mail to: > users+unsubscribe@global.**libreoffice.org > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- Helen Etters using Linux, suse11.4 -- 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
Re: [libreoffice-users] a calc - ods - Q
Solved - thanks! I can accomplish what I need with the ctrl+enter Thanks all! On Sat, Jan 26, 2013 at 12:33 PM, Johnny Rosenberg wrote: > 2013/1/26 Helen : > > In a spreadsheet, is there a way to lock two rows together, so that when > the > > spreadsheet is shuffled or otherwise modified, the two locked rows will > stay > > together? > > Probably not, but as a workaround you could type multiple lines in one > cell. Use Ctrl+↵ for line separator. > > > Johnny Rosenberg > > > > > > Helen using Linux, open suse 12.1 > > > > -- > > 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 > > > -- Helen Etters using Linux, suse11.4 -- 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] a calc - ods - Q
In a spreadsheet, is there a way to lock two rows together, so that when the spreadsheet is shuffled or otherwise modified, the two locked rows will stay together? Helen using Linux, open suse 12.1 -- 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
Re: [libreoffice-users] New brothers printer does not appear to print Landscape.
I had the same problem, and here's the fix: In OO or LO, in the print dialogue, there is a "properties" button, and from there, Device tab. One of the dropdowns there is "Language". It defaults to PDF If you instead select "Postscript (Level from driver)" then landscape printing works. It's a bug in OO and LO, and can be "fixed" for each individual printing job. Unfortunately, I haven't learned a way to make the fix permanent. Helen On Thu, Jun 21, 2012 at 9:53 PM, Steve Edmonds wrote: > > > On 2012-06-22 12:07, Thomas Taylor wrote: > >> On Fri, 22 Jun 2012 08:48:13 +1200 >> Steve Edmonds> >> wrote about Re: [libreoffice-users] New >> brothers printer does not appear to print Landscape.: >> >>> I have to print to pdf and then print the PDF to get around this on my >>> Brother, >>> printing is ok on my HP. Must be something to do with the brother driver >>> because >>> Firefox won't print in landscaqpe either. steve >>> >>> >>> On 2012-06-22 00:55, upscope wrote: >>> >>>> LibreOffice 3.5.3.2 >>>> Build ID: 350m1(Build:2) >>>> >>>> Has printer administration been removed or the name changed in version >>>> 3.5.3? >>>> >>>> KDE applications print good with CUPS and LPR. >>>> >>>> >>>> >>>> Russ >>>> openSUSE 12.1(3.1.10-1.9-desktop x86_64)|KDE Platform Version >>>> 4.8.3 (4.8.3) "release 504"|Intel core2duo 2.5 MHZ,|8GB >>>> DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-**295.53) >>>> >>>> Printing from FF has been a known problem for some time. >> >> Tom >> >> FF prints landscape on my HP, not the Brother. > steve > > > -- > For unsubscribe instructions e-mail to: users+help@global.libreoffice.** > org > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > -- Helen Etters using Linux, suse11.4 -- 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
Re: [libreoffice-users] Open Office and Libre Office Questions...
I've also been wondering how I can go back to OpenOffice, wondering whether I should uninstall LibreOffice first. I've had trouble with LibreOffice refusing to print in landscape mode. I googled and learned that it's a known issue -- at least a few people have reported this. I've tried everything I know (not much) to fix it, but, although Print Preview looks fine, anything printed in landscape mode is distorted. So I'm thinking of getting rid of Libre Office and re-installing Open Office. I'm not a sophisticated user and not even sure I know how to do this correctly. On Thu, Apr 19, 2012 at 10:56 AM, John Bijnens wrote: > Hi, > > I thought after the fork of LibreOffice Oracle gave the source code of > OpenOffice to the Apache Foundation. > IBM donated the source code of their OpenOffice fork called Lotus Symphony > also to the Apache Foundation. > If I've read everything correctly the Apache Foundation has a special policy > called the Incubation this is a period of time during which amongst lots of > other things the new project is kept under quarantine for patent issues and > to see whether the project is viable. > I thought this period of time is practically over and a new release of > OpenOffice can be expected during the second half of this year. > > I have OpenOffice installed on my laptop and I have LibreOffice as a > portable app on an external hard drive in case I need it. > I prefer OpenOffice because, although it lacks some features available in > LibreOffice which I don't use that often, it is much stabler and thus more > of use in a production environment. Of course this is my personal > impression, things can be different for someone else. > > Best regards, > > John Bijnens > > > On 19/04/2012 16:18, webmaster-Kracked_P_P wrote: >> >> >> I really do not think having LO and AOO on the same computer works >> properly for most users. LO is well beyond what AOO is at, and LO people >> have cleaned out so much of the old/bad/outdated code that it would be a >> real catch-up act for AOO to give you the same features and such that LO >> have given us since mid-3.3.x line. I use 3.4.6, but will got to 3.5.x when >> it get some of its issues fixed that are specific for my needs. >> >> Yes, you can have LO and AOO installed on the same computer. >> No, you cannot run both at the same time. >> No, it is not something that works well for most users. >> >> Yes, it is your choice to try. >> >> On 04/19/2012 08:49 AM, Caesar wrote: >>> >>> On Thu, 19 Apr 2012 14:34:39 +0200, "R.S." >>> wrote Re Re: [libreoffice-users] Open >>> Office and Libre Office Questions...: >>> >>>> Il 19/04/2012 6.03, Jerry Greenberg ha scritto: >>>>> >>>>> Is it possible to have both Libre Office and Open Office installed at >>>>> the same time on the same computer? >>>>> >>>>> Are there going to be any new updates for Open Office. I read that >>>>> since Oracle took over they have not been very keen on supporting Open >>>>> Office. >>>>> >>>> Hi, although it colud be possible, the installation program registers on >>>> the registry the same associations. If you have encountered crashes with >>>> Libreoffice 3.5.2.2 try using version 3.4.6. >>>> I prefer using Libreoffice because it is more efficient and it has a lot >>>> of functions that are not included in OpenOffice. >>> >>> You can probably avoid any such conflicts by using a "portable" >>> version of LO from here: >>> >>> http://portableapps.com/news/2012-04-16_-_libreoffice_portable_3.5.2_released >>> >>> for more info, see this: >>> http://portableapps.com/support/libreoffice_portable >>> >> >> > > > -- > 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 > -- Helen Etters using Linux, suse11.4 -- 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
