[libreoffice-users] need help off this list - need Linux package choice help

2016-10-24 Thread tonybsa
Hi Tim There is a very comprehensive Video editor for Linux called OpenShot 2.0. Runs well on Ubuntu 16.04. (Not sure about previous ubuntu systems, but am pretty sure will run on 14.04 plus). The program is a Kickstarter success. OpenShot Video Editor is a free, open-source video editor for Li

Re: [libreoffice-users] Re: missing in Calc 5.1.5.2

2016-08-09 Thread tonybsa
> On 9/08/2016, at 09:04, V Stuart Foote wrote: > > Controls affecting the content of the sheet have been consolidated in the > Sheet menu. Fill actions are in Sheet -> Fill Cells menu. WHY? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.

Re: [libreoffice-users] Compatibility of LO Base with Access databases

2016-08-02 Thread tonybsa
In defence of LibreOffice Base. Unlike Ian I have had very good results with Base. Over the last 8 years I have used Base as a a "front end" to a MySQL database in 5 different countries for different projects. One database was for the New Ireland (PNG) Provincial Government Old Age & Disabled P

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

2016-04-15 Thread tonybsa
> On 15/04/2016, at 08:54, tonybsa wrote: > > Microsoft Front page; Scribus This is incorrect -- Sorry had a slip of the brain or copy / paste !!! Front page is one of the worst programs for creating Web pages (HTML). Even "Dreamweaver" used to have a menu option cal

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

2016-04-14 Thread tonybsa
> On 15/04/2016, at 08:19, toki wrote: > > On 14/04/2016 16:58, nasrin khaksar wrote: A "couple" more to add to Toki's list Microsoft Front page; Scribus Microsoft Publisher; Scribus Microsoft Project; Libre project -- Tony Bray tony...@mac.com MacBook Pro 15 inch Mid 2009 2.8 GHz

Re: [libreoffice-users] Disabling Tool Tips / Balloon Tips

2016-03-19 Thread tonybsa
> On 18/03/2016, at 13:00, Remy Gauthier wrote: > > I can disable tips by going in Tools -> LibreOffice -> Options -> > Advanced Options -> Advanced configuration. Seach for the keyword "Tip" > (not case sensitive), then searching for org.openoffice.Office.Common, > Help -> Tip and setting it to

Re: [libreoffice-users] Database help please

2016-03-02 Thread tonybsa
> On 3/03/2016, at 08:07, John Montgomery wrote: > > My problem arises when I enter double numbers eg A11, A20 etc, these should > follow in sequence but do not follow the sequence I want but A10 follows A1 > etc. > How can I ensure correct sequencing. Enter A1 to A9 as A01 - A09 Similarly wi

Re: [libreoffice-users] calc filter?

2016-03-01 Thread tonybsa
> Hi, > My understanding is you want to re-display the list in the order you provided. Set B2 to B17 to your list Then set A2 to A17 to your required order. Note in column A you are telling the numbers in column B where they should appear in the sorted list i.e Number 16 (sixteen) in column B

Re: [libreoffice-users] Base - automatically running a macro on form opening

2016-02-13 Thread tonybsa
A long set of macros to open & close forms. To open a form when the database starts select "Tools > Customize > Events > Open Document. Click Assign: Macro and assign the DBOpen macro. HERE ARE THE MACROS. As I can't send attachments you will have to copy and paste these into your Macro Libra

Re: [libreoffice-users] I just downloaded Libre Office last night, and I have a couple of questions.

2015-11-15 Thread tonybsa
> On 16/11/2015, at 10:52, Susan Mason wrote: > > I know of no open source equivalent for Publisher...but, I wish I could find > one. I also know of no open source program which will even open my old > Publisher files. I wish I could find that, as well The best open source program that I hav

Re: [libreoffice-users] Shortcut changes

2015-10-19 Thread tonybsa
> On 18/10/2015, at 08:17, James E. Lang wrote: > > PLEASE, developers, think about the impact your change will have on existing > users. The longer a shortcut has existed the more attention should be given > should be given to the impact of changing it with shortcuts that have existed > for

