[libreoffice-users] Re: Calc as a Flat File Database

2016-03-10 Thread Alex Thurgood
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

[libreoffice-users] Re: Lost connection to Database.

2015-11-20 Thread Alex Thurgood
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

[libreoffice-users] Re: Lost connection to Database.

2015-11-20 Thread Alex Thurgood
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

[libreoffice-users] Re: precision of Draw dimensions - 3 place

2015-11-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Lost connection to Database.

2015-10-22 Thread Alex Thurgood
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

[libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-11 Thread Alex Thurgood
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-users] Re: Installing Libreoffice in Ubuntu

2015-10-11 Thread Alex Thurgood
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 >

[libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-11 Thread Alex Thurgood
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

[libreoffice-users] Re: How to work with PyUNO documentation?

2015-08-09 Thread Alex Thurgood
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

[libreoffice-users] Re: Libre Office Base

2015-07-20 Thread Alex Thurgood
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

[libreoffice-users] Re: how to insert path/filename in draw

2015-06-27 Thread Alex Thurgood
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

[libreoffice-users] Re: BASE mail list

2015-06-01 Thread Alex Thurgood
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?

[libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-17 Thread Alex Thurgood
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

[libreoffice-users] Re: macro - find record based on text entry

2015-05-01 Thread Alex Thurgood
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

[libreoffice-users] Re: Problem viewing Excel charts in odt document

2015-04-30 Thread Alex Thurgood
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

[libreoffice-users] Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?

2015-04-30 Thread Alex Thurgood
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

[libreoffice-users] Re: column limit in libreoffice 4.3.something

2015-04-25 Thread Alex Thurgood
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:

[libreoffice-users] Re: column limit in libreoffice 4.3.something

2015-04-25 Thread Alex Thurgood
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

[libreoffice-users] Re: Using SQL functions in LibreOffice base (notation)

2015-03-22 Thread Alex Thurgood
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

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Alex Thurgood
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

[libreoffice-users] Re: LO Base Problem

2015-02-23 Thread Alex Thurgood
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

[libreoffice-users] Re: LO Base Problem

2015-02-22 Thread Alex Thurgood
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

[libreoffice-users] Re: LO Base Problem

2015-02-21 Thread Alex Thurgood
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

[libreoffice-users] Re: LO Base Problem

2015-02-20 Thread Alex Thurgood
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

[libreoffice-users] Re: LO Base Problem

2015-02-20 Thread Alex Thurgood
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

[libreoffice-users] Re: And while I'm here, data extraction

2015-02-03 Thread Alex Thurgood
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

[libreoffice-users] Re: Split Screen in Writer?

2015-02-03 Thread Alex Thurgood
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

[libreoffice-users] Re: And while I'm here, data extraction

2015-02-02 Thread Alex Thurgood
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

[libreoffice-users] Re: Split Screen in Writer?

2015-02-02 Thread Alex Thurgood
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

[libreoffice-users] Re: JDBC params - the J null date problem

2015-02-02 Thread Alex Thurgood
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

[libreoffice-users] Re: Split Screen in Writer?

2015-02-02 Thread Alex Thurgood
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

[libreoffice-users] Re: JDBC-connector to MySQL database

2015-02-02 Thread Alex Thurgood
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:

[libreoffice-users] Re: JDBC-connector to MySQL database

2015-02-02 Thread Alex Thurgood
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?

[libreoffice-users] Re: JDBC-connector to MySQL database

2015-02-02 Thread Alex Thurgood
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?

[libreoffice-users] Re: Navigator / References / Drag Mode: Useless? Deprecated?

2015-01-31 Thread Alex Thurgood
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),

[libreoffice-users] Re: compatibility with Microsoft Access

2015-01-31 Thread Alex Thurgood
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

[libreoffice-users] Re: [tdf-announce] The Document Foundation announces the results of the Android Tender

2015-01-27 Thread Alex Thurgood
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

[libreoffice-users] Re: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite

2015-01-21 Thread Alex Thurgood
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

[libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite

2015-01-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Support options

2015-01-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Solver kills LiberOffice under Mac OS X.10

2015-01-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Base: Questions From Potential New User

2015-01-17 Thread Alex Thurgood
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

[libreoffice-users] Re: Solver kills LiberOffice under Mac OS X.10

2015-01-17 Thread Alex Thurgood
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

[libreoffice-users] Re: Font color based on value

2015-01-16 Thread Alex Thurgood
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

[libreoffice-users] Re: Support options

2015-01-16 Thread Alex Thurgood
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

[libreoffice-users] Re: What is the current best ODF editing Android Package?

2015-01-16 Thread Alex Thurgood
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.

[libreoffice-users] Re: Base: Questions From Potential New User

2015-01-16 Thread Alex Thurgood
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

[libreoffice-users] Re: What is the current best ODF editing Android Package?

2015-01-14 Thread Alex Thurgood
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

[libreoffice-users] Re: MySQL Native Connector for Linux 4.2 and 4.3

2015-01-04 Thread Alex Thurgood
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

[libreoffice-users] Re: Google Sheets QUERY and Calc equivalent

2014-12-31 Thread Alex Thurgood
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

[libreoffice-users] Re: Select Concat in Form Dropdown?

2014-12-17 Thread Alex Thurgood
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

[libreoffice-users] Re: LOBase connected to SQLite3

2014-12-17 Thread Alex Thurgood
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

[libreoffice-users] Re: Select Concat in Form Dropdown?

2014-12-17 Thread Alex Thurgood
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

[libreoffice-users] Re: How to edit a signature file into a PDF document

2014-12-03 Thread Alex Thurgood
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 +

[libreoffice-users] Re: Impress videos on wrong screen

2014-11-27 Thread Alex Thurgood
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:

[libreoffice-users] Re: Report in Base not executed

2014-11-19 Thread Alex Thurgood
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

[libreoffice-users] Re: Report in Base not executed

2014-11-16 Thread Alex Thurgood
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

[libreoffice-users] Re: Java LO and OSX

2014-11-07 Thread Alex Thurgood
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

[libreoffice-users] Re: LO 4 on OSX 10.10

2014-11-07 Thread Alex Thurgood
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

[libreoffice-users] Re: LO and Java 8u25 - SOLVED

2014-10-28 Thread Alex Thurgood
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

[libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

2014-10-08 Thread Alex Thurgood
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

[libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

2014-10-08 Thread Alex Thurgood
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 :

[libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

2014-10-08 Thread Alex Thurgood
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?

[libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-04 Thread Alex Thurgood
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

[libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-03 Thread Alex Thurgood
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

[libreoffice-users] Re: [Base Database] How to open a particular form at startup ?

2014-10-03 Thread Alex Thurgood
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 ?

[libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

2014-09-26 Thread Alex Thurgood
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

[libreoffice-users] Re: Styles Don't Retain Bold?

2014-09-12 Thread Alex Thurgood
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

[libreoffice-users] Re: Selected fonts are no longer displaying in LO 4.2.4.2 on OSX 10.9.4

2014-09-12 Thread Alex Thurgood
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

[libreoffice-users] Re: Styles Don't Retain Bold?

2014-09-10 Thread Alex Thurgood
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

[libreoffice-users] Re: longstanding bugs - what does it take to get them fixed?

2014-08-31 Thread Alex Thurgood
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.

[libreoffice-users] Re: version backups

2014-08-29 Thread Alex Thurgood
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

[libreoffice-users] Re: Running a Macro from a form

2014-08-29 Thread Alex Thurgood
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

[libreoffice-users] Re: Displaying MathType equations in Writer

2014-08-25 Thread Alex Thurgood
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

[libreoffice-users] Re: LibreOffice - Base...

2014-08-06 Thread Alex Thurgood
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

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alex Thurgood
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 -

[libreoffice-users] Re: Schema in Calc

2014-08-04 Thread Alex Thurgood
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

[libreoffice-users] Re: MAC: 4.3.0.4 Info.plist version confusion

2014-08-04 Thread Alex Thurgood
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).

[libreoffice-users] Re: File corruption on OSX and LO 4252

2014-07-20 Thread Alex Thurgood
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

[libreoffice-users] Re: Sponsoring improvements and bug fixes

2014-07-01 Thread Alex Thurgood
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 :

[libreoffice-users] Re: Fwd: Re: Base graphics/visualization

2014-06-23 Thread Alex Thurgood
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

[libreoffice-users] Re: Fwd: Re: Base graphics/visualization

2014-06-23 Thread Alex Thurgood
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

[libreoffice-users] Re: Base graphics/visualization

2014-06-23 Thread Alex Thurgood
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

[libreoffice-users] Re: Quicklook Plugin?

2014-06-17 Thread Alex Thurgood
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

[libreoffice-users] Re: Quicklook Plugin?

2014-06-16 Thread Alex Thurgood
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

[libreoffice-users] Re: Quicklook Plugin?

2014-06-16 Thread Alex Thurgood
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

[libreoffice-users] Re: Mail Merge - Standard Filter issues

2014-06-03 Thread Alex Thurgood
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

[libreoffice-users] Re: Bug check - 4.2.4, editing Input fields is broken?

2014-06-03 Thread Alex Thurgood
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

[libreoffice-users] Re: Bug check - 4.2.4, editing Input fields is broken?

2014-06-03 Thread Alex Thurgood
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?

[libreoffice-users] Re: [Calc] - Rendering problems /very slowly in 4.2?

2014-05-29 Thread Alex Thurgood
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

[libreoffice-users] Re: table not appearing in .doc format in MAC

2014-05-23 Thread Alex Thurgood
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,

[libreoffice-users] Re: table not appearing in .doc format in MAC

2014-05-23 Thread Alex Thurgood
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

[libreoffice-users] Re: *** SPAM *** Re: Native Connector

2014-05-12 Thread Alex Thurgood
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

[libreoffice-users] Re: Native Connector

2014-05-11 Thread Alex Thurgood
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,

[libreoffice-users] Re: Mac Upgrade error?

2014-05-06 Thread Alex Thurgood
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:

[libreoffice-users] Re: CONVERTING A MICROSOFT TEMPLATE TO BE USED WITH LIBRE OFFICE

2014-04-23 Thread Alex Thurgood
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

[libreoffice-users] Re: Possible LibreOffice Duplex Printing Bug

2014-04-10 Thread Alex Thurgood
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

[libreoffice-users] Re: Bullets Numbering

2014-03-21 Thread Alex Thurgood
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?

[libreoffice-users] Re: Turning spreadsheet data into legible report?

2014-03-19 Thread Alex Thurgood
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

  1   2   3   4   >