Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Dan Lewis
On 7/16/19 1:54 PM, Harvey Nimmo wrote: I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb using the MySQL (JDBC) connector. A form I had generated in Base needed a new field that had to be added to the source (Base) query and the related (Mariadb) table. Having added the

Re: [libreoffice-users] Re: Reveal code, old macros convert them to LO

2019-07-06 Thread Dan Lewis
On 7/6/19 5:18 AM, Uwe Brauer wrote: Den tors 4 juli 2019 kl 18:16 skrev John : If you use styles the way it's intended, you won't have those problems in the first place. I have never had them (as far as I remember), even when I was not using styles properly. Direct formatting should generally

Re: [libreoffice-users] What happened to "My Templates"?

2019-06-19 Thread Dan Lewis
On 6/19/19 4:21 PM, James Knott wrote: I recently updated LibreOffice to v6.1.3.2 on openSUSE 15.1.  One thing I've noticed is my own templates are now mixed in with the provided templates.  Why was this done?  I now have to sort through several templates, that I have no use for, to find the

Re: [libreoffice-users] How to format fields?

2019-05-21 Thread Dan Lewis
What component of LO have you been using to do this? (Writer [mail merge], Calc, Base) More specifics would be nice in terms of the step you took to create the documents. Dan On 5/17/19 4:32 AM, Oszkó Albert wrote: Hi all, I have quite a few certificates containing several data. I inserted

Re: [libreoffice-users] "Add to dictionary" doesn't work

2019-04-19 Thread Dan Lewis
Tools > Options > Language settings > Writing Aides. Under User-defined dictionaries, click New. Name your new dictionary. You do not have to select a language for this dictionary unless necessary. [All] will work in all languages. Click OK. Now when you right click on a new technical term,

Re: [libreoffice-users] Tabs in selection of text

2019-04-08 Thread Dan Lewis
On 4/3/19 8:37 PM, Carl Paulsen wrote: I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops.  I select the lines and click the tab stop I want, then click in the ruler, but nothing happens.  I see no menu item to format tabs, though I

Re: [libreoffice-users] Auto recovery problem

2019-02-04 Thread Dan Lewis
Two things are needed to help you: your version of LibreOffice, and  your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter.  I'm adding fields directly to retain formatting control and NOT have to deal with a text block

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Dan Lewis
To begin with, what is the query's SQL. Someone might be able to discover the problem from there. In addition, knowing the properties of each one of the tables could also help solve it. On 1/14/19 6:23 PM, Paul D. Mirowsky wrote: I have shifted one of my database to Firebird using the advanced

Re: [libreoffice-users] Cell style background colour

2019-01-03 Thread Dan Lewis
On 1/3/19 11:14 AM, Dan Lewis wrote: Inline post On 1/2/19 7:17 PM, Johnny Rosenberg wrote: Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker : At 22:58 01/01/2019 +0100, you wrote: ... I can't find how to add colours to the background colour palette. In older LibreOffice versions, or maybe

Re: [libreoffice-users] Cell style background colour

2019-01-03 Thread Dan Lewis
Inline post On 1/2/19 7:17 PM, Johnny Rosenberg wrote: Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker : At 22:58 01/01/2019 +0100, you wrote: ... I can't find how to add colours to the background colour palette. In older LibreOffice versions, or maybe it was even Apache OpenOffice, I could

Re: [libreoffice-users] Summing currency fields in base

2018-10-13 Thread Dan Lewis
Perhaps you need to begin over as far as you fields are concerned. First of all, you only need two fields in the table: Fee1 and Fee2. You also need a primary key which is listed first. Fee1 and fee2 need to be given the properties you want for them. The primary key has to have "entry

Re: [libreoffice-users] side by side tables

