[libreoffice-users] Re: Moving Templates from 3.5.5 to 4.0

2013-02-20 Thread Alexander Thurgood
Le 20/02/13 16:18, Karen DInse a écrit : Hi Karen, > Unless someone has another idea, we will create an application that will > open the template from the network location. It's an added step, and takes > almost 1 minute to open the template, even if LO is already open. I've > increased the mem

[libreoffice-users] Re: MySQL-Connector

2013-02-20 Thread Alexander Thurgood
Le 20/02/13 17:04, Dan Lewis a écrit : Hi Dan, > I have a MacBook (Intel)circa 2006 that originally had OS X 10.4 > installed. It has 2 GB RAM and is 32 bit. I have installed Ubuntu 12.04. > Could this be used to compile a connector? If so, what has to be done to > do so? I really have no kn

[libreoffice-users] Re: Any plans to incorporate anything from the Lotus Symphony UI?

2013-02-20 Thread Alexander Thurgood
Le 19/02/13 20:32, Steve Edmonds a écrit : Hi Steve, > Also I found Approach far more intuitive than Base. We could use > Approach in our business, Base is just too much effort, too high a skill > set required for an average user. > Yep, but Approach has never been part of Lotus Symphony...

[libreoffice-users] Re: Any plans to incorporate anything from the Lotus Symphony UI?

2013-02-20 Thread Alexander Thurgood
Le 19/02/13 19:20, Tanstaafl a écrit : Hi, > >> I hear from a believable source that OpenOffice will incorporate some or >> all the symphony GUI in its next release, later this year. > > Yeah, I read that too - but I don't use AOO, I use LibO, hence my > question here specifically baout LibO's p

[libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

2013-02-20 Thread Alexander Thurgood
Le 20/02/13 11:52, Ian Whitfield a écrit : Hi Ian, > MySQL is part of the new installation and I have set it to 'Start on Boot'. > I re-installed MyAdmin via Synaptic > I should have the Connector in the installation. > I edited out the "skip networking" line in /etc/my.cnf > > Now if I try to

[libreoffice-users] Re: MySQL-Connector

2013-02-20 Thread Alexander Thurgood
Le 20/02/13 19:41, Tom Davies a écrit : > Hi :) > Could you copy&paste that to a wiki-page? Then maybe we could expand it a > bit later to cover the main platforms so that point&click users like me are > less scared of doing it? > > How about > https://wiki.documentfoundation.org/Documentation

[libreoffice-users] Re: MySQL Native Connector for 32 bit LibreOffice on Ubuntu 12.04

2013-02-23 Thread Alexander Thurgood
Le 22/02/13 11:49, Fernand Vanrie a écrit : Hi Fernand, > > BUT: we need to find a solution for this problem, for aOO there is also > a connector, it works fine with LO 3.6 , for using it in LO 4.0 we need > to re-compile the extension using the SDK and not the whole code base > who looks a less

Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

