Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?
Here we go again. There is top-posting, which is, in general, a good thing, and is preferred by most email users, including the technically inclined, like myself. Its primary advantage is that it is a great courtesy to the readers of email threads, who can quickly assess a contribution to the thread for relevance to them. A secondary advantage for the poster is that it increases the likelihood that the new material will actually be read, or at least skimmed. There is in-line posting, which is necessary when you need to reply to specific points in a previous post. You can put your comments into the immediate context to which they apply. This is also a good thing, if the circumstances require it. Then there is bottom-posting. It's a kind of virus that contaminates, primarily, open-source mailing lists. When a poster is infected he (yes, overwhelmingly, he) is overcome with the urge to tell people what to do. He is filled with a (completely spurious) sense of righteousness. He is a rebel, he is liberated, he carries the banner of freedom (free as in speech) against the grinding capitalist forces of oppression and regimentation. Therefore, you MUST DO AS YOU ARE TOLD. And so the champions of freedom become tuppenny Trotskys, low-rent Lenins, and we can say a quiet prayer of thanks that their influence extends no farther than the occasional mailing-list. How do I know? I've been there. I am now afflicted by a complementary virus. I am equally righteous and insufferable. I know, I know. But my desire is to see all of this nonsense fade away into an easy-going environment of live and let live. Bakunin before Lenin, and classical small-l liberalism before either. Peter West And he said to them, Do you not yet understand? On 23 Feb 2014, at 7:41 am, Tanstaafl tansta...@libertytrek.org wrote: On 2014-02-22 4:28 PM, Johnny Rosenberg gurus.knu...@gmail.com wrote: I'm subscribed to a few groups myself, maybe I confused this one with the Apache OpenOffice one, but most of them seems to prefer everything but top posting. Personally I prefer this way, I'm not sure what to call it, but I'm doing it right now… It is called bottom or in-line posting, and is preferred by the more technically inclined. It is primarily Outlook users who prefer blind top-posting (ie, quoting the entire message they are replying to and adding their comment at the top). Most people who are rabidly anti bottom/inline posting will go out of their way to complain about how bad bottom posting is, and will invariably use BLIND bottom posting - quoting the ENTIRE message ABOVE your comment, which is admittedly way WORSE than blind top-posting - as examples of why bottom/inline posting is bad. They almost always simply refuse to even acknowledge the difference between BLIND bottom posting, and inline posting (quoting only the relevant portion, and putting your responses/comments AFTER the relevant quoted text, which is much cleaner and easier to read than even top-posting, mainly because you can clearly see the full context). -- 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] Neat Writer Feature -- Relative Font Sizes
TeX (and LaTeX) is one of those things I was always gunna learn to use. More power to you. -- Peter West What comes out of a man is what defiles him. On 14/02/2014 8:55 am, e-letter wrote: OK, fair enough but as a latex user, was amazed to read a claim that LO provides greater control! :) -- 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] Truce
What do you do with these guys? They can't help themselves. Libre? Ha. On 6/02/2014 9:06 pm, e-letter wrote: On 06/02/2014, Peter West li...@pbw.id.au wrote: When I see someone hinting, suggesting, urging or just plain bullying a top-poster to reform his or her bad habits, I'll buy in. And of course, you can do the same thing if the shoe is on the other foot. At least we have an admission: it's a poor habit. Can we just let posters do their own thing? Let's drive however we like; rules are un-necessary! ;) -- Peter West For what does it profit a man if he gains the whole world and loses or forfeits himself? -- 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: low traffic lately?
On 6/02/2014 5:31 am, Robert Holtzman wrote: On Wed, Feb 05, 2014 at 01:37:52PM +, Tom Davies wrote: Bottom posting requires a ton of extra work such as trimming and such which office workers really do not have time for. Trimming is a sensible thing to do, whichever way you post. It's work for the poster, not the reader, and top-posting is a benefit for the reader, not (primarily) the poster. . I really hope you don't mean that trimming is a waste of time. Ever see a reply to a digest message that quoted the whole digest. What fun. But doesn't trimming undermine the argument? How can the discussion be read sequentially when bits of it have been deleted? -- Peter West For what does it profit a man if he gains the whole world and loses or forfeits himself? -- 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] Truce
I'll never proselytise for top posting if you never proselytise for bottom-posting. When I see someone hinting, suggesting, urging or just plain bullying a top-poster to reform his or her bad habits, I'll buy in. And of course, you can do the same thing if the shoe is on the other foot. Can we just let posters do their own thing? -- Peter West For what does it profit a man if he gains the whole world and loses or forfeits himself? -- 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: low traffic lately?
Why is, do you think, that people feel the need to apologise on this very list for bottom-posting? Because of my ad-hominem attacks? It must be, because all the bottom-posters on this list are angels of forbearance, while all the top-posters are repeatedly admonishing bottom-posters to please, please, top-post. Fellas, look in the mirror. On 4/02/2014 5:36 pm, pete nikolic wrote: On Tue, 04 Feb 2014 05:33:24 + Brian Barker b.m.bar...@btinternet.com wrote: At 09:58 04/02/2014 +1000, Peter West wrote: It mystifies me that some ossers become tossers on this particular topic, ... Whatever value your argument might have had, you destroy it by being abusive and using an ad hominem argument, of course. It is thus surprising that you should choose to do this. Brian Barker +1 P -- Peter West ...and a sword will pierce through your own soul also... -- 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] diff of 2 docx files
If you write the files out as .fodt (Flat XML) files from within LO, you will have straight XML files to compare. Beyond that, you could get the tika-app.jar from the Apache Tika project, which will let you extract plain text from the .fodt files and directly from the .odt files. On 4/02/2014 6:36 pm, berenger.mo...@neutralite.org wrote: Hello. Is it possible to have a diff between 2 .docx files in libreoffice? Or with any other tool, I do not really mind... I am not fond of office suites, but at my work they sent me an outdated document describing what I have to do, and when I asked about some details ( or errors, in fact ) in it, they sent me a different ( but still with errors... ) version of the same document. With a simple text file, I could have made a diff ( lot of tools for that ) but I have no idea about how to do it with docx files. I have obviously tried to unzip them, and use diff and meld on resulting files, but those files are so messy, that I thought that, maybe, they are encrypted of whatever! Now that I think about it, I could do a diff of files made through a copy/paste of the text... but that would be quite dirty. Thanks for any suggestions. PS: I did not registered to this list, so please add me in CC. -- Peter West ...and a sword will pierce through your own soul also... -- 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: Removing Index Markers from Writer: a How-To
Hi Frank, This script works on OS X, to the extent that does the conversions and creates new filtered odt files. The only questions are whether it works in Linux, and whether the filter does the right thing with the index markers. I haven't created any files with such index-markers, so maybe you can run it against your files to see how it goes. http://pbw.id.au/src/sh/strip-odt-index-markers It's a shell script, using soffice and perl. On 29/01/2014 11:23 pm, CVAlkan wrote: Peter: I mentioned sed and grep, but don't see any reason why perl couldn't be used as well. If you test this and it works, please post back to give others another option. BUT: my sed command only removed the markers from the fodt. As I mentioned I was unable to convert the odt to an fodt (essentially uncompressing the odt to readable xml) using the unzip capability of my OS (as I'm pretty sure could be done with earlier open office documents). Since LO can easily write and read fodt files, though, it really wasn't necessary to do any file format conversion, and I didn't bother spending the time to figure out how to do everything in one shot. Frank -- Peter West ...and a sword will pierce through your own soul also... -- 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: low traffic lately?
This sent to me off-list. No further comment required. On 5/02/2014 12:24 am, Anthony Baldwin wrote: On 2/4/2014 2:59 AM, Peter West wrote: Why is, do you think, that people feel the need to apologise on this very list for bottom-posting? Because of my ad-hominem attacks? It must be, because all the bottom-posters on this list are angels of forbearance, while all the top-posters are repeatedly admonishing bottom-posters to please, please, top-post. Fellas, look in the mirror. I will never apologize for proper behavior on mailing lists. I don't waste time correcting those who top-post. As Mark Twain said, Never try to teach a pig to whistle; it wastes your time and annoys the pig. Tony -- Peter West ...and a sword will pierce through your own soul also... -- 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] diff of 2 docx files
On 4/02/2014 8:08 pm, Peter West wrote: If you write the files out as .fodt (Flat XML) files from within LO, you will have straight XML files to compare. Beyond that, you could get the tika-app.jar from the Apache Tika project, which will let you extract plain text from the .fodt files and directly from the .odt files. Make that .docx files. On 4/02/2014 6:36 pm, berenger.mo...@neutralite.org wrote: Hello. Is it possible to have a diff between 2 .docx files in libreoffice? Or with any other tool, I do not really mind... I am not fond of office suites, but at my work they sent me an outdated document describing what I have to do, and when I asked about some details ( or errors, in fact ) in it, they sent me a different ( but still with errors... ) version of the same document. With a simple text file, I could have made a diff ( lot of tools for that ) but I have no idea about how to do it with docx files. I have obviously tried to unzip them, and use diff and meld on resulting files, but those files are so messy, that I thought that, maybe, they are encrypted of whatever! Now that I think about it, I could do a diff of files made through a copy/paste of the text... but that would be quite dirty. Thanks for any suggestions. PS: I did not registered to this list, so please add me in CC. -- 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: Removing Index Markers from Writer: a How-To
D'uh! Thanks Frank. I've updated the script with that change. Attachments aren't accepted by this list, are they? What did you mean by post the shell script? Peter Peter West ...and a sword will pierce through your own soul also... On 5/02/2014 1:54 am, CVAlkan wrote: Peter: The actual perl command should be changed slightly to: perl -pi'orig_*' -e 's/text:alphabetical-index-mark text:string-value=[[:alpha:]]*\///g' Index_Experiment.fodt After [[:alpha:]]* the \/ needs to be added to remove the / ending of the XML tag - otherwise it seems to work fine. The full blown shell script you sent me (I don't see it here on the forum for some reason) needs to be modified in the same way of course. I used [A-Za-z] instead of the [:alpha:] that you used because some systems don't respect that substitution syntax (I can't remember what it's called), which limits things just a bit, but a comment might be added to take care of that - the [:alpha:] syntax, again, is probably a little easier to understand for those not familiar with grep, sed and their relatives. You should post the shell script, as it is probably easier to use (?) for some folks than my simple sed command, since it takes care of hand-holding, locating the right directories and so forth. Of course, I hope some of the LibreOffice developers will incorporate the option and capability to remove old markers when an index is regenerated, and fix the generator so that it doesn't add additional markers to the same word when updating takes place. (It doesn't always do that, but I haven't figured out the exact conditions when it does). So - good work. -- View this message in context: http://nabble.documentfoundation.org/Removing-Index-Markers-from-Writer-a-How-To-tp4094327p4095465.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: low traffic lately?
Every now and then ossers (open source people) get a bee in their bonnet about something. Top-posting is one of those somethings. The most popular email clients default to top-posting. There's a reason for that. On a list, if you are interested in a particular topic, you will have been following along as it developed, generally pretty quickly. You know what the context is, and you just want to see what the latest contributor is saying. If you need to check the context, you scroll down. So top-posting satisfies the vast majority of use cases, and bottom-posting is a pain in the vast majority. Easy. It mystifies me that some ossers become tossers on this particular topic, and start to denigrate perfectly sensible users for doing the simple an sensible thing and top-posting. On 4/02/2014 2:30 am, Tom Davies wrote: Hi :) re: top vs bottom posting Many people using this mailing list are likely to be unfamiliar with various notions that are in common usage on other mailing lists. Hopefully this mailing list responds to people in ways they are familiar with but at the same time prepares them for other possibilities. Many office workers have no idea that bottom posting sometimes happens until after they have been (possibly) rudely told off on some other mailing list. On this list people use all 3 methods so that new users become aware that top-posters are often responding to something that was bottom posted. So we do it gently. Oddly it seems that most other mailing lists for LibreOffice seem to use top-posting almost exclusively whereas many other Open Source projects bottom-post. LibreOffice is one of the gateway projects into the world of Open Source so it makes sense to guide people gently. -- Peter West ...and a sword will pierce through your own soul also... -- 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: Removing Index Markers from Writer: a How-To
Hi Frank, Finally got back to this. Can you check this for me against an .fodt file, please? perl -pi'orig_*' -e 's/text:alphabetical-index-mark text:string-value=[[:alpha:]]*//g' On 29/01/2014 11:23 pm, CVAlkan wrote: Peter: I mentioned sed and grep, but don't see any reason why perl couldn't be used as well. If you test this and it works, please post back to give others another option. BUT: my sed command only removed the markers from the fodt. As I mentioned I was unable to convert the odt to an fodt (essentially uncompressing the odt to readable xml) using the unzip capability of my OS (as I'm pretty sure could be done with earlier open office documents). Since LO can easily write and read fodt files, though, it really wasn't necessary to do any file format conversion, and I didn't bother spending the time to figure out how to do everything in one shot. Frank -- View this message in context: http://nabble.documentfoundation.org/Removing-Index-Markers-from-Writer-a-How-To-tp4094327p4094482.html Sent from the Users mailing list archive at Nabble.com. -- Peter West ...and a sword will pierce through your own soul also... -- 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: Removing Index Markers from Writer: a How-To
The file name goes at the end of the command, of course. On 4/02/2014 3:44 pm, Peter West wrote: Hi Frank, Finally got back to this. Can you check this for me against an .fodt file, please? perl -pi'orig_*' -e 's/text:alphabetical-index-mark text:string-value=[[:alpha:]]*//g' -- Peter West ...and a sword will pierce through your own soul also... -- 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] Where is the documentation for soffice command line execution?
Thanks folks. soffice --help did the trick. On 29/01/2014 11:03 am, Peter West wrote: There are plenty of snippets on the web about using soffice command line for document conversion, for example, but I cannot find documentation. Looking for 'soffice' in the LO help file yields no results. Anyone have any idea? -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
[libreoffice-users] A word of warning about PDF text
A word of warning about text retrieved from PDF documents. Recovering text blocks from PDFs is inherently risky. PDF is a page definition format, and so it has no notion of the semantics of the text it contains. It places bits of text at certain positions on the page. You can create a whole page of text by taking the individual characters and their attributes and position on the page, shuffling them, and writing them to the file. That will produce a readable file, but try extracting the text from that file. Unless you have a very, very smart text extractor that reverse-engineers the process of creating the page, then calculates the _visual_ order of the text elements, you will end up with gibberish. _Most_ pdf text, _most_ of the time, is laid on the page in visual order, but in even the best-behaved files, you are likely to be surprised. If you don't _know_ that your PDF text extractor program is completely visually accurate by design, don't tell your boss that you can easily extract that PDF text, without allowing time for proof-reading every page. You will get burned. I don't know how LO extracts PDF text; perhaps it is very sophisticated. I have my doubts. -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
Re: [libreoffice-users] Writer - Merging PDFs
Another way to manipulate PDFs is with PDFBox. https://pdfbox.apache.org/index.html If you're on a Mac, you can just use Preview. However, these things are not designed to modify the layout of pages. PDF is a page definition format; it defines the layout of pages. There are only very limited changes you can make. Changing layouts means going back to sources and re-creating the PDFs. On 29/01/2014 2:32 pm, Anthony Baldwin wrote: On 01/28/2014 09:50 PM, Don Myers wrote: Hi Charles, I'm not aware of any way to merge multiple pdf files using LO. The only way I know to merge pdf files with with pdftk. http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ Works great. tony There are others on the list more knowledgeable than I, so maybe it can be done. There is a free, open source program that I've used to merge multiple PDF files into one file called PDFsam. It is available for Linux, Windows, and Mac. In Ubuntu there is an older version in the software center. That is what I've used. It has always worked well. Don On 01/28/2014 08:41 PM, charles meyer wrote: I've got 3 or so separate PDF files. I'd like to merge them all into one PDF file in Writer in Office 3.6.2.2 Each page of each PDF file has a lot of empty space around the graphic image. Ex. 2 inches above and below the graphic on each page and a good 3 inches on each side of each graphic is white, empty space. Is there a way to eliminate all the empty space around each graphic in in each page in each PDF or once all the PDFs are merged into one larger PDF? Thanks so much, Charles. -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
Re: [libreoffice-users] Writer - Merging PDFs
It's a bit fiddly. You need to experiment a bit, because there are certain quirks in the process, and I don't remember them all off the top of my head. For example, you may find that you can only insert a page in front of an existing page, in which case, you will have to work from the last document, backwards. I'll assume here that you can insert after an existing page. Copy the first document you want to merge, and open it in Preview. Open the thumbnails sidebar. Now open the next document, and open its thumbnails panel. The safest but slowest way to do this is to select one page at a time from the thumbnails of the second document, and drag that thumbnail into the thumbnail panel of the first document. Save your resulting document. You have to be careful with the positioning of the inserted page, because you can end up with multiple documents within the target pdf. You might be Ok with that. This outcome seems to be more likely when you select multiple pages from the source document. Try it out. Make sure that, as you complete the merge of one document, you make a separate copy of the merged result, so that if things subsequently go wrong, you don't have to start from the beginning. Let me know how you go. On 30/01/2014 2:28 am, Cliff Scott wrote: ** Reply to message from Peter West li...@pbw.id.au on Wed, 29 Jan 2014 23:04:39 +1000 Peter, Could you explain off list how to do it with Preview? I've looked it over and there is no obvious way I can see to do it. Thanks. Cliff Another way to manipulate PDFs is with PDFBox. https://pdfbox.apache.org/index.html If you're on a Mac, you can just use Preview. -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
Re: [libreoffice-users] Re: low traffic lately?
I've just switched to Thunderbird from Apple Mail, and the Reply List button is very handy indeed. There is a minority of lists that exhibit the same behaviour as this one with replies. The fact that it is a minority makes it all the more likely that I will send replies to the wrong address - the OP. P.S. Apple has had ongoing problems with Mail in Mavericks, and I suspect they have decided to phone home about everyone you add to the address list of an email. Using Contacts groups became painfully slow. On 29/01/2014 9:59 am, Dave Liesse wrote: Virgil, I don't think it's just the list. The mail client must have something to do with it, as well; I use Thunderbird and have a Reply List option on this list, while on some others I do and some I don't. Dave -- Peter West ...for whoever exalts himself will be humbled, and whoever humbles himself will be exalted . -- 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] Where is the documentation for soffice command line execution?
There are plenty of snippets on the web about using soffice command line for document conversion, for example, but I cannot find documentation. Looking for 'soffice' in the LO help file yields no results. Anyone have any idea? -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
Re: [libreoffice-users] Removing Index Markers from Writer: a How-To
I've asked a question on this list about soffice, and this topic is the reason I was asking. Let's say we can use the command line to 1) convert an .odt to an .fodt file, and 2) to convert it back again. If so, I can write a script that uses soffice to do 1) as above perl -e # perform the text substitutions 2) as above to re-establish the modified .odt file. Peter West Other seed fell among thorns, and the thorns grew up and choked it... On 29/01/2014 1:45 am, CVAlkan wrote: In previous posts, I described how Writer adds extra index markers when updating an Alphabetical Index. One side effect of this behavior is that, even if an item is later removed from the concordance file, the marker remains in the text, and therefore in the index. So, here's how to remove all of the index markers from a Writer document so you can start with a clean slate. To do this, you will need to be running LibreOffice on some flavor of Linux/Unix, or at least on a system that has a command line or some text editor with sed or grep capabilities. 1: Make a backup of your Writer document. You know the consequences if something goes amiss. 2: Open the document in Writer, and choose Save As OpenDocument Text (Flat XML) (fodt) This creates an uncompressed XML version of the document. On my system (Ubuntu), I was unable to decompress the odt version, as the OS complained it was malformed, but using the native capability is always a better idea. 3: Close the document and exit Writer. 4: Open a command line shell, preferably in the directory containing the fodt file. 5: Run the following command (all one line - broken apart here for clarity): sed 's/text:alphabetical-index-mark text:string-value=\([A-Za-z]*\)\///g' Old_File_Name_and_Path.fodt New_File_Name_and_Path.fodt Depending on the file size and processor speed, this may take a bit. If this gives errors, you're on your own. 6: Close the command line shell. 7: Open the new cleansed fodt file with Writer. 8: The file should look the same but without any alphabetical index markers. (Your index formatting is still there, though) 9: Go to where your alphabetical index is located, right click on it and select Update Index/Table A: All of the index entries should disappear; if any remain, go find them on the referenced pages and manually delete them. Apparently, some of the indexes are embedded in others and aren't found by the sed command above. I didn't bother to try figuring out how or why that happened. I had several hundred markers, of which only five weren't removed. B: Now, go back to the index and select Edit Index/Table, then File | Open. C: Select the original concordance file (assuming you have it set up how you want it), and let Writer go do its thing. D: You now have a clean document with no duplicate index entries. E: LOOK AT IT CAREFULLY, of course, before replacing your original. The document I tried this on was over four hundred pages with lots of tables, graphics and so forth, and I found no problems, but it's up to you to determine if everything is ok. I hope this helps any others who might be using alphabetic indexes. -- View this message in context: http://nabble.documentfoundation.org/Removing-Index-Markers-from-Writer-a-How-To-tp4094327.html Sent from the Users mailing list archive at Nabble.com. -- Peter West Other seed fell among thorns, and the thorns grew up and choked 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
Re: [libreoffice-users] malfunzione
Thanks Brad, I follow that, but that doesn't seem to be what the OP was saying. Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. On 25 Jan 2014, at 9:53 pm, Brad Rogers b...@fineby.me.uk wrote: On Sat, 25 Jan 2014 09:27:33 +1000 Peter West li...@pbw.id.au wrote: Hello Peter, I can't see what you mean about having to squeeze an extra row (column?) onto the page. You have the same number of columsn whether you start at 31 or 1. Consider a 31 day month starting on Friday. It will end up looking like this; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 31 Note that this takes six rows for the dates, but if the 31 is added at the top row, you only need five rows; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 31 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 This increases the space available to users to write info, appointments etc. in each day, assuming each row is expanded slightly to fill the page. Admittedly, this might be of limited usefulness for a spreadsheet, but if the data gets printed to a sheet of paper, the extra space for each day's box often proves useful. It seems to me that the OP was worried about the layout unnecessarily, as the sheet's design must have taken the date ordering into account for performing any calculations. Of course, given that the original post was in a language I don't read, I may have missed some of the subtleties of that post as a result of working only from Tom's translation. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent If you ain't sticking your knives in me, you will be eventually Monsoon - Robbie Williams -- 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] malfunzione
On 25 Jan 2014, at 3:52 am, Brad Rogers b...@fineby.me.uk wrote: On Fri, 24 Jan 2014 16:14:31 + Tom Davies tomc...@gmail.com wrote: Hello Tom, the last day of the month, eg. for January 2014 I find the following list: 31 1 2 3 .. 30 in Annex I send the doc. how can I fix the problem? I see calendars done like that all the time; It saves having to squeeze an extra row onto a single sheet, or adding a sheet for just one day. In short, I don't see it as a problem at all. Brad, I can't see what you mean about having to squeeze an extra row (column?) onto the page. You have the same number of columsn whether you start at 31 or 1. Is Guglielmo saying that the Excel sheet starts at 1? Or is he just asking how to move the column? Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to copy a frame with its text and sub-frame contents?
I'm creating a flyer to be printed on an A4 sheet, which will then be cut in half, so I want identical contents on the top and bottom halves of the page. I have created the top in one of two frames that I have placed on the page. The frame contains a background image, text, and a sub-frame. Having created one half, I now want to copy the lot, and place it in the second frame. How? Peter West Those who are well have no need of a physician, but those who are sick... -- 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 copy a frame with its text and sub-frame contents?
Ok. I had two problems. 1) I somehow got two copies of the file open simultaneously. When I tried to select the frame for copying, copy was not an option. Once I sorted that out, 2) when I selected what I thought was the main frame (and, indeed, I had), when I tried to paste into the second frame, I saw offset copies of the two subframes, but nothing of the main frame with its background images and its text. I finally discovered that I had copied everything, but that the main frame had been copied in place, right over the top of the original, while the subframes had been offset. When I selected again, back over the main frame, and moved the selection, my copy moved. Even better, when I dropped the dragged copy in the new frame, the sub-frame were magically restored to their correct relative positions in the main frame. Using 4.2.0.2 on OS X 10.9.1 (Mavericks) Peter West Those who are well have no need of a physician, but those who are sick... On 22 Jan 2014, at 10:39 pm, Peter West li...@pbw.id.au wrote: I'm creating a flyer to be printed on an A4 sheet, which will then be cut in half, so I want identical contents on the top and bottom halves of the page. I have created the top in one of two frames that I have placed on the page. The frame contains a background image, text, and a sub-frame. Having created one half, I now want to copy the lot, and place it in the second frame. How? Peter West Those who are well have no need of a physician, but those who are sick... -- 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] Re: having 2525 defined colors to choose from within LO
For example, apropos an earlier discussion on this list, see http://www.numbertext.org/logo/librelogo.pdf p52 Color names. In 25 basic colours three duplicates: aqua+cyan, fuchsia+magenta and gray+grey. Peter West Those who are well have no need of a physician, but those who are sick... On 20 Jan 2014, at 9:26 am, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: Printed it out Will update it soon. As I stated before, there may be duplicates. I took several lists and converted them outside the main file and then added them. Sometimes certain colors in a color sequence should be kept, even if it is a repeat. But I will look at each case. On 01/19/2014 12:15 PM, Tom Davies wrote: Hi :) Good bit of proof-reading there! I can't believe how quickly this has come together. For years i have been wondering why the colour selection was so pitiful. I've been using quite a long work-around or just putting up with it. Regards from Tom :) On 19 January 2014 17:09, Luuk luu...@gmail.com wrote: On 19-01-2014 16:54, Kracked_P_P---webmaster wrote: For those who have been looking at my color postings, I have been adding colors to the standard.soc file so there are many more defined colors to choose from withing Writer, Calc, etc., for things like font color and shading, or cell backgrounds. I took the original file and added the LO branding colors, and decided to go from there. With the help from a fellow user, added some colors to that list from some I had and some he had. I added gray and 99 different shades of it - i.e. 1% to 99%. At that point, I still wanted more. I found colors like Gold, Silver, Bronze, Brass, etc. and added them in. Then I added the colors from a set of color tables where they took one color and kept lightening it up 6 times, for a total of 7 color blocks. There were 7 colors per table making each one 77 colors. This added 462 colors to the color blocks you see. So now, I have 2525 color blocks, if my count is correct. For Ubuntu users, you have to look into the hidden dot folders to find the standard.soc file. .config/libreoffice/4/user/config where it is on other systems, I do not know. I have not added it to my Windows systems, yet, but will find the file later. So here is the download file link. It should work fine, but I am still new at using the ownCloud system. https://owncloud.documentfoundation.org/Common/QA/New-Colors/standard.soc--jan-19--10_26am---2525-color-blocks.txt Total colors in that file : 2525 Total unique colors in that file: 2366 The following colors are named more than two times: (color # is found 6 times, color #80 is found 4 times, etc) # color 6 00 4 80 3 0066cc 3 008080 3 00 3 33 3 66 4 800080 3 808000 3 99 3 b3b3b3 3 c0c0c0 3 cc 3 ff 3 ff00ff 3 ff4500 4 ff9966 5 66 3 ff -- 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 -- 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] mail format
On 19 Jan 2014, at 6:12 am, Doug dmcgarr...@optonline.net wrote: (As an editor of a small (~1000 circulation) newsletter, it is important to me to use standards which are available and in common use by those with Windows PCs, Apple computers with either of two quite different operating systems, and Linux--the latter probably only by me!) --doug So your requirement is, quite literally, read-only. What's wrong with PDF? Peter West Those who are well have no need of a physician, but those who are sick... -- 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] mail format
PDF is great for printing - that's what it was designed for. Commercial printers love PDF. But it sounds as though your publisher is also editing layout. If there is anything like that happening, forget PDF. Open submissions will always be a can of worms. But at least (he said with fingers crossed) you don't have round-tripping issues, with files going back and forward between different systems, accumulating edits as they go. Peter West Those who are well have no need of a physician, but those who are sick... On 19 Jan 2014, at 11:25 am, doug dmcgarr...@optonline.net wrote: On 01/18/2014 06:32 PM, Peter West wrote: On 19 Jan 2014, at 6:12 am, Doug dmcgarr...@optonline.net wrote: (As an editor of a small (~1000 circulation) newsletter, it is important to me to use standards which are available and in common use by those with Windows PCs, Apple computers with either of two quite different operating systems, and Linux--the latter probably only by me!) --doug So your requirement is, quite literally, read-only. What's wrong with PDF? Peter West Well, not quite: I forward my edited files to the publisher, who happens to own a Mac with the old Mac Os, so it's not just read, it's also write. I'm sure he could read pdfs, but his Publisher program likes .doc files. And I have heard that not all pdfs are created equal. There have been reports of some problems, depending on what program generated them. OTOH, some of the sources are from fairly unsophisticated people, to whom pdf is probably less familiar than stp (a motor lubricant). Some of that input comes from .doc files, some from email (!) And some of it is kinda tricky, no matter what extension it may have. I have used Libre, TextMaker, and WordPerfect (under Windows) and even Kate to decode some submissions. (There is a tendency for blocks of text in some submitted files to be displaced to the right hand side of the page, such that the right ends of lines are not available. I have never found out why this happens. One of the programs mentioned will usually make the file readable and editable.) --doug -- Blessed are the peacemakers...for they shall be shot at from both sides. --A. M. Greeley -- 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] Re: Connection to SQL database
Peter West So his fame spread throughout all Syria... On 18 Jan 2014, at 4:19 am, Carl Paulsen carlpaul...@comcast.net wrote: Basically, I'm at a huge disadvantage b/c I don't understand ANY of the terms or tools. I'm watching a ton of videos and reading a ton of material. But being someone who has done a lot of teaching/tutoring, I have to say no one out there seems to know how to assume a user knows nothing but is still capable of learning. Too much is assumed in all the materials I find. Carl, this is an endemic problem in _all_ software documentation. I don't know whether it's worse in this area than others, but it is in any case horribly difficult to remember what it is like not to know anything. We don't observe the steps by which we come to know something; we are too busy struggling to understand. -- 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] mail format
Hi Doug, I think the best solution to your problem is to buy a copy of Microsoft Office. Peter West So his fame spread throughout all Syria... On 18 Jan 2014, at 7:49 am, Doug dmcgarr...@optonline.net wrote: On 01/17/2014 04:00 PM, Tom Davies wrote: Hi :) Yes there is but it's not advisable. Its better to keep your originals in ODF and only File - Save As ... when you really need to. Otherwise formatting and things can go a bit wrong. MS Office 2013 can read ODF. As James said it's Tools - Options - Load/Save - General but at the bottom see the 2 drop-downs? Roll the 2nd one up 1 or 2 places, avoiding the Templates option. Then go back to the first and change to a different one of the types of documents, eg down to spreadsheets and then to presentations etc. Regards from Tom :) On 17 January 2014 20:51, James Knott james.kn...@rogers.com wrote: Doug wrote: Is there a way to make Libre save in MS Word 1997-2003 .doc format as a default? If so, how? Using version 4.1. Thanx--doug Yes, click on ToolsOptionsLoad/SaveGeneral and make your selection there. Thanx for the advice, Tom, but MS 1997-2003 .doc is readable by EVERYBODY, even people who don't have MS Office 2013. I don't care if I ever see .odf again! --doug -- 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] mail format
Doug, About that standard: http://msdn.microsoft.com/en-us/library/dd946767(v=office.12).aspx How much longer do you think that a lowest common denominator format (97) will be generally used? Anyway, for the time being it's working, and you have your solution. Peter West Those who are well have no need of a physician, but those who are sick... On 18 Jan 2014, at 4:15 pm, Doug dmcgarr...@optonline.net wrote: On 01/17/2014 09:25 PM, Peter West wrote: Hi Doug, I think the best solution to your problem is to buy a copy of Microsoft Office. Peter West So his fame spread throughout all Syria... /snip/ I do not like Microsoft Office. I think it is a PITA, and I have thought so since I was using WordStar! But a standard is a standard, and whether you like it or not, the old 1997 .doc format is that standard, as nearly as there is one. LIve with it! --doug On 18 Jan 2014, at 7:49 am, Doug dmcgarr...@optonline.net wrote: Doug wrote: Is there a way to make Libre save in MS Word 1997-2003 .doc format as a default? If so, how? Using version 4.1. Thanx--doug Yes, click on ToolsOptionsLoad/SaveGeneral and make your selection there. /snip/ Thanx for the advice, Tom, but MS 1997-2003 .doc is readable by EVERYBODY, even people who don't have MS Office 2013. I don't care if I ever see .odf again! --doug -- 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
Fwd: [libreoffice-users] Connection to SQL database
Carl, You can export csv directly from MySql. For example: http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format If you need modified data, it seems to me that the best way to do that is to 1) work out the changes you need to the existing data 2) create a new table or tables in MySql that reflect the changes, selecting data from the originals CREATE TABLESELECT.; 3) use UPDATE to perfom any necessary modifications to the original data 4) export the table(s) as csv files. There is plenty of help out there for MySql users. Peter West So his fame spread throughout all Syria... Begin forwarded message: From: Carl Paulsen carlpaul...@comcast.net Subject: Re: [libreoffice-users] Re: Connection to SQL database Date: 16 January 2014 11:45:01 pm AEST To: users@global.libreoffice.org users@global.libreoffice.org Reply-To: cpaul...@alumni.middlebury.edu Tom, Let me clarify what I need to do. I need the raw data to move to a new relational database. I'm not planning on having them work directly on spreadsheets. The data will go into Salesforce, but I don't know how to get the raw SQL data into Salesforce with the changes I need to make to it before the move without exporting it. I may have confused the discussion but not explaining my exact needs, but that's because I (wrongly) tend to think I can do almost everything, and only ask for help for specific issues I think I'm facing. There may well be other ways to do this, but I was focused on what I thought was the only way. So...what I need is to remove the data from the current database (apparently what I have is the best we can get), manipulate it so that certain fields meet the requirements of the new database, then move it into the new database. The only way I am aware of to get the data into the new (Salesforce) database is in CSV files. Field mapping is done via the first row of data (I need the field names), and I also need to figure out what fields contain what data for the mapping process. My goal was to use Base as a tool to extract the data, or perhaps even accomplish the manipulations I need to do in prep for the move to Salesforce. I thought I might be able to open or link to the data file I have through Base and export it. That's because I haven't really understood how to use SQL. I then realized I'd probably first need to open or host the SQL data through MySQL or another variant of that. Trouble is, I don't know how to do that. Alex gave some specific suggestions which I will try today. Honestly, though, I don't understand what MySQL does. Does it open the data file, interpret the commands in it, and then allow the user to manipulate and/or display the data correctly (with the correct relational links)? And is that the only - or best - way to access the data with Base? Can I just use MySQL to generate CSV files (or some other format that Calc can open) for each of the tables in the file? At this point, I'm not yet sure I have MySQL running properly, because it ain't like any packaged software I've used in the past (and it's been a LONG time since I've done and command-line work - like since the mid to late 1980s). Or maybe there's an option I haven't thought of to manipulate and move the data into Salesforce. At this point I'm all ears. If I need MySQL for this, can someone either point out a forum where I could get help with it or offer to coach me (off list if need be) through the process of opening the data and extracting it or connecting to Base? OK, thanks, and sorry for the tome. Carl On 1/16/14 5:41 AM, Tom Davies wrote: Hi :) Hmmm, actually i've only just realised that a 2nd grab from the 'proprietary' back-end data-tables might not be such a nightmare. Just keep a copy of the current export as it is so that the new grab can be compared against it. Any differences could then be added to the data-tables held fairly locally. Hopefully it's unlikely that different updates would happen to a single old field both here and there! Anyway, i guess my main question is could Base be used as the front-end for data tables (the back-end) that is online? Regards from Tom :) On 16 January 2014 10:32, Tom Davies tomc...@gmail.com wrote: Hi :) Thanks :) I guess that is part of my question. The original back-end of the database in this case is MySql/MariaDb. Base can normally use MySql/MariaDb as it's own back-end so there would seem to be 2 different routes that might be worth considering; 1. Attach Base directly to the existing MySql/MariaDb that is hosted on some web-site (or at least on an internet-facing server such as a Cloud). I know the back-end can either be on a local machine or on a local-area-network but could it work over the internet too? 2. Since the exported data is already laid out for MySql/MariaDb then just install MySql
Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...
Peter West Where is he who has been born king of the Jews? On 6 Jan 2014, at 6:11 pm, James E Lang jim+...@lang.hm wrote: This has been a most enlightening discussion. I am a big fan of open source software. That said, this discussion has shined a bright light on one of the most problematic areas of the concept. I might be totally off base here but as I view it, without a central management structure to _enforce_ standards two separate groups of developers may develop what appear to the end user as being similar related features that are inconsistent with each other. This results in unpleasant surprises for the end user. If there had been a central management structure to _enforce_ standards, there would be NO open source software, full stop. No linux, no OS X, no samba, no python, no MySql, no Open Office and no Libre Office, to mention but a few. The productivity of OSS development teams, imperfect as it is, cannot be matched by any structures designed for the management of software development. It is only matched by startups with small, committed teams and inspired technical leadership. Success and rapid increases in the scale of the development teams kills their productivity. Companies that have carved out a fantastically profitable niche can survive this transition, bit they can only retain a fraction of their original productivity. -- 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: Label creation Q
Too cranky, Brian. Mr Sowden thought table referred to a database table. Peter West For my yoke is easy, and my burden is light. On 19 Dec 2013, at 1:00 pm, Brian Barker b.m.bar...@btinternet.com wrote: At 15:10 18/12/2013 -0800, John R. Sowden wrote: I do not know what ya'all mean by 'table' ... Have you looked at the help text? Do you see that menu labelled Table? That's all about tables. Table | Insert | Table... inserts a table. Try it and see how it works. So having a command that would take the label that you just created and populate the other label locations on the sheet seemed to be the next step, and I could not find the option. If you are using a table, see previous advice. If not, I don't imagine anyone can help you whilst you keep secret exactly what you are doing. Problem: In label design, the text and the drawing are separate objects, ... The *drawing*?! Why did no-one mention drawings in their answers? Oh, perhaps because you kept them a secret too? ... so selecting the top left label by highlighting the upper left to lower right the, rt cl copy, put cursor in upper right box, upper right corner, put the lower half of my original label (drawing only, no text) below the original and nothing in the upper right box. This behaviour appears to depend on how your graphic is anchored. Try anchoring As Character to achieve what you need easily. It just seems that a populate other empty labels on this sheet with original would make sense. With tables, it's probably too simple for there to be a special command. See previous advice. 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 -- 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: sumif question
I have a pivot table with results representing hours and dollar amounts. These values total to the right over a number of fields, and then appear in adjacent cells within a column: hours value hours value ... I ned to sum the hours and values separately (the right hand totals columns may have been calculated differently, so I cannot just rely on the running cross-sum in the bottom right hand corner. In the right-hand totals, some columns from the pivot may have been excluded, for example, so my only source for the overall totals that I want is the right-hand column. I could do this if I could access the row() value for individual elements, either in a sumif or by means of a filter, but I don't know whether this is possible, and in the test I tried, it did not work. Can anyone suggest a way to do this? Peter West For my yoke is easy, and my burden is light. -- 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] email notifications
Unfortunately, this list is set up to reply to the author, not the list. I've been caught by that on numerous lists. To eliminate the duplication, I have to Reply-all, then remove the OP from the To, and move the Cc field to the To field. I generally do that; I've just done it. Yes, it's a pain, and it's more of a pain to do the courtesy than to delete the duplicate that comes in. If you don't like the policy, ask the list manager whether it can be changed. I have never been able to comprehend why a mailing list would default that way. Replying to the OP only is the outlier, not the norm. Peter West We have only five loaves here, and two fish. On 4 Dec 2013, at 2:06 am, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk wrote: anne-ology wrote: not true. That'll be why there's a support article about the problem then, and numerous threads in forums. https://support.google.com/mail/answer/8395?hl=en PS Please don't copy me on any reply. That's just plain rude. -- 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: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office
On 30 Nov 2013, at 4:32 pm, M. Fioretti mfiore...@nexaima.net wrote: (*) where give it away for free doesn't mean only free trial periods. It also means keeping the software very easy to pirate so people learn it at home and then throw a tantrum if their company (that can't use pirated software) tries to migrate to something else Hi Marco, This is a very important observation. Whether deliberately cultivated or not, the near universal practice of stealing, or quietly being given, a copy of an employer's software meant that MS Office products gained near-ubiquity. If people writing documents on their private computers had been obliged to but a copy of MS Office, alternatives would have been embraced much more enthusiastically. We would not have seen, as an example, demands to provide documents in MS Word format when providing a CV. I believe that at some time in the future, former MS executives will reveal that theft was a vital element in MS' strategy for their Office products during the world colonisation phase. Peter West ...he saw a poor widow put in two copper coins. -- 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: Cost of MS Office relative to LO, was: Fwd: Re: moving to new version of MS Office
Mac OS X (based on BSD and the Mach kernel) Android (based on Linux) Linux apache Firefox ant gcc OpenJDK xerces xalan fop saxon (up to and including Saxon HE) itext (recently commercialised) pdfbox Gnome KDE Gimp Clojure etc etc etc Oh, yes, LibreOffice. Seems successful to me. The world looks very small and far away when viewed through MS goggles. Peter West ...he saw a poor widow put in two copper coins. On 30 Nov 2013, at 1:25 pm, Urmas davian...@gmail.com wrote: Virgil Arrington: I'm no fan of MS, and I'm sure I don't fully understand all of its business practices, but I truly hope that disdain for Redmond is not the primary motivation for LO and other forms of FOSS. Foss people are hurt that no one is interested in their bungles except occasional corrupted officials. They are imagine themselves as grown-ups and do not understand why the adults pet their heads and tell them to go play elsewhere. Just think about it: there was NOT A SINGLE successful FOSS-created project so far. -- 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: A feature, or ...?
Oh yes and that hits the nail on the head. Now that the problem has been defined, the solution becomes easy. Provide a way to SEE exactly how the formatting has been applied - and a quick link shortcut to removing it! Formatting/styles are - in my mind - similar to field codes. They're hidden formulas and such that could be turned on and off for viewing at will. That would be very useful. Peter West ...he saw a poor widow put in two copper coins. On 29 Nov 2013, at 7:00 am, A [via Document Foundation Mail Archive] ml-node+s969070n4085467...@n3.nabble.com wrote: On 11/28/2013 10:44 AM, Brian Barker wrote: As far as I can see: o Format | Default Formatting removes both direct formatting (to characters or paragraphs) and formatting by character styles. o The Apply Style drop-down applies paragraph styles, so you'd expect Clear formatting there to reset the paragraph style to Default - and it does. But it also does the same as Format | Default Formatting as well. For me at least, there's just too much to remember. (You're in a maze of twisty little passages. You're in a twisty maze of little passages. Now you're in a twisty little passage with a maze.) It's enough to make me lose my mind. I can't keep track of all these various intracacies. It sure would be nice to have some tool tips. Also, if Apply Style applies paragraph styles and only paragraph styles, why not have it say Apply Paragraph Style so as to make it obvious and avoid the obscurity. Default Formatting could either have a tool tip, or perhaps broken up into separate functions that do one thing each. i.e. 1) Remove formatting to characters. 2) Remove formatting to paragraphs. 3) Remove formatting by character styles. That would provide more control. I don't know if there's an advantage to it - other than knowing precisely what function is being performed. In addition, I do NOT expect Clear formatting to reset the paragraph style to default. I expect it to do 1,2,3 above. i.e. Clear the formatting just as it implies. I would expect Reset Paragraph Style to Default to reset the paragraph style to default. There's far too much guesswork and intimate knowledge required here. It's all quite NON-obvious. Sure, if one works with it all the time one can learn these things - but I shouldn't have to be an expert - it should be intuitive and if it's not intuitive it should be spelled out in a tool tip. I suspect that at least part of the problem here is that it is sometimes difficult to see - especially with an inherited document - exactly how formatting has been applied and consequently how it might be removed. Oh yes and that hits the nail on the head. Now that the problem has been defined, the solution becomes easy. Provide a way to SEE exactly how the formatting has been applied - and a quick link shortcut to removing it! Formatting/styles are - in my mind - similar to field codes. They're hidden formulas and such that could be turned on and off for viewing at will. Just my opinions of course. -- 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-tp4064910p4085467.html To unsubscribe from A feature, or ...?, click here. NAML -- 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 feature, or ...?
I suspect that at least part of the problem here is that it is sometimes difficult to see - especially with an inherited document - exactly how formatting has been applied and consequently how it might be removed. The problem is that _some_ formatting seems to get stuck. This is either an implementation bug or, for some obscure reason, a design decision; which makes it a design bug. Named styles are exclusive. Even though a style is _based_ on another style, recursively, applying a named style overrides the previous named style, whether the old style is an ancestor of the new style, or a completely different beast. That should be that as far as applying named styles goes. All that should be left is any style fragments that one has applied from the toolbar: bold, italic, etc; left, centered, etc; a particular font and so on. That may include bits of format applied through a formatparagraph or formatcharacter menu, _provided_ that all of this formatting is removed by the 'Clear direct formatting' operation. _Everything_ else must be reset to the values defined (or defaulted) in the applied style. This should not be a problem. If you like the look of some styling, create a new named style from the selection. Then extend and modify as required. That's what styles are all about. The other thing is to clearly display the interaction of paragraph and list styles. The style name display should have the capacity to display ALL the named styles that are in play, and there should be a display option, similar to the 'Display special characters' button, to toggle 'Show direct formatting.' It all boils down to being able to determine the source of any formatting, and being able, easily, to reset all formatting to a named style or set of complementary style types; paragraph, character, list. And yes, your discussion does help. Peter West ...he saw a poor widow put in two copper coins. On 29 Nov 2013, at 4:44 am, Brian Barker b.m.bar...@btinternet.com wrote: I still don't understand why you consider any of this a difficulty. If you have a mixture of direct formatting along with character and paragraph styles, you may well wish to remove some parts of it, but not all. So it's useful to have more than one facility. Surely you would expect to need to remove the different parts of applied formatting separately - and delight that you were able to do so selectively. As far as I can see: o Format | Default Formatting removes both direct formatting (to characters or paragraphs) and formatting by character styles. o The Apply Style drop-down applies paragraph styles, so you'd expect Clear formatting there to reset the paragraph style to Default - and it does. But it also does the same as Format | Default Formatting as well. I suspect that at least part of the problem here is that it is sometimes difficult to see - especially with an inherited document - exactly how formatting has been applied and consequently how it might be removed. 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