[libreoffice-users] When using tools - update - update all bibliography styles get lost.

2011-07-13 Thread Dietrich Bollmann
Hi, I configured the styles applied to the bibliography via the styles tab of the bibliography tool. But whenever I use tools - update - update all they get lost again. Also, when saving the document in another format, the bibliography is not exported. Am I doing something wrong or are these

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Dietrich Bollmann
Hi, Jay, On Tue, 2011-07-12 at 16:38 -0400, planas wrote: On Tue, 2011-07-12 at 17:48 +0900, Dietrich Bollmann wrote: for a paper I have to only render the Initials of the first name in the list of references: At the place of: Anderson, David I have to use:Anderson, D.

[libreoffice-users] Re: Feature Request :Evolution

2011-07-13 Thread Andreas Säger
Am 12.07.2011 18:46, Shane Van Loenen wrote: I could not find a place on the website to list a feature request, so I will try here. Open Office and Libre Office are great tools that can be used in the enterprise, but since there is not an e-mail client, my org will gravitate back to MS. Anyway

[libreoffice-users] Re: Mail merge saved into individual documents

2011-07-13 Thread Olivier Bietzer
Le 12/07/2011 22:12, nvrk a écrit : On Tue, Jul 12, 2011 at 11:21 AM, Steve Edmonds steve.edmo...@ptglobal.comwrote: On 13/07/11 4:14 AM, Olivier Bietzer wrote: Hello, Using LibreOffice after some years under OOo... The Mail merge has an option to save the merged documents into one single

Re: [libreoffice-users] Re: Mail merge saved into individual documents

2011-07-13 Thread Tom Davies
Hi :) Did you manage to file the bug-report in the LibreOffice area or OpenOffice? http://wiki.documentfoundation.org/BugReport Hopefully reports filed agaist LibreOffice get some sort of priority when people are looking for something to fix. The Easy Hacks is a good way to pick bugs that you

Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-13 Thread webmaster for Kracked Press Productions
On 07/12/2011 04:10 PM, Zak McKracken wrote: Am 10.07.2011, 15:49 Uhr, schrieb webmaster for Kracked Press Productions webmas...@krackedpress.com: On 07/09/2011 07:12 PM, Zak McKracken wrote: Am 09.07.2011, 20:40 Uhr, schrieb webmaster for Kracked Press Productions

Re: [libreoffice-users] Error in Calc logical functions

2011-07-13 Thread John B
Michael Excellent, I did not know ISNUMBER existed, I never needed it before, but for my usage I would remove the word Non-numeric and just leave so the cell would remain blank. I can see that in LO or any other spreadsheet that treats Letters as Numbers, this would be a necessary

Re: [libreoffice-users] Error in Calc logical functions

2011-07-13 Thread Regina Henschel
Hi John, John B schrieb: Dear Regina The way LO explains (you mention), its not a bug, but that does not mean that it is correct either and can be classed as a false positive. It is not until you have practical use. LO follows the standard ODF and acts the same as main competitors. There

Re: [libreoffice-users] Error in Calc logical functions

2011-07-13 Thread Tom Davies
Hi :) Wow!! I wonder if this answers the bigger question behind what the original poster was asking. Sometimes it's difficult to See the forest(/wood) for the trees = If you are too close to the problem it can be difficult to get a good overview. Anyway it looks as though this question has

Re: [libreoffice-users] Re: Feature Request :Evolution

2011-07-13 Thread Tom Davies
Hi :) +1 would be my vote for how this all works. I've not really tried it but hopefully it works that way for several email clients possibly including the proprietary The Bat. I tend to prefer OpenSource programs such as Thunderbird or Claws and suspect that Thunderbird is the most likely

Re: [libreoffice-users] When using tools - update - update all bibliography styles get lost.

2011-07-13 Thread Tom Davies
Hi :) If it works fine using ODF formats such as Odt then it's possibly either a problem or restriction of the alternative format you are trying to use or else it's a problem with LibreOffice's implementation. Either way it's probably a good idea to post a bug report and mention which format