2018-09-26 Thread Dan Lewis
On 09/26/2018 03:42 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: Gary Collins wrote: Hi Ive found out how to resize tables so they dont take up the full page width (though to be honest i usually find it easier and more flexible to simply include an additional  empty column to right and

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Dan Lewis
On 08/08/2018 11:37 AM, M Henri Day wrote: Den ons 8 aug. 2018 kl 17:22 skrev James Knott : I see the same thing. On 08/08/2018 11:13 AM, Paul D. Mirowsky wrote: FYI 11:08 AM EST YouTube video is not displaying. Results in message "If playback doesn't begin shortly, try restarting your

Re: [libreoffice-users] broken file associations after installing the new version.

2018-07-19 Thread Dan Lewis
On 07/19/2018 12:57 AM, Tim-L wrote: When I removed LibreOffice 6.0.3 from my Ubuntu 18.04 system, and then installed 6.0.5, the first time I opened a ODT document, it showed the ebook library package "Calibre" as the default package to open the ODT document. SO, any ideas why after removing

Re: [libreoffice-users] My Templates?

2018-07-09 Thread Dan Lewis
On 07/09/2018 09:23 AM, Virgil Arrington wrote: On 07/08/2018 05:12 PM, James Knott wrote: On 07/08/2018 04:52 PM, toki wrote: * /home/ your-user-name /.config/libreoffice/4/user/template/ Found 'em there.  However, that does nothing for the problem of removing My Templates, so that my

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Dan Lewis
On 05/21/2018 10:46 AM, Dan Lewis wrote: On 05/21/2018 09:57 AM, HBarr wrote: Thanks Robert, that's very helpful. Now, how would I change the result to -MM-DD? Regards, Howard This is a little more difficult, but not by much. Right click the date. Select Additional

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Dan Lewis
On 05/21/2018 09:57 AM, HBarr wrote: Thanks Robert, that's very helpful. Now, how would I change the result to -MM-DD? Regards, Howard This is a little more difficult, but not by much. Right click the date. Select Additional formats in the Format column. Enter what

Re: [libreoffice-users] New LibreOffice Book

2016-03-25 Thread Dan Lewis
On 03/25/2016 05:22 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: Bruce Byfield wrote: On Friday, March 25, 2016 01:51:25 PM James Knott wrote: On 03/25/2016 01:42 PM, Dave Liesse wrote: This is my busy season at work so I haven't had a lot of time, yet, but I downloaded the PDF version

Re: [libreoffice-users] Hidden Section Problem

2016-03-01 Thread Dan Lewis
Please send a copy of the database to me personally, and I will see what I can discover from it. Dan On 03/01/2016 02:57 PM, anne-ology wrote: When clicking on this URL, a blank box appears ... then clicking on the file icon, 4 images are listed, but none are available

Re: [libreoffice-users] Linking a Form to another table

2016-01-08 Thread Dan Lewis
On 01/07/2016 04:15 PM, Ian Whitfield wrote:s. Hi All I take from the lack of any replies to my post of a few days back that either anyone who can help out is still on Christmas Holidays or this just can not be done ?? Ianw Pretoria RSA In reality your question does not make very much

Re: [libreoffice-users] Lost connection to Database.

2015-10-21 Thread Dan Lewis
On 10/20/2015 11:02 AM, Ian Whitfield wrote: Hi All Due to problems with Kernel updates I have rebuilt my system using the last ISO disk I had, (2014-12). I re-installed the ISO formatting the complete drive, updated the system via Synaptic to bring it up to date and restored all my

Re: [libreoffice-users] Reset for tracked changes

2015-09-30 Thread Dan Lewis
On 09/30/2015 04:57 AM, Mike Cowlishaw wrote: I have been experimenting with tracked changes and they look ideal for indicating Editor's changes to a Standard document. However, I cannot see how to 'reset' the track once changes have been approved. It seems one can either show all changes

Re: [libreoffice-users] AutoText crashes

2015-09-14 Thread Dan Lewis
On 09/12/2015 02:32 PM, Sylvain Bromberger wrote: AutoText used to work well, but now when I click on it in Edit (writer) it crashes LibreOffice writer. I am currently located where I cannot download 5. Is there any remedy? Thanks in advance for any help. Sylvain Are you perhaps using a

[libreoffice-users] Re: Unable to use Writer as a publication tool

2015-08-07 Thread Dan Lewis
On 08/06/2015 11:56 PM, V Stuart Foote wrote: @madrosh, The major bug I have is applying a register-true to an entire document at a time. I use OL to put together a periodical, with columned text and many images (which are put in frames and anchored to specific pages). It is LO not OL, or

Re: [libreoffice-users] Question about LO Writer and complex documents

2015-07-24 Thread Dan Lewis
On 07/24/2015 09:31 AM, Tom Williams wrote: Greetings! With all of the recent discussion about Linux being a viable alternative to Windows, in today's computing world, I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no.

Re: [libreoffice-users] Form navigator button not working in LO base

2015-05-11 Thread Dan Lewis
On 05/10/2015 03:20 PM, Paul Fearnley wrote: I have been successfully designing forms with subforms in LO Base using the form navigator. Strangely the form navigator has just stopped working. When I click on the icon, nothing happens. No further information is displayed. I have rebooted,

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Dan Lewis
On 12/07/2014 08:12 AM, Wiebe van der Worp wrote: First post, not sure it is the right place, hi there! For 2015 I would like to keep a shadow bookkeeping in Calc in order to check our bookkeeping program for a while. Input: In order to keep things simple: three columns with Description,

Re: [libreoffice-users] Lost Pass Word

2014-11-26 Thread Dan Lewis
On 11/26/2014 01:39 AM, Isaac Cajina wrote: I need to open some documents and I do not remember my pass word. I need you help. Thanks. There is a reason for encrypting a document: to prevent others from seeing it if they do not know the password. LibreOffice does an excellent job of

Re: [libreoffice-users] LO Writer, how to insert horizontal line

2014-11-15 Thread Dan Lewis
On 11/15/2014 10:57 AM, William Drago wrote: I'm trying to insert a horizontal line into my LO document. The help says: 1. Click in the document where you want to insert the line. 2. Choose *Insert - Horizontal Rule* see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line Well,

Re: [libreoffice-users] outline numbering

2014-11-08 Thread Dan Lewis
Comment inline On 11/08/2014 01:21 PM, Virgil Arrington wrote: On 11/08/2014 11:12 AM, libreoffice-ml.mbou...@spamgourmet.com wrote: Are all the documents (old and new) in ODF Text (.odt) format? Or are the older ones in Word (.doc) or OpenOffice 1.0 (.sxw) format? I'm wondering if the

Re: [libreoffice-users] Java LO and OSX

2014-11-06 Thread Dan Lewis
On 11/06/2014 04:33 PM, Virgil Arrington wrote: On 11/6/2014 3:14 PM, Marc Grober wrote: Sorry I changed the subject line there... I have never been able to get the list to copy me with my posts and I just forgot that I had the post in Sent mail. I am having the same problem. I never see my

Re: [libreoffice-users] Re: LibreOffice Writer - Bold activates by itself

2014-11-04 Thread Dan Lewis
On 11/04/2014 01:33 PM, jerryvb wrote: However, LO also remembers the style of the last entry on the line, and applies it to the next paragraph as well. To see this in action, perform jerryb's procedure, but type some text in normal style after the bold text on the first line. You will see the

Re: [libreoffice-users] Calc SUM Function

2014-10-27 Thread Dan Lewis
On 10/27/2014 07:55 AM, Adrenolin wrote: So I can select an area of a column =SUM(B2:B50) and have it add and produce a total in say B51. Thats fine but fairly simplistic and I need more. Completely new to spreadsheets and how to do this stuff. 1. Can I add ALL of Column B, Minus B1 and have

Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications

2014-10-26 Thread Dan Lewis
On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most

[libreoffice-users] Final Release: MySQL/MariaDB Native Connector for Linux

2014-10-20 Thread Dan Lewis
Today, I have changed the status of this connector from Release Candidate #1 to Final Release. This should be used with LibreOffice 4.2.x and 4.3.x that are downloaded from the LibreOffice website. LibreOffice that is downloaded from a Linux repository can use the MySQL native connector

Re: [libreoffice-users] Writer 4.6.2.3 Failure With Word Document

2014-10-18 Thread Dan Lewis
On 10/18/2014 08:41 PM, Stephen Morris wrote: On 10/15/2014 10:09 AM, Tom Davies wrote: Hi :) The macros are very specific to that 1 specific version of MS Office. To use the file in MSO 2007 or 2013 or 365 then you might need to have the macro rewritten. If you had them rewritten for

