Re: [libreoffice-users] 2 things: Base and captcha
On Wed, 27 Nov 2013 15:38:29 -0500 "Bob Muir" wrote: > 1. > I am new to the field of data base and to LibreBase. > I need to get help (ask questions), but I do not find it easy to do via your > websites. I went to http://ask.libreoffice.org/en/account/signin/?next=/en/ > and try to sign in, but get “Sorry, we don't have this email address in the > database” > > I thought that I had joined the community and I am now receiving email, but I > cannot sign in to "ask" a question. > > When I try, I get the response that my email address in not recognized. > > I really want to ask a question about Base. > > 2. > When I tried to send the above message at > http://ask.libreoffice.org/en/feedback/, I couldn’t get past the “captcha” > thing. > > I have no idea what I am supposed to do with the “(Please solve the captcha)” > thing! Add, subtract, divide, substring, parse,...? > > What am I supposed to do with the two series of numerals? Can't help with #1. #2, the "captcha" thing, is a method of foiling machine generated responses. The captha is shown in a distorted font which computers have trouble deciphering. Just determine what the letters or numbers are and enter them in the box that says "enter text here". No calculations are required. Tom, list moderator -- It is curious that physical courage should be so common in the world, and moral courage so rare. - Mark Twain ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. Tom Taylor - retired penguin - KG7CFC AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 13.1_RC2-x86_64 KDE 4.11.12, FF 24.0, claws-mail 3.9.2 registered linux user 263467 -- 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] How to reduce installation size?
At 19:19 27/11/2013 +, Tom Davies wrote: 350Mb is about the size of a Cd. Ask for a refund: it's faulty. 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
Re: [libreoffice-users] Re: A feature, or ...?
At 17:45 27/11/2013 -0800, Peter West wrote:
It's a bug, or, if you prefer, a missing vital feature.
It's a feature - and I don't think it's missing, in fact.
The problem: If you have a document filled with paragraph formatting
which has been applied directly using a paragraph style menu, any
styles you define and apply as a style will be overridden by the
direct formatting previously applied. There is no way that I have
found to remove it, except by a manual change using the paragraph
style menu. That fixes my problem, but passes the same problem on
to the next person who wants to change the paragraph styling.
I fear that paragraph is somewhat confused. There is direct
character formatting, character style formatting, paragraph
formatting, and paragraph style formatting - all different. To
confuse things further, you can apply character formatting or
character style formatting to an entire paragraph. If you really do
solve your problem using a new paragraph style (and I'm not clear why
you would call this a "manual change"), I think you have left your
document in an ideal state for later modification by yourself or others.
How to fix it: Add Format menu items "Clear all
paragraph/character(/list?) formatting." It doesn't actually remove
all formatting, but applies a default format which clear all the
problem formats and allows a style to be cleanly applied.
You don't need to clear any style formatting, as any modifications to
these styles or replacements by other styles will simply supersede
existing effects. What can be a problem is any local ("direct")
character formatting which may have been applied - perhaps even
(confusingly) to complete paragraphs. (This is the way that a
beginner will format his or her documents.) But no-one needs to add
any menu items: what you need is already there, at Format | Default
Formatting (or right-click | Default Formatting or Ctrl+M). If you
invoke this and then apply your new styles, everything should be hunky-dory.
List formatting is such a delicate matter that I don't know whether
a clear all list formatting operation would cause more trouble than it's worth.
Any proper list formatting (applied using styles) should survive the
application of Default Formatting, which is what you would want.
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
Re: [libreoffice-users] Re: A feature, or ...?
Interesting... yours is the only post I've seen so far. On 11/27/2013 08:29 PM, pbw wrote: I don't know, because there were elements whose particular formatting I needed. But I know that that sequence on individual paragraphs does not work, for the reasons explained by others in earlier posts in this discussion. Peter West ...he saw a poor widow put in two copper coins. On 28 Nov 2013, at 2:07 pm, A [via Document Foundation Mail Archive] wrote: Would "Select All" (CTRL-A), Menu->Format->Clear Direct Formatting (CTRL-M) not work for you? On 11/27/2013 05:45 PM, pbw wrote: It's a bug, or, if you prefer, a missing vital feature. The problem: If you have a document filled with paragraph formatting which has been applied directly using a paragraph style menu, any styles you define and apply as a style will be overridden by the direct formatting previously applied. There is no way that I have found to remove it, except by a manual change using the paragraph style menu. That fixes my problem, but passes the same problem on to the next person who wants to change the paragraph styling. I have just had to do this. The document was an imported Word .doc, but the principle seems to apply everywhere. How to fix it: Add Format menu items "Clear all paragraph/character(/list?) formatting." It doesn't actually remove all formatting, but applies a default format which clear all the problem formats and allows a style to be cleanly applied. List formatting is such a delicate matter that I don't know whether a clear all list formatting operation would cause more trouble than it's worth. -- View this message in context: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [hidden email] 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085305.html To unsubscribe from A feature, or ...?, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085306.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: A feature, or ...?
I don't know, because there were elements whose particular formatting I needed. But I know that that sequence on individual paragraphs does not work, for the reasons explained by others in earlier posts in this discussion. Peter West ...he saw a poor widow put in two copper coins. On 28 Nov 2013, at 2:07 pm, A [via Document Foundation Mail Archive] wrote: > Would "Select All" (CTRL-A), Menu->Format->Clear Direct Formatting > (CTRL-M) not work for you? > > On 11/27/2013 05:45 PM, pbw wrote: > > > It's a bug, or, if you prefer, a missing vital feature. > > > > The problem: > > > > If you have a document filled with paragraph formatting which has been > > applied directly using a paragraph style menu, any styles you define and > > apply as a style will be overridden by the direct formatting previously > > applied. There is no way that I have found to remove it, except by a > > manual > > change using the paragraph style menu. That fixes my problem, but passes > > the same problem on to the next person who wants to change the paragraph > > styling. > > > > I have just had to do this. The document was an imported Word .doc, but > > the > > principle seems to apply everywhere. > > > > How to fix it: > > Add Format menu items "Clear all paragraph/character(/list?) formatting." > > It > > doesn't actually remove all formatting, but applies a default format which > > clear all the problem formats and allows a style to be cleanly applied. > > > > List formatting is such a delicate matter that I don't know whether a clear > > all list formatting operation would cause more trouble than it's worth. > > > > > > > > > > > > -- > > View this message in context: > > http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html > > Sent from the Users mailing list archive at Nabble.com. > > > > > -- > To unsubscribe e-mail to: [hidden email] > 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 > > > > If you reply to this email, your message will be added to the discussion > below: > http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085305.html > To unsubscribe from A feature, or ...?, click here. > NAML -- View this message in context: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085306.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
Re: [libreoffice-users] Re: A feature, or ...?
Would "Select All" (CTRL-A), Menu->Format->Clear Direct Formatting (CTRL-M) not work for you? On 11/27/2013 05:45 PM, pbw wrote: It's a bug, or, if you prefer, a missing vital feature. The problem: If you have a document filled with paragraph formatting which has been applied directly using a paragraph style menu, any styles you define and apply as a style will be overridden by the direct formatting previously applied. There is no way that I have found to remove it, except by a manual change using the paragraph style menu. That fixes my problem, but passes the same problem on to the next person who wants to change the paragraph styling. I have just had to do this. The document was an imported Word .doc, but the principle seems to apply everywhere. How to fix it: Add Format menu items "Clear all paragraph/character(/list?) formatting." It doesn't actually remove all formatting, but applies a default format which clear all the problem formats and allows a style to be cleanly applied. List formatting is such a delicate matter that I don't know whether a clear all list formatting operation would cause more trouble than it's worth. -- View this message in context: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.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: A feature, or ...?
It's a bug, or, if you prefer, a missing vital feature. The problem: If you have a document filled with paragraph formatting which has been applied directly using a paragraph style menu, any styles you define and apply as a style will be overridden by the direct formatting previously applied. There is no way that I have found to remove it, except by a manual change using the paragraph style menu. That fixes my problem, but passes the same problem on to the next person who wants to change the paragraph styling. I have just had to do this. The document was an imported Word .doc, but the principle seems to apply everywhere. How to fix it: Add Format menu items "Clear all paragraph/character(/list?) formatting." It doesn't actually remove all formatting, but applies a default format which clear all the problem formats and allows a style to be cleanly applied. List formatting is such a delicate matter that I don't know whether a clear all list formatting operation would cause more trouble than it's worth. -- View this message in context: http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.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
Re: [libreoffice-users] How to reduce installation size?
Hi, Kracked_P_P: Thanks for your suggestion, I will try it. I do have a very limited drive space. I use a 4GB CF card to install a Debian, and now I have only 500-600MB leave for install Libreoffice and other use. So I want reduce the size of Libreoffice as small as possible. Regards, Minshein0330 2013/11/27 Kracked_P_P---webmaster > On 11/26/2013 08:59 PM, minhsien0330 wrote: > >> Dear all: >> The full size of Libreoffice 4.1.3 (Linux version) is more than 400 MB, >> but >> I want to limit it to 350-370MB or less. >> Do you know how to do it? >> What files or directories should I delete? >> >> Regards, >> Minhsien0330 >> >> > > Reduce the number of extensions, galleries, templates, etc., to start. > You might need to do this by "removing" the associated ".deb" or ".rpm" > files in the installs. But you need to be careful not to remove needed > items. Remove any language pack that you do not need. Remove any other > item that ends up in the extension manager list that you do not need. The > "locked" ones can be "removed" by not installing them. Do not install the > help pack. Do a full purge of LO and then do the install so there are not > any files that are carried over from the previous versions. Delete LO's > old config files before the new version. > > The real question I have is why do you want or need to limit LO's install > size? > > Do you have a limited drive space? > > I have installed packages on Windows that take up 1 or 2 GIG for the > install space, so 400+/- is not bad for an office suite. > > > > -- > 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
Re: [libreoffice-users] Question
I've had troubles in the past finding specific financial functions, as well. Can't help from the function standpoint in this case, but you could always fall back on the actual equation: FV = PV*(1+i)^n where FV is future value, PV is present value, i is the periodic interest rate, and n is the number of periods. Dave On 11/27/2013 15:10, Cliff Scott wrote: I haven't done much spread sheet formula work so please don't mind a couple of simple questions. I would like to do two things: 1. Calculate compound interest on an amount given the rate and number of interest periods. Looking at the list of functions there are lots of ones that come close to that, but I wasn't able to find one that would do exact that. 2. How do I write a conditional loop in Calc? If I want to calculate a formula for 10 iterations how would I do that? For instance Value=Value*N+Value. That would give me the compound interest also. I can do it with a bunch of cells strung out each one representing one interest period, but for any length of time it becomes unwieldy. Thank you very much for any help. Cliff -- 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] Question
I haven't done much spread sheet formula work so please don't mind a couple of simple questions. I would like to do two things: 1. Calculate compound interest on an amount given the rate and number of interest periods. Looking at the list of functions there are lots of ones that come close to that, but I wasn't able to find one that would do exact that. 2. How do I write a conditional loop in Calc? If I want to calculate a formula for 10 iterations how would I do that? For instance Value=Value*N+Value. That would give me the compound interest also. I can do it with a bunch of cells strung out each one representing one interest period, but for any length of time it becomes unwieldy. Thank you very much for any help. Cliff -- 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: 2 things: Base and captcha
Le 27/11/13 21:38, Bob Muir a écrit : Hi Bob, > 1. > I am new to the field of data base and to LibreBase. > I need to get help (ask questions), but I do not find it easy to do via your > websites. > I went to http://ask.libreoffice.org/en/account/signin/?next=/en/ and try to > sign in, but get > “Sorry, we don't have this email address in the database” > > I thought that I had joined the community and I am now receiving email, but I > cannot sign in to "ask" a question. The signup to the ask.libreoffice forum and the mailing lists are not the same, I think. Why not just ask your Base question here on the mailing list instead ? Alex -- 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] 2 things: Base and captcha
1. I am new to the field of data base and to LibreBase. I need to get help (ask questions), but I do not find it easy to do via your websites. I went to http://ask.libreoffice.org/en/account/signin/?next=/en/ and try to sign in, but get “Sorry, we don't have this email address in the database” I thought that I had joined the community and I am now receiving email, but I cannot sign in to "ask" a question. When I try, I get the response that my email address in not recognized. I really want to ask a question about Base. 2. When I tried to send the above message at http://ask.libreoffice.org/en/feedback/, I couldn’t get past the “captcha” thing. I have no idea what I am supposed to do with the “(Please solve the captcha)” thing! Add, subtract, divide, substring, parse,...? What am I supposed to do with the two series of numerals? -- 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] How to reduce installation size?
2013/11/27 Tom Davies > Hi :) > 350Mb is about the size of a Cd. > > While most such projects try to bundle a few different programs > together onto a Dvd there is something to be said for trimming it down > to fit on Cd. > > Herm, I might be mistaken, but a CD usually have a capacity ranging from 650MB to 900MB... This doesn't change the OP requirement, but I suppose it's more than just the limitation of a CD here :) -- 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] How to reduce installation size?
Hi :) 350Mb is about the size of a Cd. While most such projects try to bundle a few different programs together onto a Dvd there is something to be said for trimming it down to fit on Cd. Regards from Tom :) On 27 November 2013 15:55, Kracked_P_P---webmaster wrote: > On 11/26/2013 08:59 PM, minhsien0330 wrote: >> >> Dear all: >> The full size of Libreoffice 4.1.3 (Linux version) is more than 400 MB, >> but >> I want to limit it to 350-370MB or less. >> Do you know how to do it? >> What files or directories should I delete? >> >> Regards, >> Minhsien0330 >> > > > Reduce the number of extensions, galleries, templates, etc., to start. You > might need to do this by "removing" the associated ".deb" or ".rpm" files in > the installs. But you need to be careful not to remove needed items. > Remove any language pack that you do not need. Remove any other item that > ends up in the extension manager list that you do not need. The "locked" > ones can be "removed" by not installing them. Do not install the help pack. > Do a full purge of LO and then do the install so there are not any files > that are carried over from the previous versions. Delete LO's old config > files before the new version. > > The real question I have is why do you want or need to limit LO's install > size? > > Do you have a limited drive space? > > I have installed packages on Windows that take up 1 or 2 GIG for the install > space, so 400+/- is not bad for an office suite. > > > > > -- > 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
Re: [libreoffice-users] Using the TOC/Index function.
Hi :) At a guess Scribus probably have their own forum/mailing-list and you might get better answers from them. Are you creating the document in Writer first and then opening it with Scribus later on? Did the Scribus document start as a fresh document within Scribus and using their native format or did it start out in another program such as Word? I found that of the few documents i have trouble with in Writer if i start a fresh new document and then copy&paste in the old contents using "Paste as unformatted text" then almost all troubles i've had with the document vanish. A couple of times i've done that within LibreOffice. Going from the 1st branch, 3.3.x, to 3.4.x or either of those to a 4.x.x it seems to help to go through that process again. The 3.3.x seemed very unripe, but all later ones have drastically reduced the occasional need for that sort of faffing around. So with a different program i would advise creating a fresh document in that program and then try to bring in elements with as little formatting as possible. Ideally go back to original images rather than moving them from one document to the next. That seems to raise the quality from 80-90% up to around 99% on those rare documents that seem grumpy about weird things. Regards from Tom :) On 27 November 2013 07:58, Ian Whitfield wrote: > Hi all > > I've been looking for a way to index my monthly Journal I edit in Scribus. > > I have managed to get the Scribus function working, (after a battle), but > two problems remain. > > 1) In all my Paragraph Styles the 'Fill Character' is greyed-out!! > How do I activate this? > > 2) The created Index is in page order and not Alphabetical order. > Can this be changed? > > [My Scribus version is 1.4.3 on PClinuxOS 2013.08] > > Thanks for any help. > > IanW > Pretoria RSA > -- > > -- > 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: Base; Setting up relations between tables
Le 27/11/13 15:24, Scott Castaline a écrit : Hi Scott, > What am I not doing? I'm thinking of changing one other field this way > and was doing this one to figure out doing it. From your description, it sounds like you have not set the correct bound field in the properties of your Combobox on your main form. Enter Design mode for your main form, and then select the control you want to edit, or if you have both a control and associated label, enter the group first (right mouse button click on the control in question > Edit/Enter group). From here, you need to make sure that your box is bound to the right data source in the Data tab, and the correct field, or alternatively, make the population of that field dependent on a SQL statement that basically just says "SELECT * FROM fieldusedtopopulateform". Save the form, leave edit mode and see if it now works. Alex -- 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] How to reduce installation size?
On 11/26/2013 08:59 PM, minhsien0330 wrote: Dear all: The full size of Libreoffice 4.1.3 (Linux version) is more than 400 MB, but I want to limit it to 350-370MB or less. Do you know how to do it? What files or directories should I delete? Regards, Minhsien0330 Reduce the number of extensions, galleries, templates, etc., to start. You might need to do this by "removing" the associated ".deb" or ".rpm" files in the installs. But you need to be careful not to remove needed items. Remove any language pack that you do not need. Remove any other item that ends up in the extension manager list that you do not need. The "locked" ones can be "removed" by not installing them. Do not install the help pack. Do a full purge of LO and then do the install so there are not any files that are carried over from the previous versions. Delete LO's old config files before the new version. The real question I have is why do you want or need to limit LO's install size? Do you have a limited drive space? I have installed packages on Windows that take up 1 or 2 GIG for the install space, so 400+/- is not bad for an office suite. -- 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: Base; Setting up relations between tables
On 11/17/2013 04:53 AM, Alexander Thurgood wrote: Le 17/11/13 06:32, Scott Castaline a écrit : Hi Scott, So how would I do that in the graphical tool? I can't seem to get it to work. I vaguely remember working with foreign keys and the sql statement would refer to AlbumID from the parent as Album.AlbumID for both tables. Wouldn't I also need the ID from the Album table as well? Maybe I'm just better of using SQL Statements, but I don't see where I can do that. The GUI does not seem to be able to do what I am trying to do or I have forgotten more than I thought. If you want to use SQL DDL through LO's UI, Options > SQL (or Tools> SQL on the Mac) from the main menu is your friend, although the feedback is minimal (i.e. you get a message that the statement has executed correctly or not). Other than that, if you are trying to set it up so that your Album.AlbumID is referenced in the Track.AlbumID, then the way it should work in the GUI is via Tools > Relations in the LO Base file main window, adding the tables you want to join, setting the relation as 1-to-n by dragging the field AlbumID field from your Album table to your corresponding Track.AlbumID field in the Album table and then setting the UPDATE/CASCADE/DELTE options as appropriate. If this doesn't work after saving the database, then that would probably be a bug. Alex Thanks for the info Jay & Alex. I later went and recreated the db inputting SQL myself and it worked. I then repeated it using the GUI and found my error. I would create the relation by click and drag between tables. Then for some reason I was clicking on the toolbar icon for creating a new relation instead of right clicking on the line to edit the one already created. So I was actually creating duplicate relations. It's working now. I found that I do recall quite a bit of SQL as I also duplicated the full db in SQLite using just SQL, just lack the programming skills to create the UI, and entering the info by SQL statements for each record is a real PITA. I do have one more question though. I decided to add another table that would allow me to select existing data from this table to fill in a field in the main table. I created the new table with 2 fields. First field is an integer that is auto entered (essentially record count) and the second field is a text field. I then added a field in the main table that provides the link to this new table. In the form I changed the field type from Text Box to Combo Box (originally used List Box, but it didn't work). When I change to entry mode and enter a new record, when I get to this field and I click on the Drop Arrow a blank box is displayed. I am able to manually enter the correct data myself. I do have the new table populated with data. What am I not doing? I'm thinking of changing one other field this way and was doing this one to figure out doing it. Scott C. -- 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] How to find a text consisting of line break/ paragraph break marks [Writer]?
W dniu 2013-11-26 18:51, Brian Barker pisze: At 16:42 26/11/2013 +0100, Gordom Noname wrote: I can't figure out how to write a regex to find all text in between certain words. The problem I have is related to line break marks. These two words belong to different paragraphs and therefore the text I'm looking for consists of numerous line break or paragraph break marks. Let say the text, I'm looking for, follows abc123 and goes before xyz. Of course I can temporally replace all line break marks with some other character and use a regex like this one for example: abc123.+xyz. It works but I would like to find a straight way to do it. There's no need to replace the line breaks: just search for abc123(.|\n)+xyz instead. This finds one or more of either any character or a line break bracketed by your sentinel strings. > But no: I don't see any simple way to match an expression across a paragraph break. That's a pity :(. Regards, gordom -- 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] How to find a text consisting of line break/ paragraph break marks [Writer]?
I thought it would be much easier. Writing a macro is not worth the effort in my case. I'm not going to use it very often. I think I will stick to regex and delete temporally all line brake marks to make a text one single and continuous paragraph for a moment. It requires few more operations on regex but is still easier and faster way then writing a macro. Thank you very much for your help. Regards, gordom W dniu 2013-11-26 17:35, Kracked_P_P---webmaster pisze: You know that you need to go to Find/Replace and choose "more options" to get to the regular expressions, correct? Now the problem you have is something that is more of a macro and not a find/replace with "regex". You have to find the first word and then mark that text placement. Then find the second word and mark that text placement. At that point you need to highlight all the text between those text placements. My question is . . . Are you going to do this many times or only once or twice? If you so not need to do this ofter, I would use the Find option and write down the line/column/etc. of the word. Then I would search for the second word. At that point I would go back to the first word's position and highlight al the text till I get to the position of the second word. I see no way to do something like this outside of a macro and I do not know macros so I could not tell you how to do this. I might be able to write a Pyhton script to do the work, but that would not be something you would do inside Writer. On 11/26/2013 10:42 AM, gordom wrote: Hallo everyone. I can't figure out how to write a regex to find all text in between certain words. The problem I have is related to line break marks. These two words belong to different paragraphs and therefore the text I'm looking for consists of numerous line break or paragraph break marks. Here you have a sample of the text: Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam convallis nisi lorem, sit amet sagittis tortor interdum a. abc123Integer facilisis nisl ut est commodo varius. Integer luctus massa in ultrices scelerisque. Pellentesque scelerisque velit ullamcorper libero tempor dapibus a nec risus. Pellentesque vehicula, erat id mollis tempus, lorem lacus congue dolor, id interdum est diam ac felis.xyz Nunc a tincidunt massa, vitae placerat urna. Suspendisse potenti. Let say the text, I'm looking for, follows abc123 and goes before xyz. Of course I can temporally replace all line break marks with some other character and use a regex like this one for example: abc123.+xyz. It works but I would like to find a straight way to do it. Any help will be appreciated. Best regards, gordom -- 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] Using the TOC/Index function.
Hi all I've been looking for a way to index my monthly Journal I edit in Scribus. I have managed to get the Scribus function working, (after a battle), but two problems remain. 1) In all my Paragraph Styles the 'Fill Character' is greyed-out!! How do I activate this? 2) The created Index is in page order and not Alphabetical order. Can this be changed? [My Scribus version is 1.4.3 on PClinuxOS 2013.08] Thanks for any help. IanW Pretoria RSA -- -- 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