Re: [libreoffice-users] Operating Environment Survey

2015-07-25 Thread tonybsa
On 26/07/2015, at 5:54, James Knott wrote: > Did they have slide rules way back then? ;-) Yep, they were still using slide rules when I joined the Royal Navy in 1959 (No that is not a mistake!) The first computers I wrote about, as a technical author in 1969, was the "Energy Management Analo

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-16 Thread tonybsa
Use Edit > Fill > Series Click in cell A2 Right click Format Cells > date > Fri, 31Dec 99 > OK With A2 still selected shift click A6 Click Edit>Fill>Series When the dialog box opens Select Down > Date > Day Enter start date: 3/08/2015 Enter finish date: 7/08/2015 Increment: 1 Click OK Result: M

Re: Re: [libreoffice-users] Installation version chaos

2015-04-17 Thread tonybsa
On 17/04/2015, at 19:05, Tom Davies wrote: > There's a tiny "gotcha" in there that i only noticed because i have done > the same thing myself. It's the . in > sudo apt-get remove libreoffice*.* > > Try again but this time without the extra * and the . before it; > sudo apt-get remove libreoffi

Re: [libreoffice-users] Re: Styles and Formatting Not Working

2015-02-21 Thread tonybsa
On 22/02/2015, at 12:37, Taang Zomi wrote: Just a suggestion with the Save button appearing not to dim after saving. Do you have "Allow to save document even when the document is not modified" selected under the LibreOffice > General Options? This sometimes means that the save button does not

Re: [libreoffice-users] And while I'm here, data extraction

2015-02-03 Thread tonybsa
On 3/02/2015, at 22:55, Mark Stanton wrote: > I've been thinking about this. > > Firstly, the cut'n'paste solution isn't working here for me on the results > (23 rows, perhaps ten columns) of a query in SQL view with Fedora Linux (20) > and LO 4.2.8.2 (please don't suggest I upgrade to the la

Re: [libreoffice-users] JDBC-connector to MySQL database

2015-02-01 Thread tonybsa
On 2/02/2015, at 6:53, Heinrich Stöllinger wrote: > I don't see any error messages in any of the logs I wonder what's the > problem... When I run your Create Table script (copied from your Email) in MySQL Workbench I get the following error Error Code: 1005. Can't create table 'sanmadb_test.

Re: [libreoffice-users] MySQL - LO Base question.

2015-01-23 Thread tonybsa
On 24/01/2015, at 6:13, Ian Whitfield wrote: > I now need to set-up my Database again but have a question. > (My Database has only one table with about 2500 records and each record has > 80 fields.) > > Which is the correct procedure?? > 2) Set-up the Database in MySQL then use LO Base to crea

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-19 Thread tonybsa
On 20/01/2015, at 9:16, Rich Shepard wrote: > Tony, > > With the help of one subscriber to the unixODBC mail list we may have > found the problem source. > dltest /usr/local/lib/libsqlite3odbc.so SQLConnect Good to know that there is a solution. Perhaps the documentation team can find time

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-19 Thread tonybsa
On 20/01/2015, at 8:08, Rich Shepard wrote: > Tony, > > I've done this several times, but the only drivers visible are for sun > (now oracle) star. See attached .png. Yes I was aware of this but thought that just "maybe" the oracle drivers would work for you. Sorry all out of other suggestio

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-19 Thread tonybsa
On 20/01/2015, at 6:40, Rich Shepard wrote: > "The connection to the data source '' could not be established. > "[unixODBC][Driver Manager] Data source name not found, and no driver > specified." > What am I doing incorrectly here? You may need to go to "LibreOffice > Tools > Options > Libr

[libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-18 Thread tonybsa
On 19/01/2015, at 4:43, Rich Shepard wrote: > Step 4 is 'Save and Proceed' which is where my choices do not produce the > result I expect. > > The top portion of the dialog box has 2 radio buttons: do I want to > register the database with Base? I assume so, but the help button moves the > ope