[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 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: 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 acco

[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 Capture

[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 ter

[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: 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 > platfo

[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 L

[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 Problems

[libreoffice-users] Re: Libre Office Base

2015-07-19 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: >>insert>field> I have only file name, but no others t

[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? http://www.libreoffice.org/get-help/mailing-lists/ho

[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 kn

[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 f

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

2015-04-29 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 bug

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

2015-04-29 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 optio

[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 guidelines

[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: users+unsubscr...@global.libreoff

[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 c

[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 t

[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 depen

[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, o

[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 dragging

[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: 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 p

[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 th

[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 may

[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: 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 wh

[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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr

[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=40&t=837#p4041 Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-u

[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: users+unsubscr...@glob

[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: 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 produ

[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: [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

[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 t

[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 confi

[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 the

[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

[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 spre

[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

[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 fr

[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 perfe

[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: 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 http://www.techrepublic.com/blog/diy-it-guy/diy-conditio

[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 p

[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 incl

[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 Goo

[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) >> >

[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 & PHP&SQLite3 as separate > programs but the config process was too much for me why I installed > WAMP2.4.As you know is WAMP

[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 (

[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: users+unsubscr...@global.

[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 provid

[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 profi

[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 J

[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: Recommended version of Java?

2014-11-01 Thread Alex Thurgood
Le 31/10/2014 21:12, Andreas Säger a écrit : > Huh? Really? Which issue number was that? I can't believe that any LO > version had been released with such a show stopper issue. > Well, please reconsider your statement in light of the requirement for LibreOffice 4.3.3 on OSX Yosemite and current

[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 : 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-h

[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 : http:

[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: 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: [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 ? https://forum.openoffice.org/en/forum/viewtopic.php?f=

[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 primar

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

2014-09-27 Thread Alex Thurgood
Le 26/09/2014 11:03, Don Parris a écrit : > Thanks Alex. The underlying query gets the month from the date, as well as > the total, average, max and min for each month. The results are, of > course, already grouped & calculated by month. I was able to get the > overall total, but also wanted to

[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: 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 wo

[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 sequ

[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

[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 suppor

[libreoffice-users] Re: [Not to group] Re: files on network shares not opening. Own ones are ok?

2014-08-29 Thread Alex Thurgood
Le 29/08/2014 12:37, hdv@gmail a écrit : Hi, > P.S. To be honest, I have neglected til now to file a bug-report for > this. Should have done so, but somehow I never did. > There have already been several bug reports about this. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.lib

[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 >

[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 ~/.config/libreoffice/3/u

[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 copy/paste

[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: 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: z

[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

[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 Acces

[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 > h

[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=libreoffice&project_id=&project_name= and here : https://www.bountysource.com/trackers/52

[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 supporti

[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

[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: 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

[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

[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: 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? http://www.libreoffice.org/get-help/

[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 https://www.li

[libreoffice-users] Re: Importing financial report into Write

2014-06-03 Thread Alex Thurgood
Le 03/06/2014 03:34, Keith Bates a écrit : Keith, You could try this : http://sourceforge.net/projects/csv2odf/ 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 + mo

[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 > p

[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

[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 (g

[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

[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 t

[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, or

[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

  1   2   3   4   >