Re: [libreoffice-users] Fedora Libreoffice install problem

2011-12-28 Thread Onyeibo Oku
Sad to hear that. Describe what you did during the installation? I'm not a fan of "add and remove" in Linux (not because its a bad idea, but because its not as effective as the good old yum command running on the terminal) "Not Supported?" Try running LibreOffice from terminal to see if you can

Re: [libreoffice-users] Fedora Libreoffice install problem

2011-12-28 Thread Scott Castaline
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/28/2011 05:08 PM, Jay Lozier wrote: > Clinton > > On 12/27/2011 05:54 PM, Clinton Lucas wrote: >> Having installed Libreoffice on Fedora 16, I get and error: >> "This operation not supported on this operating system". I >> installed using the "

Re: [libreoffice-users] Fedora Libreoffice install problem

2011-12-28 Thread Jay Lozier
Clinton On 12/27/2011 05:54 PM, Clinton Lucas wrote: Having installed Libreoffice on Fedora 16, I get and error: "This operation not supported on this operating system". I installed using the "Add/Remove software" application and all seemed to work fine". It is only when I try to run the appli

[libreoffice-users] Fedora Libreoffice install problem

2011-12-28 Thread Clinton Lucas
Having installed Libreoffice on Fedora 16, I get and error: "This operation not supported on this operating system". I installed using the "Add/Remove software" application and all seemed to work fine". It is only when I try to run the application that I get the error. I am new to Linnux and ope

Re: [libreoffice-users] Cell formatting with CSV files in Calc

2011-12-28 Thread Paul D. Mirowsky
I work with csv/txt in Writer as a filter function. I substitute commas for spaces, insert commas for field separation and add missing column information. It is very fast and have set up recording macros to do it based on the original files Calc import problems. Not pleasant, but works well o

Re: [libreoffice-users] Font bug

2011-12-28 Thread Jay Lozier
On 12/28/2011 12:13 PM, Disintegrati wrote: hello, I'm using windows 7 and the latest version of libreoffice (3.4.4). i encountered a small bug while making a doc, the display shows two sizes of fonts, even though they are actually the same. when i uploaded the same on google docs, the text seeme

Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc

2011-12-28 Thread Ing. Jiří Hladůvka
Dne 28.12.2011 18:28, berntie napsal(a): Jay Lozier wrote What are you actually trying to do? It sounds like your trying do something that a database may be better at doing. I'm just trying to keep some kind of record of my daily expenses. While there's some hassle involved, LibreOffice provide

Re: [libreoffice-users] Re: To sum only those values in a range that are between two number

2011-12-28 Thread Regina Henschel
Hi Pál, csanyipal schrieb: So if I understand well, SUMPRODUCT in this case will summarize values of cells in an array if we gives the formula: =SUMPRODUCT('O.tanácsi f.év'.Z7:Z26;'O.tanácsi f.év'.Z7:Z26>=8;'O.tanácsi f.év'.Z7:Z26<=17) *=SUMPRODUCT(array;condition1;condition2)* but will only

[libreoffice-users] Re: Cell formatting with CSV files in Calc

2011-12-28 Thread berntie
Jay Lozier wrote > > What are you actually trying to do? It sounds like your trying do > something that a database may be better at doing. I'm just trying to keep some kind of record of my daily expenses. While there's some hassle involved, LibreOffice provides all the features I need for that p

[libreoffice-users] Re: To sum only those values in a range that are between two number

2011-12-28 Thread csanyipal
csanyipal wrote > > Hi Gérard, > > > Gérard Fargeot wrote >> >> Hi Pal, >> >> Did you forget the "magic" function SUMPRODUCT ? >> >> =SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi >> f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384) >> >> Gérard (again) >> > No, I didn't forget it, but it seems

Re: [libreoffice-users] Base - Relationship issues

2011-12-28 Thread Fernand Vanrie
Op 28/12/2011 14:55, HRdesigner schreef: One or more off your tables has no primery key or the fields you use to make the relationship is not indexed ? hope it helps fernand I am creating a database to track employee information I have a 1:n relationship and I always get a "generate foreign

[libreoffice-users] Font bug