Re: [libreoffice-users] Feature Request :Evolution

2011-07-13 Thread T. R. Valentine
I can understand why software companies expand software products to do more and more things (to justify new versions, to convince chumps to 'upgrade', and to push other software companies out of the picture), but I do not understand those who buy into such a process with its accompanying bloat. I

Re: [libreoffice-users] Feature Request :Evolution

2011-07-13 Thread David B Teague sr
On 7/13/2011 11:20 AM, T. R. Valentine wrote: I can understand why software companies expand software products to do more and more things (to justify new versions, to convince chumps to 'upgrade', and to push other software companies out of the picture), but I do not understand those who buy

Re: [libreoffice-users] Save odt/ods files take too much time

2011-07-13 Thread Tom Davies
Hi :) Here is a guide to posting a bug-report http://wiki.documentfoundation.org/BugReport It might help you work out if it is a bug or not. Sorry, hopefully it's more helpful than i am! If in doubt it's probably better to file a bug-report and let the triagers decide how to treat it. Good

Re: [libreoffice-users] Feature Request :Evolution

2011-07-13 Thread Roland Hughes
The pathetic draw tool MS had before purchasing another company was actually part of office for a while. Now it usually only comes bundled with Corporate and super professional versions. They found people would pay for a drawing program. KOffice includes a pretty good drawing program bundled as

RE: [libreoffice-users] Error in Calc logical functions

2011-07-13 Thread Dennis E. Hamilton
+1 -Original Message- From: Regina Henschel [mailto:rb.hensc...@t-online.de] Sent: Wednesday, July 13, 2011 06:14 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Error in Calc logical functions Hi John, John B schrieb: Dear Regina The way LO explains (you mention),

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Keyboard short-cuts sometimes work when menus don't Ctrl C = copy Ctrl X = cut (X looks a little like a pair of scissors) Ctrl V = Paste Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my web-based email program) ✁

[libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread Thorsten Kampe
Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. For example: [July 2011 Sheet] A B 1 07/02 75.6 2 07/03 3 4 07/04 76.4 5

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Tom Davies
Hi :) +1 Lol, i totally agree. I just never thought about it. I did notice someone taking extravagant care in a very precise guide ages ago. Hmm Ctrl+c would be Ctrl and the + key and the c? I got told off for using the + one time. I have even been told off for using the space too but

[libreoffice-users] My Tools, Options, Security menu doesn't exist?!?

2011-07-13 Thread floridabrits
Hello I am hoping someone can help me here. Thanks in advance! I have installed LibreOffice on my Mac and am opening a spreadsheet that has macro's in it. I get a warning that says macros contain viruses and I don't have macros enable and so I need to go to Tools - Options - LibreOffice -

Re: [libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread Tom Davies
Hi :) This sort of summary report is usually easier in a proper database program such as Base. Coincidentally Base can read Calc/Excel files so you wouldn't have to transfer any data, just use what you have. Personally i would probably stick to Calc and insert a new sheet that calculated

[libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread Thorsten Kampe
Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. For example: [July 2011 Sheet] A B 1 07/02 75.6 2 07/03 3 4 07/04 76.4 5

Re: [libreoffice-users] My Tools, Options, Security menu doesn't exist?!?

2011-07-13 Thread Tom Davies
Hi :) I don't understand Macros but Chapter 13 here http://www.libreoffice.org/get-help/documentation/ might help. Which file-format is the file in? Is it an .xls or .xlsX (from MS Excel) or is it an .ods? MS do their macros slightly differently so it can take a bit of lkuck gettign them to

[libreoffice-users] Re: [Calc] Create and export chart

