[libreoffice-users] Re: Base DB Connections
Le 07/07/13 21:37, Mark LaPierre a écrit : Hi Mark, Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? You could try this : 1) Open your ODB file, click on the Tables icon so that you can see the list of tables in your mysqldb. 2) Now open your Calc spreaadsheet. 3) In the top left hand corner of your spreadsheet, click on the on the grey corner square/rectangle so that the whole sheet gets selected. 4) Now drag and drop the whole sheet to the space where your mysql table list is visible within the ODB container and the copy data assistant should start up. Bear in mind that the assistant doesn't always recognize and set field types correctly when converting from Calc to Base, so you will have to check this before validating the creation of the table, otherwise you may end up with truncated data in your table or some funky odd stuff. The most problematic ones seem to be date/datetime strings. If you have images pasted in your spreadsheet cells as part of your data set, these will not be converted to binary large objects by the assistant. HTH, 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] Book-writing with Writer
Hi, I know this book: http://www.openoffice.org/documentation/whitepapers/Creating_large_documents_with_OOo.odt It's an old book, and is writed for OpenOffice, but the most important part is the same, and you can reuse in LibreOffice. I know an another book for you, but it's exists only in Hungarian: http://numbertext.org/libreoffice/libreoffice.pdf is a hybrid PDF, the PDF file contains the source of the book in ODT format. Probably you don't understand it, but can see come stuff that can do with LibreOffice and Graphite technology. 2013.07.08. 7:34 keltezéssel, Pablo Dotro írta: Greetings! I am beginning a large writing project, that will most probably take the form of a self published, free ebook. And while I have created very long, complex documents before, I have never formatted them as a book. Having been using word processing software for a living for the last 15 years or so, I thought myself as power user enough to take the next step and try to create my document relying on Writer's features and not depending on someone else to typeset the material. However, after reading both the Getting Started and the Writer Guide, I am convinced that it is possible. Heh, the mere existance of those books is proof enough ;-) But I find that there is a gap between the techniques described there for working with templates, styles and master documents... and the actual craft needed to make them work. A quick look to the odt files themselves convinced me of that. So after some googling and a disappointint amazon search on books on this subject, I come here to rely on our collective knowledge, with a question: Does anyone know about a tutorial, book or website where I can specifically learn about creating a book-lenght document, with chapters (as subdocuments) and a master document, consistent styling, indexing and table of contents with Libreoffice? Thnk you very much for your time, and best regards, -- 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] Unknown Infection
I just received the following response from trex5...@aol.com directly to me. Sending it to the list. Wanted it on the same thread, thus the copy-paste of his response. On Mon, Jul 8, 2013 at 10:58 AM, trex5...@aol.com wrote: Thank you, it was a false alarm. I used AVG 2013. The virus database was 3204/6473. I am terribly sorry if this has caused any concern. I didn't pay attention carefully to the How To Report section on the LibreOffice website. Used the wrong link haha. I'll refer to the security link on the website next time. Thank you and I appreciate your understanding. Regards, Trex5473 I also received the response directly to me instead of the list, with good information. Copy-paste again. On Sun, Jul 7, 2013 at 9:48 PM, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: I have heard of anti-virus packages in the past having a false positive for a part of LO system. But it has been maybe 6 months to a year since I have heard of one doing this, if my memory is correct. Yes, we need the anti-virus package name and what it states is the virus involved. To be honest, it could be a virus that infected the file on/by his/her system so it would activate every time LO starts up, instead of the file being download with the infection. I know that I run anti virus on my most active systems daily automatically so I can keep infections off my system. I even have my Linux system run its anti virus starting before hours midnight nightly. With 3 drives totaling of up to 5 TB of storage space, sometimes it does not finish till after I have breakfast. I keep my Windows laptops protected by Comodo Internet Security Suite - the free version - and run other security package weekly and/or monthly. Windows users need all the protection they can get to stop all of those nasties that people are getting every day or so. Peace, -- Barry Smith Secure Computer Service c 704-497-4217 e bnsmith...@gmail.com e scs.bns...@gmail.com w1 http://bit.ly/l8QJup w2 http://scs-llc.info/ -- 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] Book-writing with Writer
I have seen quote a bit of argument against using a master document for a book as I was exploring this subject just recently as well. The help docs of course are a good place to start. https://help.libreoffice.org/Writer/Master_Documents_and_Subdocuments There are a number of different tools for moving from LO to epub. There is the new eLAIX extension, Writer2epub, and you can also export as docxml and then use pandoc which will create epub3 docs for you. I used to use eScape but that is no longer supported, though it still works. The folk at infogridpacific looked like they were going to move it to an online service but it looks like that project was killed and that they are concentrating on their Digital publisher solution. On 7/8/13 5:44 AM, Nagy Ákos wrote: Hi, I know this book: http://www.openoffice.org/documentation/whitepapers/Creating_large_documents_with_OOo.odt It's an old book, and is writed for OpenOffice, but the most important part is the same, and you can reuse in LibreOffice. I know an another book for you, but it's exists only in Hungarian: http://numbertext.org/libreoffice/libreoffice.pdf is a hybrid PDF, the PDF file contains the source of the book in ODT format. Probably you don't understand it, but can see come stuff that can do with LibreOffice and Graphite technology. 2013.07.08. 7:34 keltezéssel, Pablo Dotro írta: Greetings! I am beginning a large writing project, that will most probably take the form of a self published, free ebook. And while I have created very long, complex documents before, I have never formatted them as a book. Having been using word processing software for a living for the last 15 years or so, I thought myself as power user enough to take the next step and try to create my document relying on Writer's features and not depending on someone else to typeset the material. However, after reading both the Getting Started and the Writer Guide, I am convinced that it is possible. Heh, the mere existance of those books is proof enough ;-) But I find that there is a gap between the techniques described there for working with templates, styles and master documents... and the actual craft needed to make them work. A quick look to the odt files themselves convinced me of that. So after some googling and a disappointint amazon search on books on this subject, I come here to rely on our collective knowledge, with a question: Does anyone know about a tutorial, book or website where I can specifically learn about creating a book-lenght document, with chapters (as subdocuments) and a master document, consistent styling, indexing and table of contents with Libreoffice? Thnk you very much for your time, and best regards, -- 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] Info from 3 cells merged into 1
Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column “A” includes the name of the path “data/” and column “B” has the name of the image “12345” and column “C” has the name for the file extansion “.jpg” or “.png”. So far all is ok. But now I would like to have these 3 facts together, so column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- 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] Info from 3 cells merged into 1
Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column “A” includes the name of the path “data/” and column “B” has the name of the image “12345” and column “C” has the name for the file extansion “.jpg” or “.png”. So far all is ok. But now I would like to have these 3 facts together, so column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- 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] Info from 3 cells merged into 1
And then, in the interest of being complete, you of course need to copy and paste that formula to all relevant rows... Carl On 7/8/13 1:46 PM, Steve Edmonds wrote: Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column “A” includes the name of the path “data/” and column “B” has the name of the image “12345” and column “C” has the name for the file extansion “.jpg” or “.png”. So far all is ok. But now I would like to have these 3 facts together, so column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Info from 3 cells merged into 1
Thanks Steve! Ive tried this now, but I got Err:501 for this. Any idea why? Best regards, Marino -Ursprungligt meddelande- From: Steve Edmonds Sent: Monday, July 8, 2013 7:46 PM To: Marino / WellnessWebshop.se Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Info from 3 cells merged into 1 Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column “A” includes the name of the path “data/” and column “B” has the name of the image “12345” and column “C” has the name for the file extansion “.jpg” or “.png”. So far all is ok. But now I would like to have these 3 facts together, so column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- 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] Info from 3 cells merged into 1
err501 means the formula was written incorrectly. here is a working example of what Steve and Carl said Errol On 2013/07/08 09:57 PM, Marino / WellnessWebshop.se wrote: Thanks Steve! Ive tried this now, but I got Err:501 for this. Any idea why? Best regards, Marino -Ursprungligt meddelande- From: Steve Edmonds Sent: Monday, July 8, 2013 7:46 PM To: Marino / WellnessWebshop.se Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Info from 3 cells merged into 1 Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column A includes the name of the path data/ and column B has the name of the image 12345 and column C has the name for the file extansion .jpg or .png. So far all is ok. But now I would like to have these 3 facts together, so column D would include facts from column A+B+C, so in column D I can see data/12345.jpg. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- -- 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] Book-writing with Writer
I'll probably be (justifiably) ostracized for this on a LO user list, but to me trying to write a book with LO Writer is like trying to force a square peg into a round hole. Yes, it can be done, but the labor involved may not be worth it. In my mind, Writer is a business application, useful for letters, memos, legal documents, school reports, and the like. While I love working with LO's styles (which would be essential for book writing), I find LO's implementation of master documents to be too involved and clunky for my taste. For organizing a book length document, with parts, chapters, and tables, indexes, and sub-documents, etc, I much prefer LyX and LaTeX, both of which are free and opensource. Yes, the LaTeX learning curve can be steep, but LyX makes it so much easier. You can type away and let the computer do the formatting, just by selecting the Book class. Unlike the business oriented LO, LyX and LaTeX were created specifically for making long documents such as books. Round hole, round peg. The biggest drawback is that changing default formatting settings can be daunting for the uninitiated. But, if you accept the defaults, you'll still have a beautifully formatted book with *much* less effort than you would with LO. For example, several years ago, my 14 year old son challenged himself to type a 50,000 word novel in November, which is National Novel Writers Month. He met his goal, and quickly dropped the project. As a proud papa, I wanted to put his document to paper. He wrote the original in WordPerfect, and it was a formatting mess, with stray tabs, carriage returns, and inconsistent formatting across chapter and section headings. I began the task of reformatting his 127 page novel using WordPerfect, the original program. It didn't take long for me to realize it would take days and days to wade through all of the formatting codes inserted by WP. Instead, I saved the document as a plain text file, stripping all formatting. I then loaded it into LyX. Using the Book class (think template), I applied Part and Chapter styles, (called environments in LaTeX speak) to the part and chapter titles, and then inserted a fully formatted, numbered, and typed table of contents with a couple mouse clicks. I set NO page formatting parameters such as page margins, page numbering, etc., as those were handled entirely by the Book class. I then compiled the book and had a fully formatted novel, complete with Title page, Table of Contents, properly formatted right and left hand pages with fully formatted headers with page numbers, etc. The entire formatting process took about a half hour. I surprised even myself. I could have done the same thing with LO's styles and master documents, but they're not quite as fully automatic as LyX/LaTeX, so it would have longer. So far, however, I've found LyX/LaTeX's support for e-books to be a little lacking (but no more so than LO's). For storing documents in an e-book format (whether Nook's Epub, or Kindle's MOBI), the best solution that I've found is Atlantis (a $35.00 shareware program). It is a Word clone word processor that supports direct export to Epub and MOBI with preservation of nearly all formatting. Every other solution I've tried (including LO, LyX, and Markdown editors) screws up formatting to some degree or another. Atlantis does 90% of what I need in a word processor, with the sole exception of tables. In short, while I love LO, I honestly think there are better tools for the task of book and e-book writing. Virgil 2013.07.08. 7:34 keltezéssel, Pablo Dotro írta: Greetings! I am beginning a large writing project, that will most probably take the form of a self published, free ebook. And while I have created very long, complex documents before, I have never formatted them as a book. Having been using word processing software for a living for the last 15 years or so, I thought myself as power user enough to take the next step and try to create my document relying on Writer's features and not depending on someone else to typeset the material. However, after reading both the Getting Started and the Writer Guide, I am convinced that it is possible. Heh, the mere existance of those books is proof enough ;-) But I find that there is a gap between the techniques described there for working with templates, styles and master documents... and the actual craft needed to make them work. A quick look to the odt files themselves convinced me of that. So after some googling and a disappointint amazon search on books on this subject, I come here to rely on our collective knowledge, with a question: Does anyone know about a tutorial, book or website where I can specifically learn about creating a book-lenght document, with chapters (as subdocuments) and a master document, consistent styling, indexing and table of contents with Libreoffice? Thnk you very much for your time, and best regards, -- To
Re: [libreoffice-users] Info from 3 cells merged into 1
oops, perhaps attachments get stripped out on this list. I've now sent the example direct to Marino. Errol On 2013/07/08 10:10 PM, Errol Goetsch wrote: err501 means the formula was written incorrectly. here is a working example of what Steve and Carl said Errol On 2013/07/08 09:57 PM, Marino / WellnessWebshop.se wrote: Thanks Steve! Ive tried this now, but I got Err:501 for this. Any idea why? Best regards, Marino -Ursprungligt meddelande- From: Steve Edmonds Sent: Monday, July 8, 2013 7:46 PM To: Marino / WellnessWebshop.se Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Info from 3 cells merged into 1 Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column A includes the name of the path data/ and column B has the name of the image 12345 and column C has the name for the file extansion .jpg or .png. So far all is ok. But now I would like to have these 3 facts together, so column D would include facts from column A+B+C, so in column D I can see data/12345.jpg. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- -- 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] Book-writing with Writer
On 08/07/2013 at 22:58, Virgil Arrington cuyfa...@hotmail.com wrote: but to me trying to write a book with LO Writer is like trying to force a square peg into a round hole. Yes, it can be done, but the labor involved may not be worth it. I think you merge two totally different ideas: writing a book and publishing a book. As for writing, Writer and LaTeX are pretty much comparable - they both sucks. They do not provide basic tools needed for writers, such as character descriptions (were her eyes blue or green?) or detailed outline of story (this is different than outline of chapters). Of course you can overcome it with nice note-taking app, custom wiki or organized papers, but in some other programs you do not have to. As for publishing (making it look beautiful), LaTeX classes and forced separation of structure and look usually provides better defaults than Writer. Agreed. But then, we talk about defaults. It's not like you can't change them. If you learn your tools and think in advance, create decent-looking long document in Writer can be done with little hassle. I have created and edited some long (100+ pages) documents in Writer and never seen anything in LaTeX that would be a dealbreaker for me. If anywhere, I would go to full-fledged DTP suite such as Adobe InDesign. -- Best regards Mirosław Zalewski -- 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] Book-writing with Writer
Miroslaw, You're right; I did merge *writing* and *publishing*. To that end, let me muddy the waters even more by mentioning yWriter, a software program designed specifically and solely for writing novels with many of the tools you suggest. The frustration that I've found is that there are some publishing (or formatting) tasks that are best handled completely separate from writing, such as page layout, font selection, table of contents generation, etc. However, I find other formatting tasks are better handled on the fly while typing, such as applying italics to a word. Sometimes, I find seeing the paragraph layout onscreen helpful to organizing my thoughts, which of course you won't see with a strict text editor or pure LaTeX editor. At least LyX helps by showing some formatting onscreen. Anytime I use a program like yWriter, I end up spending a lot of time later applying formatting that I could have applied on the fly with a decent word processor. That may not be a concern for a person whose work will be published, and therefore formatted, by someone else, like a professional publishing house. But, the original poster mentioned self-publishing an e-book. Virgil -Original Message- From: Mirosław Zalewski Sent: Monday, July 08, 2013 5:51 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Book-writing with Writer On 08/07/2013 at 22:58, Virgil Arrington cuyfa...@hotmail.com wrote: but to me trying to write a book with LO Writer is like trying to force a square peg into a round hole. Yes, it can be done, but the labor involved may not be worth it. I think you merge two totally different ideas: writing a book and publishing a book. As for writing, Writer and LaTeX are pretty much comparable - they both sucks. They do not provide basic tools needed for writers, such as character descriptions (were her eyes blue or green?) or detailed outline of story (this is different than outline of chapters). Of course you can overcome it with nice note-taking app, custom wiki or organized papers, but in some other programs you do not have to. As for publishing (making it look beautiful), LaTeX classes and forced separation of structure and look usually provides better defaults than Writer. Agreed. But then, we talk about defaults. It's not like you can't change them. If you learn your tools and think in advance, create decent-looking long document in Writer can be done with little hassle. I have created and edited some long (100+ pages) documents in Writer and never seen anything in LaTeX that would be a dealbreaker for me. If anywhere, I would go to full-fledged DTP suite such as Adobe InDesign. -- Best regards Mirosław Zalewski -- 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] Info from 3 cells merged into 1
THANKS! This works perfect! Exactly as I want it to work - you have saved many hours for me :-) Kind regards, Marino -Ursprungligt meddelande- From: Errol Goetsch Sent: Monday, July 8, 2013 11:27 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Info from 3 cells merged into 1 oops, perhaps attachments get stripped out on this list. I've now sent the example direct to Marino. Errol On 2013/07/08 10:10 PM, Errol Goetsch wrote: err501 means the formula was written incorrectly. here is a working example of what Steve and Carl said Errol On 2013/07/08 09:57 PM, Marino / WellnessWebshop.se wrote: Thanks Steve! Ive tried this now, but I got Err:501 for this. Any idea why? Best regards, Marino -Ursprungligt meddelande- From: Steve Edmonds Sent: Monday, July 8, 2013 7:46 PM To: Marino / WellnessWebshop.se Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Info from 3 cells merged into 1 Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column A includes the name of the path data/ and column B has the name of the image 12345 and column C has the name for the file extansion .jpg or .png. So far all is ok. But now I would like to have these 3 facts together, so column D would include facts from column A+B+C, so in column D I can see data/12345.jpg. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- -- 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] template menu
It is good to see that there are more LibO users who don't understand the improvements concerning templates from 3.6 to 4.0. Since a few weeks I try to understand it and still struggle. The only advantage is that I immediately can see thumbnails and this is combined with the disadvantage that the full name of the template is not visible. I hope that someone is brave enough and rethinks the advantages of the old template manager (up to 3.6) and creates a real good one even if this one looks and functions more like the one until 3.6 Reinhold . On 04.07.2013 21:23, Virgil Arrington wrote: I confess that I don't understand this type of improvement in software development. It's sort of like when MS decided that users couldn’t understand the Windows menu structure that had been used for two decades and gave us the ribbon. The LO/OO method of organizing templates has been around for...what, ten ... fifteen years now? If I'm not mistaken it goes all the way back to StarOffice. Long time users have grown accustomed to it. So, what would prompt someone to think it needs fixing? Was there a survey showing that a ton of new people would suddenly start using LO if it would only change its goofy way of organizing templates? I know people are always resistant to change; it took me a couple years to abandon DOS in favor of Windows. And, over time, I may get to like the new template menu placement (if I ever reinstall LO 4 after going back to 3.6.6). But to change a working menu structure just because we can? I just don't get it. Virgil -Original Message- From: Tim Lloyd Sent: Thursday, July 04, 2013 12:49 AM To: Thomas Blasejewicz Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] template menu Hi Thomas, I have to admit this confused me also. I don't know whether you can simply organize anymore. From the manual: To begin, choose *File **New **Templates***from the Menu bar to openthe Template Manager dialog. http://www.odfauthors.org/libreoffice/english/writer-guide/published-lo-4.0/wg4-0-ch10-templates/view At this point you can add, modify, delete and move! Cheers On 07/04/2013 02:38 PM, Thomas Blasejewicz wrote: Good afternoon The last few days I upgraded from 3.6 something to 4.0.4. And this morning I noticed the template menu is gone. One of my computers has still 3.6 on it and there it is under Files - Templates. That's also where the extension items for the extension template changer appeared. After along search I found, that the template changer can now only be found in an unmarked grave = empty white space with a black triangle at its right margin BELOW File - Exit. But so far I was not able to find anything like Templates - Organize anywhere. Where is this now??? Or has the software advanced so far, that creating, deleting, organizing templates etc. is now a thing of the past? Thank you. Thomas -- 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] Book-writing with Writer
Hello Virgil! On 08/07/13 17:58, Virgil Arrington wrote: I'll probably be (justifiably) ostracized for this on a LO user list, but to me trying to write a book with LO Writer is like trying to force a square peg into a round hole. Yes, it can be done, but the labor involved may not be worth it. In my mind, Writer is a business application, useful for letters, memos, legal documents, school reports, and the like. While I love working with LO's styles (which would be essential for book writing), I find LO's implementation of master documents to be too involved and clunky for my taste. Hehehe. Don't worry, I won't ostracize you. For organizing a book length document, with parts, chapters, and tables, indexes, and sub-documents, etc, I much prefer LyX and LaTeX, both of which are free and opensource. Yes, the LaTeX learning curve can be steep, but LyX makes it so much easier. You can type away and let the computer do the formatting, just by selecting the Book class. Unlike the business oriented LO, LyX and LaTeX were created specifically for making long documents such as books. Round hole, round peg. The biggest drawback is that changing default formatting settings can be daunting for the uninitiated. But, if you accept the defaults, you'll still have a beautifully formatted book with *much* less effort than you would with LO. I know... I am familiar with LaTeX and LyX. My day job is at the Physics Deptartment at a local Univesity, and we use them a lot for reports and papers. My problem is that I *do* want to give my document a distinctive visual format, with nice typography and so on... and writinf a LaTeX class or the LyX equivalent is beyond my skill level. And since I am not that fluent with LaTeX (I've personally never wrote anything complex with it), I wanted to use a more point-and-click approach, to able to focus on my subject matter and not so much in learning new tools at the same time. Another reason is that the small printing houses around here who may be able to do some small self publish job for me are all set up for files in PDF or MS Word .doc format. My experience with LaTeX to Word conversion is that the result is quite ugly. For example, several years ago, my 14 year old son challenged himself to type a 50,000 word novel in November, which is National Novel Writers Month. He met his goal, and quickly dropped the project. As a proud papa, I wanted to put his document to paper. He wrote the original in WordPerfect, and it was a formatting mess, with stray tabs, carriage returns, and inconsistent formatting across chapter and section headings. I began the task of reformatting his 127 page novel using WordPerfect, the original program. It didn't take long for me to realize it would take days and days to wade through all of the formatting codes inserted by WP. Instead, I saved the document as a plain text file, stripping all formatting. I then loaded it into LyX. Using the Book class (think template), I applied Part and Chapter styles, (called environments in LaTeX speak) to the part and chapter titles, and then inserted a fully formatted, numbered, and typed table of contents with a couple mouse clicks. I set NO page formatting parameters such as page margins, page numbering, etc., as those were handled entirely by the Book class. I then compiled the book and had a fully formatted novel, complete with Title page, Table of Contents, properly formatted right and left hand pages with fully formatted headers with page numbers, etc. The entire formatting process took about a half hour. I surprised even myself. Uh WP. That brings back memories ;-) In that specific case, I too would have turned to LaTeX. And don't take me wrong, I fully appreciate the need to separate format from content in a project this size. I could have done the same thing with LO's styles and master documents, but they're not quite as fully automatic as LyX/LaTeX, so it would have longer. So far, however, I've found LyX/LaTeX's support for e-books to be a little lacking (but no more so than LO's). For storing documents in an e-book format (whether Nook's Epub, or Kindle's MOBI), the best solution that I've found is Atlantis (a $35.00 shareware program). It is a Word clone word processor that supports direct export to Epub and MOBI with preservation of nearly all formatting. Every other solution I've tried (including LO, LyX, and Markdown editors) screws up formatting to some degree or another. Atlantis does 90% of what I need in a word processor, with the sole exception of tables. In short, while I love LO, I honestly think there are better tools for the task of book and e-book writing. I thank you for your time and effort. I would prefer to stick to using LO... I seriously considered turning to LaTeX, but I truly feel a little overwhelmed with the amount of learning I would need to do in order to reach the same formatting proficiency I have
Re: [libreoffice-users] Book-writing with Writer
Hi! On 08/07/13 18:51, Mirosław Zalewski wrote: On 08/07/2013 at 22:58, Virgil Arrington cuyfa...@hotmail.com wrote: but to me trying to write a book with LO Writer is like trying to force a square peg into a round hole. Yes, it can be done, but the labor involved may not be worth it. I think you merge two totally different ideas: writing a book and publishing a book. As for writing, Writer and LaTeX are pretty much comparable - they both sucks. They do not provide basic tools needed for writers, such as character descriptions (were her eyes blue or green?) or detailed outline of story (this is different than outline of chapters). Of course you can overcome it with nice note-taking app, custom wiki or organized papers, but in some other programs you do not have to. Heh, you are right. Even if this is more of a technical writing project than a novel, None of these tools are really focused on the high level creative process. Both are tools for creating the output of said process. My approach is to keep detailed paper notes ;-) As for publishing (making it look beautiful), LaTeX classes and forced separation of structure and look usually provides better defaults than Writer. Agreed. But then, we talk about defaults. It's not like you can't change them. If you learn your tools and think in advance, create decent-looking long document in Writer can be done with little hassle. I have created and edited some long (100+ pages) documents in Writer and never seen anything in LaTeX that would be a dealbreaker for me. If anywhere, I would go to full-fledged DTP suite such as Adobe InDesign. That's my problem. I do not want LaTeX defaults. I want a distinctive format appealing to not only the geeky tech/science community, but to people who are not into technology. LaTeX produces beautiful output... but it's too serious for my target audience. The Right Thing to do, if this would have been a commercial or for-hire job, would be to hire a designer to use DTP tools and typeset my text. but it's not, and it's just me, so I am trying to get the most out of my experience and training ;-) Anyway, thanks for trying to help. I really appreciate the response of the community :-) -- Pablo M. Dotro wiz...@elysium.com.arpdo...@df.uba.ar pdo...@gmail.com Twitter: @Pablo_El_Mago http://www.blog.elysium.com.ar -- 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] Book-writing with Writer
On 08/07/13 10:44, Nagy Ákos wrote: Hi, I know this book: http://www.openoffice.org/documentation/whitepapers/Creating_large_documents_with_OOo.odt It's an old book, and is writed for OpenOffice, but the most important part is the same, and you can reuse in LibreOffice. I know an another book for you, but it's exists only in Hungarian: http://numbertext.org/libreoffice/libreoffice.pdf is a hybrid PDF, the PDF file contains the source of the book in ODT format. Probably you don't understand it, but can see come stuff that can do with LibreOffice and Graphite technology. You are right, Hungarian is not my thing hehehe. But I downloaded your first suggestion, and it's very informative. Thank you very much! When this is over, if I manage to get it right, I will write a how-to document with my experience ;-) Again, thanks for the references! -- Pablo M. Dotro wiz...@elysium.com.arpdo...@df.uba.ar pdo...@gmail.com Twitter: @Pablo_El_Mago http://www.blog.elysium.com.ar -- 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] Book-writing with Writer
On 08/07/13 14:30, Marc Grober wrote: I have seen quote a bit of argument against using a master document for a book as I was exploring this subject just recently as well. The help docs of course are a good place to start. https://help.libreoffice.org/Writer/Master_Documents_and_Subdocuments There are a number of different tools for moving from LO to epub. There is the new eLAIX extension, Writer2epub, and you can also export as docxml and then use pandoc which will create epub3 docs for you. I used to use eScape but that is no longer supported, though it still works. The folk at infogridpacific looked like they were going to move it to an online service but it looks like that project was killed and that they are concentrating on their Digital publisher solution. Hi! Thanks. I went through that. It's well written. It helped me to understand the concept. But It's a little shy on the actual practice. I've been experimenting with templates and a set of test documents, with mixed results. I notice that master documents tend to elicit a love-hate relationship: some people think they are The Right Thing, others that they are worse than accepting a ring from Sauron hehehe. I had bad experiences dabbling with them in MS Word a few years ago, and I never touched them again. I've also experienced that Writer is a lot more stable than MS Word when dealing with very long documents and complex formatting (embedded images, tables, crossreferences, etc.), but I never have used it for anything over 100-120 pages long. I expect my current assignment to reach around 500 pages easily, with math, complex tables and so on. When I read the Writer's Guide, I came across the suggestion that a master document and chapter subdocuments where the preferred way to tackle long, complext texts. In any case, I am aware that I will need a lot of planning, careful styling and no direct formatting to make it work, either as a single file or using a master document. As for publishing... I was thinking plain PDF export with no DRM. Epub is an interesting option. On the print side... small printing houses down here, the ones that accept material for self publishing, demand MS Word .doc format, so that was another reason for me to chose Writer instead of a full DTP or plain text format. Anyway, thanks for the tips. I'll keep digging ;-) -- Pablo M. Dotro wiz...@elysium.com.arpdo...@df.uba.ar pdo...@gmail.com Twitter: @Pablo_El_Mago http://www.blog.elysium.com.ar -- 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] Book-writing with Writer
Hi! On 08/07/13 21:29, Virgil Arrington wrote: Anytime I use a program like yWriter, I end up spending a lot of time later applying formatting that I could have applied on the fly with a decent word processor. That may not be a concern for a person whose work will be published, and therefore formatted, by someone else, like a professional publishing house. But, the original poster mentioned self-publishing an e-book. Virgil It seems the ideal software does not yet exist hehe. Maybe some day, when LO gets a more widespread user base, we will see an extension or extension set that could bridge the gap between full fledged word processing/design and the kind of writing aids that are needed to help us tell a good story, or create a consistent document without copious paper notes or auxiliary databases ;-). -- Pablo M. Dotro wiz...@elysium.com.arpdo...@df.uba.ar pdo...@gmail.com Twitter: @Pablo_El_Mago http://www.blog.elysium.com.ar -- 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 DB Connections
On 07/08/2013 02:45 AM, Alexander Thurgood wrote: Le 07/07/13 21:37, Mark LaPierre a écrit : Hi Mark, Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? You could try this : 1) Open your ODB file, click on the Tables icon so that you can see the list of tables in your mysqldb. 2) Now open your Calc spreaadsheet. 3) In the top left hand corner of your spreadsheet, click on the on the grey corner square/rectangle so that the whole sheet gets selected. 4) Now drag and drop the whole sheet to the space where your mysql table list is visible within the ODB container and the copy data assistant should start up. Bear in mind that the assistant doesn't always recognize and set field types correctly when converting from Calc to Base, so you will have to check this before validating the creation of the table, otherwise you may end up with truncated data in your table or some funky odd stuff. The most problematic ones seem to be date/datetime strings. If you have images pasted in your spreadsheet cells as part of your data set, these will not be converted to binary large objects by the assistant. HTH, Alex Okay, that worked pretty well. It's still not a good solution because, to make it work with the multitude of spreadsheets that I have, I have to import each one by dragging and dropping then spending several minutes defining all the data types to match the internal table that I want to import the data into. This would be so much easier if I could link to the external spreadsheet, import the data from it, then copy the new spreadsheet to the same name/location as the linked file, start up the LO-BASE and import that batch of data into the SQL back end. I get a new spreadsheet every week with some duplication of data on each sheet from what was on the previous sheet. I don't want to copy and paste the duplicate data into the main table. I'll have to think about this one for a while. Thank you for the solution Alex. It's a good start to what I hope is a workable solution. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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] Cloister Font.
To USERS: I asked this question earlier about how to find just that one font, but I did not make it clear what I had already done. First I use a Windows 7- 64 bit system, with libre office 4.0 suite. I have tried a Google search and ended up with getting a installation package of several programs, NONE of which I needed and then finding out that the package did not even include the font I wanted. I would like to have one font titled Cloister and, short of buying a Print Master program or Print shop , I have no way of knowing how to get that Font, and, clearly, do not want five or six other programs cluttering up the system.can anyone tell me how I can go about doing this? -- Old Sarge-John Boyle IN GOD WE TRUST! -- 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