2011-12-28 Thread Disintegrati
hello, I'm using windows 7 and the latest version of libreoffice (3.4.4). i encountered a small bug while making a doc, the display shows two sizes of fonts, even though they are actually the same. when i uploaded the same on google docs, the text seemed to appear normal. http://nabble.documentfoun

Re: [libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Regina Henschel
Hi, Csanyi Pal schrieb: Hi, I'm trying to sum only those values in a range that are in the same time greater than 25 and lower or equal than 384. How can I do that? =SUMIF(range;"<=384") - SUMIF(range;"<=25") Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global

Re: [libreoffice-users] Paste into Draw

2011-12-28 Thread .
On 12/28/2011 09:51 AM, Regina Henschel wrote: > Hi ??? > > . schrieb: >> Many of the Calc sheets I work on get pasted into Draw (or Writer) using >> the Paste Special-> Calc8 or GDI options. >> >> It takes some time to resize the sheets I'm pasting into Draw or Writer >> so that they fit to

[libreoffice-users] Re: To sum only those values in a range that are between two number

2011-12-28 Thread csanyipal
Hi Gérard, Gérard Fargeot wrote > > Hi Pal, > > > >> I'm trying with this formula: >> {=SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi >> f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384))} >> > > Did you forget the "magic" function SUMPRODUCT ? > > =SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi

Re: [libreoffice-users] Python info for a new learner

2011-12-28 Thread webmaster for Kracked Press Productions
On 12/27/2011 12:48 PM, doug wrote: There is a free book called "Snake Wrangling for Kids, Learning to Program with Python," by Jason R. Briggs. It's not just for kids, and it doesn't "talk down." Downloadable. There are apparently two current versions of Python, ver 2.x and 3.x. The books

Re: [libreoffice-users] Base - Relationship issues

2011-12-28 Thread Dan Lewis
On Wed, 2011-12-28 at 05:55 -0800, HRdesigner wrote: > I am creating a database to track employee information I have a 1:n > relationship and I always get a "generate foreign key" error no mater how I > go about creating it. How do I create a Foreign Key? Thanks. > > -- > View this message in co

[libreoffice-users] Re: To sum only those values in a range that are between two number

2011-12-28 Thread Gérard Fargeot
Hi Pal, > I'm trying with this formula: > {=SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi > f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384))} > Did you forget the "magic" function SUMPRODUCT ? =SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384) Gérard (ag

Re: [libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Mirosław Zalewski
On 28/12/2011 at 15:18, Csanyi Pal wrote: > I'm trying to sum only those values in a range that are in the same time > greater than 25 and lower or equal than 384. > > How can I do that? You can use extra column. Let's say in column A you have some numbers. In column B enter formula: =IF(AND(

Re: [libreoffice-users] Paste into Draw

2011-12-28 Thread Regina Henschel
Hi ??? . schrieb: Many of the Calc sheets I work on get pasted into Draw (or Writer) using the Paste Special-> Calc8 or GDI options. It takes some time to resize the sheets I'm pasting into Draw or Writer so that they fit to the margins in Draw or Writer. Is there a simple and quick way t

[libreoffice-users] Re: To sum only those values in a range that are between two number

2011-12-28 Thread Csanyi Pal
Csanyi Pal writes: > I'm trying to sum only those values in a range that are in the same time > greater than 25 and lower or equal than 384. I'm trying with this formula: =SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi f.év'.Y7:Y26>25;'O.tanácsi f.év'.Y7:Y26<=384)) but that doesn't give to me th

Re: [libreoffice-users] Re: Paste into Draw

2011-12-28 Thread Tom Davies
Hi :) After you have pasted the worksheet into Draw or whatever can you right-click on it and choose "Object"?  The first tab might allow you to set the size of the embedded object? Regards from Tom :) --- On Wed, 28/12/11, . wrote: From: . Subject: Re: [libreoffice-users] Re: Paste into Dra

[libreoffice-users] Base - Relationship issues

2011-12-28 Thread HRdesigner
I am creating a database to track employee information I have a 1:n relationship and I always get a "generate foreign key" error no mater how I go about creating it. How do I create a Foreign Key? Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Relationship-is

[libreoffice-users] Re: Base - Relationship issues

2011-12-28 Thread Tom
Hi :) Another person whose post has not reached the mailing list yet. HRDesigner please complete registration/subscription to the mailing-list. You can choose the "nomail" option so that you can view through Nabble and perhaps just subscribe to a single thread through Nabble but that still needs

Re: [libreoffice-users] Re: Paste into Draw

2011-12-28 Thread .
On 12/28/2011 09:08 AM, Tom wrote: > Hi :) > Can you do the same thing that you can with pictures or frames? With frames > you can right-click on the picture, choose "frame" from the context menu > that pops-up and then the first tab allows you to type in numbers to set the > frame size. I keep