2011-07-13 Thread Thorsten Kampe
* Tom Davies (Wed, 13 Jul 2011 18:42:47 +0100 (BST)) Personally i would probably stick to Calc and insert a new sheet that calculated summaries from all the other sheets and then use that as the basis for a chart. So you cannot create charts in one sheet that takes data from another sheet

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are copied too, however the formulae still refer to the same cell

Re: [libreoffice-users] Re: [Calc] Create and export chart

2011-07-13 Thread Tom Davies
Hi :) You probably can do it all in one sheet but 2 would probably be easier to trouble-shoot later if you ran into problems. What type of chart are you hoping to end-up with? Do you want a single line representing the entire year or do you want to compare months against each other? For

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Tom Davies tomdavie...@yahoo.co.uk: Hi :) +1 Lol, i totally agree.  I just never thought about it.  I did notice someone taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would be Ctrl and the + key and the c?  I got told off for using the +  one time.  I have

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Johnny Rosenberg gurus.knu...@gmail.com: 2011/7/13 Tom Davies tomdavie...@yahoo.co.uk: Hi :) +1 Lol, i totally agree.  I just never thought about it.  I did notice someone taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would be Ctrl and the + key and the c?

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Tom Davies
Hi :) You are right. Some people have a different view which is not entirely wrong. I think there are various agreed standards and your way fits at least one of them. Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To:

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Hylton Conacher (ZR1HPC) hyl...@conacher.co.za: Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are

Re: [libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread Regina Henschel
Hi Thorsten, Thorsten Kampe schrieb: Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. For example: [July 2011 Sheet] A B

Re: [libreoffice-users] Conditional formatting cell copying?

2011-07-13 Thread Regina Henschel
Hi Hylton, Hylton Conacher (ZR1HPC) schrieb: Hi all, Is there a way to copy a particular cells conditional formatting rules across a cell selection either in a row or a column? Yes. Copy a cell, which has the conditional formatting assigned. Mark the target and goto Edit Paste Special.

RE: [libreoffice-users] Re: [Calc] Create and export chart

2011-07-13 Thread Dennis E. Hamilton
You can see if it is possible to select a cuboid, but that may or may not provide what you want. Also, there is an interesting problem of maintaining the correspondence between the column A entries and the column B entries if that is important to you. A cuboid is a range that starts on one

Re: [libreoffice-users] Re: [Calc] Create and export chart

2011-07-13 Thread Michael D. Setzer II
On 13 Jul 2011 at 20:09, Thorsten Kampe wrote: To: users@global.libreoffice.org From: Thorsten Kampe thors...@thorstenkampe.de Subject:[libreoffice-users] Re: [Calc] Create and export chart Date sent: Wed, 13 Jul 2011 20:09:50

[libreoffice-users] Re: Has anyone used RapidShare for sharing ISO files?

2011-07-13 Thread Michelle Konzack
Hello webmaster for Kracked Press Productions, Am 2011-07-09 14:40:30, hacktest Du folgendes herunter: Does anyone have any suggestions on low-cost or free places to share these LibreOffice ISO files? How much traffic do you expect per month? I have a bunch of VServers and RootServers with a

Re: [libreoffice-users] Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Regina, See my earlier reply to Dave in addition to the below:. Copying and writing the conditions are not the problem. Getting the condition to automatically increment is the problem e.g. I have cell A1 that has the formula to add the contents of cells B1, C1 and D1. Cell A1 also has 3

[libreoffice-users] RE: Re: [Calc] Create and export chart

2011-07-13 Thread Thorsten Kampe
* Dennis E. Hamilton (Wed, 13 Jul 2011 13:04:23 -0700) A lot of how this works really depends on what it is you want in the chart - then you can figure out how to boil the date from the other sheets down to produce the data that is exactly the basis for the chart. I don't want to speculate

Re: [libreoffice-users] RE: Re: [Calc] Create and export chart

2011-07-13 Thread Regina Henschel
Hi Thorsten, Thorsten Kampe schrieb: * Dennis E. Hamilton (Wed, 13 Jul 2011 13:04:23 -0700) A lot of how this works really depends on what it is you want in the chart - then you can figure out how to boil the date from the other sheets down to produce the data that is exactly the basis for the

[libreoffice-users] Re: Printing OLE problem

2011-07-13 Thread NoOp
On 07/12/2011 09:10 AM, Jeremy Morris wrote: Hope someone can provide some advice - System: Ubuntu 64-bit v11.4, LibreOffice 3.3.3 I have a .doc file from an MS-Word 2003 source, containing two OLE images. When opening this file I can see the images, but they are not visible in the

[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-13 Thread floridabrits
Thanks for the quick response Tom. It is an ODS file... I just don't understand why I don't have this tools/options menu that is discussed. Anyone? Thanks in advance for your help and suggestions... /g -- View this message in context:

[libreoffice-users] Converting references to non-reference text in LibreOffice Writer: the dumbest possible way?!

2011-07-13 Thread Sandy Miller
I have LibreOffice documents (written in 3.2/3.3) with extensive field cross-referencing to numbers of tables, numbered paragraphs, numbered sections and chapters, etc. Conversion to Word often messes those up so I wanted to change them all to text. Now, in Word one could just highlight the whole

[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-13 Thread Dave Griffiths
floridabrits wrote: Thanks for the quick response Tom. It is an ODS file... I just don't understand why I don't have this tools/options menu that is discussed. Anyone? Thanks in advance for your help and suggestions... /g -- View this message in context:

[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-13 Thread Larry Gusaas
On 2011/07/13 12:04 PM floridabrits wrote: I just don't understand why I don't have this tools/options menu that is discussed. On Macs it is /Preferences. Larry -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread jorge
Hi You can do it like this: 1) Select two columns and all rows that you need format. 2) Select Menu-Format-Conditional Format 3) Make the format that you need 4) Accept I know that this conditional format is for all area selected and it didn't show a special cell formula o

