[libreoffice-users] Re: stubborn macro security

2012-07-01 Thread Andreas Säger
Am 30.06.2012 23:44, Girvin R. Herr wrote: [...] How can we know all this? *You* are the owner of that document. It is *your* hierarchy of templates and someone in *your* domain spills dirty Basic into this world. Do those macros serve any purpose in the distributed document? May be you

[libreoffice-users] Lost Python macros

2012-07-01 Thread Ulf Göransson
Hi, I have a problem running an old Python macro that I've written for Calc. It is a plain .py file, stored under ~/.libreoffice/3/user/Scripts/python. I used to be able to run it via the Tools - Macros - Run Macro... menu command but now when I try, none of my macros are listed. It's been

[libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Andreas Säger
Am 01.07.2012 11:08, Ulf Göransson wrote: Hi, I have a problem running an old Python macro that I've written for Calc. It is a plain .py file, stored under ~/.libreoffice/3/user/Scripts/python. I used to be able to run it via the Tools - Macros - Run Macro... menu command but now when I try,

Re: [libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Ulf Göransson
On 01/07/12 11:28, Andreas Säger wrote: Am 01.07.2012 11:08, Ulf Göransson wrote: Hi, I have a problem running an old Python macro that I've written for Calc. It is a plain .py file, stored under ~/.libreoffice/3/user/Scripts/python. I used to be able to run it via the Tools - Macros - Run

Re: [libreoffice-users] Tie a line to two cells

2012-07-01 Thread Tom Davies
Hi :) How about just drawing a graph of all their results?  Each person could have a different colour line.  A line graph could show change over time. Regards from Tom :)  --- On Sat, 30/6/12, Johnny Rosenberg gurus.knu...@gmail.com wrote: From: Johnny Rosenberg gurus.knu...@gmail.com

Re: [libreoffice-users] Which SQL standard does LibreOffice Base support?

2012-07-01 Thread Tom Davies
Hi :) So does Base's version of Sql change when a different back-end is used? Regards from Tom :) --- On Sat, 30/6/12, Dan elderdanle...@gmail.com wrote: From: Dan elderdanle...@gmail.com Subject: Re: [libreoffice-users] Which SQL standard does LibreOffice Base support? To:

[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] Macro code to highlight a field on a Form

2012-07-01 Thread Marion Noel Lodge
I'm writing an accounting application and on the data entry Form I use a macro to automatically fill in fields for regular recurring entries, e.g. a payment of a Gas or Electricity bill. This speed up the data entry a lot, as usually the only fields that need changing are the Date and Amount

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

2012-07-01 Thread Tom Davies
Hi :) It might be worth looking into Gnu Cash http://www.gnucash.org/ It may just need a plug-in / add-on to make it do what you want if it doesn't already.  Regards from Tom :) --- On Sun, 1/7/12, Marion Noel Lodge lodg...@gmail.com wrote: From: Marion Noel Lodge lodg...@gmail.com

Re: [libreoffice-users] animation in an impress documennt

2012-07-01 Thread Tom Davies
Hi :) You might get better answers on the devs list or their iirc channel or something.  perhaps post a feature request type of bug-report Regards from Tom :) --- On Sat, 30/6/12, Eric S. Johansson e...@harvee.org wrote: From: Eric S. Johansson e...@harvee.org Subject: [libreoffice-users]

[libreoffice-users] PDF Irregularities - uncontrollable line spacing problems

2012-07-01 Thread Rogier F. van Vlissingen
Back in 2002 I produced a book, going straight to print off a Open Office PDF, and the results were thoroughly satisfactory. In fact, my book at that time was probably the first production book that was fully produced straight from OO, skipping DTP altogether. Today, 10 years later I'm doing a

Re: [libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Ulf Göransson
On 01/07/12 12:07, Alex Thurgood wrote: I take it that your own python scripts are still in the Script directory ? Just wondering whether an update hasn't overwritten the directory completely, and wiped them out. Yes, they are still where they've always been. And I copied the file

Re: [libreoffice-users] Which SQL standard does LibreOffice Base support?

2012-07-01 Thread Dan
Yes, when Base uses a different database engine to connect to a database. HSQLDB, MySQL, Oracle, and PostgreSQL each has differences in how it uses SQL. Even different versions of any of these will have differences. Each newer version has improvements in how SQL is implemented and what

Re: [libreoffice-users] impress, dual screen, dual x servers

2012-07-01 Thread Tom Davies
Hi :) It is the sort of functionality one would expect but i couldn't find any mention of it in a quick hunt around in documentation https://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :)  --- On Thu, 28/6/12, Mike Scott m...@scottsonline.org.uk wrote: From: Mike

