[libreoffice-users] Autofilter sorting bug
I ran into a bug today, and it seems to be reported already: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=35294#add_comment Last comment was: ”Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian” The bug persists in 3.5.7.2. Could someone please test this in 3.6 and 4.0 and report back? I want to reopen that bug report unless someone tells me that it no longer exist in more recent LibreOffice versions. Johnny Rosenberg -- 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: [tdf-discuss] First Round of Questions for my Master Thesis
On 1/25/2013 4:34 PM, Simos Xenitellis wrote: ... Hi Regina, Indeed, the ASF holds now the OpenOffice.org trademark in the US. The issue is about the OpenOffice trademark (without the .org part), which for the US it is reserved by someone else, http://tess2.uspto.gov/bin/showfield?f=docstate=4002:4o6qwv.2.1 If there is such a trademark search website for Europe, then you will find that the OpenOffice trademark is also taken in Europe by someone else, and also in Brazil (that's why the Brazilian team selected BrOffice). That's why we do not use OpenOffice by itself. Simos My trademark search says that open office and openoffice both have dead trademark applications and thus are available to be trademarked. -- Bill Drescher william {at} TechServSys {dot} 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: Base Query Sort and Reports
Yes, thank you Dan. I upgraded to 3.6.4, and the problem went away. Perhaps you can add assistance with another query? I have created a parameter query with a case when statement : case when dateadd('dd', 365, originaldate) = dateadd('dd', 90, current_date) else '' end Problem is that instead of showing just the records that satisfy the parameter, it shows all records. If I solve that part, then the query will run exactly as I want it to. Thanks again, Al On Thu, Jan 24, 2013 at 12:23 PM, Dan Lewis [via Document Foundation Mail Archive] ml-node+s969070n4031515...@n3.nabble.com wrote: On 01/23/2013 04:22 PM, capemayal wrote: LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) I have created a query from one table. In the query design grid I sort, ascending, on a 'name' field. The query works as expected with results sorted on the 'name' field. When creating a report, using the wizard, with the query as the source, no matter what I do the query sort does not carry over to the report. It appears that no matter what field the query is sorted on, the report always sorts via the ID field, which is also the primary key. I have tried using the query sort, then using the same field in the report's sort option; I've tried using the report control to change SQL Command as source to the query, and order by 'name' in the report control. All of this makes no change. The report does not sort the way the query is made. Any help would be appreciated. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350.html Sent from the Users mailing list archive at Nabble.com. Have you been able to correct your query and report? Where did you get your version of LO 3.5.4? Did it come with a Linux distribution? If so, which one? I ask these questions because I have not been able to duplicate your problem using LO 3.5.7 from the LibreOffice website. --Dan -- For unsubscribe instructions e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4031515i=0 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4031515.html To unsubscribe from Base Query Sort and Reports, click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4031350code=Y2FwZW1heWFsQGdtYWlsLmNvbXw0MDMxMzUwfDkzNzY1NjE0 . NAMLhttp://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/Base-Query-Sort-and-Reports-tp4031350p4032025.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: Calc sliding scale formulae? - SOLVED Part 1
On 10/01/13 17:38, Hylton Conacher (ZR1HPC) wrote: Hi, I am using Calc 3.4.5 on openSuSe Linux 11.2 I am working on a spreadsheet to cater for the monthly measurement of household electricity consumption, new unit purchase and costing of used units. The electricity supplier gives me the first 150 units of electricity at R1.29 per unit. The next 350 units are costed at R1.35 per unit. Thereafter the units cost me R1.60 per unit. The monetary values per set amount of unit changes when the electricity provider increases prices i.e. the first 150 units might increase to R1.50 per purchased unit, the next 350 units might be costed at R1.55 and thereafter units will cost R2.00. Each time I purchase electricity the units I am allocated are based on the above sliding scale starting from 0. How can I work out the number of units I will receive for a given currency value i.e. R2000.00? i.e. x @ R1.29, y @ R1.35 and z @ R1.60= R2000 In addition how could I work out the value of units consumed using the above scale? I am assuming the R values in the scale will change over time and these can each be averaged to calculate the cost of units used, but the problem is still to work out the formula. Anybody have an idea if this is possible and where to start? I am investigating results found on Google but would appreciate a pointer or three. The calculation of the number of unit of electricity across a sliding scale has been solved. A member of this mailing list suggested using the IF formula. With some formula tweaking with , it proved to be the right answer. Tnx to that member. I only wish they had corresponded via the mailing list as opposed to directly, as perhaps there would have been greater learning for all subscribers. I have attached the completed to date file, via BCc email, for those who showed an interest in solving the problem, as I know the ML doesn't accept attachments. . I anyone else wants it, feel free to contact me directly at hyl...@conacher.co.za and request it. I have tested the Purchases tab in the spreadsheet using LibreOffice 3.4.5 and using common currency values, it works. Next are the other tabs etc. Thanks again to those that helped Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds largest non profit NGO -- 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] Printing Envelopes [RESOLVED]
On Thu, 24 Jan 2013, Rich Shepard wrote: Running LO-3.5.5.3 on Slackware-13.1. The envelope template was built for a COM10 size envelope in 2003 using whatever version of OO.o was then current. Worked fine then; hasn't since OO.o was supplanted by LO. Time to fix this problem. I have a solution that works for me: a short (32 lines) PostScript program. I edit the code for each address, then print it using lpr. Simple. Efficient. Works. Thanks, all! Rich -- 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] a calc - ods - Q
In a spreadsheet, is there a way to lock two rows together, so that when the spreadsheet is shuffled or otherwise modified, the two locked rows will stay together? Helen using Linux, open suse 12.1 -- 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] a calc - ods - Q
On 01/26/2013 12:00 PM, Helen wrote: In a spreadsheet, is there a way to lock two rows together, so that when the spreadsheet is shuffled or otherwise modified, the two locked rows will stay together? Helen using Linux, open suse 12.1 For example you have to rows, say 15 and 16, and if you move row 15 row 16 is moved to the new location keeping the relative its relative position? I do not remember seeing this in any spreadsheet. With adjacent rows and columns it is fairly easy to highlight the rows and columns to move them. -- 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
[libreoffice-users] Installing 4.0 alongside 3.5
For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg -- 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] Installing 4.0 alongside 3.5
Il 26/01/2013 20:02, Johnny Rosenberg ha scritto: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg hi. in theory it is possible, having the software different names (lo36 or lo40). then you bild different launchers to call different packages. one problem may be given by the configuration files in your home/.config directory: inside you should find 2 directories: 3 4... installatio may replace some libraries, but it shouldn't give conflicts or problems... you should also be able, for example, to add to submenus (eg lo3 and lo4) to the menus... try with the packages names. -- www.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] Installing 4.0 alongside 3.5
` On 01/26/2013 02:52 PM, Paolo Debortoli wrote: Il 26/01/2013 20:02, Johnny Rosenberg ha scritto: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg hi. in theory it is possible, having the software different names (lo36 or lo40). then you bild different launchers to call different packages. one problem may be given by the configuration files in your home/.config directory: inside you should find 2 directories: 3 4... installatio may replace some libraries, but it shouldn't give conflicts or problems... you should also be able, for example, to add to submenus (eg lo3 and lo4) to the menus... try with the packages names. In theory it is possible. In reality, you can run LO 3.5.7.2s and 4.0.0.2 at the same time. What you can not do is install the desktop-integration file for both of these. In Ubuntu 12.04, you have to Edit Menus. (I use gnome classic rather than Unity.) As a test, I ran LO 3.5.7.2 and 4.0.0.2 at the same time with no problems. I also ran AOO 3.4.1. That is three different soffice.bin files running at once. The key as mentioned is the configuration folders. For anyone having installed 3.X.X and 4.0.0.2, the LibreOffice folder in the .config folder is really two configuration folders: 3 and 4. The former is used by LO 3.5.x or 3.6.x, so these can not be run at the same time. I had the Ubuntu version of LO 3.5.4 on my laptop. It also used .config/LibreOffice/3/. This prevented me from running the Ubuntu version and LO 3.6.X from the LO website at the same time. --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] Printing Envelopes [RESOLVED]
On Sat, 26 Jan 2013 07:59:48 -0800 (PST) Rich Shepard rshep...@appl-ecosys.com wrote: On Thu, 24 Jan 2013, Rich Shepard wrote: Running LO-3.5.5.3 on Slackware-13.1. The envelope template was built for a COM10 size envelope in 2003 using whatever version of OO.o was then current. Worked fine then; hasn't since OO.o was supplanted by LO. Time to fix this problem. I have a solution that works for me: a short (32 lines) PostScript program. I edit the code for each address, then print it using lpr. Simple. Efficient. Works. Thanks, all! Rich Hi Rich, Would you please post that short PS program so other might be able to use it? That would be especially useful for newbies. Thanks, Tom -- A positive attitude may not solve all your problems, but it will annoy enough people to make it worth the effort. Herm Albright (1876 - 1944) -- Tom Taylor - retired penguin AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 12.2x86_64openSUSE 12.3-ß1_x86_64 KDE 4.7.2, FF 9.0 KDE 4.9.1, FF 17.0 claws-mail 3.9.0 registered linux user 263467 linxt-At-comcast-DoT-net -- 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] Installing 4.0 alongside 3.5
On Saturday, January 26, 2013 08:02:34 PM Johnny Rosenberg wrote: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for mission-critical purposes”. So obviously I need a stable version as well, like the 3.5.7.2 that I have installed right now. So I presume that I can use both versions at the same time, that they are ”isolated” from each other as long as 4.0 is a pre-release, right? But before I'm going to install it, I want to know rather than just assume… So, is it possible? If so, can I just install the debs (operating system=Ubuntu 12.04) and it will just work? Will I be able to run both versions at the same time safely? Johnny Rosenberg In the Linux enviroment I have 3.6.3 (openSUSE verssion), 3.6.4 and 4.0-dev (from libreoffice download page0 all installed and running together at times. install generated the icons and i Just select the one for the version I want. Will as long at each version has a different name. Not sure about the windows versions, I'll leave that to one of the Windows users. Russ -- openSUSE 12.2(Linux 3.4.11-2.16-desktop x86_64)| KDE 4.9.5 release 3|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-304.60) -- 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] a calc - ods - Q
Solved - thanks! I can accomplish what I need with the ctrl+enter Thanks all! On Sat, Jan 26, 2013 at 12:33 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/1/26 Helen etter...@gmail.com: In a spreadsheet, is there a way to lock two rows together, so that when the spreadsheet is shuffled or otherwise modified, the two locked rows will stay together? Probably not, but as a workaround you could type multiple lines in one cell. Use Ctrl+↵ for line separator. Johnny Rosenberg Helen using Linux, open suse 12.1 -- 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 -- Helen Etters using Linux, suse11.4 -- 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: Base Query Sort and Reports
Hi capemayal, In your case expression you use the WHEN keyword. You should have a THEN keyword to match. If the two dates in your expression match THEN what happens ? Hank On Sat, Jan 26, 2013 at 10:52 AM, capemayal capema...@gmail.com wrote: Yes, thank you Dan. I upgraded to 3.6.4, and the problem went away. Perhaps you can add assistance with another query? I have created a parameter query with a case when statement : case when dateadd('dd', 365, originaldate) = dateadd('dd', 90, current_date) else '' end Problem is that instead of showing just the records that satisfy the parameter, it shows all records. If I solve that part, then the query will run exactly as I want it to. Thanks again, Al On Thu, Jan 24, 2013 at 12:23 PM, Dan Lewis [via Document Foundation Mail Archive] ml-node+s969070n4031515...@n3.nabble.com wrote: On 01/23/2013 04:22 PM, capemayal wrote: LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) I have created a query from one table. In the query design grid I sort, ascending, on a 'name' field. The query works as expected with results sorted on the 'name' field. When creating a report, using the wizard, with the query as the source, no matter what I do the query sort does not carry over to the report. It appears that no matter what field the query is sorted on, the report always sorts via the ID field, which is also the primary key. I have tried using the query sort, then using the same field in the report's sort option; I've tried using the report control to change SQL Command as source to the query, and order by 'name' in the report control. All of this makes no change. The report does not sort the way the query is made. Any help would be appreciated. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350.html Sent from the Users mailing list archive at Nabble.com. Have you been able to correct your query and report? Where did you get your version of LO 3.5.4? Did it come with a Linux distribution? If so, which one? I ask these questions because I have not been able to duplicate your problem using LO 3.5.7 from the LibreOffice website. --Dan -- For unsubscribe instructions e-mail to: [hidden email] http://user/SendEmail.jtp?type=nodenode=4031515i=0 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4031515.html To unsubscribe from Base Query Sort and Reports, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4031350code=Y2FwZW1heWFsQGdtYWlsLmNvbXw0MDMxMzUwfDkzNzY1NjE0 . 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/Base-Query-Sort-and-Reports-tp4031350p4032025.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
[libreoffice-users] Re: Base Query Sort and Reports
My last message should have said the case statement is case when dateadd('dd', 365, originaldate) = dateadd('dd', 90, current_date) THEN 'Expired' else '' end AS Message On Sun, Jan 27, 2013 at 12:34 AM, Hank Alper [via Document Foundation Mail Archive] ml-node+s969070n403214...@n3.nabble.com wrote: Hi capemayal, In your case expression you use the WHEN keyword. You should have a THEN keyword to match. If the two dates in your expression match THEN what happens ? Hank On Sat, Jan 26, 2013 at 10:52 AM, capemayal [hidden email]http://user/SendEmail.jtp?type=nodenode=4032140i=0 wrote: Yes, thank you Dan. I upgraded to 3.6.4, and the problem went away. Perhaps you can add assistance with another query? I have created a parameter query with a case when statement : case when dateadd('dd', 365, originaldate) = dateadd('dd', 90, current_date) else '' end Problem is that instead of showing just the records that satisfy the parameter, it shows all records. If I solve that part, then the query will run exactly as I want it to. Thanks again, Al On Thu, Jan 24, 2013 at 12:23 PM, Dan Lewis [via Document Foundation Mail Archive] [hidden email]http://user/SendEmail.jtp?type=nodenode=4032140i=1 wrote: On 01/23/2013 04:22 PM, capemayal wrote: LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) I have created a query from one table. In the query design grid I sort, ascending, on a 'name' field. The query works as expected with results sorted on the 'name' field. When creating a report, using the wizard, with the query as the source, no matter what I do the query sort does not carry over to the report. It appears that no matter what field the query is sorted on, the report always sorts via the ID field, which is also the primary key. I have tried using the query sort, then using the same field in the report's sort option; I've tried using the report control to change SQL Command as source to the query, and order by 'name' in the report control. All of this makes no change. The report does not sort the way the query is made. Any help would be appreciated. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350.html Sent from the Users mailing list archive at Nabble.com. Have you been able to correct your query and report? Where did you get your version of LO 3.5.4? Did it come with a Linux distribution? If so, which one? I ask these questions because I have not been able to duplicate your problem using LO 3.5.7 from the LibreOffice website. --Dan -- For unsubscribe instructions e-mail to: [hidden email] http://user/SendEmail.jtp?type=nodenode=4031515i=0 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4031515.html To unsubscribe from Base Query Sort and Reports, click here . 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/Base-Query-Sort-and-Reports-tp4031350p4032025.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4032140i=2 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: [hidden email]http://user/SendEmail.jtp?type=nodenode=4032140i=3 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 -- If you reply to this email, your
Re: [libreoffice-users] Re: Base Report Builder
Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I feed more data into it.) If I connect to an external server is there any way I can save my forms and reports? Or shall I have to start anew ? My tables, queries and views were all produced using SQL and I have text copies of all of them to feed any server I might select. Transfer of data becomes a problem, of course. Hank On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/01/13 16:01, Mark Stanton a écrit : Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. As I mentioned in my answer to Tom, if you use an external version of hsqldb, it can only be the same version number as the internal version provided with LO, else the old ODB files can no longer be opened. In other words, you can not install an external hsqldb jar and expect your old ODB(hsqldb) files to keep working, as this will throw an error. So yes, it still remains a possibility, but one that you may want to avoid if you still have old ODB files that use the internal hsqldb with an older revision number than the externa jar you plug into LO. Alex -- 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
[libreoffice-users] libreOfficeImpress hangs after inserting 2minute video
As I did not get answer to my post I am sending my question here: Here is my posting in libreOfficeForum.org http://en.libreofficeforum.org/node/5187: Inserting short video (mpeg2, extension *.mpg) into libreOffice impress did work well. I did the insert of the video by drag and drop. May be this was the course of the problem? Now, after inserting a video with 2 minutes length I cannot use libreOfficeImpress any more: When starting libreOfficeImpress the window opens, but with a blinking window-frame, without anything inside the window. LibreOfficeImpress is just blockt, and other screenactivities are becomming slowly. My system: Ubuntu precise (12.04.1 LTS) Memory Size: 4 GB Libreoffice 3.5.4.2 LibreOfficeWrite does open, I can write a letter and when I close it, libreOfficeImpress stops also. 1. Question: What are the limits of file-amount for films? 2. Question: Where does libreOfficeImpress saves its systemdata? As I cannot start libreOffice any more, I tried to uninstall and install libreOffice new. Same Problem! I tried to delete /home/philipp/.libreoffice* and uninstall and install new. Same Problem! Cannot use libreOffice any more!!! Thanks for any help. -- 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