Re: [libreoffice-users] Feature Request :Evolution

2011-07-13 Thread planas
Lorenzo On Wed, 2011-07-13 at 11:45 +0200, Lorenzo Sutton wrote: Hi, Shane Van Loenen wrote: I could not find a place on the website to list a feature request, so I will try here. Open Office and Libre Office are great tools that can be used in the enterprise, but since there is not

Re: [libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread Simon Cropper (The foss Workflow Guides)
On 14/07/11 03:13, Thorsten Kampe wrote: Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. For example: [July 2011 Sheet] A

[libreoffice-users] Re: Feature Request :Evolution

2011-07-13 Thread NoOp
On 07/12/2011 09:46 AM, Shane Van Loenen wrote: I could not find a place on the website to list a feature request, so I will try here. Open Office and Libre Office are great tools that can be used in the enterprise, but since there is not an e-mail client, my org will gravitate back to MS.

Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-13 Thread webmaster for Kracked Press Productions
On 07/13/2011 04:22 PM, Michelle Konzack wrote: Hello webmaster for Kracked Press Productions, Am 2011-07-10 09:49:11, hacktest Du folgendes herunter: 3.7 GB as an ISO 3.4 GB as a zipped file. How do you get this size? I create regulary Install-CD/DVD and they have ALWAYS onle the size

Re: [libreoffice-users] [Calc] Create and export chart

2011-07-13 Thread jorge
Hi I sent an e-mail answer to Mr. Kampe with How to I think he would solve his problems. I sent directly because I think this users@ list not accept add files and I sent three files to him with the answer, because is to hard to explain all with words. If someone wants to

[libreoffice-users] Re: RE: Re: [Calc] Create and export chart

2011-07-13 Thread Thorsten Kampe
* Regina Henschel (Wed, 13 Jul 2011 22:36:31 +0200) Thorsten Kampe schrieb: I'd like to create a line chart with the values from columm A (the dates) as the X axis and the values from column B for the Y axis and this from all sheets in the spreadsheet. As if I would not have used multiple