[libreoffice-users] Network Folders
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 around in the folder? 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. * Ian D. Samson http://www.lp2cd.za.net/index.htm* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Network Folders
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 - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Network Folders
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 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 - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- * Ian D. Samson http://www.lp2cd.za.net/index.htm* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Network Folders
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 all the marvellous crowd involved in it! On Wed, 28 Dec 2011 09:24:03 +0100, 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 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, -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Network Folders
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 the early 1980s and on the internet since 1990. On 28 December 2011 10:33, Heinrich Stoellinger hc.stoellin...@aon.atwrote: 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 all the marvellous crowd involved in it! On Wed, 28 Dec 2011 09:24:03 +0100, 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 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, -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- * Ian D. Samson http://www.lp2cd.za.net/index.htm* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Network Folders
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, but do not remember details right away. Cheers, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Paste into Draw
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 sheets so that they will fit to the margins of the page in Draw or Writer? If sohow? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc Writer Crash- Constantly
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. There is no urgent need for you to reply quickly. The thread gets bumped to the top of the list whenever you reply and people can see previous posts through things such as Nabble or perhaps GMane. It's just that crashing is an unusual problem and it's the sort of thing we would like to help fix quickly. Presumably it is just LibreOffice that crashes without taking the rest of the system down to a reboot? GnuLinux systems almost never crash due to a single app misbehaving but it's quite common in Windows. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Writer-Crash-Constantly-tp3615146p3616445.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Paste into Draw
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 same so i have to cancel and re-try sometimes. Pictures are handled similarly so perhaps it might work for pasted work-sheets too? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Paste-into-Draw-tp3616426p3616454.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] To sum only those values in a range that are between two number
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-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Fedora Libreoffice install problem
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. Hopefully someone else here is. Usually a package manager such as Add/remove programs has some sort of check for broken dependencies or fix broken packages or something like that. There are some other links you might find useful for Fedora generally. The DistroWatch site is excellent for finding the links and for comparing different distros against each other. Their page about Fedora ... http://distrowatch.com/table.php?distribution=fedora leads to the Fedora home-page http://fedoraproject.org/ and documentation http://docs.fedoraproject.org/en-US/index.html http://fedoraproject.org/wiki/Docs but more importantly to their official forums http://forums.fedoraforum.org/ Forums are good places to ask questions and get support about a wide-range of issues. There is a good one that covers a wide-range of different distros http://www.linuxquestions.org All good links to have bookmarked! Hmm, i bookmark the DW homepage rather than one for a specific distro as it's a good way to see what is going on elsewhere in GnuLinux-land (err BSD-land sometimes too). Anyway hopefully someone here might be able to help with a specific command for your distro or guide you through how to check/fix broken packages or something Good luck and regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Fedora-Libreoffice-install-problem-tp3615236p3616487.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Paste into Draw
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 forgetting to set the aspect ratio to stay the same so i have to cancel and re-try sometimes. Pictures are handled similarly so perhaps it might work for pasted work-sheets too? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Paste-into-Draw-tp3616426p3616454.html Sent from the Users mailing list archive at Nabble.com. Tom, I'm sort of confused. I don't know what you mean by your first sentence above? Do I create a table first? 'Don't really understand. Thanks. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base - Relationship issues
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 you to complete subscription to the main mailing list. Thanks, apols and regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Base-Relationship-issues-tp3616436p3616496.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: To sum only those values in a range that are between two number
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 doesn't give to me the right result.
--
Regards, Pal
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Paste into Draw
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 to re-size the pasted sheets so that they will fit to the margins of the page in Draw or Writer? If sohow? It depends on the document and on the target format. Draw: Calc8 -- OLE GDI -- Picture Use Format PositionSize. Or you single click the object and drag the green handles while pressing the Shift-key. RTF -- native Draw-table Single click the table and drag the handles. In Addition use the table properties to change the font size. Draw has no object size relative to page size. Only when you change the page settings, you can check to adapt the object sizes. Writer: Calc8 -- OLE Use Format Frame/Object. In tab Type check keep ratio, check width relative and set width to 100%. GDI -- Picture Use Format Picture, then same as above for OLE RTF -- native Writer-table Use the Table Properties, tab Table. Check width relative and set to 100%. HTML -- native Writer-table Nothing to do, table is already at width 100% Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] To sum only those values in a range that are between two number
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 formula:
=IF(AND(A124;A1=384);A1)
You see that little black square in lower right corner of cell border? When
you hover it, your mouse pointer will change into cross. Just grab that square
and drag it all way down column B to place where number in column A stops.
This will copy formula from cell B1 to B{number}, changing it's reference
number in column A.
Now you can simply use SUM function on column B.
One of disadvantages of this method is that AVERAGE function will not work
correctly. If you need average, you can use something like this:
=SUM(B1:B12)/COUNTIF(B1:B12; 0)
Hopefully there is simpler method someone will point out.
--
Best regards
Mirosław Zalewski
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: To sum only those values in a range that are between two number
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)
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616564.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - Relationship issues
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: http://nabble.documentfoundation.org/Base-Relationship-issues-tp3616436p3616436.html Sent from the Users mailing list archive at Nabble.com. I suggest you get Chapter 8 of the Getting Started Guide available at http://www.libreoffice.org/get-help/documentation/. Getting Started with Base is the chapter's name. It describes how to create relationships between tables using a primary-foreign key pairs. Briefly, The field that is at the 1 end of the 1:n relationship must be the primary key of its table. The second table must have a field with the same attributes as the primary key with the except that this field does not have AutoValue set to Yes. This field in the second table is the foreign key. Once the tables have been created, Use Tools Relationships to create the relationship between the two fields. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Python info for a new learner
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 are slightly different, so see what version of Python you're going to use, and get the correct book. 150 pages, including an index--use your duplex printer! (I'm running PCLinuxOS, and the current repo has both versions of Python available.) The book I have says Linux Edition--I downloaded it from a Linux machine. There must be another edition for some other OS, don't know what. I don't remember the URL, you'll have to Google for it. The introduction in Chapter 1 indicates that there might also be a print version--maybe O'Reilly? --doug Thanks for the info. It does not look like the site I found was updated since 2009. I have Python 2.x and 3.x loaded on my Ubuntu 10.04 desktop and I will use 2.7.2? on my XP and Vista laptops. I was told that more things support 2.7.x, but I could be wrong. I wonder what version of Python LibreOffice is written in? I will have to switch to that after my initial learning of Python. I was asked the question about would I be interested in helping the Dev project with some simple Python stuff. If I decide to really learn beyond my needs for Python, I will see how complex the programming is before I decide to get in to Python that far. I have not done any real programming in years, and complex programming in 15-20 years. That complex stuff was before my last two strokes. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: To sum only those values in a range that are between two number
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
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 understand it well.
Sorry.
Thanks again, Gérard!
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616606.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Paste into Draw
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 in Draw or Writer. Is there a simple and quick way to re-size the pasted sheets so that they will fit to the margins of the page in Draw or Writer? If sohow? It depends on the document and on the target format. Draw: Calc8 -- OLE GDI -- Picture Use Format PositionSize. Or you single click the object and drag the green handles while pressing the Shift-key. RTF -- native Draw-table Single click the table and drag the handles. In Addition use the table properties to change the font size. Draw has no object size relative to page size. Only when you change the page settings, you can check to adapt the object sizes. Writer: Calc8 -- OLE Use Format Frame/Object. In tab Type check keep ratio, check width relative and set width to 100%. GDI -- Picture Use Format Picture, then same as above for OLE RTF -- native Writer-table Use the Table Properties, tab Table. Check width relative and set to 100%. HTML -- native Writer-table Nothing to do, table is already at width 100% Kind regards Regina Wow...you folks are really smart! Here's how I solved the problem with all of your help; In Writer- Paste the Calc sheet into Writer Right click on the pasted in sheet and select Picture Select the first tab which is Type Adjust the Size so that the sheet will fit loosely between the page's margins Under Position change the Horizontal and Vertical so that the sheet is Centered..to..The Entire Page Thank you everyone -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] To sum only those values in a range that are between two number
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.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Font bug
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.documentfoundation.org/file/n3616834/hg.png thanks -- View this message in context: http://nabble.documentfoundation.org/Font-bug-tp3616834p3616834.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - Relationship issues
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 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-issues-tp3616436p3616436.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: To sum only those values in a range that are between two number
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 understand it
well. Sorry.
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 count cells with the given conditions if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26=8;'O.tanácsi f.év'.Z7:Z26=17)
* =SUMPRODUCT(condition1;condition2)*
condition1 and condition2 are arrays too.
As one can see in the LO Help, SUMPRODUCT multiplies corresponding elements
in the given arrays, and returns the sum of those products.
I'm trying to understand SUMPRODUCT considering this case abowe. Is there
something more to be added to this explanation?
Thanks!
Pál
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616853.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Cell formatting with CSV files in Calc
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 purpose (pivot-tables are most important), so a real RDBMS would be far too complex for my requirements. Concerning the file format, CSV files have the huge advantage of being * a single file, * small, * and plain text files. (Tom has already pointed out some of that.) Especially the last point is important, since you can check text files into version control and diff them. This would require far more efforts with a binary format like ODS (always (de-)compressing might me scriptable, but that's too cumbersome for me). So much for my motivation. :-) Cheers berntie -- View this message in context: http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3616866.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: To sum only those values in a range that are between two number
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 count cells with the given conditions if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26=8;'O.tanácsi f.év'.Z7:Z26=17)
* =SUMPRODUCT(condition1;condition2)*
condition1 and condition2 are arrays too.
As one can see in the LO Help, SUMPRODUCT multiplies corresponding elements
in the given arrays, and returns the sum of those products.
I'm trying to understand SUMPRODUCT considering this case abowe. Is there
something more to be added to this explanation?
Yes. The part 'O.tanácsi f.év'.Z7:Z26=8 results in an internal array of
boolean and in LibreOffice boolean is not an own data type, but it is
used as number with TRUE = 1 and FALSE = 0. Therefore the product table
first operand second operand product
1 (=TRUE) 1 (=TRUE)1 (=TRUE)
1 (=TRUE) 0 (=FALSE) 0 (=FALSE)
0 (=FALSE) 1 (=TRUE)0 (=FALSE)
0 (=FALSE) 0 (=FALSE) 0 (=FALSE)
is the table of logical AND at the same time.
And because multiplying with 0 results in 0 only those entries, which
are multiplied with 1, are count in the summing up.
Kind regards
Regina
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc
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 provides all the features I need for that purpose (pivot-tables are most important), so a real RDBMS would be far too complex for my requirements. Concerning the file format, CSV files have the huge advantage of being * a single file, * small, * and plain text files. ... If you prefer to edit plain text file and process its data in Calc, you have two other ways: 1) do not import the file. Simply copy the text in which the Tabs are the delimiters and then Paste as unformatted text into the pre-formatted sheet - there is an icon in the toolbar for it. 2) Create an extra sheet (name it e.g. CSV) which is linked to your external regular csv file. In your main sheet (name it e.g. DATA) and put everywhere formulas (e.g. in DATA.A1 enter =CSV.A1) Then format cells in DATA as you need. Define your pivot tables source area big enaugh to cover future hundereds of rows :) Regards, Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Font bug
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 seemed to appear normal. http://nabble.documentfoundation.org/file/n3616834/hg.png thanks I would try scrolling down then up to see if the font size corrects itself. I have seen this with other software on occasion and I think it is the video rendering system getting confused. If I remember correctly I saw this most when I was scrolling rapidly through the document. If you close and reopen the file, does the problem disappear? -- View this message in context: http://nabble.documentfoundation.org/Font-bug-tp3616834p3616834.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cell formatting with CSV files in Calc
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 once understood and set. It may be best to separate the EUR to a different field/column. Then use some form of if statement in Calc to format your numbers in column A based on column B. (This part has not been tested by me.) It may not be very elegant, but because your data set is consistent, may temporarily answer your problem. On 12/3/2011 3:05 PM, berntie wrote: Hi, I'm having an issue with cell formatting in CSV files. Consider the following simple CSV file (should be self explanatory): Date;Item;Amount 01.12.2011;New laptop;-1.000,00 02.12.2011;Glass of beer;-3,00 (I'm using a German locale, so the comma is the decimal spearator.) If you import that into Calc and format the date column with a rule like TT. and the amount column as a currency with a rule like #.##0,00 [$EUR];[ROT]-#.##0,00 [$EUR], then everything works fine (negative amounts are red etc.) Save the CSV file and you end up with Date;Item;Amount Donnerstag, 01. Dezember 2011;New laptop;-1.000,00 EUR Freitag, 02. Dezember 2011;Glass of beer;-3,00 EUR in the file. Now open that file again with Calc and try to format the amount column with the same rule: fail. New entries are formatted correctly, but not existing entries. It works for the date column if you select date as the column type in the import dialog, but you cannot choose currency as column type. I'm tempted to think that this is either a missing feature (no column type currency in the import dialog) or incorrect saving/exporting behavior by Calc (the cell format should only affect how the values are displayed, not how they are stored in the file). So, what should I do: * File a bug/feature request? If yes, where can I do that? * Work around the issue? What would that workaround be?? * Or am I using Calc the wrong way? Any suggestions appreciated... Thanks, Bernhard -- View this message in context: http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3557689.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fedora Libreoffice install problem
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 office systems and I ould be most grateful for any help that you can give. Regards Clinton Lucas -- View this message in context: http://nabble.documentfoundation.org/Fedora-Libreoffice-install-problem-tp3615236p3615236.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fedora Libreoffice install problem
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 application that I get the error. I am new to Linnux and open office systems and I ould be most grateful for any help that you can give. Regards Clinton Lucas -- View this message in context: http://nabble.documentfoundation.org/Fedora-Libreoffice-install-problem-tp3615236p3615236.html Sent from the Users mailing list archive at Nabble.com. Which version of LO are you using, I am assuming 3.4.4? Check to see that you are installing the correct architecture (32or 64 bit). The 32 bit is sometimes called x86. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fedora Libreoffice install problem
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 get more descriptive error dumps. - from twohot@device.mobile :) -Original Message- From: Clinton Lucas clintonluc...@gmail.com Date: Tue, 27 Dec 2011 14:54:42 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Fedora Libreoffice install problem 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 office systems and I ould be most grateful for any help that you can give. Regards Clinton Lucas -- View this message in context: http://nabble.documentfoundation.org/Fedora-Libreoffice-install-problem-tp3615236p3615236.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fedora Libreoffice install problem
-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 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 office systems and I ould be most grateful for any help that you can give. Regards Clinton Lucas -- View this message in context: http://nabble.documentfoundation.org/Fedora-Libreoffice-install-problem-tp3615236p3615236.html Sent from the Users mailing list archive at Nabble.com. Which version of LO are you using, I am assuming 3.4.4? Check to see that you are installing the correct architecture (32or 64 bit). The 32 bit is sometimes called x86. Assuming (as much as I hate to use that word) he is using the package manger in Fedora then it should install the correct arch which is determined by the arch of the OS. That would also be version 3.4.4 as that is what is in the Fedora repos. Clinton, does this happen when you first launch a LO app from you menu or icon? I presume that the error is in a dialogue box as well? You may want to open a terminal and enter the appropriate command for the app you want to launch and see what gets outputted to the terminal prior to this message. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQIcBAEBAgAGBQJO+96ZAAoJEIefqZ0kni1df74P/jRiIH+X9tIHnGNaFEAn8r1t M5+bk7pWiJvjpMiyLGd4j1oc0GuQC+gcOfRmzAEta7INMr1OLQvKsNqf7L39dn2v Xli0bIEfqDgY0SUOJaB//BRcNkikwKcaAxF6zh0HzyTwTLtc+jvFJRBdC/f2BBQu U+jUhrGpfyTQAnyJjv7Ftynw7uv7CFCoWdou7zYjzKMPcVa01nKLyWuoEdnXAuEE movWFpv22WORyKI8ykoqZSkFGtquxdagrfWKH1cuFmxx9ClSmEj/KHjMWX1jAx13 onYCZXphV39iyDI+8V8DN6AZagWM+uQ9Jo4Nxp8ZW+m3FYkqS3L1e7FU8mGIDAu7 7QAX+A52yYiKmPLg4uAgLLQQnM34ZvbPHFauj8RSQgMaXDDClOVO+Qtf/VGmTATk uiD5EO8YuGlJf9S2mg50Avv08eqp9ugS1qt8REb59QS/BLnfg4I6dQ5lIJoWOi+E 3YQX32adUUNj9mAdqXNMhNN0vqI+Qh74W0Zjmtu/CXOgpvTs+qGEFNY84uuEyUkV QDrm51KDDwFewJvVkq50bcAup+7wBoySEymVIHTLTK2kBKecmzxwrw/hiZCajpnR IXKpbG3LO3fOkRt+9wTE4MVnmQvtSLOLFxwWqJPyef7Sc+kEdEHBDa/iF9tjiaCa sSM/WCa+UwH09aeo8Jg1 =iOak -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