[libreoffice-users] Re: Fedora Libreoffice install problem

2011-12-28 Thread Tom
Hi :) The question doesn't seem to have reached the lists yet so i think you need to complete the subscription to the mailing list. There is possibly a mail in your inbox (or perhaps junk folder if you are unlucky) that might help. I'm not familiar enough with Fedora to be able to help much. Ho

[libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Csanyi Pal
Hi, I'm trying to sum only those values in a range that are in the same time greater than 25 and lower or equal than 384. How can I do that? -- Regards, Pal -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lis

[libreoffice-users] Re: Paste into Draw

2011-12-28 Thread Tom
Hi :) Can you do the same thing that you can with pictures or frames? With frames you can right-click on the picture, choose "frame" from the context menu that pops-up and then the first tab allows you to type in numbers to set the frame size. I keep forgetting to set the aspect ratio to stay the

[libreoffice-users] Re: Calc & Writer Crash- Constantly

2011-12-28 Thread Tom
Hi :) please let us know how it goes with any of the advice so far or if you find your own way. It might help generate other ideas on how to solve the issue. In one forum a certain persons 1st answer is to do an md5sum check on the installer but that is less likely to be an issue with LibreOffice

[libreoffice-users] Paste into Draw

2011-12-28 Thread .
Many of the Calc sheets I work on get pasted into Draw (or Writer) using the Paste Special-> Calc8 or GDI options. It takes some time to resize the sheets I'm pasting into Draw or Writer so that they fit to the margins in Draw or Writer. Is there a simple and quick way to re-size the pasted s

Re: [libreoffice-users] Network Folders

2011-12-28 Thread Cor Nouws
Hi Ian, Ian Samson wrote (28-12-11 09:29) Oh wow! Thank you so much Cor. I did not know that. Now that I unchecked the option, now I see the Windows folders. Many thanks. Great that this helps. IIRC there is also the option in the other dialog to access volumes/paths via the icon top-right, b

Re: [libreoffice-users] Network Folders

2011-12-28 Thread Ian Samson
It's all sorted, Heinrich, thank you, and the same Happy New Year to you all too. I'm running Vista 64-bit desktop, XP-Home Desktop, Windows 2000 Desktop, and two Vista Business 32 HP Laptops. I created my own home network via Ethernet, Router, Wireless Networking, etc. I have worked with PCs since

Re: [libreoffice-users] Network Folders

2011-12-28 Thread Heinrich Stoellinger
Hi Ian, What operating system do your PCs run under? I use both Linux and Windows-Vista. On both systems I mount the respective file systems (e.g. through fstab in Linux). Then the files can be accessed like any other, local file. Regards Heinrich P.S.: --- and a Happy New Year to LibreOffice and

Re: [libreoffice-users] Network Folders

2011-12-28 Thread Ian Samson
Oh wow! Thank you so much Cor. I did not know that. Now that I unchecked the option, now I see the Windows folders. Many thanks. On 28 December 2011 10:24, Cor Nouws wrote: > Hi Ian, > > Ian Samson wrote (28-12-11 09:20) > > > I run LibreOffice on 3 of my computers and will need to have a Netw

Re: [libreoffice-users] Network Folders

2011-12-28 Thread Cor Nouws
Hi Ian, Ian Samson wrote (28-12-11 09:20) I run LibreOffice on 3 of my computers and will need to have a Network Dialog without the need to type in the long target name. Does is help to change the dialog via Tools > Options > LibreOffice > General , 2nd section ? Regards, -- - Cor - htt

[libreoffice-users] Network Folders

2011-12-28 Thread Ian Samson
Hello all, When I start LibreOffice and I wish to open a file on one of my 4 networked computers, I simply cannot do this as there is no dialog for networks. I can type in the \\server\drive\folder\document path, but without first having mapped a network drive to that directory, how can I move arou