Re: [libreoffice-users] Tie a line to two cells

2012-07-01 Thread Johnny Rosenberg
2012/7/1 Tom Davies tomdavie...@yahoo.co.uk: Hi :) How about just drawing a graph of all their results? Each person could have a different colour line. A line graph could show change over time. Regards from Tom :) Yes, that works, but that was not what I asked. Thanks anyway. Kind

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

Re: [libreoffice-users] Re: Lost Python macros

2012-07-01 Thread webmaster-Kracked_P_P
On 07/01/2012 07:54 AM, Alex Thurgood wrote: 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

Re: [libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Ulf Göransson
On 01/07/12 15:23, webmaster-Kracked_P_P wrote: On 07/01/2012 07:54 AM, Alex Thurgood wrote: 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

Re: [libreoffice-users] Re: Lost Python macros

2012-07-01 Thread webmaster-Kracked_P_P
On 07/01/2012 09:35 AM, Ulf Göransson wrote: On 01/07/12 15:23, webmaster-Kracked_P_P wrote: On 07/01/2012 07:54 AM, Alex Thurgood wrote: 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

[libreoffice-users] How can I edit a database with Calc ?

2012-07-01 Thread Sylvain Vasseur
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/

Re: [libreoffice-users] How can I edit a database with Calc ?

2012-07-01 Thread Dan
Sylvain Vasseur wrote: Your question does not make any sense. Calc is a spreadsheet. A database is a collection of information (a data source). It might be in the form of one or more spreadsheets. It might be one or more text files with a special format. An address book using the V-card

Re: [libreoffice-users] How can I edit a database with Calc ?

2012-07-01 Thread Sylvain Vasseur
Thank you for your detailed answer. Apparently my question wasn't. I created a database with Libreoffice Base, I've been able to access this database through Libreoffice Calc but I can't find a way to edit it with Calc. On 01/07/2012 17:04, Dan wrote: Sylvain Vasseur wrote: Your

Re: [libreoffice-users] How can I edit a database with Calc ?

2012-07-01 Thread Dan
You need to edit your database in Base. I'm not sure how you access your database in Calc unless you used the F4 key to open the database window. Even then, the F4 key opens the database and shows you the data in the tables and queries. Recommendation: Download the Getting Started

[libreoffice-users] Re: How can I edit a database with Calc ?

2012-07-01 Thread Andreas Säger
Am 01.07.2012 16:23, Sylvain Vasseur wrote: Attach a form to a sheet and connect it to your database. ViewToolbarsFormDesign + FormControls Turn on design mode. Hit the 5th button for the form navigator and start with a new form. Bind the form to a table. Attach form controls and bind them

[libreoffice-users] Re: Lost Python macros

2012-07-01 Thread Andreas Säger
Am 01.07.2012 11:33, Ulf Göransson wrote: Yes and no. I see three example macros under LibreOffice Macros but none of my own. And the hello world macro runs just fine. /ug You upgraded from 3.4 to 3.5 and some devel moron changed the location of the user profile from ~/.libreoffice/ to

[libreoffice-users] Re: The vlookup don't work properly.

2012-07-01 Thread Andreas Säger
The only bug is that you are misusing a spreadsheet as database. Your formula is =VLOOKUP($A6,'all Staging'.$A$2:$E$1197,3,0) and A6 would be matched in row #2335 -- View this message in context: http://nabble.documentfoundation.org/The-vlookup-don-t-work-properly-tp3993117p3993160.html Sent

[libreoffice-users] General Error

2012-07-01 Thread Nero
Hello, I was sent a PPTX file that I needed to translate and spent hours on it, saving regularly only to find out that after closing it, I couldn't reopen it due to a General Error - General input / output error. SAPP COPY-Sistema Automatizado de Pases a Producción v2.pptxhttp://db.tt/yTaVDf86

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

2012-07-01 Thread Marion Noel Lodge
Hi Tom, Thanks for the suggestion - Gnu Cash looks to be very comprehensive, but I would think twice about starting all over again on a new platform. What I neglected to say was that I started writing the accounting system over 20 years ago as a Paradox application for a large non-profit

Re: [libreoffice-users] General Error

2012-07-01 Thread webmaster-Kracked_P_P
On 07/01/2012 07:56 PM, Nero wrote: Hello, I was sent a PPTX file that I needed to translate and spent hours on it, saving regularly only to find out that after closing it, I couldn't reopen it due to a General Error - General input / output error. SAPP COPY-Sistema Automatizado de Pases a