Re: [libreoffice-users] CALC - How to count blank cells?

2012-07-09 Thread MiguelAngel
El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi Date: 7/4/12 3:44 AM To:

[libreoffice-users] Re: CALC - How to count blank cells?

2012-07-09 Thread Andreas Säger
Am 09.07.2012 10:22, MiguelAngel wrote: El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi

[libreoffice-users] [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Gilles
Hello The C1 column contains percentages, eg. 1,80% while C2 contains rational numbers, eg. 0,70. I need to multiple C1 x C2, but Calc displays #NAME?. What should I do to perform this operation? Thank you. -- View this message in context:

Re: [libreoffice-users] [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Dan
Gilles wrote: Hello The C1 column contains percentages, eg. 1,80% while C2 contains rational numbers, eg. 0,70. I need to multiple C1 x C2, but Calc displays #NAME?. What should I do to perform this operation? Thank you. -- View this message in context:

[libreoffice-users] LibreOffice won't save settings

2012-07-09 Thread Don
I'm running LibreOffice 3.5.4.2, BuildID: 350m1(Build:2) on Kubuntu 10.04. I love the program, but it will not save any of my customization settings. For example, I've recorded macros and then placed them on a toolbar, but the next time I open the program, they are not on the toolbar.

[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Tinkerer
It worked for me, = 1.26 In the multiply C1 by C2 cell you must have hit the function icon and not the equals icon. This would Sum the two in the absence of any chosen function. Tink. -- View this message in context:

Re: [libreoffice-users] LibreOffice won't save settings

2012-07-09 Thread Mirosław Zalewski
On 09/07/2012 at 17:24, Don d...@law.pace.edu wrote: I'm running LibreOffice 3.5.4.2, BuildID: 350m1(Build:2) on Kubuntu 10.04. I love the program, but it will not save any of my customization settings. For example, I've recorded macros and then placed them on a toolbar, but the next time I

[libreoffice-users] Re: LibreOffice won't save settings

2012-07-09 Thread Don
Miroslaw, Thanks for getting back to me so quickly. I think I'm up to date on the program since the first things I do every day are to use the Kpackage Manager update feature and then run sudo apt-get update. Do you know which files I would need to change the permissions on? That seems from

Re: [libreoffice-users] updated list of KPP English dictionaries for LO

2012-07-09 Thread Udvarias Ur
Dear webmaster-Kracked_P_P, I just downloaded and installed the KPP 2012 dictionaries. I found that after I installed them either the descriptions and/or the dates/version numbers had not been updated properly so that it is difficult or impossible to tell which version is installed. (In the case

Re: [libreoffice-users] updated list of KPP English dictionaries for LO

2012-07-09 Thread webmaster-Kracked_P_P
You are correct. I forgot to update the internal reference for the files. Will work on that issue soon. Have caught a bug over the weekend, so it will not be today. The real update was some missing words that should have been included in the first place. I once had a spell checking

[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Andreas Säger
Am 09.07.2012 14:54, Dan wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? -- For unsubscribe instructions

Re: [libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Dan
Andreas Säger wrote: Am 09.07.2012 14:54, Dan wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? Probably

Re: [libreoffice-users] Re: LibreOffice won't save settings

2012-07-09 Thread Thomas Taylor
On Mon, 9 Jul 2012 09:12:46 -0700 (PDT) Don d...@law.pace.edu wrote about [libreoffice-users] Re: LibreOffice won't save settings: Miroslaw, Thanks for getting back to me so quickly. I think I'm up to date on the program since the first things I do every day are to use the Kpackage Manager

Re: [libreoffice-users] Re: LibreOffice won't save settings

2012-07-09 Thread Mirosław Zalewski
On 09/07/2012 at 18:12, Don d...@law.pace.edu wrote: Do you know which files I would need to change the permissions on? As I said, give ~/.config/libreoffice/3/user/registrymodifications.xcu a try. All changes are written to that file. It tends to grow in size over time. I believe changes

[libreoffice-users] Outline woes

2012-07-09 Thread Rahn Land
Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it works, the more confused I

Re: [libreoffice-users] Outline woes

2012-07-09 Thread Regina Henschel
Hi, Rahn Land schrieb: Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it

[libreoffice-users] Re: Outline woes

2012-07-09 Thread Rahn Land
I think I want to number headings by manipulating styles, but I am not sure. I don't understand the distinctions between the three. I want an outline system that uses styles, so that I can easily change or modify the format of multiple headings at once. I want it automatic in the sense that

Re: [libreoffice-users] Outline woes

2012-07-09 Thread Steve Edmonds
Hi On 10/07/12 6:40 AM, Rahn Land wrote: Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach

[libreoffice-users] Re: LibreOffice won't save settings

2012-07-09 Thread Andreas Säger
You have a macro and a toolbar button. Where is the macro stored? Globally or in a document? Where is the modified toolbar stored? Globally or in a document? -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487p3994541.html Sent from

Re: [libreoffice-users] Outline woes

2012-07-09 Thread lllact...@gmx.net
Hi Andy, OOo and derivatives like LO cannot do outlining. What LO does is an outline formatting with the Navigator, which is useless for outlining. Those who use outlining intensively will confirm that (see link below). It has been an issue for more than 10 years now. Use a real outliner; I

[libreoffice-users] Can't install Libre

2012-07-09 Thread Robert Ruff
This is the first time I've had any trouble installing Libre. I'm getting an installation error, 2755, 110 if I download the main file, and a 1305 error if I try to install from the torrent file. I'm using Windows 7 Home, just reinstalled it in the last week. I've not had any problems with any

Re: [libreoffice-users] Can't install Libre

2012-07-09 Thread Leif Lodahl
Hi, A quick search indicates that the folder where you store the installation file is encrypted. Try to set that folder to be not encrypted and start again. Cheers, Leif Lodahl Den 09/07/2012 23.06 skrev Jay Lozier jsloz...@gmail.com: Robert, On 07/09/2012 04:37 PM, Robert Ruff wrote: This

[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Gilles
Thanks everyone for the help. Turns out the error was due to my using a . instead of , as decimal separator. This works for me... =$C4 * 0,845 ... while this doesn't =$C4 * 0.845. -- View this message in context:

Re: [libreoffice-users] Re: Outline woes

2012-07-09 Thread Regina Henschel
Hi, Rahn Land schrieb: I think I want to number headings by manipulating styles, but I am not sure. I don't understand the distinctions between the three. I want an outline system that uses styles, so that I can easily change or modify the format of multiple headings at once. I want it

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Multiply percentage with fraction?

2012-07-09 Thread Brian Barker
At 18:55 09/07/2012 +0200, Andreas Säger wrote: At 08:54 09/07/2012 -0400, Dan Lewis wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any

Re: [libreoffice-users] Re: CALC - How to count blank cells?

2012-07-09 Thread Simon Cropper
On 09/07/12 20:35, Andreas Säger wrote: Am 09.07.2012 10:22, MiguelAngel wrote: El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells?