[libreoffice-users] Re: Templates for Minutes

2013-02-07 Thread Alex Thurgood
Le 07/02/2013 13:39, Tom Davies a écrit : Hi Tom, I just looked through the Templates web-page http://templates.libreoffice.org/template-center but i couldn't find anything there to help people wanting to write-up Minutes a bit more easily. There's a wizard for this built-in. Try

[libreoffice-users] Re: RE-NAMING database (Base) tables is broken in LO v.4?

2013-02-08 Thread Alex Thurgood
Le 08/02/2013 08:00, frofa a écrit : Hi, I have just installed the newly-released LO Version 4.0.0.3 (Build ID: 53fd80e80f44edd735c18dbc5b6cde811e0a15c) and testing with some of my 'split' databases (using HSQLDB v.2.2.8 in 'file mode'). I notice when I right-click on a TABLE NAME (in the

[libreoffice-users] Re: Value and Date function in Macro

2013-02-08 Thread Alex Thurgood
On 02/08/2013 11:15 PM, Joel Madero wrote: Hi Joel, I have some vague recollection that the Date function in Calc (i.e. the one used when entering manually) and the Date function in Basic are not the same... You could always see whether any of the methods used in this Java snippet, taken from

[libreoffice-users] Re: RE-NAMING database (Base) tables is broken in LO v.4?

2013-02-10 Thread Alex Thurgood
Le 08/02/2013 10:32, frofa a écrit : Hi, Also the RENAME option under the mail EDIT menu is dimmed. I have restarted the OS and cleared caches with no result. Open a bug report against the Database component, but please provide detailed information on how to set up your particular

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

2013-02-11 Thread Alex Thurgood
On 02/11/2013 11:31 PM, Uwe Brauer wrote: Hi Uwe, As I said, in another mail, when I connect the data base to mysql via ODBC then I can set more relations, but they are not saved.. I take it that you are using InnoDB engine in your mysql db ? Otherwise, e.g. if you are using myisam or

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

2013-02-12 Thread Alex Thurgood
On 02/12/2013 05:59 PM, Uwe Brauer wrote: Hi Uwe, Well show engines; showed InnoDB | YES | Supports transactions | YES | YES | YES So I presume the answer is yes. In theory, yes, but you might want to check each table to see whether it does actually use the

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

2013-02-12 Thread Alex Thurgood
On 02/12/2013 06:03 PM, Uwe Brauer wrote: Hi Uwe, Robert Grosskopf wrote a handbook in German that should be available on the German LO wiki somewhere. As far as MySQL problems, I think I tried to modify fields in a table while using MySQL. They were not saved either. You might

[libreoffice-users] Re: MySQL-Connector

2013-02-15 Thread Alex Thurgood
On 02/15/2013 10:24 PM, Tom Davies wrote: Tom, Is there a problem with running different versions on different OSes? It should be fine t do that shouldn't it? Regards from Tom :) Please, please, pretty please, sometimes I really do get the impression you have not read anything we have

[libreoffice-users] Re: MySQL-Connector

2013-02-16 Thread Alex Thurgood
On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, - it neither works on Mint-Nadia or Windows-Vista (I know, I know -- I should upgrade THAT system!). The connector DID however work under Vista and LO 3.6.5. Unfortunately I really don't have the time to compile it

[libreoffice-users] Re: MySQL-Connector

2013-02-16 Thread Alex Thurgood
On 02/15/2013 08:15 PM, Dan Lewis wrote: Hi Dan, One of the problems depends upon whether the OS is 32 bit or 64 bit. I have a tower that is 64 bit and a MacBook which uses 32 bit with both using Ubuntu 12.04 LTS. The native connector works fine for 64 bit but does not work for the 32

[libreoffice-users] Re: MySQL-Connector

2013-02-16 Thread Alex Thurgood
On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, Unfortunately I really don't have the time to compile it myself... What are the plans in any case? If your Nadia OS is 32bit, try this : https://dl.dropbox.com/u/107086405/32bit/U1204/mysql-connector-ooo.oxt and let me know

[libreoffice-users] Re: MySQL-Connector

2013-02-16 Thread Alex Thurgood
On 02/16/2013 10:09 AM, Alex Thurgood wrote: If your Nadia OS is 32bit, try this : https://dl.dropbox.com/u/107086405/32bit/U1204/mysql-connector-ooo.oxt and let me know whether it works. 64bit version here (Ubuntu1204 baseline) : https://dl.dropbox.com/u/107086405/64bit/U1204/mysql

[libreoffice-users] Re: MySQL-Connector

2013-02-16 Thread Alex Thurgood
On 02/16/2013 06:55 PM, Heinrich Stoellinger wrote: Hello Alex, Thanks for the offer - unfortunately it does NOT work.. What a pity! Regards H Ok, so that confirms that it is Linux OS bit and version dependent, probably because the versions of the mysql libraries have changed too. Alex

[libreoffice-users] Re: Link Base to External Spreadsheet

2013-02-17 Thread Alex Thurgood
Le 17/02/2013 02:38, Mark LaPierre a écrit : Hi Mark, Now how do I create non-linked tables inside the same DB? How do I link to another external spreadsheet using the same DB? You would be better off using an external HSQLDB instance to link directly to text tables (note that these

[libreoffice-users] Re: MySQL-Connector

2013-02-17 Thread Alex Thurgood
Le 16/02/2013 22:40, Heinrich Stoellinger a écrit : Looks like it, Alex! As I said before, I don't really want to use the Java version, it I had an afterthought question for you : do you have libmysqlclient or libmysqlcppconn installed on your Nadia box ? These might well be necessary for

[libreoffice-users] Re: MySQL-Connector

2013-02-20 Thread Alex Thurgood
Le 20/02/2013 22:15, Dan Lewis a écrit : Hi Dan, Steps taken so far: 1) Used synaptic to download libmysqlclient and libmysqlcppconn. I also downloaded the dev version of these. 2) |sudo apt-get build-dep libreoffice # Debian derivatives| |3) sudo apt-get install git 4) |git clone

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

2013-02-21 Thread Alex Thurgood
managed to fathom that out. Prior to downloading the master build, I installed two files that Alex Thurgood suggested: libmysqlclient18 and libmysqlcppconn5 using synaptic. I also noticed these files were available: libmysqlclient-dev and libmysqlcppconn-dev. So I installed these also

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

2013-02-21 Thread Alex Thurgood
Le 21/02/2013 04:21, Dan Lewis a écrit : So the reason for this email including the QA people is that I would like a simple test done by someone with a 32 bit Debian system and MySQL server. Please install the AOO MySQL native connector. Also install these two files: libmysqlclient18 and

[libreoffice-users] Re: Filtering a Base Table by Data

2013-02-21 Thread Alex Thurgood
Le 21/02/2013 10:00, Marion Noel Lodge a écrit : Hi Noel, Can someone tell me what I'm missing? Not sure, but you could try : [D:01/07/2012] Which version of LO are you using ? What is your Base table's data source (embedded hsqldb, spreadsheet or text file, mysql, postgresql) ?

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

2013-02-21 Thread Alex Thurgood
Le 21/02/2013 09:57, Ian Whitfield a écrit : Hi Ian, mysql CREATE USER 'ianw'@'localhost' IDENTIFIED BY 'pwd'; Query OK, 0 rows affected (0.00 sec) mysql GRANT ALL ON db1.* TO 'ianw'@'localhost'; Query OK, 0 rows affected (0.00 sec) But when I try to get into MyAdmin with this user and

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

2013-02-21 Thread Alex Thurgood
Le 21/02/2013 12:57, Ian Whitfield a écrit : [ian@localhost ~]$ mysql -u ianw -p Enter password: Welcome to the MySQL monitor. This means that you should also be able to connect from LO. Looks like your PHP and phmyadmin installation are screwed, can't help you there I'm afraid, but you

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

2013-02-21 Thread Alex Thurgood
Le 21/02/2013 13:41, Dan Lewis a écrit : Hi Dan, What I am going to do is run make again. This time I will use the following so I have a log of the process: | make 21 | tee build.log You have a successful LO build, congratulations. You can now setup the build as a developer

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

2013-02-22 Thread Alex Thurgood
Le 22/02/2013 10:53, Ian Whitfield a écrit : Ian, Well I'm in a real hole here!!! This morning I decided to go back to basics and re-installed all the MySQL packages (in case) Seriously, that was an unnecessary, and potentially, bad move. I have no idea how PCLinuxOS packages mysql server

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

2013-02-24 Thread Alex Thurgood
Le 23/02/2013 11:56, Ian Whitfield a écrit : Hi Ian, I have accepted what has happened and am busy re-building my DB from scratch! IMHO it is still WRONG to store Data in an area that gets overwritten every time you do a upgrade or re-install. In over 30 years Usually, an simple upgrade of

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

2013-02-24 Thread Alex Thurgood
Le 24/02/2013 14:05, Ian Whitfield a écrit : Hi Ian, As per the WebSite I opened my already prepared DB Table and tried the instruction to Drag the Calc Sheet from Calc to the open DB Table. All I get is a red circle with a line through it which I interpolate as meaning Not Allowed. So I went

[libreoffice-users] Re: Looking for PyUno Contributor(s)

2013-02-24 Thread Alex Thurgood
On 02/24/2013 08:32 PM, Adam Tauno Williams wrote: Hi all, I've even attempted to make several runs at it. The documentations is a *@(^@*$^@*# crime. There are silly trivial Hello World examples, and there is the dump of the API. And nothing in between. mailmerge.py LibreLogo.py

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

2013-02-24 Thread Alex Thurgood
On 02/24/2013 04:05 PM, Ian Whitfield wrote: Hi Ian, You could be right Alex!! I KNOW one of these two ways worked for me last time!! Is there another way to input the CSV data if it is a bug?? http://dev.mysql.com/doc/refman/5.1/en/load-data.html Alex -- For unsubscribe instructions

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

2013-02-24 Thread Alex Thurgood
On 02/24/2013 04:05 PM, Ian Whitfield wrote: Is there another way to input the CSV data if it is a bug?? http://www.softwareprojects.com/resources/programming/t-how-to-use-mysql-fast-load-data-for-updates-1753.html -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-28 Thread Alex Thurgood
On 02/28/2013 03:16 PM, Tom Davies wrote: Hi Tom, It is god to hear you have found a work-around. If you wanted to install a version of Libreoffice or OpenOffice alongside it then please use the Installing in Parallel wiki-guide https://wiki.documentfoundation.org/Installing_in_parallel

[libreoffice-users] Re: definition of flat/relational database

2013-03-03 Thread Alex Thurgood
Le 03/03/2013 19:50, Wolfgang Keller a écrit : Hi all, Neither OOo, AOO, or LO have ever supported multitable referential integrity, multitable write or multitable query operations with regard to the dBase file format. It was requested by users several times in various ways over the years

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

2013-03-04 Thread Alex Thurgood
Le 02/03/2013 14:10, Heinrich Stoellinger a écrit : Hi Heinrich, Hello, Seeing as the Native MySQL-connector seems to be a difficult birth - I tried both ODBC and JDBC lately. Unfortunately both seem to be unusable! JDBC: I cannot get it to accept German special characters (even though I

[libreoffice-users] Re: Macro Security Settings

2013-03-10 Thread Alex Thurgood
Le 09/03/2013 23:12, Andrew a écrit : Hi Andrew, On 3/9/2013 12:42 PM, Johnny Rosenberg wrote: VBA. Ouch. I've received Basic runtime error 1. Is there a translation guide? There used to be one available for paying customers of StarOffice, at the time supplied by Sun, not sure whether

[libreoffice-users] Re: Basic macro – How to get locale info?

2013-03-10 Thread Alex Thurgood
Le 09/03/2013 21:52, Johnny Rosenberg a écrit : Hi Johnny, http://api.libreoffice.org/docs/common/ref/com/sun/star/i18n/LocaleDataItem.html#decimalSeparator Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 21:16, Tom Davies a écrit : Hi Tom, Apparently it also doesn't work on Macs although i'm entirely certain how far that goes. For example could Base as a front-end on a Mac read MariaDb as a back-end on a Debian server. Presumably it does but i don't know of anyone that has

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

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:37, Tom Davies a écrit : Hi Tom, My quick, probably inaccurate guess is the connector. Is the system 32 or 64bit? Clearly a GnuLinux. Is the MySql on the same computer or on a separate server? It has nothing to do with the connector. We are talking about the (in)correct

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

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:12, mickeyf a écrit : Hi Mickey, C:\Program Files (x86)\LibreOffice 4.0\share\Scripts\python\pythonSamples I was interested in using macros with calc, but since they should also be available in writer I find it a bit ironic that I need a external program (or non-integrated

[libreoffice-users] Re: Macros don't run

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:13, Malcolm Moore a écrit : Hi Malcolm, If you recorded a calc macro in 3.5.4 and then open the same spreadsheet in 4.0.n the macro isn't there .. or at least I can't find them. Anyone got any ideas Quite possibly, the configuration files from 3.5.x which point to the

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

2013-03-14 Thread Alex Thurgood
Le 14/03/2013 14:16, Heinrich Stoellinger a écrit : Hi Heinrich, Thanks for your hint! I had Ignore Driver Privileges checked BEFORE! Turning it off didn't make any difference... Well at least that's another thing to report as not working ;-) Alex -- For unsubscribe instructions e-mail

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

2013-03-20 Thread Alex Thurgood
Le 19/03/2013 17:15, Paul D. Mirowsky a écrit : Hi Paul, I recently tried to use 2 Base queries within a single Writer document. What exactly do you mean here ? - a first query from a first datasource/table in one part of the document that returns a first set of data values (e.g. refs,

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

2013-03-20 Thread Alex Thurgood
Le 18/03/2013 21:21, Girvin R. Herr a écrit : Hi Girvin, Alex, Is Datavision on your list? http://datavision.sourceforge.net/ No, but I'll take a look. I'm actually considering Dabo (already mentioned here in a previous thread), or just simply using Python/UNO or PHP to manipulate

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

2013-03-27 Thread Alex Thurgood
Le 27/03/2013 08:59, Ian Whitfield a écrit : Hi Ian, I have set-up a new MySQL Database, imported all my CSV data from my old Database, Connected LO Base to this and designed my 'User Form'. Everything is working fine _EXCEPT_ my 'User Form' seems to be stuck in 'Read Only' mode as I can not

[libreoffice-users] Re: Inserting an empty string in Base

2013-03-30 Thread Alex Thurgood
Le 29/03/2013 21:57, Girvin R. Herr a écrit : Hi Girvin, Why not use NULLs? I use them all the time when a field is unknown. The only places I do not allow NULLs are the primary and foreign keys and maybe some fields that are in calculated field formulas, such as: price * quantity. Hope

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

2013-04-11 Thread Alex Thurgood
Le 11/04/2013 02:47, Joel Madero a écrit : Hi Joel, A quick trawl reveals several possibilities : http://stackoverflow.com/questions/4749658/inserting-filename-into-last-column-of-csv-file http://stackoverflow.com/questions/9506810/add-column-to-end-of-csv-file-using-awk-in-bash-script

[libreoffice-users] Re: Oracle Report Builder - Text field overflow and N.aN problem

2013-04-12 Thread Alex Thurgood
Le 04/04/2013 11:16, Marion Noel Lodge a écrit : Hi Noel, As it turns out, this is a known bug suspected to be in the number formatting code of the reportbuilder Java code and associated XSLT processing : https://bugs.freedesktop.org/show_bug.cgi?id=33091 So not, at first sight, easy to

[libreoffice-users] Re: Printing speed is glacial for large file

2013-04-12 Thread Alex Thurgood
Le 11/04/2013 00:13, David Ronis a écrit : Hi David, Any suggestions? I'm not certain, but it might have something do with the Print to File being a synchronous code execution, so the app has to wait until the data has been processed before being able to free up enough resources for fluid

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

2013-04-22 Thread Alex Thurgood
Le 21/04/2013 15:30, Dan Lewis a écrit : Bear in mind as well that if you are using MyISAM as your table memory storage engine then referential integrity will not be enforced between tables. The switch to use the InnoDB storage engine by default, which supports intertable relations and

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

2013-04-24 Thread Alex Thurgood
Le 02/04/2013 19:48, Johnny Rosenberg a écrit : Hi Johnny, Just a few thoughts in an attempt to narrow down the problem : - which version of OpenOffice.org did you originally use to create the file ? - the cells that show Err 522, do they have a particular formula that requires recalculation

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

2013-04-24 Thread Alex Thurgood
Le 24/04/2013 14:36, sun shine a écrit : Hi, How can I advise her to save spreadsheets as *.csv formats in a way that HMRC can read these as if saved in the MS Dos CSV format (which LibO doesn't have the option to do)? Is there something in the save procedure that she needs to attend to?

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

2013-04-24 Thread Alex Thurgood
Le 24/04/2013 14:36, sun shine a écrit : Looking at this : http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true_pageLabel=pageImport_ShowContentid=HMCE_PROD_010685propertyType=document gives a list on how to structure the file and hints on what to do if your

[libreoffice-users] Re: printers compatible with GnuLinux

2013-06-09 Thread Alex Thurgood
Le 07/06/2013 12:33, Tom Davies a écrit : Hi Tom, Does anyone know of companies that do product-lines that are easily compatible with GnuLinux? My 2cents : Canon : OK for workgroup printing, even fairly complicated option stuff *_IF_* you manage to get hold of a PPD file that you can then

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

2013-06-21 Thread Alex Thurgood
Le 21/06/2013 05:23, howellsilverman a écrit : Hi, When I try to move a database field on top of an image (or PDF object), writer won't let me place it on top of the image. Is there a way to put a database field on top of an image? If you try to insert the fields by dragging and dropping

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

2013-06-22 Thread Alex Thurgood
Le 21/06/2013 20:46, howellsilverman a écrit : That is correct. These are forms that are available to me as pdf's without fillable fields. Even if the fields were fillable - I want to fill them from a database. I'm not the creator of these forms so I have to work backward from what I receive.

[libreoffice-users] Re: Impress Templates

2013-06-22 Thread Alex Thurgood
Le 21/06/2013 22:20, Sajan Parikh a écrit : Are there any sources I can find some better, cleaner, and more modern looking Impress templates? Try here : http://extensions.services.openoffice.org/fr/project/oxygenoffice-templates-multilanguage Alex -- To unsubscribe e-mail to:

[libreoffice-users] Re: Base PostgreSQL Transactions

2013-07-22 Thread Alex Thurgood
Le 19/07/2013 22:31, Don Parris a écrit : Hi Don, One possible way is to set up your form (which after all, is only a Writer or Calc document) as a dummy interface that is not bound to any data fields, and then use Basic to manage the data entered by the user as an array, construct a SQL

[libreoffice-users] Re: Kerning issue with LIbreOffice 4 and Helvetica font

2013-07-22 Thread Alex Thurgood
Le 18/07/2013 20:17, pfrost a écrit : Hi Patrick, In LibreOffice 4.1.0.1, if I open a document containing Helvetica font and export to PDF, the Helvetica font has horrible kerning--almost all spaces between words are removed, making the PDF very difficult to read. If I open the same document

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

2013-07-28 Thread Alex Thurgood
Le 26/07/2013 00:15, Heinrich Stoellinger a écrit : Hi Heinrich, This query (ommitting the ) has been working perfectly for years when issued from the mysql command-line client. It is correct SQL syntax... Are you attempting to run it in LO with the internal SQL parser on or off ? My guess

[libreoffice-users] Re: writer-basic: insert an image from a database binary field

2013-08-03 Thread Alex Thurgood
Le 02/08/2013 08:39, Alain Van Utterbeeck a écrit : Hi Alain, Chapter 2.5.2. Extracting binary data http://www.pitonyak.org/database/AndrewBase.pdf might be of some help here. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Mail merge manual field entry

2013-08-19 Thread Alex Thurgood
Le 12/08/2013 22:12, Carl Paulsen a écrit : Hi Carl, 1) Create a Writer document template with the size of the label you require or use one of the pre-supplied label formats provided with LO. 2) In order to be able to include Database Field Names, you will need to (a) be able to either

[libreoffice-users] Re: Converting Access 2003 DB w/Security

2013-08-19 Thread Alex Thurgood
Le 14/08/2013 21:36, dfrerichs a écrit : Hi Dave, The problem arises when I have to add or delete a new user or change an existing user's rights. It seems that the only way I can modify the workgroup settings is by opening the DB up in Access, changing the security settings there and then

[libreoffice-users] Re: Mail merge manual field entry

2013-08-25 Thread Alex Thurgood
Le 23/08/2013 03:45, Carl Paulsen a écrit : Hi Carl, Thank you Alex. I'll give your ideas some thought. The key issue for me is that I can manually enter placeholders for fields as text that Salesforce can interpret for the merge on their platform (well, I think I can but haven't been able

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

2013-08-25 Thread Alex Thurgood
Le 22/08/2013 11:52, mhaverin a écrit : Hi, I went and added this: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68417 Thank you for your help! No problem, the only difficulty now will be finding a QAer who has the same setup or can attempt to do what you are trying to do. I don't

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

2013-08-25 Thread Alex Thurgood
Le 25/08/2013 13:05, Alex Thurgood a écrit : Me again. You also might want to read this thread : http://forum.openoffice.org/en/forum/viewtopic.php?f=30t=41226 which basically resumes the whole situation pretty well. Alex -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Alex Thurgood
On 01/07/2012 11:33, Ulf Göransson wrote: Hi Ulf, On 01/07/12 11:28, Andreas Säger wrote: Yes and no. I see three example macros under LibreOffice Macros but none of my own. I take it that your own python scripts are still in the Script directory ? Just wondering whether an update

[libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Alex Thurgood
On 01/07/2012 13:02, Ulf Göransson wrote: Hi Ulf, /usr/lib/libreoffice/share/Scripts/python/HelloWorld.py to the same location, just in case there had become something wrong with my files but that doesn't show up either. However, when I did the opposite and put my script under /usr/lib/...,

[libreoffice-users] Re: Macro code to highlight a field on a Form

2012-07-02 Thread Alex Thurgood
On 01/07/2012 12:11, Marion Noel Lodge wrote: Hi, *This works well, but what I haven't been able to work out is how to highlight the Amount field so that the user can then type in the new amount over the top of the existing amount. The user could just type Ctrl + A, but I'm trying to reduce

[libreoffice-users] Re: Base fread-only

2012-07-20 Thread Alex Thurgood
On 07/18/2012 09:22 PM, Larry Blanchard wrote: Hi Larry, I purged OO and installed LO. Still using Ubuntu 10.04. Did you also purge (or otherwise rename) your OOo user configuration folder ? If I open one of my databases in LibreOffice 3.5.4.2 it works fine. If I open the other, I

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

2012-07-20 Thread Alex Thurgood
On 07/20/2012 07:06 PM, webmaster-Kracked_P_P wrote: Now we need to build up the numbers in the Windows and Mac office market. LO does have the advantage of more [so I have heard] language support than MSO does, and you do not need to buy a new version to get these 100+ supported languages

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

2012-07-20 Thread Alex Thurgood
On 07/20/2012 08:05 PM, Ken Springer wrote: Apple doesn't include things similar to Wordpad and the like with their OS. It does come with TextEdit, a RTF capable editor/word processor, although I would use that last term lightly. So I'm collecting some software that can be installed by

[libreoffice-users] Re: Bug #53591: Field properties in Table Design dialog in Base

2012-08-19 Thread Alex Thurgood
On 19/08/2012 13:07, Dan wrote: Hi Dan, Confirmation by someone else would be appreciated. Confirmed. I could also reproduce the problem on 3.4.4, so the problem is actually fairly old. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: segfault when trying to use base-reports

2012-08-29 Thread Alex Thurgood
On 08/27/2012 10:50 PM, Heinrich Stoellinger wrote: Hi Heinrich, Hi again... The report builder actually works just fine under my 3.6.0.4 LO on Linux Mint-Maya. It is a known bug : https://bugs.freedesktop.org/show_bug.cgi?id=53872 I take it that your report contains fixed lines or cells

[libreoffice-users] Re: Ver. 3.6.1 still bad recognition date.

2012-08-29 Thread Alex Thurgood
On 08/29/2012 10:50 PM, Rafał Piszczek wrote: Hi Rafal, Ver. 3.6.1 still bad recognition date. Up to ver. 3.5.6 when I wrote 23/8 or just 23 / changed to 23.08.2012 - now despite cell format as a date - nothing changes ... For me it falls off. Daily I have to write on a sheet about 150 dates.

[libreoffice-users] Re: spadmin fails to run

2012-08-30 Thread Alex Thurgood
On 08/26/2012 08:39 PM, rcdawson wrote: Hi, In order to change the default printer language I attempted to run spadmin. Logged in as root, I located the directory containing spadmin and issued the command +./spadmin. The result was to return four lines, each reading No protocol specified. I

[libreoffice-users] Re: Using photos within a Mail Merge setup??

2012-10-06 Thread Alex Thurgood
Le 05/10/2012 23:45, robertjm a écrit : Hi Robert, While I understand how to insert the name and ages text from a Calc spreadsheet, I'm not clear on how to automate the photo insert. Is it as simple as adding a URL link into a cell within Calc (i.e.: John,Smith,c:\files\JohnSmith.jpg)

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Alex Thurgood
Le 08/10/2012 15:24, Andreas Säger a écrit : When the whole OpenOffice.org project was at risk, LibreOffice could have had it all. Unfortunately, some extra smart meritocrats rejected the idea of taking over that forum at the price of hosting it. Now it is part of the Apache infrastructure.

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

2012-10-18 Thread Alex Thurgood
On 10/18/2012 08:02 AM, John Clegg wrote: Hi John, I am accessing the remote MySQL database using com.mysql.jdbc.Driver. When I access the data by opening the table or using the form it is read-only. Any ideas again? Several possible reasons : - no primary key field defined in your

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

2012-10-19 Thread Alex Thurgood
On 10/18/2012 03:49 PM, John Clegg wrote: Hi John, Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather than JDBC. The table now becomes editable, but when I make a change I can't save because I get a message that nothing has changed! Shot in the dark - the ODB file

[libreoffice-users] Re: Cannot add primary key after saving without primary key.

2012-10-24 Thread Alex Thurgood
Le 23/10/2012 07:38, David Smith a écrit : Hi David, Strange.. It said it was completed successfully. When I do this, I can now see the ID column and it appears I can add records. However, when I go into the design view for the table, there is no ID column or primary key columns and it

[libreoffice-users] Re: LibreOffice 3.6.3.2 build on Linux fail on dictionaries and help (localize.sdf not found)

2012-11-19 Thread Alex Thurgood
Le 19/11/2012 09:57, Alex Thurgood a écrit : Le 19/11/2012 00:42, piernov a écrit : Hi there, The SDK stuff has been killed in master, which is probably why your build is failing. Localisation and help file build systems are being migrated. Your question really belongs on the dev mailing

[libreoffice-users] Re: MS Office MacIntosh to Libre Writer Windows

2012-11-28 Thread Alex Thurgood
Le 27/11/2012 18:47, bsn a écrit : Hi Bruno, many friends using MS Office. Recently a guy sent me a doc created on a Mac. It is impossible to open it . LO opens a small window (ASCII filter options) and converts the doc to a unreadable scribble. We would need to know the application on the

[libreoffice-users] Re: How to enable pre-installed extensions

2012-11-28 Thread Alex Thurgood
Le 28/11/2012 12:29, Tom Davies a écrit : Hi Tom, Hi :) Does that mean you can rename the User Profile to fix the corruption without losing the Extensions? http://wiki.documentfoundation.org/Documentation/UserProfile I guess you could always copypaste the Extensions out of your old

[libreoffice-users] Re: Specifying PDF Form Field Names

2012-12-01 Thread Alex Thurgood
Le 01/12/2012 00:31, Luke Paireepinart a écrit : Hi Luke, The ONLY problem I have (and I can't seem to find a workaround) is that the form field loses the name I specified inside LibreOffice. So even if I edit the field to be called first_name in LibreOffice it exports and shows up as

[libreoffice-users] Re: Font Issues Mac OS X

2012-12-05 Thread Alex Thurgood
Le 05/12/2012 18:23, Oogie McGuire a écrit : Hi Oogie, Some fonts on my system suddenly become unavailable to LO. It happens in Calc and Writer. This has been known to happen, I've seen it with Writer, but don't recall it happening with Calc (yet), possibly because I wasn't using one of the

[libreoffice-users] Re: Chart Range Entire Column

2012-12-05 Thread Alex Thurgood
Le 05/12/2012 22:55, Alex Thurgood a écrit : The Base one won't help you at the moment because Charts appear to be partly broken in the report designer : https://bugs.freedesktop.org/show_bug.cgi?id=48056 Hmm, also these : https://bugs.freedesktop.org/show_bug.cgi?id=48251 (dup

[libreoffice-users] Re: Base Form behavior.

2012-12-05 Thread Alex Thurgood
On 12/06/2012 05:08 AM, Hank Alper wrote: Hi Hank, ith the same result. Is this a bug? Has anyone noticed this type of behavior ? Base seems to start out handling records in increments of about 40 records until it finds the end of the file. Strange. Hank Alper This is the programmed

[libreoffice-users] Re: Ubuntu Libreoffice

2012-12-05 Thread Alex Thurgood
On 12/06/2012 02:25 AM, Anthony Easthope wrote: Hi Anthony, You could try looking here : http://www.libreoffice.org/developers-2/ Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: A Tale of Two Office Suites

2012-12-12 Thread Alex Thurgood
On 12/11/2012 06:23 PM, NoOp wrote: Hi all, Interesting, mine does not. Lowercase (c) = (c) Uppercase (C) = © Unfortunately, I've noticed this too on Mac, with FR as the default language / locale, and it is rather annoying when typing lists within a paragraph. Mind you, it has been like

[libreoffice-users] Re: Value '0000-00-00' can not be represented as java.sql.Date

2012-12-17 Thread Alex Thurgood
Le 17/12/2012 04:41, Brian Barker a écrit : Hi Brian, Wouldn't a better solution be to construct your database so that you didn't need to represent this thrice-inappropriate date value? The problem stems from the fact that the MySQL JDBC driver can not handle Java null dates, which were

[libreoffice-users] Re: Fwd: Re: Value '0000-00-00' can not be represented as java.sql.Date

2012-12-17 Thread Alex Thurgood
Le 16/12/2012 02:49, receiver a écrit : Hi receiver, It is MySQL's choice to have allowed '-00-00' as the representation of an invalid date string. Previous versions of the JDBC connector could handle these strings. When the connector J development moved to 5.x, MySQL had to introduce an

[libreoffice-users] Re: record changes weakness compared to m$

2012-12-20 Thread Alex Thurgood
Le 20/12/2012 00:19, Dennis E. Hamilton a écrit : Hi Dennis, This requirement seems to emerge from users in public administration, somewhat akin to the use in law firms. I can certainly second the law firm requirement, and as a lawyer that also has to work with French public

[libreoffice-users] Re: Referring to an input list variable

2012-12-20 Thread Alex Thurgood
Le 19/12/2012 20:24, Michael Nachtigal a écrit : Hi Michael, I'm trying to create a form that does two (main) things: Lets the user select one of two options, and depending on which option is selected, certain sections of the form will appear or disappear (be hidden). I originally tried to

[libreoffice-users] Re: Base scenario

2013-01-02 Thread Alex Thurgood
On 12/27/2012 10:09 AM, Ian Whitfield wrote: Hi Ian, So all I need now is for the Sub-Form to AUTOMATICALLY pick-up the Members ID from the main Form and to use as the filter criteria for which eMails to show. (I will also use this form to enter new eMails so the automatic pick-up of the

[libreoffice-users] Re: Base date entry less flexible

2013-01-02 Thread Alex Thurgood
On 01/01/2013 09:19 PM, Girvin R. Herr wrote: Hi Girvin, The point I was trying to make was that when I forget and use dashes, this particular error message was not very informative and I, for one, would like to see more diagnostic information in the Java exception error dialog so I could

[libreoffice-users] Re: Keyboard Shortcuts for Buttons in Base

2013-01-02 Thread Alex Thurgood
On 12/30/2012 02:22 AM, Marion Noel Lodge wrote: Hi, My question is, can the same thing be achieved with a button in a Base Form? In Paradox for example, typing 'Choose Regular Entry' as the button's label, results in 'Choose *R*egular Entry' being displayed on the button. However '' does not

[libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Alex Thurgood
Le 11/01/2013 21:28, Tom Davies a écrit : Hi Tom, I've exported a tiny part of the data, and ended up with 2 columns ClientID CompanyName Not all clients have a company name so there are a lot of blanks in the 2nd column. I've written a query to just show the non-blanks (=non-nulls) but now

[libreoffice-users] Re: Base: Action Queries

2013-01-12 Thread Alex Thurgood
Le 11/01/2013 22:42, Tom Davies a écrit : Hi Tom, SQL Status: HY000 Error code: 1000 SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE I hope that you are using the Tools Options SQL menu instead of trying to do this via

[libreoffice-users] Re: Base: Action Queries

2013-01-12 Thread Alex Thurgood
Le 12/01/2013 13:38, Tom Davies a écrit : Hi Tom, Nope. Thanks for the suggestion! Another thing i think i was doing wrong was to use Insert - Query using Sql The Query using SQL and Query Design modes only work for pure retrieval queries, i.e. SELECTS. You can not insert or update when

[libreoffice-users] Re: Database sort problem

2013-01-19 Thread Alex Thurgood
On 01/19/2013 05:59 PM, Ian Whitfield wrote: Hi Ian, Message No Date 14901/01/13 58 02/01/13 15002/01/13 22502/01/13 26107/01/13 307

[libreoffice-users] Re: base masks

2013-01-21 Thread Alex Thurgood
On 01/21/2013 09:00 AM, Paolo Debortoli wrote: Hi Paolo, sorry, wrong translation... I meant formulary, form, questionnaire, the third voice from up on the left in the 'database' menu. if there is a way to open an object without window border / controls, just the object. trying resizing.

[libreoffice-users] Re: Base Report Builder

2013-01-21 Thread Alex Thurgood
On 01/20/2013 10:31 PM, Hank Alper wrote: Hi Hank, I restarted, LO blithely announced it was recovering my database. It did, but the new Report and the modifications to a query I made in this session were gone. I think* most* of this behavior is due to Report Builder. Has anyone else

[libreoffice-users] Re: How to format a date in Inpress

2013-01-21 Thread Alex Thurgood
On 01/20/2013 09:00 PM, Giuseppe Greco wrote: Hi Giuseppe, Is that possible? It looks like only predefined formats can be applied. I can only think of a workaround : Open a writer document, type your phrase and insert the date into it from the Field menu. Then right mouse button click on

  1   2   3   4   >