2013-03-01 Thread Alexander Thurgood
On 02/28/2013 08:17 PM, Girvin R. Herr wrote: Hi Girvin, > > Just a note: Why do you think you need httpd? Unless you are running a > web server (http://www...) on your computer, you should not need httpd > installed! I am not running a web server, do not have httpd running, > and the compute

[libreoffice-users] Re: BasIe - connecting through JDBC

2013-03-04 Thread Alexander Thurgood
Le 04/03/13 10:55, Fernand Vanrie a écrit : Hi Fernand, > On 4/03/2013 10:49, Fernand Vanrie wrote: >> Heinrich , > oeps typo : read : Sinds we uses for all our tables UTF-8 we have no > encoding problems using OO via ODBC Yes, I have had better results with UTF-8 too, at least insofar as acce

[libreoffice-users] Re: Can't view/edit python macro samples

2013-03-11 Thread Alexander Thurgood
Le 11/03/13 19:23, mickeyf a écrit : Hi Mickey, You can not edit Python macros within LO, you need a separate editor/IDE for that. The same goes for managing them - use your normal file manager for that. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Proble

[libreoffice-users] Re: Problem with MySQL after upgrading OpSys

2013-03-13 Thread Alexander Thurgood
Le 13/03/13 14:54, Ian Whitfield a écrit : Hi Ian, > I added in the following two lines .. > > /$cfg['Servers'][$i]['root'] = 'root';// > //$cfg['Servers'][$i]['password'] = 'x';/ > > I then tried again to log in via phpMyAdmin. The screen does start OK > and I enter 'root' as the user and

[libreoffice-users] Re: [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-14 Thread Alexander Thurgood
Le 13/03/13 17:46, Heinrich Stoellinger a écrit : Hi Heinrich, > I wonder about ONE thing: Even though I specify the name of the database > for > the connector, LO-Base displays ALL the additional databases that are > defined > on the server. This is unlike JDBC/ODBC where only the ONE DB mention

[libreoffice-users] Re: Opening LO Base datafile

2013-03-17 Thread Alexander Thurgood
Le 17/03/13 15:33, Ian Whitfield a écrit : Hi Ian, > I have an old Base embedded HSQL Database that I need to extract all the > data from. > > For some reason I am unable to copy the data out from the Table view, > (It just freezes the whole computer!). So I renamed the ODB file to ZIP > and ex

[libreoffice-users] Re: Opening LO Base datafile

2013-03-17 Thread Alexander Thurgood
Le 17/03/13 15:33, Ian Whitfield a écrit : This should help you on your way for the export : http://www.oooforum.org/forum/viewtopic.phtml?t=59569 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/

[libreoffice-users] Re: Comments being lost

2013-03-18 Thread Alexander Thurgood
Le 17/03/13 05:18, Rogier F. van Vlissingen a écrit : Hi Rogier, > I'm a heavy user of comments, in a book editing project. > > In version 4.0.1.2 the comments go blank when you save the file. I am using > the docx format. > Known bug : https://bugs.freedesktop.org/show_bug.cgi?id=60506 Al

[libreoffice-users] Re: Fonts in Report-Writer

2013-03-18 Thread Alexander Thurgood
Le 18/03/13 16:04, Heinrich Stoellinger a écrit : Hi Heinrich, > After installing LO 4.0 I have the following "weird" behaviour in > Report Writer: > While the fonts for page headings as well as group headings are used as > specified by me when defining a report, detail lines are printed in > (my

[libreoffice-users] Re: Base multiple query access within a single Writer document

2013-03-20 Thread Alexander Thurgood
Le 20/03/13 16:15, Paul D. Mirowsky a écrit : Hi Paul, >> > I would suppose that next logical step is to suggest that like > , is to add > . Unfortunately, I don't think that this is possible. > > This maybe possible with "Section" "Conditions and Variables" but I > wouldn't know where to star

[libreoffice-users] Re: Base multiple query access within a single Writer document

2013-03-20 Thread Alexander Thurgood
Le 20/03/13 16:15, Paul D. Mirowsky a écrit : Hmm, found these : http://forum.openoffice.org/fr/forum/viewtopic.php?f=3&t=12992 http://fr.openoffice.org/Documentation/How-to/writer/Conditions_mailing23fr.sxw Unfortunately, these links lead to content which is in French, but I imagine that simil

[libreoffice-users] Re: Base multiple query access within a single Writer document

2013-03-20 Thread Alexander Thurgood
Le 20/03/13 16:15, Paul D. Mirowsky a écrit : This might help (or not) : http://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=39726 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr

[libreoffice-users] Re: Base multiple query access within a single Writer document

2013-03-20 Thread Alexander Thurgood
Le 20/03/13 16:15, Paul D. Mirowsky a écrit : The most frequently recommended way is to create a unique query or view that returns all the values that you require from each table into a single source (query result). However, doing so, depending on the way your data sets are set up, and the relatio

[libreoffice-users] Re: Base stuck in Read Only mode??

2013-03-27 Thread Alexander Thurgood
Le 27/03/13 15:55, Mark Stanton a écrit : Hi Mark, Ian, >> >> I get "HasPrimaryKey 0" >> >> What is stopping me setting the key or how do I get round this??!! > What is stopping the key being defined is probably the existence of data in the table for the PRI field (autoincrement by any chance ?

[libreoffice-users] Re: Adding values to CSV File via Terminal

2013-04-12 Thread Alexander Thurgood
Le 12/04/13 16:12, Joel Madero a écrit : Hi Joel, > Might start a new thread about this one but, have a bit of a trickier > one now. In the file there are lines that have UNCONFIRMED on a specific > line (this is again, a pull list from FDO). What I would like to do is > merge all the files but o

[libreoffice-users] Re: Python extension not working on Mac (LibreOffice 4.0.2.2)

2013-04-18 Thread Alexander Thurgood
Le 17/04/13 19:04, Carles Pina i Estany a écrit : Hi Carles, > Doing a bit of investigation I've found that if I delete this line: > manifest:media-type="application/vnd.sun.star.uno-component;type=Python" > manifest:full-path="Scripts/MendeleyDesktopAPI.py"/> > > from the file (inside the exte

[libreoffice-users] Re: Python extension not working on Mac (LibreOffice 4.0.2.2)

2013-04-18 Thread Alexander Thurgood
Le 17/04/13 19:04, Carles Pina i Estany a écrit : Hi Carles, Am getting a similar problem with the MRI tool : (com.sun.star.uno.RuntimeException) { { Message = ": invalid syntax (MRI.py, line 21), traceback follows\X000a /Applications/LibreOffice.app/Contents/program/pythonloader.py:102 in funct

[libreoffice-users] Python extensions and LO4

2013-04-18 Thread Alexander Thurgood
Just a note to all users who might have Python extensions installed. With the move to LO4, the version of python that is included in LO was moved to 3.x instead of 2.x, as can be found in LO versions 3.3.x to 3.6.x. This means that those Python extensions, e.g. MRI, pycalendar, etc, that were wri

[libreoffice-users] Re: Python and sys.argv.

2013-04-18 Thread Alexander Thurgood
Le 26/02/13 09:48, SuneOskar a écrit : Hi, Your question would be better asked on the LibreOffice developer mailing list. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Postin

[libreoffice-users] Re: Using a Button to activate Subform. Relationships

2013-04-22 Thread Alexander Thurgood
Le 22/04/13 09:26, Ian Whitfield a écrit : Hi Ian, > 2) Alex - I have checked my DB with MyAdmin and I'm on MySQL 5.1.55 and > the "default Style" is listed as MyISAM. So can I just change this with > MyAdmin or is it a more deep seated problem?? > You can change the default engine on a per ta

[libreoffice-users] Re: Using a Button to activate Subform. Relationships

2013-04-22 Thread Alexander Thurgood
Le 22/04/13 09:26, Ian Whitfield a écrit : > 2) Alex - I have checked my DB with MyAdmin and I'm on MySQL 5.1.55 and > the "default Style" is listed as MyISAM. So can I just change this with > MyAdmin or is it a more deep seated problem?? > It is not a deep seated problem as such, but you have t

[libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Alexander Thurgood
Le 24/04/13 15:35, sun shine a écrit : Hi again, > This may well be what she needs - i.e. insert the additional \r value > for formatting the line endings. I don't know and there's nothing that I > can use from looking for this on the web. As such, this shouldn't be a problem if everything is d

[libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Alexander Thurgood
Le 24/04/13 18:51, Johnny Rosenberg a écrit : Hi Johnny, Thanks for the detailed input. I'm afraid I don't have the solution to your woes, but if I have understood correctly G320, where your error appears, relies on B320 which in turn relies on execution of a macro in order to update its value an

[libreoffice-users] Re: Odd problem LO with Mac running 10.7.5

2013-05-02 Thread Alexander Thurgood
Le 02/05/13 03:04, Richard Lewis a écrit : Hi Richard, > I'm creating instructional design to teach our 8th grade students how to > use LibreOffice Impress. However I'm running into a snag on my own Mac, > developing the multimedia presentation. The slideshow utilizes the > Metropolis theme. W

[libreoffice-users] Re: Paragraph styles

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 21:40, Virgil Arrington a écrit : Hi Virgil, > 4. Document collaboration is a real bugaboo. We lawyers share documents > repeatedly. I would create a document using styles, and send it off to a > colleague for further edits. I would get it back with a mess of styles > and direct forma

[libreoffice-users] Re: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 12:43, Ian Whitfield a écrit : Hi Ian, > Is there a way of adjusting the size at all? > No, AFAIK this is an old "nice-to-have" feature from OOo days that was never implemented. You are not the first to wish for it, nor I doubt, the last. I'm not even sure now whether a bug report /

[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic

2013-05-02 Thread Alexander Thurgood
Le 28/04/13 02:53, Michael Lueck a écrit : Hi Michael, > > I am interested in the capabilities of LibreOffice Basic along the same > lines. I seriously doubt that using LO Basic, you would be able to attain a similar goal in any meaningful timeframe and with decent performance. However, using an

[libreoffice-users] Re: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 12:43, Ian Whitfield a écrit : Hi Ian, > Is there a way of adjusting the size at all? > I'll try and find out on the dev list where the code responsible for this might be (or might not be). Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Probl

[libreoffice-users] Re: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 02/05/13 19:59, Regina Henschel a écrit : Hi Regina, > AFAIK, the checkbox is not self-drawn, but it is the native checkbox > from the OS. Thanks, that would explain why I could find no corresponding code in AWT, in comparison to other elements of the toolkit. I've asked on the dev list anyw

[libreoffice-users] Re: BUG REPORT -- Version 4.0+ (Macbook Lion)

2013-05-02 Thread Alexander Thurgood
Le 03/05/13 07:05, auto78240...@hushmail.com a écrit : Hi Randal, > I have the latest 4.0+ version of Open Office, and see an unwanted > popup when initializing the program. This problem has been > persistent since 3.0+, and was never corrected. The popup shows up > immediately, and gives yo

[libreoffice-users] Re: Integer degrees in Draw

2013-05-03 Thread Alexander Thurgood
Le 03/05/13 13:14, Dan Lewis a écrit : > It is a feature that has been introduced in 4.0. 3.6.6 permits you > to set the degree angle for a line to 100th of a degree (English > system). 4.0.2 and 4.0.3 both limit the degree angle to integers. If you > are going to use 4.0.2, you will have to

[libreoffice-users] Re: Check Box size in LO Base

2013-05-03 Thread Alexander Thurgood
Le 30/04/13 12:43, Ian Whitfield a écrit : Hi Ian, A quick update : https://issues.apache.org/ooo/show_bug.cgi?id=26593 so this bug/RFE is at least 9 years old, and no one ever thought it important enough to allocate resources to it. Note that I haven't even checked in LO's bugzilla yet to see

[libreoffice-users] Re: re. Italics and bold in BASE

2013-05-09 Thread Alexander Thurgood
Le 09/05/13 08:32, Kieran Peckett a écrit : Hi Kieran, > However, MS Access has formatting support - so why not LibO Base? If there > truly is no support for this, then this could be filed as an enhancement on > FDO (our bug tracker). Probably because - LO Base only inherited what limited format

[libreoffice-users] Re: entering records

2013-05-10 Thread Alexander Thurgood
Le 11/05/13 05:28, rounak jain a écrit : Hi, Have a look here : http://www.oooforum.org/forum/viewforum.phtml?f=10 or here : http://forum.openoffice.org/en/forum/viewforum.php?f=13&sid=49d212187c5621a71ea71b35b6897abf and you will probably find what you are looking for and more. Alex -

[libreoffice-users] Re: problems with relationships created in MySQL

2013-05-13 Thread Alexander Thurgood
Le 13/05/13 06:09, rounak jain a écrit : Hi, > I have connected MySql to Base. I created some relationships in MySql. They > are properly visible in the Relationships chart in Base. See image. > http://imgur.com/qtM8fVN,jwvJpen > How did you create your relationships ? - on the mysql server, wi

[libreoffice-users] Re: help with database

2013-05-13 Thread Alexander Thurgood
Le 12/05/13 18:41, Tom Davies a écrit : Hi Tom, all, > Wow!!! That sounds good :) > Thanks Ian. Unfortunately not true. There are mysql objects you can not create from within LO Base, even if you have already got one table defined. An example : try creating a table with a tinyint autoincreme

[libreoffice-users] Re: help with database

2013-05-13 Thread Alexander Thurgood
Le 12/05/13 05:21, rounak jain a écrit : Hi, > I have connected my Base to MySql. Can you please clarify which tasks must > I perform in Base and which ones in MySql..for exampleI > guess I must create tables in MySql...what about "Forms" and "Queries"? > Where must I make the

[libreoffice-users] Re: JDBC driver for Mac OS

2013-05-13 Thread Alexander Thurgood
Le 12/05/13 05:39, rounak jain a écrit : Hi Rounak, > worked. thank you very much. > Bear in mind that performance of LO using the JDBC connector degrades rapidly (it was never stellar) once you reach a few thousand records, or if you are using multiple joins and complex queries. Also, the JDB

[libreoffice-users] Re: JDBC driver for Mac OS

2013-05-13 Thread Alexander Thurgood
Le 13/05/13 13:24, rounak jain a écrit : Hi, > so what must i use? > In the upcoming future 4.1 release of LO, the mariadb driver (which also works with mysql servers) should be included by default. You could try the mysql native C++ driver extension available here : http://code.google.com/a

[libreoffice-users] Re: help with database

2013-05-13 Thread Alexander Thurgood
Le 13/05/13 13:12, rounak jain a écrit : > My feelings too. Thats what made me look for an alternative. But Base has > begun to disappoint me if all this is STILL true: > http://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=6025#p53756 > Yes, this is still true. As I mentioned previously, t

[libreoffice-users] Re: help with database

2013-05-13 Thread Alexander Thurgood
Le 13/05/13 15:07, Ian Whitfield a écrit : Hi Ian, > I wonder what Front-End _YOU_ use Alex?? Would be interested to know. > ("m NOT on a Mac but on Linux (PCLOS 2012). I mostly use sql from the command line ;-) or MySQL Workbench :-)) I have used Base in the past (with OpenOffice.org) for a s

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 05:42, David Karr a écrit : Hi David, > If I have a main entity, and I have two one-to-many relationships to other > tables (FK links from the other tables to the main table), is there any way > to generate a report with the main table data, and the data for the other > relationships

[libreoffice-users] Re: Base data-loss and other problems

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 00:53, Dan Lewis a écrit : > And what would HSQLDB 2.x be with Base connecting to the database > files that have been extracted from an embedded ODB file? One "guru" on > this mailing list seems to have reported that it works well. Look up "DACM" as user name on the OpenOffice.o

[libreoffice-users] Re: Italics and bold in BASE.

2013-05-15 Thread Alexander Thurgood
Le 14/05/13 12:40, Ian Whitfield a écrit : Hi Ian, > Open in normal mode and whatever you enter in the field will have the > Italics and/or Bold that you selected above. > I suspect that what the original poster is looking for is the possibilty to type text strings into memo/longvarchar type fi

[libreoffice-users] Re: Italics and bold in BASE.

2013-05-15 Thread Alexander Thurgood
Le 14/05/13 00:17, acanela a écrit : Hi acanela, > Hello, > > I´m a Libreoffice user and I´d like to use italics and bold in Base. Is it > possible? It would be so important to me. > No, this is not possible. See my response in the other thread where your question was re-posted. Only forms

[libreoffice-users] Re: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 14:40, Tom Davies a écrit : Hi Tom, > Hi :) > I think the devs list might usually be the best place for this sort of thing > but you just happen to catch this list at a particularly good time and it's > been this way for years already. > The dev list is only advisable when somet

[libreoffice-users] Re: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 14:24, Steven Friedrich a écrit : Hi Steven, > I'm looking for a place where I can ask questions about programming Base > applications, using LibreBasic and the API. Is this the right place? > > Ask here : http://forum.openoffice.org/en/forum/viewforum.php?f=13&sid=85991db5df

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : Hi David, > No, I haven't gotten into that yet. I assume I can do some sort of looping > construct in writer that will allow me to step through rows in both the > main table and the relationships tables? Can I use Java or Javascript to > do that iteration

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : Me again. > No, I haven't gotten into that yet. I assume I can do some sort of looping > construct in writer that will allow me to step through rows in both the > main table and the relationships tables? Can I use Java or Javascript to > do that iteration

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : This too, might help you along : http://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=10865&p=51051&hilit=two+queries+in+one+writer+document#p51051 As I mentioned in a previous response, I'm really not sure about whether you can insert two different q

[libreoffice-users] Re: no answers to my question

2013-05-22 Thread Alexander Thurgood
Le 22/05/13 10:25, McBride a écrit : > My question was Can libre office read pages/appleworks/clarissworks? > Thanks. Turquoisegrece The short answer : No. Never could and probably never will unless someone decides to develop the corresponding filters. Clarisworks and Appleworks used binary form

[libreoffice-users] Re: rounding off number results in Base

2013-05-22 Thread Alexander Thurgood
Le 22/05/13 09:34, jnrigg a écrit : Hi, > Dan, it is occurring in a table. The database has no forms. > > I have been using this database for over 10 years (but previously in > OpenOffice). I was under the impression (perhaps wrongly) that a form wasn't > needed if you were comfortable entering

[libreoffice-users] Re: rounding off number results in Base

2013-05-22 Thread Alexander Thurgood
Le 22/05/13 09:34, jnrigg a écrit : > Sorry, just saw that you mentioned you are using LO 4.0.3 on Windows 7. I would say this is a number formatting bug. The question now is whether there is a setting somewhere in the general setup options of Calc, Writer or the dbtable grid component that will

[libreoffice-users] Re: Base to Heroku PostgreSQL requires "SSL=true"

2013-05-23 Thread Alexander Thurgood
Le 23/05/13 05:59, Richard Broermsa Jr. a écrit : Hi Richard, It might well be that a postgres SSL connection isn't supported in your version of LO. Which version of LO, which OS and which version of Java ? I don't know whether the main developer of the LO postgres support code reads this list v

[libreoffice-users] Re: no answers to my question

2013-05-23 Thread Alexander Thurgood
Le 22/05/13 20:45, Tom Davies a écrit : Hi Tom, > Hi :) > It might be worth putting forwards as a major project for next year's "Google > Summer of Code". The topics for this year have been selected already. Seriously, I doubt that anyone is going to volunteer to provide Claris or Applework

[libreoffice-users] Re: LO Base/MySQL Backup??

2013-05-27 Thread Alexander Thurgood
Le 27/05/13 13:27, Ian Whitfield a écrit : Hi Ian, > My question now is - Where does MySQL store the Database and how do I > track it down to make a backup?? Because of all my "messing" around I > have several different files in the system that may be the right one but > I'm not sure which is wh

[libreoffice-users] Re: LO Base/MySQL Backup??

2013-05-27 Thread Alexander Thurgood
Le 27/05/13 13:27, Ian Whitfield a écrit : Hi Ian, Note that if you are using InnoDB as your engine for your database, simply copying the whole data directory to somewhere else in the hope of being able to copy it back one day if everything goes pear shaped will not work. InnoDB uses a binary log

[libreoffice-users] Re: Libreoffice multiple cores - problem

2013-05-27 Thread Alexander Thurgood
Le 26/05/13 10:40, Rinat Camalov a écrit : Hi, > I use libreoffice over 1 year, but now I have one problem. > Libreoffice is uses only one core from CPU, even if i have 6 cores it uses > only one. On my laptop it slows down documents opening, especially *.ods > documents. > How can i make him

[libreoffice-users] Re: How to insert a row between current fields?

2013-05-31 Thread Alexander Thurgood
Le 31/05/13 02:42, minhsien0330 a écrit : Hi, > Dear all: > When editing field names in Design View in Libreoffice Base, I cannot > insert a new row between current fields. > If I click the "Insert Rows", Base will add a new row at the end of > this table, but not the current site. > Does Base no

[libreoffice-users] Re: V4.0 On Mac OS X small vertical scroller does not scroller is flaky

2013-06-10 Thread Alexander Thurgood
Le 10/06/13 13:33, wyattbiker a écrit : Hi, > I just downloaded LO and have found a small issue. Sliders/scrollers > especially small sized will not scroll home easily using the sidebar. > Sometimes the only way is to use the mouse wheel over the list to make them > scroll. > This is one of ma

[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic

2013-06-20 Thread Alexander Thurgood
Le 19/06/13 20:12, Adam Tauno Williams a écrit : Hi Adam, > One thing I haven't found is a good example of presenting / driving some > UI from within the scope of LOo from Python. I don't even know that it > is possible. But I've been lurking the developer list[s] and see talk > about LOo & gl

[libreoffice-users] Re: Database field on top of PDF document

2013-06-21 Thread Alexander Thurgood
Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell, > Ok thanks. I tried that. It worked. You need a form with a transparent > background which took a little work with gimp ( > http://www.ehow.com/how_8422694_remove-white-gimp.html). Then I used a > table to place the fields where I wanted

[libreoffice-users] Re: Libreoffice 4.0.4 OS X - Gatekeeper - missing Developer Signature

2013-06-24 Thread Alexander Thurgood
Le 23/06/13 11:37, Volker Guelke a écrit : Hi Volke, > Dear Libreoffice Team, > > I just tried to run Libreoffice OS X on an OS X Mountaion Lion Installation. > Sadly the binary seems not to be signed by an official OS X developer > certificate generating an warning message to the user. Inside

[libreoffice-users] Re: Libreoffice 4.0.4 OS X - Gatekeeper - missing Developer Signature

2013-06-26 Thread Alexander Thurgood
Le 23/06/13 11:37, Volker Guelke a écrit : Hi Volke, There has been an update of the DMG files to the server, so the download should now contain a signed app. Haven't tried it though. LO 4.0.4 doesn't interest me personally for various problems that it has with databases, so I am holding off on i

[libreoffice-users] Re: Base DB Connections

2013-07-07 Thread Alexander Thurgood
Le 07/07/13 21:37, Mark LaPierre a écrit : Hi Mark, > > Any suggestions on how to proceed from here? Do I just copy and paste > the data from the spreadsheet directly into the mySQL table? > You could try this : 1) Open your ODB file, click on the Tables icon so that you can see the list of

[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 09/07/13 06:46, Mark LaPierre a écrit : Hi Mark, > > I get a new spreadsheet every week with some duplication of data on each > sheet from what was on the previous sheet. I don't want to copy and > paste the duplicate data into the main table. I'll have to think about > this one for a while

[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 07/07/13 21:37, Mark LaPierre a écrit : > Any suggestions on how to proceed from here? Do I just copy and paste > the data from the spreadsheet directly into the mySQL table? > On further reflection, it might be possible to do this by using a macro, in which you connect to the Calc sheet, lo

[libreoffice-users] Re: Need help to "translate" mdb file in odb

2013-07-13 Thread Alexander Thurgood
Le 13/07/13 00:33, Jean Milot a écrit : Hi Jean, > I have tried : > > - [NAME] + [FIRSTNAME] , ok but i need an espace > - [NAME] + " " + [FIRSTNAME] , doesn't work > - LTRIM( coalesce( "NAME", '' ) || ' ' || "FIRSTNAME" ) , doesn't work > - "NAME" || ' ' || "FIRSTNAME", doesn't work > - CONCAT

[libreoffice-users] Re: Need help to "translate" mdb file in odb

2013-07-13 Thread Alexander Thurgood
Le 13/07/13 00:33, Jean Milot a écrit : > How i can make it ??? > Alternatively, this will also work : SELECT CONCAT("prenom_coach" || ' ' || "nom_coach") FROM "coaches" Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

[libreoffice-users] Re: LO-4.0.4 Reportwriter crashes

2013-07-24 Thread Alexander Thurgood
Le 24/07/13 18:13, Heinrich Stoellinger a écrit : Hi Heinrich, > Hello, > I am trying to use LO 4.0.4 on my Linux-Debian-Wheezy system. Most > things work > o.k., except when I try to run a report based on a view within a MySQL > DB, LO > crashes momentarily. The same reports run without problems

[libreoffice-users] Re: SQL-Query Syntax in LO-3.6-Base

2013-07-25 Thread Alexander Thurgood
Le 25/07/13 18:54, Heinrich Stoellinger a écrit : Hi Heinrich, > What's wrong with my query? Which db engine are you using ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting gui

[libreoffice-users] Re: SQL-Query Syntax in LO-3.6-Base

2013-07-25 Thread Alexander Thurgood
Le 25/07/13 18:54, Heinrich Stoellinger a écrit : Hi Heinrich, > insert into "anwesenheit" "a1" > (select > 795,"a2"."persNr","a2"."anwesend","a2"."statAnw","a2"."abwGrund","a2"."mitfahrer","a2"."bemerkung" > > from "anwesenheit" "a2" > where "a2"."veranstNr" = 796) > http://www.hsqldb.

[libreoffice-users] Re: SQL-Query Syntax in LO-3.6-Base

2013-07-28 Thread Alexander Thurgood
Le 28/07/13 17:03, Heinrich Stoellinger a écrit : Hi Heinrich, > I never tried it previously. How do I set the internal SQL parser "off"? > Regards Sorry, I'm being a bit dim. INSERT statements can only be run from the Tools > SQL menu entry and not from the SQL Query window (or Designer for th

[libreoffice-users] Re: SQL-Query Syntax in LO-3.6-Base

2013-07-29 Thread Alexander Thurgood
Le 29/07/13 10:00, Heinrich Stoellinger a écrit : Hi Heinrich, > Using the German UI, I don't have a "Tools" menu item. I suspect it is > called > "Extras" in my version. Clicking on "SQL" under THAT menu I can enter the > SQL statement alright. As mentioned before, this statement is > Yes, tha

[libreoffice-users] Re: Automatic Backup in LibreOffice Base

2013-07-31 Thread Alexander Thurgood
Le 30/07/13 17:26, Tom Davies a écrit : Hi, I could be mistaken, but automatic backup doesn't work for Base documents, and to be honest, I don't think it ever did (or at least not properly). Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libr

[libreoffice-users] Re: Base: In basic, how do you open a form to a particular record number?

2013-08-07 Thread Alexander Thurgood
Le 06/08/13 15:23, Jason White a écrit : Hi Jason, > This is some example code I'm using that opens a form. How do set set > the current record number of the newly opened form from the basic > script. > > Sub OpenDataEntry(oEvent As Object) > Dim FrmName as string > FrmName = "Finalizat

[libreoffice-users] Re: What's needed for reading and writing an excel o spreedsheet file from Java

2013-08-07 Thread Alexander Thurgood
Le 06/08/13 16:08, Edwin F. López A. a écrit : Hi, > I saw the examples of libre office for openning an Excel file, and was > wondering what is required to create a java application that uses > LibreOffice UNO runtime for such a task. That is, use LibreOffice for You need a running instance of L

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

2013-08-07 Thread Alexander Thurgood
Le 07/08/13 10:56, Harshad Italiya a écrit : Hi, > Is there any way so I can set DD/MM/ default so whenever I go for > editing it will show me 30/05/2013 not 05/30/2013 ? > 1) What is your system locale set to ? 2) What is your LO locale set to ? 3) Which lang-pack (if any) are you using ?

[libreoffice-users] Re: I have a question

2012-07-28 Thread Alexander Thurgood
Le 28/07/12 14:17, Lynne Stevens a écrit : Hi Lynne, > *How do I check for duplicates in a data base using another data base ? > By "another data base", do you mean : (a) another ODB file ? (b) another type of database manager, e.g. Access vs Calc, or MySQL vs Access, or even Access vs Acces

[libreoffice-users] Re: Another question concerning Base

2012-08-20 Thread Alexander Thurgood
Le 16/08/12 00:56, Thomas Taylor a écrit : Hi Thomas, > When creating a table in Base with the wizard, is it possible to use a > boolean (yes/no) to control further input fields? If so, how please? > my assumption is that entry conditional control must be done without > the wizard. No, the wiza

[libreoffice-users] Re: Cannot access my database file!

2012-08-25 Thread Alexander Thurgood
Le 24/08/12 21:34, hover2gb a écrit : Hi, > It may help for me to mention that I only added 2 images to the DB before I > began having issues. And the images were 1.7MB and 7 MB, so only a total of > 8.7MB. I wouldn't think this should create any kind of memory issue > No, this shouldn't have

[libreoffice-users] Re: LO 3.6.1 bug report

2012-09-02 Thread Alexander Thurgood
Le 01/09/12 17:58, Dave Long a écrit : Hi Dave, > The file has 4 columns of data: in the first is a date, in the second an item > description, in the third a number (my example records amounts paid into or > taken out of a bank account, so this is a sum of money), and the 4th column > holds t

[libreoffice-users] Re: dBASE file access

2012-09-12 Thread Alexander Thurgood
Le 12/09/12 01:25, Girvin R. Herr a écrit : Hi Girvin, > I did discover that LO requires the dBASE filename to end in ".dbf", not > ".DBF" as I started with. So, LO is case sensitive in this instance. > Yes, that is true. There has been a previous thread on allowed characters and extension nam

[libreoffice-users] Re: Automatically fill user informations from Sun LDAP

2012-09-12 Thread Alexander Thurgood
Le 12/09/12 07:52, Nicolas ABEL a écrit : Hi Nicolas, > I would need a way to fill user informations from a Sun LDAP on a few > hundred computers (Libreoffice 3.5.6.2 already installed). > The best would be to update informations from the LDAP at each restart > or on demand. > Any clue to help us

[libreoffice-users] Re: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

2012-09-14 Thread Alexander Thurgood
Le 14/09/12 12:25, Richard Quadling a écrit : Hi Richard, > I need to be able to double click the file and have it open in Libre Office > Calc. Even if it has to ask me to choose the delimiter to process it with. > > I've no idea if this is possible. On Windows, I'd associate .tsv with Excel > a

[libreoffice-users] Re: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

2012-09-14 Thread Alexander Thurgood
Le 14/09/12 17:22, Richard Quadling a écrit : Hi Richard, > I know I could type lovely long command lines - but why? I want to just > double click a file and get it to do what I want. And I can't seem to find > even the simplest questions. > > If I could find the mechanics that associates a fil

[libreoffice-users] Re: Properties of a Memo field in a Base form for OS X

2012-09-28 Thread Alexander Thurgood
Le 27/09/12 19:27, Dan Lewis a écrit : Hi Dan, > When using a Memo field in a Base form, one can have multi-line > text in it. I know how to specify this . The problem is with another > property of the Memo field: what each line ends with for OS X. Unix uses > a Line Feed to end a line, and

[libreoffice-users] Re: Properties of a Memo field in a Base form for OS X

2012-09-28 Thread Alexander Thurgood
Le 27/09/12 19:27, Dan Lewis a écrit : Hi Dan, > I would like to get some feed back from someone using OS X. More testing confirms that with the build from master I indicated in my previous post, neither LF or CR/LF make any difference, it is impossible to save any data entered in the co

[libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Alexander Thurgood
Le 28/09/12 14:43, Mark Stanton a écrit : Hi Mark, > My query couldn't use the query wizard (Andreas won't be surprised). > In coding the query I wrote the field names in camelcase (eg > "Address1", "PersonName"), the actual database fields are all in > lowercase. Changing this made the mail

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Alexander Thurgood
Le 03/10/12 20:54, Mark Stanton a écrit : Hi Mark, > I've got an XML file (I've generated myself, programmatically). > > I thought it ought to be easy to import it in LO (3.4.6), somehow. I > thougth Calc would be a good bet, but it just gives me "General I/O > error". Base does the same. >

[libreoffice-users] Re: Can someone on OS X verify a writer bug? (bugzilla-link inside)

2012-10-10 Thread Alexander Thurgood
Le 10/10/12 18:20, Dushan Mitrovich a écrit : > This time I opened a new spreadsheet and tried a couple of elementary > things. They worked, so I accessed Preferences and started to look at > the General subheading under LibreOffice. After a few seconds, without > my doing anything, the app hung

[libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread Alexander Thurgood
Le 18/10/12 11:46, John Clegg a écrit : Hi John, > > I can access the data via phpMyAdmin and make changes. I have added a > primary key this way, but I'm not sure that Base is seeing that - there is > no sign of it if I edit the table structure in Base. > How is your primary key defined ? - si

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread Alexander Thurgood
Le 18/10/12 15:10, John Clegg a écrit : > It's a single field, integer and unique. And having been out and in > again base can see the index now, but I still can't edit. Dumb question perhaps, but : user privileges ? Any difference between Base user and phpmyadmin user ? Alex -- For unsubscri

  1   2   3   4   5   6   7   8   9   >