[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

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 -

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 oo...@nouenoff.nl wrote: Hi Ian, Ian Samson wrote (28-12-11 09:20) I run LibreOffice on 3 of my computers and will need to

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

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

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,

[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

[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-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] 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?

[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.

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: 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

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

2011-12-28 Thread Csanyi Pal
Csanyi Pal csanyi...@gmail.com 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:Y2625;'O.tanácsi f.év'.Y7:Y26=384)) but that

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

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 csanyi...@gmail.com 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

[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:Y2625;'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:Y2625;'O.tanácsif.év'.Y7:Y26=384) Gérard (again) --

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 context:

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

2011-12-28 Thread webmaster for Kracked Press Productions
snip 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

[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:Y2625;'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] 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 the margins

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:

[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.

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] 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:Y2625;'O.tanácsif.év'.Y7:Y26=384) Gérard (again) No, I didn't forget it, but it seems that that I didn't

[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

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

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

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

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

[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 open

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

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 Add/Remove