[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Alexander Thurgood
Le 11/02/13 15:18, Uwe Brauer a écrit : Hi Uwe, Now I want to edit the relation and I am offered the possibility to add more fields. So I select the notes file in either table but I receive the following error. Primary or unique constraint required on main table. Accounts in statement

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

[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

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

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

[libreoffice-users] Re: MySQL-Connector

2013-02-20 Thread Alexander Thurgood
Le 20/02/13 19:41, Tom Davies a écrit : Hi :) Could you copypaste that to a wiki-page? Then maybe we could expand it a bit later to cover the main platforms so that pointclick users like me are less scared of doing it? How about

[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

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

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

2013-03-12 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

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

[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

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

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

[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 InsertBase-QueryNext-Record, is to add InsertBase-QueryNext-Query. Unfortunately, I don't think that this is possible. This maybe possible with Section Conditions and

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

[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=7t=39726 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[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

[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 ?). You

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

[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:file-entry manifest:media-type=application/vnd.sun.star.uno-component;type=Python manifest:full-path=Scripts/MendeleyDesktopAPI.py/ from the file

[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 = class 'SyntaxError': invalid syntax (MRI.py, line 21), traceback follows\X000a

[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

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

[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

[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

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

[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

[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

[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

[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

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

2013-05-03 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 you

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

[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

[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=13sid=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, with

[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

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

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

[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=61t=6025#p53756 Yes, this is still true. As I mentioned previously, the

[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

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

[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

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

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

[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=13t=10865p=51051hilit=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

[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

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

[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

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

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

[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

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

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

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

[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

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

[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

[libreoffice-users] Re: Base DB Connections

2013-07-08 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, load

[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( [NAME],

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

[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

[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.org/doc/guide/ch09.html#insert-section

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

[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, that's right,

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

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

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

[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: SQLException when using ADO driver and prepared statements

2013-08-19 Thread Alexander Thurgood
Le 19/08/13 14:30, mhaverin a écrit : Hi, DatabaseContext = createUnoService(com.sun.star.comp.sdbc.ado.ODriver) Connection = DatabaseContext.connect(sdbc:ado:PROVIDER=sqloledb;DATA SOURCE=myserver;INITIAL CATALOG=mydb;USER ID=user;PASSWORD=pwd, flatProp()) Statement =

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-21 Thread Alexander Thurgood
Le 20/08/13 07:54, mhaverin a écrit : Hi, It doesn't seem to work. I tried SELECT col1 FROM tbl1 WHERE col2 = :x and just got a bunch of errors (listed below). I did some googling already but didn't find anything yet. I have some actual work that has to be done so I'm going to have to

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 13:35, mhaverin a écrit : Hi, I tried that. The only difference when the Run SQL command directly button is on is that I don't get the Parameter Input dialog. The errors stay the same. Sounds like bug submission time then ;-) Alex -- To unsubscribe e-mail to:

[libreoffice-users] Re: Problem with definite integral

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 11:40, Uwe Dippel a écrit : Hi Uwe, I have yet to find a nice way to draw the vertical line that is usually used in solving definite integrals; the one where one writes upper and lower limits as sub and sup. Can anyone suggest anything better than | which comes out looking quite

[libreoffice-users] Re: Problem with definite integral

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 15:15, Alexander Thurgood a écrit : Or alternatively : int_1^infty() Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

[libreoffice-users] Re: Cross Platfrom Support Question

2013-08-26 Thread Alexander Thurgood
Le 24/08/13 11:21, Jay Ridgley a écrit : Hi Jay, there were no regular installation files available and to make another selection She is running MAC OSX How should she proceed? There is currently no fully functional mobile version of LibreOffice available for Android or iOS touchscreen

[libreoffice-users] Re: LO - 4.1.1-report-builder problem

2013-08-30 Thread Alexander Thurgood
Le 30/08/13 11:47, Heinrich Stoellinger a écrit : Hi Heinrich, Having just installed the released LO 4.1.1 version, I still keep getting the same error as under 4.1.1-RC2 when trying to run a report based on a MySQL-Database view (I tend to assume that they are actually the same anyway?).

[libreoffice-users] Re: Database error

2013-08-30 Thread Alexander Thurgood
Le 29/08/13 11:04, Andreas Kloss a écrit : Hi Andreas, I use Mac and have Libreoffice 4 download 2 day a go from your Server. Then I like to use the Database I get this error : SQL Status: 42000 Error code: 105 [Actual][SQL Server] Unclosed quotation mark after the character string

[libreoffice-users] Re: LO for a Mac Powerbook G4

2012-07-20 Thread Alexander Thurgood
Le 20/07/12 17:23, Ken Springer a écrit : Which version of LO is the latest and/or most bug free that will run on the Powerbook G4? Apparently, this one : http://www.libreoffice.org/download/?type=mac-ppclang=en-USversion=3.5.5 However, the term bug free is too relative to be of any

[libreoffice-users] Re: Base and SQL statement

2012-07-20 Thread Alexander Thurgood
Le 20/07/12 16:41, Dan a écrit : Hi Dan, Is it a good idea to have the three conventions checked that are listed there? Why or why not? I generally uncheck the ODBC convention option when working with dates, as otherwise LO and OOo Base do things like injecting additional characters

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

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

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

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

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

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

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

[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

  1   2   3   4   5   6   7   8   >