[libreoffice-users] I need help with functions in Base
Hello I'm starting with queries and functions. Right now I know how to tackle queries, but I don't know very well how may I use functions on queries. I would like to master all functions, so I need examples with functions. The problem is I don't know where may I find help with this? *I'd like to see samples about these functions*: Average, Count, Maximum, Minimum, Sum, Every, Any, Some, STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection, Group Sadly I don't have seen any documentation from LibreOffice explaining every function with a sample. Please, could someone give me some examples for these functions? I'd like to see them working and what everyone do. Cheers -- View this message in context: http://nabble.documentfoundation.org/I-need-help-with-functions-in-Base-tp4143633.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: I need help with functions in Base
Am 18.03.2015 um 16:00 schrieb xavier2: Hello I'm starting with queries and functions. Right now I know how to tackle queries, but I don't know very well how may I use functions on queries. I would like to master all functions, so I need examples with functions. The problem is I don't know where may I find help with this? *I'd like to see samples about these functions*: Average, Count, Maximum, Minimum, Sum, Every, Any, Some, STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection, Group Sadly I don't have seen any documentation from LibreOffice explaining every function with a sample. Please, could someone give me some examples for these functions? I'd like to see them working and what everyone do. Cheers The availlable functions depend on the type database you are connected to. The bare minimum of functions in the file based databsaes (spreadsheet, text, dBase) is documented here: http://www.openoffice.org/dba/specifications/file_based_functions.html File based databases support only one aggregation COUNT(*) The built-in HSQL 1.8 (which should better not be used embedded into the Base document) is documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html Any resource on SQL can teach you how to use all these functions properly, particularly the aggregation funcions together with GROUP. [Tutorial] Calculations in databases (quick primer) https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=26328 -- To unsubscribe e-mail to: users+unsubscr...@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] ErrorCodeIOException: SfxBaseModel::impl_store failed
Hi, It comes with the exception randomly as below when I use jodconverter to convert a ppt file to pdf format. Sometimes the conversion succeed, but sometimes failed. I wonder what factor or parameters may influence it. I search the problem on the internet but get nothing ;( Help me! Exception in thread Thread-18 org.artofsolving.jodconverter.office.OfficeException: could not store document: ppt17.pdf; errorCode: 283 at org.artofsolving.jodconverter.AbstractConversionTask.storeDocument( AbstractConversionTask.java:119) at org.artofsolving.jodconverter.AbstractConversionTask.execute( AbstractConversionTask.java:55) at org.artofsolving.jodconverter.office.PooledOfficeManager$2.run( PooledOfficeManager.java:75) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run( ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: com.sun.star.task.ErrorCodeIOException: SfxBaseModel::impl_store file:///Users/kj/Documents/jh/file/libreoffice/testfiles/ppt17.pdf failed: 0x11b at com.sun.star.lib.uno.environments.remote.Job.remoteUnoRequestRaisedException( Job.java:161) at com.sun.star.lib.uno.environments.remote.Job.execute(Job.java:125) at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:319 ) at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:288 ) at com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter( JavaThreadPool.java:80) at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest( java_remote_bridge.java:619) at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request( ProxyFactory.java:142) at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke( ProxyFactory.java:123) at $Proxy7.storeToURL(Unknown Source) at org.artofsolving.jodconverter.AbstractConversionTask.storeDocument( AbstractConversionTask.java:117) ... 8 more Thanks in advance! Mofei -- To unsubscribe e-mail to: users+unsubscr...@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: I need help with functions in Base
Am 18.03.2015 um 23:10 schrieb xavier2: Hi Andreas, thanks for the amazing info you gave me. Well, I was not meaning to SQL, because what I want to do right now are queries using the gird, the queries window. The grid (do you mean the design view?) creates an SQL statement as you can see when you toggle between the design view and SQL view. There is a toggle option in the menu and on the toolbar. The query designer does a very bad job. It is almost useless because it can only produce baby-SQL. Within a weekend you learn much more SQL than that tool will ever be able to handle. I can demonstrate lots of working queries that are messed up completely once you load them into the design view. I wanted some examples of this, with already created queries. Exactly the last link you gave me... https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=26328 On the linked forum you find dozends of example files with all kinds of calculations. However, I need a bit more: I would need help to understand these functions: *STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection* STDEV is the standard deviation, VAR stands for VARIATION, POP for a full population, STDDEV for a sample, I don't know about Collect, Fusion and Intersection. You might find them in SQL tutorials. -- To unsubscribe e-mail to: users+unsubscr...@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: Business Cards - Printing - Libre Writer version 4.3.5.2
There is a program called gLabels. I use it to create mailing labels. Re: business cards, I would avoid laser, as business cards are usually stacked together, so they rub. They will wear off the laser toner. Ink is soaked into the paper so it won't come off. That would interfere with the image that you are trying to create. John On 03/15/2015 04:31 AM, Andreas Säger wrote: Am 15.03.2015 um 01:18 schrieb charles meyer: Hi Folks, I’ve never printed business cards using Libre Writer and it didn’t go well using the Avery online template. I have blank sheets of cardstock (bought at Office Depot) to print my own business cards with logo - one sided only. There’s 10 business cards on each sheet of cardstock - 2 across and 5 down. Each card is 2 inches by 3.5 inches. Is there some kind of a template in Libre Writer for business card printing? I’ll bet you can do it by using tables or charts but that’s way past my expertise. Thanks so much! Charles. Hi, menu:FileNewBusiness Cards... Fill out that dialog and LibreOffice will generate a page with separate frames representing the space of one card. --- If you want to use one of the downloadable templates from various sites, these have basically one table without borders. Each cell represents the space of a business card. Right-click and check Table Boundaries to make the cells visible on screen but not on the print out. Now you can edit a single table cell to your liking, copy the cell content and paste into each cell. Hope this helps -- To unsubscribe e-mail to: users+unsubscr...@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: Multiple Tables In Writer Document
Hi Frank, That’s interesting and useful but this is a dynamic document. Tables may have to be changed frequently without deleting content. Thanks for the reply, Steve On Mar 18, 2015, at 3:25 PM, CVAlkan [via Document Foundation Mail Archive] ml-node+s969070n4143666...@n3.nabble.com wrote: Hi - The way I do this is to simply copy the table I want to mimic. Table | Select | Table | Ctrl+C Then paste it at the location I want. Ctrl+V Then select the pasted table. Table | Select | Table Then press the Delete key. You might think this would delete the table, but it just deletes the contents, leaving styles, backgrounds, borders and things all the same. It will also keep the repeat rows for header property as well. For tables that will repeat a lot, thia is much easier. It would be nice to have table styles, but I personally would rather have the developers working on the serious regression bugs that exist. I hope this makes life a little easier. Frank If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html To unsubscribe from Multiple Tables In Writer Document, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4143458code=c3RldmVAaGFycHNlcnZpY2VzLmNvbXw0MTQzNDU4fDE3NjcwNjY2NjM=. NAML http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143667.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: I need help with functions in Base
Hi Andreas, thanks for the amazing info you gave me. Well, I was not meaning to SQL, because what I want to do right now are queries using the gird, the queries window. I wanted some examples of this, with already created queries. Exactly the last link you gave me... https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=26328 Is very useful, because it has queries, created with several functions. What I am looking for is exactly, that. However, I need a bit more: I would need help to understand these functions: *STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection* Those functions are like a mistery. I don't know where may I found information about what every one of them do exactly. Could you give me an .odb file with some queries, showing examples for these functions? Cheers -- View this message in context: http://nabble.documentfoundation.org/I-need-help-with-functions-in-Base-tp4143633p4143701.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: Multiple Tables In Writer Document
Hi Tom, My platform is OS X. I only use Mac or Linux and avoid Windows like the plague. Yes. I know that ODF is basically just a zip file. Steve On Mar 18, 2015, at 5:12 PM, Tom Davies tomc...@gmail.com wrote: Hi :) Did you let us know which Operating System? Is it Windows 7? or could you let us know just the platform, such as Windows, Linux, Mac or BSD? Yes, this is no good as a long-term solution to your particular requirements - but it might be a good temporary work-around for right now giving you time to look into other ways of doing the job. Just a bit of brain-storming ... * Would Base's Forms or Reports be a better way of doing this? * How about using html? * If there is not much text between tables then Calc might be useful and much simpler. * Might it be possible to work on the xml inside the .Odt container format? [1] * In CV Alkan's answer does Ctrl x (or other way of doing a Cut) have the same effect and can the contents of the table then be pasted into a new table without altering it's layout? * Again, could Frank's method be adapted using Ctrl Shift v (or other way of doing paste special) to paste and does that neatly replace the original table with the new layout? [1] You know that if you rename the file-ending from .odt to .zip then you can open it as a zip-file. Inside there are some folders and xml files and things. Of course it is usually best to create a copy of the original file and do the renaming and other work on the back-up jic something goes wrong while you experiment with it. Regards from Tom :) On 18 March 2015 at 19:30, fang st...@harpservices.com mailto:st...@harpservices.com wrote: Hi Frank, That’s interesting and useful but this is a dynamic document. Tables may have to be changed frequently without deleting content. Thanks for the reply, Steve On Mar 18, 2015, at 3:25 PM, CVAlkan [via Document Foundation Mail Archive] ml-node+s969070n4143666...@n3.nabble.com mailto:ml-node%2bs969070n4143666...@n3.nabble.com wrote: Hi - The way I do this is to simply copy the table I want to mimic. Table | Select | Table | Ctrl+C Then paste it at the location I want. Ctrl+V Then select the pasted table. Table | Select | Table Then press the Delete key. You might think this would delete the table, but it just deletes the contents, leaving styles, backgrounds, borders and things all the same. It will also keep the repeat rows for header property as well. For tables that will repeat a lot, thia is much easier. It would be nice to have table styles, but I personally would rather have the developers working on the serious regression bugs that exist. I hope this makes life a little easier. Frank If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html To unsubscribe from Multiple Tables In Writer Document, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4143458code=c3RldmVAaGFycHNlcnZpY2VzLmNvbXw0MTQzNDU4fDE3NjcwNjY2NjM= http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4143458code=c3RldmVAaGFycHNlcnZpY2VzLmNvbXw0MTQzNDU4fDE3NjcwNjY2NjM=. NAML http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143667.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143667.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Re: [libreoffice-users] Re: Multiple Tables In Writer Document
Hi :) Did you let us know which Operating System? Is it Windows 7? or could you let us know just the platform, such as Windows, Linux, Mac or BSD? Yes, this is no good as a long-term solution to your particular requirements - but it might be a good temporary work-around for right now giving you time to look into other ways of doing the job. Just a bit of brain-storming ... * Would Base's Forms or Reports be a better way of doing this? * How about using html? * If there is not much text between tables then Calc might be useful and much simpler. * Might it be possible to work on the xml inside the .Odt container format? [1] * In CV Alkan's answer does Ctrl x (or other way of doing a Cut) have the same effect and can the contents of the table then be pasted into a new table without altering it's layout? * Again, could Frank's method be adapted using Ctrl Shift v (or other way of doing paste special) to paste and does that neatly replace the original table with the new layout? [1] You know that if you rename the file-ending from .odt to .zip then you can open it as a zip-file. Inside there are some folders and xml files and things. Of course it is usually best to create a copy of the original file and do the renaming and other work on the back-up jic something goes wrong while you experiment with it. Regards from Tom :) On 18 March 2015 at 19:30, fang st...@harpservices.com wrote: Hi Frank, That’s interesting and useful but this is a dynamic document. Tables may have to be changed frequently without deleting content. Thanks for the reply, Steve On Mar 18, 2015, at 3:25 PM, CVAlkan [via Document Foundation Mail Archive] ml-node+s969070n4143666...@n3.nabble.com wrote: Hi - The way I do this is to simply copy the table I want to mimic. Table | Select | Table | Ctrl+C Then paste it at the location I want. Ctrl+V Then select the pasted table. Table | Select | Table Then press the Delete key. You might think this would delete the table, but it just deletes the contents, leaving styles, backgrounds, borders and things all the same. It will also keep the repeat rows for header property as well. For tables that will repeat a lot, thia is much easier. It would be nice to have table styles, but I personally would rather have the developers working on the serious regression bugs that exist. I hope this makes life a little easier. Frank If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143666.html To unsubscribe from Multiple Tables In Writer Document, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4143458code=c3RldmVAaGFycHNlcnZpY2VzLmNvbXw0MTQzNDU4fDE3NjcwNjY2NjM= . NAML http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer-Document-tp4143458p4143667.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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