Re: [libreoffice-users] Re: Re: MySQL/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)

2014-10-17 Thread Dan Lewis
On 10/17/2014 03:00 AM, Stefan Gruber wrote: Dan Lewis schrieb: Do you use the opensuse repositories for LibreOffice Yes, opensuse-factory with current LO 4.3.2.2. Stefan Opensuse makes changes in LibreOffice before putting it in their repositories. That could be the problem. Then again

Re: [libreoffice-users] Re: MySQL/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)

2014-10-16 Thread Dan Lewis
On 10/16/2014 04:21 PM, Stefan Gruber wrote: Hi, Tom Davies schrieb am Mittwoch, 15. Oktober 2014 17:50: Has anyone been able to test this out yet? Is it possible to test-drive these connectors without breaking an existing database? Errr, i'm not going to be able to test them myself so i was

Re: [libreoffice-users] parallel text in side by side pages

2014-10-15 Thread Dan Lewis
AM, Dan Lewis elderdanle...@gmail.com wrote: On 10/14/2014 12:15 PM, Marc Grober wrote: Is there is technical solution to running parallel text in side by side pages (the best example would be a text with a translation where you have the original on one page and the translation on the facing page

Re: [libreoffice-users] parallel text in side by side pages

2014-10-14 Thread Dan Lewis
On 10/14/2014 12:15 PM, Marc Grober wrote: Is there is technical solution to running parallel text in side by side pages (the best example would be a text with a translation where you have the original on one page and the translation on the facing page. This is done easily enough in columns, but

Re: [libreoffice-users] LibreOffice Question

2014-10-14 Thread Dan Lewis
On 10/14/2014 12:58 PM, Jay Ridgley wrote: Folks, My wife has her recipes in LO Writer. My question is is it possible to sort on the 1st line of a page? That way she can keep them alphabetically This can also be done with a form in Base. The simple way is to have two fields in a table:

[libreoffice-users] MySQL/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)

2014-10-11 Thread Dan Lewis
These connectors are available as Release Candidate #1. They have been tested against both MariaDB and MySQL databases. I would like to have a few more people see if these work as well as they have so far been described. Unless I hear from someone with a reason why it does not work as

Re: [libreoffice-users] Re: Path to python macros in LO 4.2.6.3[SOLVED]

2014-10-09 Thread Dan Lewis
Actually there seems to be an important hint in the Paths section of Tools Options LibreOffice Paths. You could see this also by looking at the sub folders within the user folder. This folder's sub folders divide the configuation into individual parts: autocorr, autotext, backup, etc.

Re: [libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

2014-10-08 Thread Dan Lewis
There is an extension that should help you. Download it from the LibreOffice Extensions website: http://extensions.libreoffice.org/extension-center/access2base About a year ago or so, I downloaded an earlier version and was able to access a Access database with it. Dan On 10/08/2014

Re: [libreoffice-users] Re: [Base Database] How to open a particular form at startup ?

2014-10-03 Thread Dan Lewis
On 10/03/2014 08:27 AM, Marion Noel Lodge wrote: Hi, I have a macro similar to neptuneuk's that Alex pointed to, but I go one step further. I run Windows 7 64 bit. I right click on my project's .odb file, click on 'Send to' and then on 'Desktop (create shortcut)'. Then I can simply double

Re: [libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-03 Thread Dan Lewis
On 10/03/2014 06:07 AM, Heinrich Stöllinger wrote: Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a

Re: [libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-02 Thread Dan Lewis
Harvey On Wed, 2014-10-01 at 19:57 -0400, Dan Lewis wrote: I have built one of these for 32 and 64 bit. I am looking for someone who has MariaDB installed on a Linux operating system to test whether this connector will work with MariaDB or not. (Each connector contains the needed MariaDB

[libreoffice-users] Fwd: Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

2014-10-02 Thread Dan Lewis
Forwarded Message Subject: Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux Date: Wed, 1 Oct 2014 19:22:19 -0700 (PDT) From: Dan Lewis elderdanle...@gmail.com To: libreoffice...@lists.freedesktop.org

Re: [libreoffice-users] Re: How to handle regressions

2014-10-02 Thread Dan Lewis
+100,000! This has been a total waste of the time of the other members of this mailing list. While this thread was raging, other topics also has some fairly long threads. The only difference is that this thread produced no results. Another thread at the same time resulted in the building of

[libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-01 Thread Dan Lewis
I have built one of these for 32 and 64 bit. I am looking for someone who has MariaDB installed on a Linux operating system to test whether this connector will work with MariaDB or not. (Each connector contains the needed MariaDB library files, so they should work.) From the things I

[libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-01 Thread Dan Lewis
I have built one of these for 32 and 64 bit. I am looking for someone who has MariaDB installed on a Linux operating system to test whether this connector will work with MariaDB or not. (Each connector contains the needed MariaDB library files, so they should work.) From the things I

Re: [libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-01 Thread Dan Lewis
tried to install the 64-bit connector in LO 4.2.6.3 on 64-bit Ubuntu 14.04 and install failed. Message was The extension 'MySQL Connector' does not work on this computer. On Wed, Oct 1, 2014 at 7:57 PM, Dan Lewis elderdanle...@gmail.com mailto:elderdanle...@gmail.com wrote: I have

[libreoffice-users] MySQL native connector for OS X

2014-09-22 Thread Dan Lewis
Can MySQL be accessed on an Apple computer using a native connector? If so, what is the URL for where it is located? If not, how can it be accessed and the URL for the connector's location? Dan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] dynamic range (based on current date/month)

2014-07-21 Thread Dan Lewis
On 07/21/2014 09:19 AM, Brian Barker wrote: At 13:47 20/07/2014 -0400, Charles Marcus wrote: ... we keep sales for Sales by month, with the Sales Rep in a Row and each month in a column... So something like this: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Sales

Re: [libreoffice-users] making graphics stay where you put them

2014-05-22 Thread Dan Lewis
w On 05/21/2014 11:40 PM, Bruce Byfield wrote: On Wednesday 21 May 2014 10:22:41 PM Dan Lewis wrote: On 05/21/2014 03:16 PM, Bruce Byfield wrote: If you've done much work positioning graphics in text, then you know how difficult it can be to make sure that the graphics stay in place

Re: [libreoffice-users] Re: Tell me it's not true

2014-05-22 Thread Dan Lewis
On 05/21/2014 02:36 PM, William Salathiel wrote: Mark Stanton mark at vowleyfarm.co.uk writes: When I select the dBase connector it seems to say that queries cannot contain more than one table. Tekll me it's not true... Mark Stanton One small step for mankind... Sorry but William is

Re: [libreoffice-users] making graphics stay where you put them

2014-05-21 Thread Dan Lewis
On 05/21/2014 03:16 PM, Bruce Byfield wrote: If you've done much work positioning graphics in text, then you know how difficult it can be to make sure that the graphics stay in place. In the past, many experts have come up with recommendations about the best settings to use, but these

Re: [libreoffice-users] Which components do you use most?

2014-05-13 Thread Dan Lewis
On 05/13/2014 11:25 AM, Virgil Arrington wrote: On 05/13/2014 10:16 AM, Tom Davies wrote: I think it is helping because it helps us understand what kind of level of expertise we can expect from certain posters. So when i try to answer questions about Calc, or Base there are clearly limits

Re: [libreoffice-users] Need help with Base

2014-05-06 Thread Dan Lewis
On 05/06/2014 02:37 PM, Wolfgang Keller wrote: may I ask a question in line with that thread: a few month ago, I failed installing LO-base with PostgreSQL-DB when I stumbled over the input request URL of data source ? Since the PostgreSQL SDBC driver uses the native PostgreSQL protocol (way

Re: [libreoffice-users] Imported document becomes corrupted, when edited.

2014-05-03 Thread Dan Lewis
On 05/03/2014 04:06 PM, Virgil Arrington wrote: On 05/03/2014 10:08 AM, Ian McCarthy wrote: I have a document - https://www.dropbox.com/s/qp6rf6edhuui8qb/SpeyElectrics.v16.odt It consists of a number of pages, the first two should have only writing on them, then there are some line

Re: [libreoffice-users] LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

2014-02-27 Thread Dan Lewis
On 02/22/2014 01:11 PM, Jim Seymour wrote: Hi There, I've researched and experimented with this, and I'm out of ideas. For starters: LibréOffice 3.5.7.2, Build ID: 350m1 (Build: 2) Before anybody suggests a newer version: I'm currently on Ubuntu 10.04 LTS (Lucid Lynx), so I'm stuck with it.

Re: [libreoffice-users] Base Table Relation

2014-01-30 Thread Dan Lewis
On 01/29/2014 09:36 PM, Mark LaPierre wrote: Hey Y'all, I've been struggling with this for weeks. I've got the Base Handbook for Version 4 that goes along really well with the version 4 LO that I have on my system. I also purchased a copy of OpenOffice.prg Base Basic that contains lots of

Re: [libreoffice-users] Display running total of Table Control in LibreOffice Base form

2013-12-19 Thread Dan Lewis
On 12/11/2013 07:25 AM, Lelanthran Manickum wrote: Hi all I posted this on stackoverflow with no success; perhaps someone where can help: I'm using LibreOffice 4.0 + MySQL on Linux. I have a form which contains a Table Control. This table has a column that is an integer. I would like to have

Re: [libreoffice-users] Suggestions: Sorry but the feedback page is not working, I am sending by email

2013-09-06 Thread Dan Lewis
Comment in-line On 09/06/2013 12:14 PM, Tom Davies wrote: Hi :) It's fine posting to the Users List to start with. We might be able to deal with issues directly and if not then we can signpost you to more appropriate places. I'm not sure why OfficeSecurity is involved so they might be

Re: [libreoffice-users] Recent Documents List

2013-06-12 Thread Dan Lewis
On 06/11/2013 09:33 PM, Dr. R. O Stapf wrote: On 12.06.2013 07:22, Steve Edmonds wrote: On 2013-06-12 10:15, Dan Lewis wrote: On 06/11/2013 11:53 AM, Mirosław Zalewski wrote: On 11/06/2013 at 16:09, Tom Davies tomdavie...@yahoo.co.uk wrote: Does anyone remember how to fix the list

Re: [libreoffice-users] disable save as in odt document

2013-06-11 Thread Dan Lewis
It might depend upon how people on the clients use Save As. If they use Control+Shift+S, then I don't know. If they are like me: they click the Save As button in the Standard Tool bar, there are a couple of ways. (1) Hide the Save As button (Right click in the Standard toolbar. Then

Re: [libreoffice-users] Recent Documents List

2013-06-11 Thread Dan Lewis
On 06/11/2013 11:53 AM, Mirosław Zalewski wrote: On 11/06/2013 at 16:09, Tom Davies tomdavie...@yahoo.co.uk wrote: Does anyone remember how to fix the list of recent documents to be longer than 10? I don't know how to fix list of recent documents, but if you want to have access to more than

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-06 Thread Dan Lewis
June 2013 21:51, Dan Lewis elderdanle...@gmail.com wrote: Onn 06/05/2013 02:29 AM, Marion Noel Lodge wrote: Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form (Families) FamilyID BIGINT IDENTITY

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-06 Thread Dan Lewis
family. I think this would work just as well as the linking mechanism, but can you think of a better solution? Thanks, Noel -- Noel Lodge lodg...@gmail.com On 6 June 2013 20:57, Dan Lewis elderdanle...@gmail.com wrote: It seems that this has been a problem since 2010 with OpenOffice.org

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Dan Lewis
Onn 06/05/2013 02:29 AM, Marion Noel Lodge wrote: Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form (Families) FamilyID BIGINT IDENTITY Info fields follow Sub Form (Roll) RollID BIGINT

Re: [libreoffice-users] Creating EPUB e-books

2013-05-31 Thread Dan Lewis
On 05/31/2013 03:01 AM, Fernand Vanrie wrote: On 30/05/2013 23:09, Daniel A. Rodriguez wrote: There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-30 Thread Dan Lewis
On 05/29/2013 03:34 PM, Regina Henschel wrote: Brian Barker schrieb: At 06:19 29/05/2013 -0400, Dan Lewis wrote: On 05/29/2013 12:36 AM, Axel Braun wrote: Yes, that works for colors that are known to the system, not for custom colors (like in imported documents) Try this: Open the Styles

Re: [libreoffice-users] Creating EPUB e-books

2013-05-30 Thread Dan Lewis
On 05/30/2013 11:51 AM, James Knott wrote: There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice can save in HTML format, which can then be used as

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-29 Thread Dan Lewis
On 05/29/2013 12:36 AM, Axel Braun wrote: jorge wrote: In Writer you can select the word or letter that have the color you need to know. Then you can go to Menu - Format -Character- Font Color and there you can see the Number of the color (Grafico 10 -in spanish in my case as example). Now you

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-29 Thread Dan Lewis
On 05/29/2013 10:59 AM, Brian Barker wrote: At 06:19 29/05/2013 -0400, Dan Lewis wrote: On 05/29/2013 12:36 AM, Axel Braun wrote: Yes, that works for colors that are known to the system, not for custom colors (like in imported documents) Try this: Open the Styles and Formatting window (use

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

2013-05-25 Thread Dan Lewis
On 05/25/2013 07:10 AM, Ian Whitfield wrote: Thanks Noel !!! On 25/05/13 11:58, Marion Noel Lodge wrote: Assuming your field is 'Country', try this - SELECT Country, Count(Country) AS 'Count' FROM your Table name GROUP BY Country ORDER BY Country I had a problem, at first -

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

2013-05-25 Thread Dan Lewis
On 05/25/2013 08:37 AM, Dan Lewis wrote: On 05/25/2013 07:10 AM, Ian Whitfield wrote: Thanks Noel !!! On 25/05/13 11:58, Marion Noel Lodge wrote: Assuming your field is 'Country', try this - SELECT Country, Count(Country) AS 'Count' FROM your Table name GROUP BY Country

Re: [libreoffice-users] Unable to install LO 4.0.3.3.

2013-05-25 Thread Dan Lewis
On 05/25/2013 04:52 PM, Muriel Parker wrote: I am having trouble installing LO 4.0.3.3. The Help Pack installed, but not the program. A message comes up saying Please exit LO 3.3 before continuing. LO 3.3 is not open! Windows 7 Java 7 upgrade 21 Thanks. Muriel Since you are using

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

2013-05-22 Thread Dan Lewis
On 05/22/2013 03:34 AM, jnrigg wrote: What I need to know first is whether this is occurring in a table of the database or in a form. If the latter, you may be able to correct the problem by editing the properties of the fields in the form. The fields in the form also contains number

Re: [libreoffice-users] assign templates in Calc

2013-05-21 Thread Dan Lewis
On 05/21/2013 10:02 AM, Thomas Blasejewicz wrote: Good evening I know you can create templates in Writer and then assign them to other documents, using an extension. Now I tried to do the same thing in Calc. Does not seem to work. Is there a way of copying styles from one Calc document to

Re: [libreoffice-users] Re: How to insert date/time in a LibreOffice Writer text?

2013-05-20 Thread Dan Lewis
On 05/20/2013 04:02 PM, Luuk wrote: On 20-05-2013 19:27, André Ricardo Silva wrote: Hi. There is a command to insert date/time in a LibreOffice Writer text? Thank you in advance. In the English version follow the menu's: Insert / Fields / Date Insert / Fields / Time In addition to

Re: [libreoffice-users] Attempting to upgrade from (Swedish-language) LO 4.0.2.2 to 4.0.3.3 on 64-bit Ubuntu 12.04 LTS

2013-05-19 Thread Dan Lewis
On 05/19/2013 12:30 PM, M Henri Day wrote: 2013/5/19 Tom Davies tomdavie...@yahoo.co.uk Hi :) On Ubuntu try right-click on any Odt file and choose Properties in the Open With tab choose the 4.0.3 and set that as the default app to open Odts with Regards from Tom :) - Original Message

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

2013-05-18 Thread Dan Lewis
On 05/18/2013 03:38 AM, jnrigg wrote: I have LibreOffice 4.0.3.3 on a Windows 7 computer. I have an older database created originally with OpenOffice. The database is a household inventory including item description, brand name, serial number, date an item was purchased and its exact cost

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

2013-05-15 Thread Dan Lewis
On 05/15/2013 05:30 AM, Alexander Thurgood wrote: 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

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Dan Lewis
On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is,

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

2013-05-15 Thread Dan Lewis
On 05/15/2013 08:24 AM, Steven Friedrich wrote: 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? To save a little time, let me explain my question. I have a Base Form that uses a ListBox

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

2013-05-14 Thread Dan Lewis
On 05/14/2013 04:46 PM, Tim Deaton wrote: -- Tim === 225 Janice Drive Athens, GA 30606-1638 email: t...@timdeaton.org home: 706-543-0592 cell: 706-248-6544 fax: 888-415-5991 web: www.timdeaton.org === I know the plans I have for you: Plans to

Re: [libreoffice-users] Downloader Not Working

2013-05-13 Thread Dan Lewis
On 05/13/2013 06:39 PM, Mark LaPierre wrote: Hey All, I get a 404 error from the libre office download server. I've tried from two different Win XP machines and from my CentOS machine. All are running Fire Fox. I tried to download the Win version and the linux version. Both just got me

Re: [libreoffice-users] Installation options are remembered?

2013-05-12 Thread Dan Lewis
On 05/12/2013 05:55 AM, Thomas Becker wrote: Hello, I have read that to install a new version of LibreOffice, it is not necessary to uninstall the previous one. I can install over the previous. I am currently using version 4.0.1.2 (and am new to LibreOffice, I never used older versions). I

Re: [libreoffice-users] Installation options are remembered?

2013-05-12 Thread Dan Lewis
On 05/12/2013 11:38 AM, Thomas Becker wrote: Il 12/05/2013 14.47, Dan Lewis ha scritto: If you are using Windows as your operating system, do a custom install. (The previous installation will not be remembered.) Is there a particular reason why you do not want to install Base? You

Re: [libreoffice-users] error opening form, cannot delete form

2013-05-11 Thread Dan Lewis
On 05/11/2013 06:03 AM, rounak jain wrote: When I try to open a form, I get this error: When I try to delete it, I get the dialog box to confirm delete, I click Delete button, but the form is not deleted. What error do you get when you try to delete the form? More information about the

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

2013-05-11 Thread Dan Lewis
The method of installing the j connector should be similar to installing it on any Operating System. from the MySQL website download the zip file to your desktop: mysql-connector-java-5.1.25.zip. Double click it to unzip it producing the mysql-connector-java-5.1.25 folder. Drag it to the

Re: [libreoffice-users] help with database

2013-05-11 Thread Dan Lewis
On 05/11/2013 11:21 PM, rounak jain wrote: 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 entry?

Re: [libreoffice-users] Table of Contents woes

2013-05-10 Thread Dan Lewis
On 05/09/2013 02:21 PM, Carl Paulsen wrote: LibreOffice 3.5.6.2 Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0 On an Intel Mac on 10.6.8 I have a draft document in which I've used heading styles for sections. I now want to create a Table of Contents (ToC), but I'm having trouble getting

Re: [libreoffice-users] Currency format always gets lost/screwed up

2013-05-10 Thread Dan Lewis
On 05/10/2013 04:32 AM, Mathias Koerber wrote: I am using Libreoffice to write invoices. I have a table with several fields that need to be formatted as currency (SGD). I basically re-use an older document to save as a new one. Then I change the values. Most of the time one of the following

Re: [libreoffice-users] Database problem

2013-05-09 Thread Dan Lewis
On 05/09/2013 10:59 AM, Paul D. Mirowsky wrote: On 5/8/2013 2:43 PM, Dan Lewis wrote: On 05/08/2013 02:06 PM, Sean wrote: Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me

Re: [libreoffice-users] 4.0.3 64-bit DEB removed my extensions, but Windows version did not

2013-05-09 Thread Dan Lewis
On 05/09/2013 03:40 PM, Kracked_P_P---webmaster wrote: I just installed 4.0.3 on two systems The 64-bit DEB install removed my extensions and the persona I has setup. The Windows install did not do this. Any idea way the 64-bit DEB install in Ubuntu 12.04 would remove my added items, but

Re: [libreoffice-users] Database problem

2013-05-08 Thread Dan Lewis
On 05/08/2013 02:06 PM, Sean wrote: Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me the solution http://nabble.documentfoundation.org/file/n4054689/Capture.png -- View this

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

2013-05-08 Thread Dan Lewis
On 05/08/2013 12:31 PM, acanela wrote: 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. Soy un usuario de Libreoffice y me gustaría usar la cursiva y negrita en el programa Base. Thanks in advance, Antonio Canela.

Re: [libreoffice-users] Copy / Paste - Include Recorded Changes?

2013-05-08 Thread Dan Lewis
On 05/08/2013 07:05 PM, Joel Madero wrote: Hi All, Is there a way for me to copy a bunch of stuff that has recorded changes from one document and paste to another document including the changes? A regular copy paste seems to just copy the actual text, not the changes at all. Best, Joel

  1   2   3   4   5   >