[libreoffice-users] Re: Calc as a Flat File Database
Le 09/03/2016 10:43, Ian Whitfield a écrit : Hi Ian, > Database and re-designing your Forms etc. This has happened repeatedly > with the embedded engine and also with the MySQL engine. I'm sorry, but crashing and subsequent corruption of an ODB file that links to a mysql database does not lead to dataloss of the linked mysql db, or at least it shouldn't if you know how to manage your mysql db. At worst, you can mess up your forms, lose your query definitions and report setups, but that's about it. Yes, with embedded hsqldb, dataloss is a known problem, but not with an external database. > As far as I'm concerned there is basic unstability in Base itself which > makes it unusable on a day-to-day basis!! > This was why I was wanting to try another route. > I tried Kexi but it is still to early in its development to be reliable. > I wanted to try Glom but it is unavailable on my OpSys (PClinuxOS). > So I was hoping to try a simpler option of Calc plus a Form. Why not separate out your forms from the ODB file if you are concerned about the stability of the ODB file itself ? It is perfectly possible, you can still link to a mysql db and you won't have the issues of screwing up your ODB just because the power goes off, or your network goes down, or some other life-event that seems to befall computer users on a daily basis. You could look at Dabo (a python based UI interface to mysql dbs), or webforms using Ruby, Rails, or PHP. They all require some kind of effort to obtain a "usable" solution. Even the MySQL UI admin tool has a simple Form view mode, where you can enter data in what looks like a form - sophisticated it isn't, but it works ! Alex -- 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: Lost connection to Database.
Le 19/11/2015 15:27, Ian Whitfield a écrit : Hi Ian, > > I seem to be getting somewhere but I sit with the problem that the DB > will not accept the old username and/or Password. > > Is there a way to reset this at all?? > Which password exactly are we talking about here ? - phpmyadmin account password (pma) ? - a common or garden user password ? - the mysql administrator password ? I suggest you read the mysql official manual, it really is very helpful for things like this : https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html Please also read the user provided comments that have been posted at the end of the above article, they contain some very useful tidbits of information with regard to particular situations, one of which might be yours. Some Linux distributions nowadays often provide their own mysql "admin" or "maintainer" account - it can be sufficient just to re-initialize this account using the ad hoc distrib provided tool. Once you have gained mysql admin privileges again, you can reset any of the other mysql account passwords to your hearts content from the mysql command line. As I don't use PCLOS, nor know how the mysql server package is installed with X.Y.Z configuration options by the package manager, I can't provide any specifics in regard to that OS. Perhaps your question might be better answered on a PCLOS specific forum ? Alex -- 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: Lost connection to Database.
Le 20/11/2015 16:10, Alex Thurgood a écrit : Ian, You appear to have had the same problem back in 2012 : http://www.pclinuxos.com/forum/index.php/topic,116372.0/prev_next,prev.html#new How did you solve it back then ? -- 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: precision of Draw dimensions - 3 place
Le 18/11/2015 19:48, dave boland a écrit : Hi Dave, > > I want to locate a line 1/8-inch (0.125") from the margin. LOD > truncates that to 0.13". Is there a way to get 3-places? What precision do you have under the Tools - Options - Draw - Grid dialog preferences ? Also check out the Capture to Grid preferences, as by default, Capture to Margins is ticked, with a default 5 pixel capture range. Playing with these options might be the way around the problem. Alex -- 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: Lost connection to Database.
Le 22/10/2015 16:24, Ian Whitfield a écrit : > > > On 10/22/2015 03:31 PM, Alexander Thurgood wrote: >> Is the mysql server actually running ? > mysqld is running, (start on boot) in Services. Just because mysql is supposed to start on boot, doesn't mean that it is actually running. From a terminal, type : mysqladmin status You might be required to enter your admin (root/sudo) password for this, or you might get an error message saying that you are not authorised, in which case try : mysqladmin status -p and then you'll be asked for a password. You can also check whether it is running in the list of active processes by typing : ps aux | grep mysql Is mysql listening on the default port 3306 ? netstat -ant | grep 3306 Can you access your database/tables from the mysql management interface, for example ? The original jdbc error that you posted is indicative of something not being setup correctly in your connection to the database. When you open the ODB file, if you click on Tables, then right mouse button click on the space in which the tables are listed, you should see a context menu that says "Database" which leads to another menu entry "Advanced". This takes you through the connection configuration screens, it might be helpful to post the output of those here. One of these screens allows you to test whether the driver is loading properly. If it isn't, then LO either isn't seeing your JRE, or the driver configuration is wrong (wrong strings, wrong version, wrong place, etc) Alex -- 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: Installing Libreoffice in Ubuntu
Le 10/10/2015 23:36, Italo Vignoli a écrit : Suffice it to say that Andreas is a vociferous participant in this discussion list, but that doesn't make his criticisms any less justified or relevant. What he dislikes is badly implemented change for change's sake, and that is an inherent problem in LibreOffice's development. The project from the start has sacrificed behavioural stability with regard to the end user for feature creep. We are quite clearly in the "bazaar" mode of the cathedral and bazaar dichotomy, where no overlying dictatorship (benevolent or otherwise) exists to govern the direction code development should take. This has positive and negative effects - the positive being that people can just turn up and work on the thing they want to implement - the negative being the law of unintended consequences, or collateral damage, i.e. bugs newly introduced that change long standing behaviour to which users have become accustomed. Fortunately, there are still people like Andreas to call the code contributors out on those decisions. I would suggest putting yourself in an admin's place where they have probably invested long hours in developing a turnkey OpenOffice/LibreOffice solution for their group of users, then finding one day that that longstanding behaviour has changed because someone else has not thought through a code change due to the tentacular nature of the code base with no one having an overarching knowledge of it all, and you will perhaps understand Andreas' frustration (which I happen to share and have voiced it on the mailing lists in the past). At present, long term support (bug fixes, security updates) for older versions is to my knowledge only available on Linux and only with regard to certain distributions. If you are not on Linux, then you are stuck playing catch up with versions that successively introduce new bugs or behaviours that don't get fixed for at least several point releases, or for certain OSes, over multiple major version releases. Steve's mention in this thread of EPS support and printing is just yet another illustration of a change that was made that has a huge impact on non-Linux OSes - all because someone thought it would be a good idea to make that change without providing a solution for all platforms. Video support in Impress is yet another issue that got significantly worse with the move to the 4.x branch. What was the message we gave to our users ? "Suck it up." There is only so much of that that users and their admins are prepared to do, and in the end, it won't be surprising if people switch to another product that offers them greater longterm stability where such changes are less invasive or devastating to the day-to-day running of the organisation. Alex -- 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: Installing Libreoffice in Ubuntu
Le 11/10/2015 14:15, Charles-H. Schulz a écrit : Charles, > > I do not know where you got that support and security updates are only > available on Linux. That is factually wrong and serious bullshit. Get your > facts straight: support is the same for the three officially supported > platforms: Windowslinux and OS X. Remember that many code contributors have > customers too. > I would be interested in learning where longterm support for "older" versions of LibreOffice on OSX which involves security updates and bug fixes is generally available. It would certainly help me explain to people on bugzilla using older versions of LibreOffice on OSX why there is no hope of bug xyz being fixed unless they upgrade both their OS and install the latest version of LibreOffice. If I look here : https://www.libreoffice.org/get-help/system-requirements/#Apple Either I can't read properly or else the information at that place is incorrect. As I was unable to find anywhere on the LibreOffice website that indicates that there is support available for "older" versions of LibreOffice on OSX < 10.8, then may I assume that my facts are indeed right after all ? Alex -- 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: Installing Libreoffice in Ubuntu
Le 11/10/2015 14:50, Cor Nouws a écrit : > > Mind that not changing and improving compared where we are and were five > years ago, is no option. Agreed, but not, and I am expressing my own opinion, to the detriment of dropping a software behaviour nuke on the users/admins. >> At present, long term support (bug fixes, security updates) for older >> versions is to my knowledge only available on Linux and only with regard >> to certain distributions. > > To my knowledge bot Collabora and CIB offer versions with much longer > support. Quite affordable and really valuable for organizations. > Sure, but both of these focus on at least LO 4.4.8, from my reading of their respective websites. That is not an "old" version, it is the latest version from the Still branch. Alex -- 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: How to work with PyUNO documentation?
Le 09/08/2015 09:14, Hi-Angel a écrit : The LibreOffice API might help you a bit further, assuming you can draw a parallel from the Java UNO documentation : http://api.libreoffice.org/docs/java/ref/index.html Alex -- 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: Libre Office Base
Le 17/07/2015 15:50, Ian Whitfield a écrit : Hi Ian, This does not work - You can enlarge the box but this only creates a larger gray area round two sides of the Check Box which keeps it's original size!!?? Yes, this is a longstanding known limitation of the tickbox control object. It can not be resized, the object frame around it can, but not the object itself. Alex -- 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: how to insert path/filename in draw
Le 27/06/2015 11:26, yahoo-pier_andreit a écrit : Hi, I'm using on my opensuse 13.2 libreoffice 4.3.7.2 but also in windows 7 with the last libreoffice 4.4.x I found this problem. but in draw I cannot succeed to have this, doing: insertfield I have only file name, but no others to click and choose like in writer the path/filename I see an insert field filename (no path) in Version: 4.2.8.2 Build ID: 420m0(Build:2) on Linux Mint 17 and it works too. Alex -- 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: BASE mail list
Le 01/06/2015 05:04, Mark LaPierre a écrit : Hi Mark, Hey All, Is there a separate mail list set up just for BASE users? No, unfortunately not. Alex -- 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: [Base] Ready-to-use solutions to manage membership + inventory?
Le 17/05/2015 13:07, Gilles a écrit : Hi, You could probably adapt the mediatheque database that Robert Grosskopf provides with the Base Handbook - it has inventory management for media, like one would have for a library, with users (members), reminders for unreturned media, etc. As far as I know, it is currently only in German, but he announced the other day on the documentation list that he had started to translate it into English. Alex -- 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: macro - find record based on text entry
Le 30/04/2015 22:09, Joel Madero a écrit : Hi Joel, I have a form with a simple text document, what I'm hoping to do is take Is the text in question free-standing, as in, in a paragraph outside of a form control, or is it the value of a form control ? the text to open another form and for it to automatically be at the record that matches the text. If the value does not exist, I want the entry to be added to the related table. So, if I've understood correctly, you want to use that text string as an input value for a filter or a query that will pull up the corresponding record in the second form ? Just trying to get things clear in my head. Alex -- 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: Problem viewing Excel charts in odt document
Le 28/04/2015 11:13, Ron Crump a écrit : Hi Ron, Without knowing the complete round-trip experience it is a bit difficult to tell what went wrong. Could be a whole set of little incompatibilities from different Excel versions to xls/xlsx file format issues to OLE support between OSes, or even bugs between different LibreOffice versions - take your pick. The basic advice is to always stick to one file format, and preferably the one which the recipient expects to receive. My own experience of exchanges with clients of spreadsheets containing scientific data and graphs is to stick to XLS format - the newer xlsx formats are still prone to lots of import/export errors in LibrOffice. I would also recomment not embedding Calc/Excel files in other Writer documents, as more often than not, when crossing OS boundaries, the embedded data is not always retrievable / editable. Alex -- 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: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?
Le 29/04/2015 02:38, Mark LaPierre a écrit : Hi, I followed the link above. It took me to a download page for MRI 1.2.4 which fails to install even though it says right under the download link that it is compatible with LO 4. I started Libreoffice as root user then used the menu option Tools = Extension Manager which opens the Extension Manager window. I clicked the [Add] button and navigated to the file MRI 1.2.4. Again, it fails to install. From memory, you shouldn't need to be root to install the extension, it should install just fine as a normal user extension. Alex -- 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: column limit in libreoffice 4.3.something
Le 23/04/2015 20:39, yahoo-pier_andreit a écrit : The problem is not new, the solution at present unlikely to be implemented, see link below for further information : https://bugs.documentfoundation.org/show_bug.cgi?id=50916 Alex -- 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: column limit in libreoffice 4.3.something
Le 23/04/2015 20:39, yahoo-pier_andreit a écrit : And this : https://bugs.documentfoundation.org/show_bug.cgi?id=43911 Alex -- 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: Using SQL functions in LibreOffice base (notation)
Le 19/03/2015 23:15, xavier2 a écrit : Hello I need to insert the current date from my computer into a field from a database. SQL has a function called NOW() which introduce the current date into a field. However, I don't know very well how this work. I tried to visit a website giving code examples in SQL... w3schools.com however I find differences between the SQL language posted in that website and the SQL language used in LibreOffice Base For example, at w3schools.com they would suggest me this code to introduce the current system date and hour into a field of my database (sorry for the fields are in Spanish)... SELECT ID_Empleados, Nombre, Apellido1ero, Direccion, NOW( ) PerDate FROM tbl_EMPLEADOS If that is what w3cschools are suggesting as an insert, then they need to revise the lessons ;-) The above is a select statement, not an insert statement Okay, that code will fail in LibreOffice Base, and it is SQL ... A query like the following works fine with the default hsqldb engine (embedded hsqldb) ODB : select ID, 'TauxFacturation', NOW() from Employés So I was wondering if the SQL from LibreOffice Base change very much from the original SQL and if we have more notation changes... LibreOffice uses hsqldb 1.8 as the default embedded db engine Other db engines use their own forms of SQL syntax. Alex -- 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: database2spreadsheet
Le 04/03/2015 10:59, hw a écrit : Hi, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a field referring to the file name of the image. If you are going to use Perl to manipulate graphic objects to insert into a Calc document, why not use Perl for everything, including querying your db, outputting your data in the desired format, and inserting that array of data into a Perl-created/manipulated Calc file ? Look at the following Perl modules : ODF::lpod OpenOffice::UNO OpenOffice::OODoc Alex -- 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: LO Base Problem
Le 22/02/2015 22:36, Ian Whitfield a écrit : |ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY Try it again, adding the length of field to the INT definition ALTER TABLE Members CHANGE RecordID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY -- 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: LO Base Problem
Le 21/02/2015 22:52, Ian Whitfield a écrit : Hi Ian, Any chance you can give us the full output of : describe FedSaints.Members; from the mysql command line interface ? You can also obtain the same information via MyAdmin, I'm just not sure which tab you have to click on (as it varies depending on the version of phpMyAdmin you are running). Alex -- 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: LO Base Problem
Le 20/02/2015 22:24, Ian Whitfield a écrit : FedSaints.Members OK So, on the face of it, your data tables are consistent and error free (with regard to their definitions). The problem then, would appear to lie with your ODB file. Something, some setting, or control, is unhappy with the change in the RecordID field and its new definition. Ideally, you would compare the contents of the before and after ODB files, e.g. using a diff command on the unzipped files present in the ODBs. That would point to where things have changed, and possibly how you might correct the problem. Alex -- 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: LO Base Problem
Le 19/02/2015 15:00, Ian Whitfield a écrit : Hi Ian, But when I go back into my Database with the Base Front End the RecordID is still marked as 'No Auto-Increment' and still will not change!! What am I doing wrong and how do I urgently fix this?? Did you read Fernand's comment ? You need to look very carefully through your form's properties and controls to check where and if the form controls might have referenced the old field as this is stored in the ODB xml. I would add the following questions : - your old RecordID was just an INT that you filled in yourself - so now that you have converted it to INT AUTO_INCREMENT, did you regenerate the values, or have you just carried on from the previous lastinsert_id() of the RecordID field ? If the new values of your newly redefined field do not match the values you had originally, there will naturally be problems with form data representation... Ways around this : - reindex your table using the appropriate mysql command ; - run mysqlcheck from the command line I don't use phpMyAdmin a great deal, so I don't know whether you have access to these commands from that UI - if not, you will have to get your hands dirty and use the console/terminal, which is what most db admins do anyway. If your data _is_ coherent, then the problem lies with your form and/or LO. Alex -- 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: LO Base Problem
Le 19/02/2015 15:00, Ian Whitfield a écrit : A quick, alternative possibility : Create a new ODB file that connects to your database. Save it under a new name. Open the newly named (and currently empty, at least with regard to forms, queries, etc) ODB file. Open the old ODB file. Try dragging and dropping your form from the old ODB file to the Forms window of the new ODB file. Now try opening that form in the new ODB file. Alex -- 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: And while I'm here, data extraction
Le 03/02/2015 21:49, tonybsa a écrit : You do not select the cells from an open query. If you want individual records from your query result window, select the grey cell at the lefthand end of the grid. Use Ctrl-click to select non-contiguous results. With the rows highlighted, maintain the left mouse button clicked and drag to the Calc sheet. The drag icon will change to a dropped plus symbol indicating that multiple records are selected. The field names are also copied over. Alex -- 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: Split Screen in Writer?
Le 03/02/2015 18:46, Tom Davies a écrit : Hi Tom, Back before MS Word became so widely used there was another word-processor that had an excellent way of using tabs helpfully. I don't think it was for different documents but i'm not clear what it used to do. Does anyone here know what program i'm talkign about and what the tabs were used for? Lotus Word Pro, and in my opinion, one of the handiest functions I ever used to get my work done when drafting long documents. Alex -- 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: And while I'm here, data extraction
Le 02/02/2015 12:34, Mark Stanton a écrit : There seems to be no way to output *data* from Base, is that right? Open a blank Calc document. Create a query. Run it. In the results window, select all or some of the records with the mouse button : - ALL : click on the upper left hand grey corner cell of the query result window ; - some : using Ctrl-click to click on the grey cells leftmost of the query result window Drag and drop the selected record rows to your Calc sheet. Save sheet as CSV If you are using embedded hsqldb, it should be possible to use a statement run from Tools SQL to export directly the query result to CSV - see the hsqldb documentation for that. Indeed, the preview window in the Tools SQL dialog will show a preview (CSV from what I recall) of the results. Alex -- 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: Split Screen in Writer?
Le 02/02/2015 12:05, Tom Davies a écrit : Hi Tom, Alex i had no idea about there being an Extension that does do tabs! many thanks for pointing it out! :)) I'd kinda given up on it ever happening in LO tbh and maybe the people who kept on going on about it feel the same way (or else maybe they just got the Extension and are all happy bunnies now). There is no extension today. Code was developed as part of a GSoc project when Sun had the stewardship of the OOo project and never finally got integrated into the main product. The code was abandoned, and has probably disappeared into the annals of history. Alex -- 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: JDBC params - the J null date problem
Le 02/02/2015 12:34, Mark Stanton a écrit : I note from a quick search that this is a well known problem. There are some solutions involving to the JDBC connector load string, which seems to not be accessible from Base. Is that a good idea? The way is to add the parameter in the field where you specify which database to connect to : nameofmydb?zeroDateTimeBehavior=convertToNull Alex -- 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: Split Screen in Writer?
Le 01/02/2015 20:06, CVAlkan a écrit : Not quite the same thing, but a long time ago, and only for a little while, there was a tabbed document interface code branch/extension developed as part of a GSoC for OOo, but it was never integrated into the main code tree. Debates about the pros and cons of having a multiple document interface have been around for a long time, but have not resurfaced recently. Symphony, IBM's OOo-like offering (now abandoned) also had a tabbed document management interface more akin to browser tabs. Alex -- 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: JDBC-connector to MySQL database
Le 01/02/2015 20:53, Heinrich Stöllinger a écrit : Hi Heinrich, CHARACTER SET latin1 COLLATE latin1_german1_ci ENGINE=InnoDB ; Try setting your collation to UTF-8, in both your table and the JDBC driver connection parameters. Alex -- 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: JDBC-connector to MySQL database
Le 01/02/2015 20:53, Heinrich Stöllinger a écrit : Have a look at this thread : https://forum.openoffice.org/en/forum/viewtopic.php?f=40t=837#p4041 Alex -- 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: JDBC-connector to MySQL database
Le 01/02/2015 20:53, Heinrich Stöllinger a écrit : And this : http://lists.freedesktop.org/archives/libreoffice-bugs/2013-August/141543.html Alex -- 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: Navigator / References / Drag Mode: Useless? Deprecated?
Le 30/01/2015 22:10, Adam Tauno Williams a écrit : Hi Adam, Is this a deprecated feature whose UI has not been removed? Or am I missing how to actually use this feature? I have a very vague recollection of this having worked at some stage with OpenOffice.org (probably the 2.x line), but I noticed, as you did, that it doesn't seem to work in the current context you mention, so it could be a bug, or effectively a deprecated feature. Alex -- 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: compatibility with Microsoft Access
Le 29/01/2015 14:45, lalitadatta a écrit : Hi, My daughter's in need of Microsoft access for her homework - she's studying computer technology at high school, and she needs Access for coding. Anyone knows if liber office should do the job? Short answer - no. LibreOffice will not produce Microsoft Access databases, nor will it allow you to use the same query system, form designer, or report maker. LibreOffice can, under certain conditions however, read and write data to/from MS Access databases, but anything your daughter manages to build in the way of queries or forms or reports will not be readable by others using MS Access. So, either get her MS Access, or else complain to the high school that it would be better to teach their students database programming with freely accessible tools, rather than being locked in to one vendor. Alex -- 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: [tdf-announce] The Document Foundation announces the results of the Android Tender
Le 27/01/2015 17:50, Tom Davies a écrit : I still haven't got an Android myself so i haven't been able to try it. Has anyone here been able to try it out yet? Yes. It crashes - a lot. It messes up font layouts - with overlapping letters in words, spacing, etc. So far tested on Sony Experia Z2. Nexus 7 2013 tests coming next. Alex -- 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: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite
Le 21/01/2015 10:02, Stephan Bergmann a écrit : Hi Stephan, If you want to later use LO4352, when you start it up, it should only use the LO4352 user configuration folder (assuming you have named them the same). I don't thin you can have both running at the same time. Where did you get that idea from? The location of the user profile is Probably because that is how it used to work. Alex -- 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: Base: Connecting to SQLite3 .db and Working With it
Le 18/01/2015 23:07, Rich Shepard a écrit : Rich, Ah, but here's the problem: Base is looking for libsqliteodbc.so which is specific to SQLite2. Since SQLite3 has been out a few years now, I looked for a way to tell Base the library is called libsqlite3odbc but could not find a configuration option. On the one hand, I can make a soft link from /usr/local/lib/sqlite3odbc.so to /usr/local/lib/sqliteodbc.so, but that won't work for the users on Windows. If someone points me to the way of telling Base that the library is for SQLite3, I'll make the fix and move on with the project. Which version of LO are you using ? A distrib provided one, a TDF download ? I don't know whether there is a difference in the library versions that the various package maintainers / TDF chooses for unixODBC when they build LO. There is certainly a build switch. Alex -- 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: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite
Le 19/01/2015 02:57, Larry Gusaas a écrit : Create a sub-folder in your Applications folder and install the second version of LibreOffice in the sub-folder. If you do that, you will use the existing user configuration profile. In order to exclude user configuration profile effects, you can try the following : - download the version of LibreOffice you want to try out ; - rename your currently installed LibreOffice app bundle to something else, e.g. LO4352 ; - now change your user profile configuration folder to the same name as the just changed app bundle ; - next, install the newly downloaded version you want to install - drag and drop to /Applications or any other folder of your choice; - when you now start the LibreOffice app bundle, it will create a new fresh profile. If you want to later use LO4352, when you start it up, it should only use the LO4352 user configuration folder (assuming you have named them the same). I don't thin you can have both running at the same time. Alex -- 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: Support options
Le 18/01/2015 00:07, Charles-H. Schulz a écrit : Charles, I am curious why you are pushing the OpenOffice forum rather than the LibreOffice Forum (access via Nabble or the other forum, http:// www.libreofficeforum.org ; or Ask.libreoffice.org ). Obviously you are a volunteer there but please remember we (TDF, the LibreOffice project) don't advocate in any way that users subscribe to the OpenOffice forum hostee on OpenOffice. org Quite simply because it is better, more complete, and more replete with people knowledgable about how to use LibreOffice/AOO/NeoOffice and has been for a very long time. That cumulative experience is a goldmine. Much as I hate to say it, and despite my being a fairly frequent contributor to the AskLO forum, I still regularly search for answers in, and direct people to, the OpenOffice.org forum. That is not likely to change in my opinion as long as I continue to be a user of LireOffice. Alex -- 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: Solver kills LiberOffice under Mac OS X.10
Le 17/01/2015 18:08, Spencer Graves a écrit : On OSX 10.10.1, you will need to install AppleJavaforOSX (JDK 1.6), preferably before you install Oracle Java 1.8. You will also need to tell LO which JDK to use in the LO Preferences - Java tab, and select 1.6. Alex -- 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: Base: Questions From Potential New User
Le 16/01/2015 18:04, Rich Shepard a écrit : That copying is what I was hoping to avoid. I'll create the sqlite db, then see if I can connect to it via a sqlite-odbc driver. Should be one that will work. The copying/execution step should only really be a last resort, if the combination of driver/Base doesn't pick all of the constraints you have set. Alex -- 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: Solver kills LiberOffice under Mac OS X.10
Le 17/01/2015 07:39, Spencer Graves a écrit : Hi Spencer, With LibreOffice 4.3.5.2 Spreadhseet under OS X.10.1, Tool - Solver kills LibreOffice, reporting, LibreOffice quit unexpectedly. Click Reopen to open the application again.” I get this in an empty spreadsheet and spreadsheets with serious optimization problems solved by Solver handily under Windows. Suggestions? File a bug report. When you mention the word Solver under Windows, I take it you are talking about the integrated solver in LibreOffice, and not some separate app, or even Excel module ? Alex -- 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: Font color based on value
Le 16/01/2015 06:40, Emil Payne a écrit : Hi Emil, The red at the top is just a reminder to me of what the limits are. Sounds like you want conditional formatting : https://help.libreoffice.org/Calc/Applying_Conditional_Formatting http://www.techrepublic.com/blog/diy-it-guy/diy-conditional-formatting-in-libreoffice-calc/ Alex -- 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: Support options
Le 15/01/2015 20:11, Jim Byrnes a écrit : What are you using to access gmane? It probably relates more to what you are using to access gmane than gmane itself. I use Thunderbird. Once I subscribe to a group on gmane it asks me how many messages to download and marks the remaining as read. Once downloaded I can choose what I want to view, all msgs, just unread msgs or threads with unread msgs, plus some others I don't use. If I want to respond to a msg I can choose followup which sends the reply to the group or replY which sends it to the message's author. Yep, same here. Gmane threads show up just fine in Thunderbird. Alex -- 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: What is the current best ODF editing Android Package?
Le 15/01/2015 15:49, Tim---Kracked_P_P---webmaster a écrit : Tim, For non-ODF editing [ .doc and .docx ] . . . Which Android app would you use? I do not want Cloud computing since most of the time the tablet will not have access to the Net. In my experience, so far, nothing is perfect. If your Android device is a tablet running Kitkat 4.4, then you should be able to use Microsoft's own, free, Word/Excel/Powerpoint Preview apps, which are currently in generalized beta testing. I have tried, WPS Office, Textmaker/Planmaker/Presentations Mobile (paid app), DocsToGo (paid app), QuickOffice, Olive Office Premium (IMO the worst of the lot so far), all with varying degrees of success. Alex -- 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: Base: Questions From Potential New User
Le 16/01/2015 17:00, Rich Shepard a écrit : Hi Rich, The schema has 18 tables (including many-to-many intermediate tables) and numerous foreign key references; more may be added. Will Base handle this many tables? You don't say whether your users will be just reading, or reading from and writing to the database. I imagine that reading should be alright, you might have issues with multiple cascading table updates, that would depend on the SQLite driver no doubt. Also be aware that SQLite timestamps and datetime data are incorrectly handled by Base as far as I recall. The DDL text file (using sqlite syntax) is approximately 200 lines. Can this be imported into Base so I do not need to re-key each line to create the tables and relationships? The easiest way to do this might be to set up an empty ODB that connects to your SQlite file via a driver, then after loading the ODF file use Tools SQL and copy in your DDL statement into the SQL window. Alex -- 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: What is the current best ODF editing Android Package?
Le 13/01/2015 10:04, Tim---Kracked_P_P---webmaster a écrit : Hi Tim, So, what is the current best ODF editing package for Android? I want to be able to just take my tablet along, instead of my laptop, to certain meetings and gatherings. So that will require a WORKING text editing package that hopefully will read/write the ODT file format and maybe the spreadsheet format as well. EuroOffice Words (ODT fles) EuroOffice Calc (ODS files) EuroOffice Presenter (ODP files) Quite why these apps don't get more frequent recommendations, I don't really know, they seem to work fairly well as far as I'm concerned with my limited testing, and the UI isn't too bad either - certainly leagues beyond where the current LO project is today with its own Android offering which will only be read capable when it is finally released. The EuroOffice project is based on QT and Calligra code, the source code is available too. If you want to work with ODB database files, then you need AndrOpen Office, but it is very unstable (i.e. prone to crashing) with these. Alex -- 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: MySQL Native Connector for Linux 4.2 and 4.3
Le 04/01/2015 14:01, Heinrich Stöllinger a écrit : Hi Heinrich, the possibility to specify such a parameter. Under the given situation LO 4.3.5.2 crashes when the server goes away and one acknowledges the respective error message. Is there a chance to get an autoconnect-feature included in a future version of the connector? File a new bug request for enhancement, if one hasn't been filed already. Your description of the crash when the connection is dropped at least confirms a bug I reported here : https://bugs.freedesktop.org/show_bug.cgi?id=83995 Alex -- 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: Google Sheets QUERY and Calc equivalent
Le 31/12/2014 14:36, Marc Paré a écrit : Hi Marc, Is there an equivalent Calc function for the Google Sheets function QUERY? When I downloaded my spreadsheet from Google Sheets as a Calc file, the QUERY function was not translated into an equivalent Calc function. My original Google Sheets function is:=QUERY('NBBP Address Book'!B2:B52) I suppose it might help if we actually knew what this Google specific function did / is supposed to do ? Alex -- 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: Select Concat in Form Dropdown?
Le 16/12/2014 21:43, Joel Madero a écrit : Hi Joel I have a form based on a table with FirstName and LastName, I want the form to have a dropdown with SELECT CONCAT(FirstName,,,LastName) Is there a way to do this? Create a listbox form control. Enter the properties of the control (right mouse button click on empty part of form, context menu Control). In the Data tab, bind your control to the SQL query by choosing SQL or SQL native from the List content type, then enter your SQL statement in the field below, or alternatively, click on the ellipsis and navigate to a query you have already saved. Alex -- 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: LOBase connected to SQLite3
Le 16/12/2014 14:21, Pertti Rönnberg a écrit : Hi Pertti, My prime intention is to start building database applications using SQLite3. I first tried to install Apache PHPSQLite3 as separate programs but the config process was too much for me why I installed WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.) and the SQLite3 is an extension in PHP(v. 5.5.). You can try to connect to your SQLite datasource either via ODBC or JDBC. Using Google to search for drivers brings up a few. An example here of someone on Ubuntu : http://en.libreofficeforum.org/node/2038 Note that there are a few known bugs with current versions of LO and SQLite3, the last one being a limitation of sqlite3 (notourbug) : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=82688 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=86943 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50575 Alex -- 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: Select Concat in Form Dropdown?
Le 17/12/2014 09:45, Alex Thurgood a écrit : Le 16/12/2014 21:43, Joel Madero a écrit : Hi Joel I have a form based on a table with FirstName and LastName, I want the form to have a dropdown with SELECT CONCAT(FirstName,,,LastName) Is there a way to do this? Create a listbox form control. Enter the properties of the control (right mouse button click on empty part of form, context menu Control). In the Data tab, bind your control to the SQL query by choosing SQL or SQL native from the List content type, then enter your SQL statement in the field below, or alternatively, click on the ellipsis and navigate to a query you have already saved. Addenda : Or, as I found out with a listbox, instead of a combobox, clicking on the ellipsis takes you to the SQL query designer in SQL mode (even better IMHO). Alex -- 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: How to edit a signature file into a PDF document
Le 04/12/2014 02:08, john herron a écrit : Hi John, Master PDF Editor for Linux will let you do all this and more. Alex -- 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: Impress videos on wrong screen
Le 27/11/2014 15:46, Malcolm Moore a écrit : Does anyone know how to fix this I take it that fiddling around with Slide Show Slide Show Settings ... Under the Multiple Displays section does nothing to resolve your problem ? Alex -- 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: Report in Base not executed
Le 14/11/2014 15:39, Harvey Nimmo a écrit : Hi Harvey, My configuration is Libre-Office Version: 4.3.2.2.0+ Build ID: 430m0(Build:2) on Gnome 3.14.1 under Opensuse 13.2. Is this the version of LibreOffice provided by the OpenSuse package management system ? i.e. a version built and provided by the OpenSuse project ? Can you try a TDF provided version of LibreOffice instead (from the LibreOffice download page) or are there no suitable packages ? Alex -- 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: Report in Base not executed
Le 14/11/2014 15:39, Harvey Nimmo a écrit : com.sun.star.loader.CannotActivateFactoryException was caught. Sounds similar to this : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51278 which was around in the transition to LO 3.6.x Maybe try resetting your LO user configuration profile ? Alex -- 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: Java LO and OSX
Le 06/11/2014 21:14, Marc Grober a écrit : Hi Marc, The point of the posts was to note that in fact it is easy enough to get LO working on Yosemite but it requires a bit of messing about, some of which is counter-intuitive. Yes, the basic setup is : - install Apple Java 6 - then install Oracle JDK/JRE (currently 1.8.0_25) When you next set your Java preferences in LO, it should automatically detect the Oracle JDK/JRE (which are effectively located in different positions to Apple's Java 6). Alex -- 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: LO 4 on OSX 10.10
Le 06/11/2014 19:34, Tom Davies a écrit : Hi Tom, all That crash is highly likely to be a Java issue, of course. Switch off Java and the text files stop crashing. On Yosemite, the crash is a LO issue because LibreOffice comes bundled with at least one extension that invokes a JVM via a JNI call, or alternatively, any functionality that requires a JVM to be invoked e.g. any of the remaining Java wizards, or Base functionality requiring JVM instantiation. However, the real underlying problem is that Oracle's Java 7 and Java 8 have a bug preventing them from initiating this JVM via JNI correctly, and which is only slated to be fixed with the release of Java 9, so ultimately this is Oracle's problem. There is a bug report in the LibreOffice bug tracker which indicates where the problems lie. Alex -- 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: LO and Java 8u25 - SOLVED
Le 28/10/2014 13:06, Alain Andrieux a écrit : Hi Alain, The second one, labelled “Mac OS X (x86_64 10.8 or newer required”, does the trick and recognises Java 8u25 as valid. Although we still get this nasty alert saying we should install Java… You might still find that things don't work and that LO crashes as a result in erratic and unpredictable circumstances. This is certainly the case for the 4331 pre-release. I take it you haven't had to do anything Base related yet ? Alex -- 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: Open .accdb in--or convert to--.odb in LibreOffice Base?
Le 07/10/2014 20:46, m. nease a écrit : Hi, I'd like to do some work on Access databases (.accdb files) but haven't been able to access(!) them using Base (and have no MS OS or MS Office--happily). Is this possible? 1) If at all, Access files can only be opened from LO on Windows, so if you're not using Windows OS, you will have to find some other way. 2) Subject to point 1, and I'm not entirely certain about this as I haven't looked in bugzilla recently, but if the .accdb files were made with Access 2010, then they can not be opened via LO using the ADO driver, unless you use an ODBC connection instead. See also : https://bugs.freedesktop.org/show_bug.cgi?id=43187 https://bugs.freedesktop.org/show_bug.cgi?id=69832 https://bugs.freedesktop.org/show_bug.cgi?id=70236 Judging by the comment in bug 70236, using Apache OpenOffice might be a better solution. Alex -- 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: Open .accdb in--or convert to--.odb in LibreOffice Base?
Le 07/10/2014 20:46, m. nease a écrit : I'd like to do some work on Access databases (.accdb files) but haven't been able to access(!) them using Base (and have no MS OS or MS Office--happily). Is this possible? To assist in migration, also check out this Windows-only, GPL tool : http://mdbdoc.sourceforge.net/ Alex -- 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: Open .accdb in--or convert to--.odb in LibreOffice Base?
Le 07/10/2014 20:46, m. nease a écrit : Hmm, my last reply is of no use to you if you haven't even got Access installed, so sorry about that, but it might be useful to others. Alex -- 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: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Le 04/10/2014 00:09, Heinrich Stöllinger a écrit : Heinrich, Dan, It is a known limitation of the native mysql connector, although I don't remember right now whether an enhancement request has been filed. I couldn't find one after a quick search on bugzilla. Alex -- 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: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex -- 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: [Base Database] How to open a particular form at startup ?
Le 02/10/2014 22:00, Rafnews a écrit : Hi, i have a database created with Base from LibreOffice. i have a form stored in the same ODB file called FMain. Now how can i do to open automatically the form when i open the ODB file ? https://forum.openoffice.org/en/forum/viewtopic.php?f=39t=34147 read the thread all the way through to the end. Alex -- 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: Base Reports - Getting Monthly YTD Averages
Le 25/09/2014 23:59, Don Parris a écrit : Hi Don, shown, and that works great. I used the Accumulation function to do this. But when I try to get an overall average, I wind up getting the average for the first month (in the report), not for the year-to-date. What expression are you using in the definition of your Report Builder field to obtain the average of all months combined ? If you just use something like AVG[MONTH] then it will only average on that particular month. It might be better, as Tom has suggested, to create a separate result in your initial query in order to provide the average of the combined months rainfall. Alex -- 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: Styles Don't Retain Bold?
Le 12/09/2014 08:38, Owen Genat a écrit : Hi Owen, My experience on several occasions has unfortunately been that the Default style in Writer has hard formatting characteristics which cause application of Heading 3 not to work correctly, and it seems hard to be able to ascribe any particular sequence of actions to make it reproducible. I am not a styles expert by any means, but one would expect the default styles to work as designed. Alex -- 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: Selected fonts are no longer displaying in LO 4.2.4.2 on OSX 10.9.4
Le 11/09/2014 19:04, Marc Grober a écrit : At a guess, more font substitution issues - depending on the font type (OTF seems to be a common culprit) and family font weights, LO appears to carry out font substitution - this might be why you are seeing different characters. There appears to be no workaround other than to hope that OSX font support will someday be completely integrated natively into LO - at present, this is not the case, at least, so far as I understand the situation. Alex -- 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: Styles Don't Retain Bold?
Le 10/09/2014 17:56, Dave Barton a écrit : Hi Dave, Setting existing manually formatted text to Heading 3 is an issue, if the formatting is not completely cleared first. Shouldn't applying the style overwrite all previous style information though ? In that case, it would still be a bug. I've been hit by this very annoying behaviour more than once when using the default Heading styles - after all, what is the point of a default style if it isn't applied correctly ? Alex -- 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: longstanding bugs - what does it take to get them fixed?
Le 01/09/2014 02:25, Gary Dale a écrit : Who do I have to talk to in order to get these bugs addressed? A developer who is prepared either to fix it for free, one who will want money or gifts for doing so, or alternatively a developer who works for a company that offers paid tier 3 support. Whatever the scenario, it would be better to check with the LibreOffice bugzilla, to see whether the bugs have already been registered (or not, as the case may be) and then point the paid developers / support company in that direction. As for the volunteer developers, you can't tell any of them what to do nor when to do it, they are, after all, volunteers, much as virtually anyone else helping out here. Bug reports from the LibreOffice bugzilla are automatically referenced on the libreoffice IRC developer channel. Some developers follow particular modules, others just look at the ones they happen to be interested in at any given time. There are also a whole host of mailmerge bugfixes awaiting approval for integration into the master code repository from the Munich Wollmux project. Whether or not any of those cover your problems, I couldn't say. Alex -- 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: version backups
Le 29/08/2014 02:13, Bob Holtzman a écrit : Running LO3.5.4.2 in Debian Wheezy. Called up an existing doc in calc, made some changes, saved and quit. Next time I called it up it was blank. The problem is that I accidentally hit save. Looked for the backup file path ~/.config/libreoffice/3/user. According to the help file there should be a backup directory/file which I don't see. I need to know if LO backs up more than the latest version and where it is stored If the automatic backup every x mins option is not ticked, you will, at best, only be able to find a lock file of your document, in which you might possibly find some of your data, but as you have saved, this won't help you, unfortunately. Alex -- 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: Running a Macro from a form
Le 28/08/2014 13:46, Allan Newton a écrit : Hi Allan, However if I create blank form with just one button and set the properties of that button to run the macro it fails at the line if IsNull(ThisComponent.CurrentController.ActiveConnection) then with the error message BASIC runtime error. Property or method not found: ActiveConnection. Can anyone help me please? That error message is telling you (or should be telling you) that you have no Database Context. ActiveConnection is instantiated via a database connection context : http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sdbc_1_1XConnection.html so the macro in your form has to create such a context before ActiveConnection can return any value. As you don't say whether your form has been made within your ODB file, or whether it is independent, it is hard to help out much further. Generally, if the form is created within the ODB file, the connection context is initiated upon opening the main ODB interface, whereas an independent form needs to establish the connection context first. If your form is within the ODB file, then one of the reasons why the connection context might not be found is because it needs to walk up the window hierarchy to find the main or parent. As far as I know, this has always been a weakness of the CurrentComponent method within Base containers where child form windows do not automatically inherit the connection context. Andrew has indicated a way of obtaining the connection context from by walking up the Model hierarchy of the Database container. From a quick read, the answer to your problem seems to have been published here : https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=42882#p198477 Alex -- 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: Displaying MathType equations in Writer
Le 15/08/2014 18:02, Graham Luffrum a écrit : Hi Graham, Use Word, I have the same problem, in fact I've always had this problem with equations written in Word. Alternatively, I ask for a PDF, and either retype the formulae (not exactly very profitable, when you're translating) or else copy/paste the selected formula from the PDF as an image and insert with anchoring as character. If you have to re-export it to Word, you can forget compatibility or being able to re-edit the formulae. Alex -- 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: LibreOffice - Base...
Le 06/08/2014 08:08, David Love a écrit : Using LinuxMint v17.0 Qiana qith the MATE DE. I have Mint 17 Cinnamon Have followed with interest the recent discussins on Base and have decided to try and learn how to use it, using PostGreSQL as the backend. But - and there is always one of those :-) - how many of the multitude of postgrsql files in Synaptic do I need to install, please. postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3 postgresql-doc-9.3 libpq5 libreoffice-base-drivers libreoffice-sdbc-postgresql That should probably do it. Note that the documentation is optional, but nonetheless useful ;-) It can be read in your browser by entering the following into the URL field file:///usr/share/doc/postgresql-doc-9.3/html/ Alex -- 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: Base questions
Le 01/08/2014 12:55, Wolfgang Keller a écrit : I never understood why anyone halfway sane in their minds would use an embedded database anyway or why the developers of StarOffice/LO/OO even considered it. As I recall, at the time of the release of OpenOffice2, it had to be like Access - but of course, as Sun was mainly running the show, that meant that it had to be multi-OS, thus Java based and a fairly simple, drop-in piece of code with an appropriate licence. One would do well to remember that at the time, the internal Sun Base development team only comprised about 3 members of staff working full-time on the project, thus resources were painfully limited. It turned out to be not so simple after all, but that can be said about many things in software development. The issue of performance was raised even back then, and remains with us today - embedded Java bridging (via UNO JNI) of an in-memory database - loads of things to go potentially wrong at any given instance in the lifecycle of the application, notwithstanding that upgrading to newer versions of the db has always been fraught with complications, so a maintenance nightmare for OOo/AOO/LO developers. It can be done though, Fred Toussi (one of the lead developers on the hsqldb project) has, I believe, provided patches for the integration of an update to the hsqldb version code, but these have not been integrated due to the decision to move to Firebird. Database noobs wanted Access-like functionality and portability and multi-OS operation - the fact that they don't really get that today with LibreOffice Base is due more to lack of functional implementation/integration witn the other parts of LibreOffice than to the type of underlying db. Even MS Access has moved to a separated db/frontend paradigm, as far as I understand. Just to put things in perspective, there are, to my knowledge, currently no full/part time paid-to-work developers within the LibreOffice project that work on Base - everything done is voluntary, spare/free time involvement, so it is hardly surprising that things with Base move a little more slowly than modules such as Writer and Calc, in fact, it is my undestanding that the main voluntary developer spends most of his time in the project undoing the bugs/regressions caused by ongoing code development elsewhere within the LibreOffice project. Alex -- 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: Schema in Calc
Le 31/07/2014 00:08, Paul a écrit : Just out of interest, why would a db driver come into play? This is a spreadsheet we're talking about. The mention of db schema was merely to ask why Calc doesn't have something like it. How else would one obtain the schema in the first place ? As I see it there are only two possibilities : - import from an existing db connection using the db source/named ranges functionality -this requires a db context/connection and consequently a db driver; - import from a file (XML/UML or other Calc-recognisable file type) that has been obtained by exporting the schema from a database. The second way wouldn't require a db driver, but is more cumbersome IMO than being able to query the db directly for the schema because it requires specific matching of the structure to the internal representation of a Calc file, i.e. implementation of a separate import/export filter. Alex -- 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: MAC: 4.3.0.4 Info.plist version confusion
Le 30/07/2014 15:20, Markus Jansen a écrit : Hi Markus, I just wanted to check out the new libreOffice with a Mac and found out that in the Info.plist - file the key CFBundleShortVersionString is 4.3.4 in contrast to the CFBundleGetInfoString which is 4.3.0.4 (see the third digit: zero). Why is this? Just the shorten the version string to 3 digits? And if a future long version will be 4.3.1.3, will the short one be 4.3.1, which is smaller than the older one (4.3.4)? Such things makes automatic software deployment even harder. It might just be an error, or it might be linked to the hope of getting LibreOffice onto the Apple store - I seem to recall that there is some kind of version naming convention for that. The best place to ask your question would be on the dev irc channel or the dev mailing list. Alex -- 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: File corruption on OSX and LO 4252
Le 17/07/2014 17:17, jomali a écrit : I am working with OSX 10.9.4 I just created a test writer document in 4.2.4.2, saved it to a FAT-32 fomatted memory stick, opened it in 4.2.5.2, made some modifications and re-saved it. I then opened it in 4.2.5.2. It opened flawlessly. I don't have a FAT-32 USB hard drive to test it on, but since LO only sees the drive through the OS, I don't see what difference it would make. How long did you keep the file open for, and how many times did you make changes to file ? If you take an existing file from your FAT stick, then Save As.. with another name to the FAT stick, do you get any issues ? If you make a copy of the file from Finder on the Fat stick, then open that copy, make changes and then resave, do you get any issues ? How big is your memory stick ? Just trying to narrow down the problem. Alex -- 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: Sponsoring improvements and bug fixes
Le 02/07/2014 00:54, Andrew Beverley a écrit : Hi Andrew, A great idea (thanks Tom as well). In fact, I'm surprised it doesn't already exist. Here : https://freedomsponsors.org/core/issue/?s=libreofficeproject_id=project_name= and here : https://www.bountysource.com/trackers/52023-libreoffice There were allegedly also bounty posts on gun.io, but Firefox tells me that the site is insecure, so I've not bothered looking. Regards, Alex -- 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: Fwd: Re: Base graphics/visualization
Le 23/06/2014 04:53, dave boland a écrit : Hi Dave, So, I'm back to where we started. I have ver. 4.1.3.2, and I know there is a new version in the works for later July. Will I be able to use the report facility to build charts based on the data form the query? If so, how? Forget using Base/Calc to build complex charts from your data, unless you have some serious time and coding skills to hand to be able to drive all of this via scripts and one of LO's UNO interfaces (Python, Basic, JS, Beanshell, etc). Look for another reporting solution that integrates chart handling in a (seemingly) more reliable way : JReport (very similar to what appears to be available in Base, but organised in a better way, IMHO : http://www.jinfonet.com/manualpro/tutorial/index.htm Pentaho Business Reports (this is the superset of tools to JFreeReport, the reporting tool used by LO Base) http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+-+User+Guide+for+Report+Designer iReport / JasperReports http://sourceforge.net/p/ireport/wiki/Home/ http://community.jaspersoft.com/wiki/ireport-designer-getting-started The latter enables you to export your report to a multitude of formats, including ODF, and PDF. Alex -- 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: Fwd: Re: Base graphics/visualization
Le 23/06/2014 16:37, dave boland a écrit : Hi David, Thank you so much for the info! I have not spent much time on this, so I'm guessing that the plan (for me) is to use LO Base, then use one of these products to create the reports? These report generators require either an ODBC or JDBC driver, so I'm hoping that Base has one or the other. I did some Googling and it is not clear to me that it does. So, does that mean that I should be focusing on PostgreSQL or MariaDB for example? LO Base uses an embedded hsqldb engine by default (and an old version at that), you can not access it directly from other applications even over a JDBC driver. There are several alternative strategies : - you use Excel sheets, CSV files ot delimited text files as your data source - I believe, from preliminary reading, that at least some of the report designers I indicated allow this possibility ; - you use a separate, or external, hsqldb instance - there are tutorials for this out there on the web (look in the OOo forum), but I think that this is also given a mention in the LO Base handbook - as the standalone hsqldb package comes with a JDBC driver you could then use that in one of the report designer software programs I indicated ; - you use a known RDBMS - postgres, mysql, mariadb, firebird as a separate backend for your data, and then attach to that using the relevant ODBC or JDBC connector via the report designer software. If you want to do the whole LO-integrated thing and have complex reports including multivariable graphs, etc, you will need to learn to program LO via Basic or python, as I indicated in my first response. That as such, would be no mean feat. Alex -- 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: Base graphics/visualization
Le 23/06/2014 12:28, Tom Davies a écrit : Tom, It is not often I speak out in this way, and I hate to say it, but sometimes I really do wonder whether you're on medication, drugs, alcohol, or suffering from some form of permanent euphoric mind-altering state. Apache are far better at supporting Base. Here we rely on a few regulars Well there's a nice sweeping generalisation, and a wrong one at that. Apache don't support Base more than any other application or program or code that is covered by their foundation. who happen to be extremely good with it but they don't seem to have been around this weekend. Sorry! :( Apache forums seem quite happy answering questions about LibreOffice. Unfortunately they seem to have 1 forum that is over-run by spammers and 1 that is excellent and i never remember which is which. A google search gave me this forum; The fact that there is more information available about Base on the OOo forums is not new, those forums were around a long time before LO even existed. The posters and people on those forums were tackling real Base problems many, many years ago. The fact that the LO project thought it a necessity to provide some other forms of communication medium was borne as a result mainly of differences in egos between all of the members that had created the mammoth OOo user-based community. This created divided user support forums, which personally, I think was probably one of the biggest mistakes ever, particularly with regard to Base. But hey, such is life. The fact of the matter, and I will grant you that, is that the OOo Base forums are far more replete with useful answers than anything the LO user support media/channels have to offfer, save perhaps the present Base User Guides. there. My guess is that the chart would be fairly easy from where that thread finishes. Have you tried this for yourself ? Have you tried using any of the more sophisticated Base functionality at all ? When you do, then you can make sweeping statements about how easy, or not, something can be done. Sorry, if I appear harsh, but sometimes smiling inanely and answering off the top of one's head just doesn't cut it. Alex -- 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: Quicklook Plugin?
Le 16/06/2014 22:59, Oogie McGuire a écrit : Hi Oogie, Because I can't use LO on my iPad and yet I can copy my DEVONThink database to it and run it there. SO if I had a QL plug-in on the iPad I could at least view documents on it. As I don't have an iPad, I don't know the ins and outs of the quicklook plugin architecture on iOS, but what makes you think that it is the same ? In other words, why would a quicklook plugin built against the OSX 10.6 SDK, which is currently what LO is built against on the Mac, be likely to work on the iPad, with whatever version of iOS is running there ? The LO quicklook plugin should be found in the LO app bundle, so you'd have to inspect the app bundle in order to find the corresponding component. Alex -- 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: Quicklook Plugin?
Le 16/06/2014 21:44, anne-ology a écrit : Hi Anne, Curiously wondering why you would need anything to open LO documents ;-) Quicklook on OSX is a file previewer. The quicklook plugin is a component provided with the LO application bundle to allow the file manager Finder to display previews of the contents of LO file types (except that this currently only works for Writer and Calc documents AFAIK). Alex -- 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: Quicklook Plugin?
Le 15/06/2014 15:44, Oogie McGuire a écrit : Oogie, I would like to be able to read and review LibreOffice documents from within DEVONThink. I've been told that the reason it doesn't work now is that LO doesn't have a quicklook plugin. It does have a quicklook plugin that works from within Finder, for Writer and Calc document types. Alex -- 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: Mail Merge - Standard Filter issues
Le 02/06/2014 17:59, Vitorio Delage a écrit : Hi Vitorio, 1) Put more filter criterias in the Standard Filter window. We use 3 for a basic search. Yes, our database is complex. Doubling it to 6 would be good, using an dynamically extensible list of criterias (similar of what iTunes provide when creating a new smart playlist) would be great! Is there a simple hack to do it or do I need to fill a bug/feature report? Current limitation, as far as I'm aware === feature request on bugzilla 2) Also in the Standard Filter window, we got a logical problem. We wanted to filter criterias A AND (B OR C) but there is no way to do it. If you try to put 3 criterias 1 AND 2 OR 3 you will obtain the logic (1 AND 2) OR 3. Tried also the inverse without better luck: 1 OR 2 AND 3 is also resolved as 1 OR (2 AND 3). As our or is on looking text in the same field, I also tried to put in a single criteria as text like 'this|that' but the Standard filter doesn't seem to use the | operator. Any help on how I could do this logic? Have you tried (B or C) AND A in that order ? Just a wild guess. The standard filter is rather limited, so views would be better, but of course, as you mentioned, relies on creating as many views as there are scenarii, a subboptimal solution IMHO. Alex -- 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: Bug check - 4.2.4, editing Input fields is broken?
Le 03/06/2014 15:39, Tanstaafl a écrit : Anyone? Seem to recall there's a bug report for this : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=78470 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=74930 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=59886 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=61618 Alex -- 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: Bug check - 4.2.4, editing Input fields is broken?
Le 03/06/2014 15:39, Tanstaafl a écrit : And these : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=75995 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=76833 Alex -- 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: [Calc] - Rendering problems /very slowly in 4.2?
Le 28/05/2014 16:04, Miles Prower a écrit : Hi Miles, Scrolling the mouse... s slow, and It lets lots of artifacts and rendering problems that makes Calc unusable... And I'm not the only one https://bugs.archlinux.org/task/39474 I used Ubuntu 14.04, Lubuntu 14.04 and Xubuntu 14.04 that have the 4.2 branch, and it happens (and happened) too. I've thinked that it was a Desktop Environment problem, because on Testing (in that time with 4.1) that didn't happen... Possibly this bug : https://www.libreoffice.org/bugzilla/show_bug.cgi?id=75665 Alex -- 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: table not appearing in .doc format in MAC
Le 23/05/2014 11:11, Bala subramanian a écrit : Hi, I have .odt file where i copied a table from libreoffice Calc. Then i saved the file in .doc file. Opening the .doc file in macbook does not show the tables. Is there any way to resolve this issue. When you write that you save as doc, do you mean Doc (Word97) or Docx (Word 2003/2010) ? I should be able to test this between my Linux and Mac machines. Alex -- 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: table not appearing in .doc format in MAC
Le 23/05/2014 11:11, Bala subramanian a écrit : Errm, actually, now I think about it, isn't this normal behaviour ? What I mean is that you've inserted a Calc document into a Writer document which you then save as DOC Word97. Firstly, the DOC Word97 filter is designed to export to that format (give or take a few bugs), but that doesn't mean it supports OLE from an object that does not form part of the Word 97 format. Second, how would a Word document know anything about a Calc OLE object (or its Linux equivalent) ? If you save your Writer document as Writer ODT, instead of DOC Word 97, does the ODT document open correctly on the Mac and display the inserted Calc spreadsheet ? As I don't tend to embed certain types of document in other types of documents, I'm not really sure what is, and what isn't supposed to work anyway, much less be interoperable between different OSes that don't have the same mechanisms for object linked embedding. Alex -- 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: *** SPAM *** Re: Native Connector
Le 12/05/2014 09:03, Heinrich Stoellinger a écrit : Hi Heinrich, I use JDBC-Connector mysql-connector-java-5.1.30-bin.jar; can't tell you where I got it from, certainly not from a Linux-distribution (I run Debian-Wheezy and Mint-16 respectively). You stated initially that you were using the native connector - where did you get it from ? I don't have to shut down the ODB --- see above! Heinrich Yes, in other words, it works with the JDBC connector, but not the mysql-native C/C++ connector, this has always been the case, as far as I know. The JDBC has a far broader range of acceptable connection parameters than the native connector. Alex -- 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: Native Connector
Le 10/05/2014 15:08, Heinrich Stoellinger a écrit : Hi Heinrich, You do not give the whole story : - which connector are you talking about, where did you get it ? It is not supplied by default with official builds of LO, so either it has been included as a packet with your Linux distribution, or else you have got it from somewhere else ; - as for the autoreconnect, have you tried adding this as a parameter in the database URL when you set up the connection (i.e. as you would with the JDBC connector) - alternatively, is there anything in the Advanced Properties of the database connection ? If there isn't, or if the suggestion I made above doesn't work, then I doubt that it is possible. The only other alternative is to shut down the ODB and re-open it periodically. Alex -- 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: Mac Upgrade error?
Le 05/05/2014 23:17, Phil a écrit : There seems to have been some weird time tunnel with Gmane, where I don't see any of the posts after about 6pm on May 4th... Im running OSX 10.6.8, running Version 4.0.0.0.beta1 (Build ID: 87906242e87d3ddb2ba9827818f2d1416d80cc7) TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time: 2012-12-05_22:13:37 That 4.0.0.0 was very buggy. I believe it was one of the first beta release's, and decided to upgrade when i saw the little notification to download the updated version, after having put it off for a while. The version i downloaded was 4.2.2 First off i just dragged the file over, and ran LO, checked to make sure it was updated, just by checking about, and it still said running the above version? So put LO in the trash (in a nice way), copied the file again from the DMG and ran LO, and it still says the above version? If you tried moving the app to Trash when it was still running, it won't have been deleted. Did you empty the Trash after shutting down LO ? I would also, for good measure, remove the LibreOffice folder in your /Users/username/Library/Application Support/ folder, and then restart LO. Alex -- 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: CONVERTING A MICROSOFT TEMPLATE TO BE USED WITH LIBRE OFFICE
Le 22/04/2014 20:06, Urmas a écrit : Meanwhile, Libreoffice cannot open its own documents from 2001. Urmas, you are right. Yes, I too, remember a guarantee made by the LibreOffice project on its inception to future-proof one's data against arbitrary changes in file format or vendor support...funny how the wheel turns isn't it ? The dev working on LO didn't like the StarOffice binary filter code, so they got rid of it, simple as that - they certainly didn't care whether people who had started using the original product, the one that gave birth both to OOo and LO, over 10 years ago would still want that file format supported - data guarantee I hear you say ? Bah, humbug. Clearly a case of :if you're not working on the codebase, we're not listening to you, lalalala, sticks fingers in ears... There was nothing seriously broken about the binary filter code used to support those binary sd* file types, but it was a hefty chunk of code to get rid of from the code base, and met the goal of reducing code clutter. Then the LO project had the gall to sign itself up to some document format project that will claim to support all those old document formats...hahaha, the irony of it all... In many respects, some open source projects are no better than closed source ones where their management and communication is concerned. Inept is inept, spin is spin, marketing is marketing - beauty is in the eye of the holder, so to speak. Well, thank you for listening to my little rant for today, I'll crawl back under that rock I call LibreOffice QA, ROFLMAO. Alex -- 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: Possible LibreOffice Duplex Printing Bug
Le 09/04/2014 23:31, CVAlkan a écrit : Hi, d) Even so, once the single page is printed, the paper is sucked back in and fed through a second time. Nothing prints of course, but this is actually a potentially serious problem under some conditions which I'll explain momentarily. I see this behaviour too on my networked Kyocera LJ, but didn't manage to track it down to anything I could fiddle with. The reason this is more important than the extra three second or so return trip through the paper flipper is that Hewlett-Packard (and other printer manufacturers) do not recommend using double sided printing when using stock above a certain thickness (e.g. card stock) because doing so raises the likelihood of jamming the mechanism. With a default setting of double sided (and why else would I have purchased a double sided printer?), when I need to print on card stock, the chances of forgetting to set one-sided would be my fault, but if I set it and the driver ignores that setting, that (I believe) is a bug. You should try printing an envelope and see how often it jams...every time (at least on OSX) ! So, should this be reported as a bug? Has anyone else noticed this behavior? And if it seems like a bug, how do I report it? Yes, please report it. Alex -- 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: Bullets Numbering
Le 21/03/2014 10:39, A a écrit : Is it possible? If so, how? Yes, but it is not predefined, so would have to do that yourself via the Bullets Numbering dialog, in the Options tab. Alex -- 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: Turning spreadsheet data into legible report?
Le 19/03/2014 15:24, Gilles a écrit : Hi, In theory, a LibreOffice Database report should be able to do something like that, but : - if you bind a Calc or Excel file, you will not be able to write/edit any of the data in the bound Calc or Excel file, as these become read-only - in order to update the sheets, you would have to open them up separately in Calc, do your editing/updates, etc, and then re-open the ODB file; - binding Calc or Excel files as text file data sources within an ODB means you are limited to the column headers for your field names - anything else is just a value (text string, date, integer, etc); - if you import the data to an ODB file, via the data import wizard, you will have more flexibility in what you do with that data, but you will lose the direct link to the Excel/Calc file, so changes you make to the latter will not be reflected in the ODB file, until you reimport the data into your Base file - this might be too much of a hassle for most people. Alex -- 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