[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 09/07/13 06:46, Mark LaPierre a écrit : Hi Mark, 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.

[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 07/07/13 21:37, Mark LaPierre a écrit : Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? On further reflection, it might be possible to do this by using a macro, in which you connect to the Calc sheet, load

Re: [libreoffice-users] Cloister Font.

2013-07-09 Thread Peter Hillier-Brook
On 08/07/13 21:59, John Boyle wrote: 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

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Tom Davies
Hi :) The Docs Team use Writer for all their guides.  They do also have brief notes / summaries outside of whichever guide they are writing and do use their mailing list to help get consensus about side-issues.  Getting involved there might help you learn tricks or at least see the process. 

Re: [libreoffice-users] Cloister Font.

2013-07-09 Thread Steve Edmonds
On 9/07/13 8:02 PM, Peter Hillier-Brook wrote: On 08/07/13 21:59, John Boyle wrote: 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

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Tom Davies
Hi :) When i first started using Writer i found i struggled against the software quite a bit.  Often people try something new unaware of the baggage they bring with them (such as bad habits learned through years of using other products) and somehow keep managing to find unsuitable work-flows

[libreoffice-users] Re: Info from 3 cells merged into 1

2013-07-09 Thread Tom
Hi :) Yes, attachments do get stripped off emails to the list. This thread is not the only question being dealt with here and anyway how would people reading this thread in the future manage to get the attachment? The best answer is to use Nabble. You can upload the files you want to attach

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Tom Davies
Hi :) The Docs Team have looked into ePub versions and have found some good tools to use.  Annoyingly i can't remember what they finally worked out was the best one so it would be really good if someone could ask them again.  Anyway, perhaps there is something even better now.  In my

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Virgil Arrington
Ferand wrote, Virgil, please stop this crap, LO and OO are the right tools to produce any document any form any size, only the lack of knowledge is a barrier . All professional tools to produce a book are XML based like LO and OO, so start writing, use a simple style model , understood the

[libreoffice-users] How to remove user-defined format codes for numbers?

2013-07-09 Thread chimak111
LibreOffice 4 Some of my spreadsheets have a ridiculous number of user-defined format codes (for numbers in Alt, Format, Cells, Category, Number). I think I created them when I was learning how to format numbers. Is there some elegant way I could remove all these user-defined format codes or do

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Virgil Arrington
Tom, Actually, I have had very little struggle learning LO. I started back in the StarOffice days and haven’t looked back. I have just learned to keep LO in its place...as a business tool, not a tool for creative writing or desktop publishing. You mention the Table of Contents. Yes, the first

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Jack Wallen
Sorry, my original reply went off list. On 07/09/2013 12:10 AM, Pablo Dotro wrote: 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

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Virgil Arrington
Getting back to Pablo's original question, he asked about using master documents with sub-documents for each chapter. This is, in fact, the model used by many systems, from LaTeX to yWriter, as well as LO. But, I'm wondering how necessary it really is. The purpose of the master

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Virgil Arrington
Jack, Just curious. Do you use LO's master document system for your books? Virgil -Original Message- From: Jack Wallen Sent: Tuesday, July 09, 2013 7:12 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Book-writing with Writer Sorry, my original reply went off

[libreoffice-users] Cell background color based on last edited date?

2013-07-09 Thread Tanstaafl
Hi all, I'm wondering if it is possible to set a background color style on a group of cells such that only cells that have been edited within the last x [days][hours] will be a certain defined color, and all others will not have a BG color applied? Thanks -- To unsubscribe e-mail to:

[libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-09 Thread Tanstaafl
Is it possible to define a range of cells to auto sort themselves, such that anytime one of them is modified, the sort is reapplied? This is some Sales Numbers for some Sales Reps, and the boss wants them to always be sorted based on the total column anytime any numbers in the sheet are

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Kracked_P_P---webmaster
Here is a resend of a reply that seemed not to get to the system, so I have been told. On 07/08/2013 06:32 PM, Kracked_P_P---webmaster wrote: On 07/08/2013 05:51 PM, Mirosław Zalewski wrote: On 08/07/2013 at 22:58, Virgil Arringtoncuyfa...@hotmail.com wrote: but to me trying to write a

Re: [libreoffice-users] How to remove user-defined format codes for numbers?

2013-07-09 Thread Jay Lozier
On Tue, 09 Jul 2013 07:38:57 -0400, chimak111 chimak...@gmail.com wrote: LibreOffice 4 Some of my spreadsheets have a ridiculous number of user-defined format codes (for numbers in Alt, Format, Cells, Category, Number). I think I created them when I was learning how to format numbers. Is

Re: [libreoffice-users] Cloister Font.

2013-07-09 Thread Kracked_P_P---webmaster
On 07/09/2013 04:48 AM, Steve Edmonds wrote: On 9/07/13 8:02 PM, Peter Hillier-Brook wrote: On 08/07/13 21:59, John Boyle wrote: 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

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Kracked_P_P---webmaster
On 07/09/2013 07:27 AM, Virgil Arrington wrote: Ferand wrote, Virgil, please stop this crap, LO and OO are the right tools to produce any document any form any size, only the lack of knowledge is a barrier . All professional tools to produce a book are XML based like LO and OO, so start

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Paul D. Mirowsky
Couldn't agree more. I've found the best way to start is write short document consisting of all the parts you need. Learn the appropriate Writer terms and functions. Get everything to format properly down to the last little item. Save your template and your good to go. By the time your done

[libreoffice-users] Libre Writer - learnign Tables

2013-07-09 Thread charles meyer
Hi Folks, I'm interested in learning how to create and use tables in Libre Writer. I'm a Libre newbie. I learn fastest visually. Books and FAQ don't resonate with me. Have you used any youtube or online tutorial videos to learn tables? TIA, Charles. -- To unsubscribe e-mail to:

Re: [libreoffice-users] Cloister Font.

2013-07-09 Thread Doug
On 07/08/2013 04:59 PM, John Boyle wrote: 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

Re: [libreoffice-users] How to remove user-defined format codes for numbers?

2013-07-09 Thread Tom Davies
Hi :) I think i might have misunderstood but just in case i didn't ... You know Ctrl A selects the entire work-sheet and you can then apply a single set of formats to the entire sheet?  Regards from Tom :)  From: chimak111 chimak...@gmail.com To:

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Marc Grober
On 7/9/13 2:12 AM, Tom Davies wrote: Writer, Word and WordPerfect and others do seem to be designed for business letters and fairly short works. LaTeX (and the various front-ends (such as LyX) that attempt to make it easier to use) do seem to have advantages for larger works but are more

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Virgil Arrington
Kracked_P_P wrote: I use LO to export my work to a PDF document that would work well on my tablets. All I needed to do is format the page size to the proper one that works best for tablet reading. I choose something along the page size used for paper-back books. So I format the page to

Re: [libreoffice-users] Re: Info from 3 cells merged into 1

2013-07-09 Thread Marino / WellnessWebshop.se
Hi! Now it works to collect all in one cell. But I also need to copy the result - not the formula, to another spreadsheet. Now when I copy, I only copy th formula, not the result. Anybody know what to do? Best regards, Marino -Ursprungligt meddelande- From: Tom Sent: Tuesday, July

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Toki Kantoor
On 07/09/2013 12:05 PM, Virgil Arrington wrote: But, LO's navigator tool offers much of the same functionality without having to split your document up into many different files. With the navigator, you can jump from point to point within a single document based on headings, bookmarks, etc.

Re: [libreoffice-users] Re: Info from 3 cells merged into 1

2013-07-09 Thread Tom Davies
Hi :) Any chance someone could use Nabble so we could see the file in question?  Regards from Tom :)  From: Marino / WellnessWebshop.se mar...@wellnesswebshop.se To: Tom tomdavie...@yahoo.co.uk; users@global.libreoffice.org Sent: Tuesday, 9 July 2013,

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-09 Thread Paul
Hi Regina, Terribly sorry about the delay in following up on your suggestions. I didn't mean to just disappear like that. It's been a bit hectic here, and I haven't had time to try with LibreOffice 4.1 beta yet, but I've tried a couple of other things. Firstly, I tried formatting the cell as a

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-09 Thread Carl Paulsen
I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other spreadsheet, then select the starting cell, select Edit-Paste Special, then uncheck the Formulas option (you may first need to uncheck the Paste

Re: [libreoffice-users] Book-writing with Writer

2013-07-09 Thread Kracked_P_P---webmaster
On 07/09/2013 03:48 PM, Virgil Arrington wrote: Kracked_P_P wrote: I use LO to export my work to a PDF document that would work well on my tablets. All I needed to do is format the page size to the proper one that works best for tablet reading. I choose something along the page size used

Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -

2013-07-09 Thread Carl Paulsen
Arrgghhh. This was supposed to be a reply to the Re: Info from 3 cells merged into 1 thread. Sorry! On 7/9/13 8:31 PM, Carl Paulsen wrote: I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other

Re: [libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Mark LaPierre
On 9 July 2013 17:46, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 07/07/13 21:37, Mark LaPierre a écrit : Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? On further reflection, it might be

[libreoffice-users] Re: Book-writing with Writer

2013-07-09 Thread Urmas
Pablo Dotro: 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. But I find that there is a gap between the techniques described there

Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -

2013-07-09 Thread Marino / WellnessWebshop.se
Works perfect - thanks! Marino -Ursprungligt meddelande- From: Carl Paulsen Sent: Wednesday, July 10, 2013 3:57 AM To: users@global.libreoffice.org Subject: Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between

[libreoffice-users] Re: Book-writing with Writer

2013-07-09 Thread Ken Springer
On 7/7/13 10:34 PM, Pablo Dotro wrote: 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