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

I have uploaded two connectors to the Extension website under Base Extensions version 1.0.3. Both are for Linux only. One is 32 bit (x86) and the second is 64 bit (x86_64). For now, either should be downloaded for testing only. The 32 bit connector works on LO 4.0.x and 4.1.0 alpha for bot

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

t. Regards from Tom :) -------- *From:* Dan Lewis *To:* users@global.libreoffice.org *Sent:* Tuesday, 12 March 2013, 18:53 *Subject:* Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available But if you should change your mind, you might find

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

But if you should change your mind, you might find it difficult to go back to MySQL. I had to re-install Ubuntu 12.04 LST to remove all of the MariaDB files. Something similar happened when I tried MariaDB a few years ago. --Dan :-( On 03/12/2013 01:46 PM, Tom Davies wrote: Hi :) Just

Re: [libreoffice-users] Re: Java files

On 03/11/2013 07:17 PM, Tom wrote: Hi :) The mailing list doesn't accept attachments but you can upload your files to Nabble so that people can choose to look at them. In Nabble start writing a reply in your own thread and click on the "More" button. It inserts an html-style link into your mess

Re: [libreoffice-users] caption numbering

On 03/10/2013 11:17 PM, Thomas Blasejewicz wrote: > Good afternoon > > I am sure there is a simple trick to it, but I nevertheless cannot > figure it out. > The official documentation does not seem to mention it. > > I am writing a sort of "book" with a number of pictures in it. Some have > caption

Re: [libreoffice-users] Currency conversion/display in calc

On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format

Re: [libreoffice-users] Change of base dimensioning system from imperial to metric

On 03/07/2013 01:08 AM, David Dartnall wrote: Hi all, No doubt I've missed it but I can find no way to change the base dimensioning system from imperial to metric. Please advise if this is possible, and if so, how. Calc is seems ok but writer for page sizes, label sizes etc is imperial in my v

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

On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or mo

Re: [libreoffice-users] 3/4/13 in writer table

On 03/04/2013 10:09 AM, bill wrote: I have a writer document with a table. The first col is formatted as date, but when I enter today ( 3/4/13 ) the 3/4 is formatted as a small 3/4th. I checked the col formatting and it really is date (MM/DD/YY) Any thoughts or suggestions ? Tools > Aut

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

On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or mo

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

On 03/02/2013 01:47 PM, Heinrich Stoellinger wrote: On Sat, 02 Mar 2013 14:46:45 +0100, Dan Lewis wrote: On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: Hello, Seeing as the Native MySQL-connector seems to be a "difficult" birth - I tried both ODBC and JDBC lately. Unfortun

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

On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: 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 specify codepage

Re: [libreoffice-users] Does Libre Office have its own distinct set of fonts?

distro: the operating system on your computer (Windows, Linux, OS X, etc.) AAMOF: as far as my other fonts The latter is a "guess" but it seems logical. So, if you would tell us one more time, what is your operating system. That will tell us the location of your font folder or folders

Re: [libreoffice-users] Writer: Nested Bullet Lists with different bullets?

You are right: Edit your Default template. Then edit the List style you want to use. Make these changes in the Option tab. Make any other changes that you want to use and click OK to close it. Save your Default template. One thing that was not mentioned explicitly. Step 1 needs to be

Re: [libreoffice-users] Writer: Nested Bullet Lists with different bullets?

In addition I would change your step #3 to Choose Graphics rather than Bullets. This reveals an additional dropdown list (Select). From here you can select a graphic from a file or from the choice of bullets in the gallery. As a test, I created a nested bullet list with three levels. L

Re: [libreoffice-users] Re: another funny one from ZdNet

On 02/22/2013 02:45 PM, Urmas wrote: "Kieran Peckett": Erm... It does have user dictionaries, you just click the "Add" button! Those are wordlists, not dictionaries. Generally useless for languages other than English. Just curious: does MS Word have definitions in its dictionaries?

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

On 02/21/2013 03:09 AM, Alex Thurgood wrote: Le 20/02/2013 23:16, Dan Lewis a écrit : Hi Dan, checking for GCONF... yes checking whether to enable GNOME VFS support... yes checking for GNOMEVFS... no configure: error: Package requirements (gnome-vfs-2.0 >= 2.6.0 ) were not met: No pack

Re: [libreoffice-users] LO 4.0.0.3: Calc Crashes when setting data validity

On 02/21/2013 03:00 PM, Rev. Nick Sharp wrote: I have a spreadsheet to record financial transactions, and to save typing, I maintain a list of common transactions which can be selected in certain cells by a drop down box. I populate the list from a cell range in another sheet. When I add new tra

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

On 02/21/2013 01:10 PM, Alex Thurgood wrote: 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 2>&1 | tee build.log You have a successful LO build, congratu

Re: [libreoffice-users] Re: brochure templates for letter and A4 sizes

On 02/21/2013 10:59 AM, webmaster-Kracked_P_P wrote: On 02/21/2013 04:01 AM, Marc Paré wrote: Le 2013-02-20 21:33, webmaster-Kracked_P_P a écrit : On 02/20/2013 05:11 PM, Brian Barker wrote: At 14:36 20/02/2013 -0500, Tim Lungstrom wrote: Europe A4 size Perhaps that should be "everywhere-in

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

On 02/20/2013 10:21 PM, Dan Lewis wrote: I have a 32 bit laptop running Ubuntu 12.04. On it I have installed LO 3.6.5.2 and 4.0.0.3. This evening I was going to built LO 4.0.0 with the native connector for MySQL. In the process I had to download some files needed for autogen.sh to

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

I have a 32 bit laptop running Ubuntu 12.04. On it I have installed LO 3.6.5.2 and 4.0.0.3. This evening I was going to built LO 4.0.0 with the native connector for MySQL. In the process I had to download some files needed for autogen.sh to work properly. Among these are two groups.

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

On 02/20/2013 04:55 PM, Alex Thurgood wrote: 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 & derivati

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

On 02/20/2013 01:23 PM, Alexander Thurgood wrote: Le 20/02/13 17:04, Dan Lewis a écrit : Hi Dan, I have a MacBook (Intel)circa 2006 that originally had OS X 10.4 installed. It has 2 GB RAM and is 32 bit. I have installed Ubuntu 12.04. Could this be used to compile a connector? If so

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

On 02/20/2013 01:23 PM, Alexander Thurgood wrote: Le 20/02/13 17:04, Dan Lewis a écrit : Hi Dan, I have a MacBook (Intel)circa 2006 that originally had OS X 10.4 installed. It has 2 GB RAM and is 32 bit. I have installed Ubuntu 12.04. Could this be used to compile a connector? If so

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

On 02/17/2013 06:34 AM, Alex Thurgood wrote: 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 Nadi

Re: [libreoffice-users] Re: Moving Templates from 3.5.5 to 4.0

t things to speed it up). Any other ideas? Dan Lewis wrote I am confused. when I use Tools -> Customize, the Customize dialog opens. I don't see where I can select /New Document from Template/ nor /Template Manager/. What do see at the top is four tabs with /Menus/ selected with /File/ men

Re: [libreoffice-users] Re: Moving Templates from 3.5.5 to 4.0

I am confused. when I use Tools -> Customize, the Customize dialog opens. I don't see where I can select /New Document from Template/ nor /Template Manager/. What do see at the top is four tabs with /Menus/ selected with /File/ menu as the default for the dropdown list. Perhaps you could g

Re: [libreoffice-users] Re: MySQL on a network

On 02/18/2013 03:05 PM, Girvin R. Herr wrote: Luuk wrote: On 17-02-2013 22:53, Girvin R. Herr wrote: Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same

Re: [libreoffice-users] Re: MySQL on a network

On 02/17/2013 04:53 PM, Girvin R. Herr wrote: Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL

Re: [libreoffice-users] Irregularities with footnote numbering when switching to MSW

On 02/17/2013 12:34 PM, webmaster-Kracked_P_P wrote: On 02/17/2013 11:59 AM, Rogier F. van Vlissingen wrote: I am working on a series of documents, chapters of a book, en every time I set up footnotes with regular arabic numbers, 1/2/3/4/5 etc, but when I send the file to a colleague, and she o

Re: [libreoffice-users] MySQL on a network

On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote: On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in

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

On 02/16/2013 07:04 PM, Mark LaPierre wrote: Hey All, I need to link a database to several external spreadsheets. A.> If I use the DB wizard to create a DB linked to a spreadsheet I get the table named by the name of the tab inside the spreadsheet. That's great but I can not add any more tab

[libreoffice-users] MySQL on a network

I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes.

Re: [libreoffice-users] Re: page down in word processors - find next

On 02/16/2013 07:41 AM, william drescher wrote: On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button become

Re: [libreoffice-users] page down in word processors

Strange thing: I can not find an INS key on my MacBook. Its delete key acts like the back space key... --Dan On 02/15/2013 04:05 PM, anne-ology wrote: ooh, how I dislike that INS key ... I tend to hit that rather than the DEL key many times; then I'll start typing only to f

Re: [libreoffice-users] calc: method to subdivide individual cells

On 02/15/2013 01:29 PM, bill wrote: On 2/15/2013 10:33 AM, jomali wrote: I've been following this thread and wondering what a use case would be for subdividing cells. I own a breeding kennel. I created a table to keep track of medication administration col A: date col B: dog 1 name, col ti

Re: [libreoffice-users] MySQL-Connector

On 02/15/2013 01:59 PM, Heinrich Stoellinger wrote: Hello, I know I have gone on about the native connector before. My situtation is like this at the moment: - it works like a charm on 4.0.0.3 running Debian-Wheezy - it neither works on Mint-Nadia or Windows-Vista (I know, I know -- I should up

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

02/14/2013 07:39 PM, Girvin R. Herr wrote: Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: Some basics about creating a database: 1) You begin with data that you want to use for some

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

On 02/11/2013 05:31 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > ` > On 02/11/2013 09:18 AM, Uwe Brauer wrote: >> >> Uwe Brauer > How do you define an "intrinsic database"? I do not understand > the t

Re: [libreoffice-users] Table borders

On 02/13/2013 09:38 AM, PGR wrote: Hi, I have a MS Word document with table borders that don't get printed on Libreoffice 4.0. I can only see these borders in previsualization. My document has a table and a logo. I know this was an issue on 3.4 version but I'm using version 4.0, portable

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

On 02/12/2013 12:03 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > Perhaps you need to learn more about primary keys, foreign keys, > and the relationship that must exist between them. Another topic that > would help is normalizing tables. Sti

Re: [libreoffice-users] Feature Request

On 02/12/2013 03:01 PM, webmaster-Kracked_P_P wrote: On 02/12/2013 02:04 PM, John R. Sowden wrote: I know this is a bad time, since 4.0 was just released, but improvement is an ongoing process. For the 'recent documents' menu selection under 'file', it would be nice to: 1) allow us to set th

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

On 02/11/2013 05:31 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > ` > On 02/11/2013 09:18 AM, Uwe Brauer wrote: >> >> Uwe Brauer > How do you define an "intrinsic database"? I do not understand > the t

Re: [libreoffice-users] Re: Installing the Deb

gards from Tom :) From: Marc Paré To: users@global.libreoffice.org Sent: Monday, 11 February 2013, 18:48 Subject: [libreoffice-users] Re: Installing the Deb Le 2013-02-11 13:05, Dan Lewis a écrit : There are a variety of ways to install LO for Debian OS's. Some are harder than others,

Re: [libreoffice-users] Re: Installing the Deb

On 02/11/2013 01:48 PM, Marc Paré wrote: Le 2013-02-11 13:05, Dan Lewis a écrit : There are a variety of ways to install LO for Debian OS's. Some are harder than others, and some are easier. What no one has mentioned is the use of script files. They will do much of the work for you. Pla

Re: [libreoffice-users] Re: Installing the Deb

On 02/11/2013 11:53 AM, Marc Paré wrote: Wow, I can't imagine that it is that difficult to install LibreOffice on .deb or, for that matter, on any other package (.rpm) on Linux. I am like Tim with his suggestions below. I am on Mageia Linux rpm. Except I just don't like typing anything for ins

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

` On 02/11/2013 09:18 AM, Uwe Brauer wrote: Hello (It seems that my message did not pass to the gmane newserver, that is why I resend this message) I am using Kubuntu 10.04 and installed the latest LO 4.0 (the problem occurs also in 3.6, and in OO 3.3). I set up the intrinsic (hsql) data base.

Re: [libreoffice-users] Re: Installing the Deb

On 02/09/2013 04:21 PM, Jay Lozier wrote: On 02/09/2013 03:07 PM, Tom Davies wrote: Hi :) I downloaded the .Deb for Ubuntu (and others) twice yday and tried installing it as per instructions but when i tried running LibreOffice from the command-line by typing in libreoffice I got an error mess

Re: [libreoffice-users] explorer prewiew

On 02/09/2013 03:25 PM, Kolbjørn Stuestøl wrote: Den 09.02.2013 15:57, skreiv Thomas und Reni Schäfer: Hello I already installed libreoffice 4, and i missed the preview function for the windows explorer (Win 7 home, 32bit). Is this function available? Best regards Thomas Schaefer I did not k

Re: [libreoffice-users] A (sane) way of doing bullets and numbering

On 02/08/2013 08:02 AM, sun shine wrote: Hi list One of the biggest (personal) bugbears I have with LibO (and OOo before this) is the issue of numbering and bulleting. It just seems counter-intuitive to me and is one of the very few areas where I think that MS has a better approach. I have

Re: Fwd: Re: [libreoffice-users] [solved] Re: Spell check as I type enabled but no spell checking

This is obviously a bug in the Linux Mint version. I know that earlier I had the Ubuntu version of LO 3.5.4. When I typed every word was marked as an incorrect spelling. I have no such problems with the version supplied by LibreOffice, itself. --Dan On 02/08/2013 08:52 AM, sun shine wrot

Re: [libreoffice-users] Suggests

:) *From:* Kieran Peckett *To:* anne-ology *Cc:* users@global.libreoffice.org; Dan Lewis *Sent:* Monday, 4 February 2013, 7:22 *Subject:* Re: [libreoffice-users] Suggests It won't be copyright infringement on Windows if we use MS's API, then it won

Re: [libreoffice-users] Suggests

On 02/03/2013 07:58 AM, Roberta wrote: Can you make libreoffice's interface more similar to the office 2013 one's? Another thing... why doesn't artwork work on writer??? If I understand correctly, MS Office 2013 is a copyrighted work. Remember the recent court battle over the similar appea

Re: [libreoffice-users] VLOOKUP Problem

If you look at my address above, you will see that I use Gmail. My email client is Thunderbird which has choices as to how to reply: Reply to List (possibly because the mail headers contain a "reply to"), Reply or Reply to all (when there does not seem to be a "reply to" in the mail heade

Re: [libreoffice-users] Saving to an ascii file

On 01/31/2013 07:49 PM, John R. Sowden wrote: How do I 'save as' or export selected text in LO calc to an ascii file where i can exit it. I seem only to have the options for special file formats, PDF, XML, etc. Thanks, John Save the Calc file as CSV. This is a text file with its data s

Re: [libreoffice-users] Copy Paste Calc Writer

On 01/31/2013 03:26 AM, Ad Kurvink wrote: Dear All, Since quite some time I cannot complete copy paste anymore the way I used to. I did as follows : I made a contract in Calc Made a selection and clicked copy Than opened a writer sheet what I have already, that is where I have my adress on

Re: [libreoffice-users] changing text color

On 01/31/2013 04:01 AM, edo1 wrote: Sorry to continue asking elementary questions, I'm having a devil of a time getting LO 3.6.4.3 to behave. I cannot change the foreground color (i.e., the color of selected text) - pressing on the text-color icon in the toolbar has no effect. Setting background

Re: [libreoffice-users] Re: Numbering Equations

On 01/29/2013 03:38 PM, Taang Zomi wrote: On Tue, Jan 29, 2013 at 12:31 PM, Brian Barkerwrote: At 11:51 29/01/2013 -0500, Taang Zomi wrote: On Mon, Jan 28, 2013 at 12:30 AM, Brian Barker wrote: At 18:04 27/01/2013 -0500, Taang Zomi wrote: In LibreOffice 3.3 Math Guide (0700MG33-MathGuide3

Re: [libreoffice-users] Include movie in PDF export?

On 01/28/2013 02:38 PM, RODRIGUEZ FONSECA JORGE ALBERTO wrote: Hi all: Why not save the document as .doc ? or you can use this: http://universal-usb-installer.softonic.com/ or request permit to install LibreOffice in the computer that you are going to use...why not ? Regards, Jorge Rodrígue

Re: [libreoffice-users] Re: Base Report Builder

Many of these "advantages" also apply to HSQLDB if you know what you are doing. I refer to using Base to connect to the database rather than it be "embedded". In this case, tables, queries, forms, and reports can be copied from the embedded database to the external one. This is done using

Re: [libreoffice-users] Installing 4.0 alongside 3.5

` On 01/26/2013 02:52 PM, Paolo Debortoli wrote: Il 26/01/2013 20:02, Johnny Rosenberg ha scritto: For some reasons I want to try the upcoming version 4.0. On the web page, they say ”You are not recommended to use LibreOffice pre-release builds for "mission-critical" purposes”. So obviously I ne

Re: [libreoffice-users] Re: Urgent Base problem

On 01/24/2013 05:14 PM, capemayal wrote: Hello Alex. Thanks your response. I'm using 3.5.4 from Ubuntu 12.04 LTS software library. Right now, the only workaround I've found is to create view from the query, then use that for the report. However, I'm going to assume you've gotten 3.7 from the

Re: [libreoffice-users] Re: LibreOffice 3.6.4 Romanian installer translation is HORRIBLY broken

OK, now I understand. These are the steps needed to download the Romanian version of LibreOffice. 1) Use this link: http://www.libreoffice.org/download/?nodetect This opens with the versions of LibreOffice available by the type of operating system used. Click the windows version. 2) On

Re: [libreoffice-users] Re: LibreOffice 3.6.4 Romanian installer translation is HORRIBLY broken

On 01/24/2013 01:18 PM, zugu wrote: I'm sorry, but even your English is compromised. If you're the one who translated the installer, there's nothing you can do. I am appealing to whoever's in charge and granting Pootle access to translators: please remove whoever committed the broken translation

Re: [libreoffice-users] Base Query Sort and Reports

On 01/23/2013 04:22 PM, capemayal wrote: LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) I have created a query from one table. In the query design grid I sort, ascending, on a 'name' field. The query works as expected with results sorted on the 'name' field. When creating a report, using the wi

Re: [libreoffice-users] Re: calendar project - should i use writer or calc

Having viewed your links, I think the Writer would be a better choice. --Dan On 01/24/2013 12:11 PM, anne-ology wrote: I think you meant to send this to the list, so am forwarding this on to them. As for me, I haven't a clue as to how to use the calc program

Re: [libreoffice-users] base masks

On 01/21/2013 03:00 AM, Paolo Debortoli wrote: Il 21/01/2013 01:48, Dan Lewis ha scritto: On 01/20/2013 05:58 PM, Paolo Debortoli wrote: hi. using base... is there a way to open masks without borders or tools, just the mask, to make it smaller ? I an not sure I understand what you mean

Re: [libreoffice-users] Base Report Builder

d. That might be useful as Base is getting much less responsive, seems bloated.. The size of my database file is about 360 KB. Hank On Sun, Jan 20, 2013 at 4:55 PM, Dan Lewis <mailto:elderdanle...@gmail.com>> wrote: On 01/20/2013 04:31 PM, Hank Alper wrote: Hi

Re: [libreoffice-users] base masks

On 01/20/2013 05:58 PM, Paolo Debortoli wrote: hi. using base... is there a way to open masks without borders or tools, just the mask, to make it smaller ? I an not sure I understand what you mean. The only thing in Base that has a mask that I know is a pattern field. It has two of them:

Re: [libreoffice-users] Base Report Builder

On 01/20/2013 04:31 PM, Hank Alper wrote: Hi I've invested a considerable amount of time in constructing tables, forms and queries for a project of mine. I successfully produced 3 nice reports using Report Builder. Now, I'm starting to observe strange behavior in Base. Queries and Reports I've pr

Re: [libreoffice-users] Database sort problem

On 01/19/2013 11:59 AM, Ian Whitfield wrote: Hi All I now have my Main Form with Sub Form working well with one remaining problem... My Sub Form has a Field 'Date' (Type Date) and I have set it to sort into Date Order by selecting the field 'Date' and the value 'Ascending'. My date format i

Re: [libreoffice-users] Re: Thunderbird Address Book as Data Source

On 01/18/2013 04:58 PM, webmaster-Kracked_P_P wrote: On 01/18/2013 11:59 AM, Alex Thurgood wrote: On 01/15/2013 03:15 AM, David Burleigh wrote: Hi David, It is very nice that the new 4.0 release includes support for the Thunderbird address book as a data source for mail merges, but it seems t

Re: [libreoffice-users] Calc sliding scale formulae?

Perhaps the private suggestion was correct. Perhaps your understanding of Algebra is not as good as it needs to be. After all this is an Algebra problem. Now for some questions: 1. How much will 1 to 150 units cost? What is the formula to determine this? 2. How much will 151 to 599 u

Re: [libreoffice-users] Broken file

On 01/17/2013 10:53 AM, Sandy Harris wrote: On Thu, Jan 17, 2013 at 8:32 AM, Dan Lewis wrote: I'm not sure about this: Where did you get your copy of LibreOffice? Via the Xubuntu Linux distro, 64-bit X86, 3.5.something kernel. And would you mention what version you are using

Re: [libreoffice-users] Broken file

On 01/17/2013 06:24 AM, Sandy Harris wrote: On Thu, Jan 17, 2013 at 6:03 AM, Tom Davies wrote: Ah, so if it's never been touched by MSO is you Odt version as up-to-date as your Doc version? Not even close. There are .doc backups that are closer, but not up-to-date. It's best to do all edi

Re: [libreoffice-users] Selection List editing

On 01/16/2013 10:07 AM, JeepNut wrote: Have looked for an hour online and in the help texts trying to figure out how to edit what I see in the Selection List when I right click on a cell in Calc and get the pulldown list. I've been through the data validity drill but see nothing in the "list" t

Re: [libreoffice-users] Broken file

On 01/16/2013 09:07 AM, Sandy Harris wrote: I've been editing a file that is in Word .doc format using L-O 3.6 on Xubuntu Linux, with all updates Xubuntu provides. File was created by L-O on this system as ODF, later converted to Word format for some sharing. Formatting is not remarkably complex;

Re: [libreoffice-users] Did you get my Hyperlink message?

On 01/16/2013 06:58 AM, rjh wrote: How do I report it? Thanks Use this link: https://www.libreoffice.org/get-help/bug/. Then create an account followed by coming back to this web page. Follow the steps to report the bug. --Dan -- For unsubscribe instructions e-mail to: users+h...@gl

Re: [libreoffice-users] Did you get my Hyperlink message?

On 01/15/2013 09:28 PM, rjh wrote: sorry everyone I have made it public now :-) http://youtu.be/T3XH5AO2jws I think you have found a bug! You need to file a bug report. The hyperlink is not working like it should. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreo

Re: [libreoffice-users] Did you get my Hyperlink message?

On 01/15/2013 08:58 PM, rjh wrote: Hi I made a video as it was easier to explain. http://youtu.be/T3XH5AO2jws thanks Big problem: This is what I get when I clicked your link. This video is private. If the owner of this video has granted you access, please log in

Re: [libreoffice-users] Recent Documents list

On 01/14/2013 04:36 PM, Caesar wrote: Hello all, Re: LO 3.6.4 on Windows XP In both Writer and Calc if one clicks on File - Recent Documents they are presented with a list of up to ten of the most recently accessed documents. Is there anyway to increase that number to greater than ten? Tha

Re: [libreoffice-users] Re: [libreoffice-documentation] I joined recently. How can I help?

and 3 are only drafts). I must have slipped the third chapter in without anyone noticing it. --Dan From: Dan Lewis Completing the Base Handbook might be a good idea also. Completing it would be nice. Chapter 5 discusses queries. This is the link where

Re: [libreoffice-users] Re: Embedded Java

On 01/13/2013 10:44 PM, Paul Schwartz wrote: Does this update fix the Java plugin for Firefox? No it does not. A recent update for Firefox disabled the Java plugin as explained in the Firefox Help. I suggest you read what Firefox Help has to say about the Java plugin. --Dan

Re: [libreoffice-users] Base: Setting the default listbox entry

On 01/11/2013 09:46 PM, Girvin R. Herr wrote: Greetings, I am using LO 3.6.4.3 for Linux. I am trying to set a default entry for a listbox based on a joined table. The listbox has entries from the joined table as options. One of those options is the character: - (dash). I would like this o

Re: [libreoffice-users] Embedded Java

On 01/13/2013 03:28 AM, Jay Lozier wrote: On 01/12/2013 10:42 PM, George R. Crossman wrote: I'm seeing warnings saying that one should disable embedded Java to avoid hacking. Does this apply to linux users? If so, what is the procedure? George Crossman George, Yes, all OS's are affected be

Re: [libreoffice-users] Base: Changing & restoring (Default) font

I use the Ubuntu OS, and I have noticed that the Default font setting is "Ubuntu" which got me to thinking. Is Base using the OS font settings? It seems that it is. I changed the Ubuntu OS font settings from Ubuntu to Liberation Sans and then checked the default fonts in Base. They also were ch

Re: [libreoffice-users] Re: Base: Action Queries

into a fresh query. I'm not quite sure what i'm doing wrong but that is not a big surprise. I've got a bit of reading to do and some of that should make more sense now i've played around a bit. Thanks all and regards from Tom :) ________ From: Dan

Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1

On 01/12/2013 12:14 AM, NoOp wrote: On 01/11/2013 08:04 PM, C. H. D. wrote: Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here: https://www.libreoffice.org/get-help/bug/ The error message I get is:

Re: [libreoffice-users] Re: Base: Action Queries

I wonder about the last line of your code: WHERE OrgName IS NOT NULL; Above this line you used "OrgName" Your field has upper and lower case letters. When this is the case, you must enclose the field's name in double quotes. So, I'm thinking that this is likely the problem. A

Re: [libreoffice-users] Re: Base scenario

Comment inline below. --Dan On 01/08/2013 07:07 PM, Girvin R. Herr wrote: Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the on

Re: [libreoffice-users] Re: Base scenario

On 01/08/2013 09:32 AM, Ian Whitfield wrote: Hi All Re - My previous post Have been doing some Googling etc and found the 'Relationships Window' for setting Relationships. I can get the Window up, select my Tables but it _DOES NOT_ draw any connecting lines or set any Relationships!!??

Re: [libreoffice-users] Changing time format in Calc header

On 01/08/2013 03:15 PM, Karen DInse wrote: We are using Windows XP, SP3, LibreOffice 3.5.5.3 We have created a Calc spreadsheet and want to show the time in the header. When we print the sheet, the time shows military time. Is there a way to change that to show 12 hour time? I know that we wou

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

On 12/29/2012 07:46 PM, Dan Lewis wrote: On 12/29/2012 03:28 PM, Girvin R. Herr wrote: Greetings, I noted that after I updated LO from 3.5.7 to 3.6.4, the Base date entry format flexibility has changed. With a 3.5.7 (and before) Base form, I could enter 12-29-12 and it would be changed to 12

Re: [libreoffice-users] problems with "update style" on some headers

On 01/01/2013 11:52 AM, Rob Nikander wrote: Hi, I have LibreOffice 3.6.4.3, on Mac OS, and a new document. I'm trying to change the style of "Header 2" by changing one header and using "Update Style", but it doesn't work. Here's exactly what I do... I have 2 paragraphs of style "Header 2". T

Re: [libreoffice-users] calculating time differences

On 12/31/2012 02:20 PM, Daniel A. Rodriguez wrote: Hi there I need to calculate several videos duration having initial and final time in hh:mm:ss.000 format. But even if such format is set as a custom one just got a #VALUE! message. Is possible to achieve that task or need to look for an alterna

Re: [libreoffice-users] Base Compact and Shutdown

On 12/31/2012 03:26 AM, Mark Stanton wrote: Even if it existed, I would be quite surprised if such a thing is necessary for MySQL. Looking through the (5.1) manual, the only references to "compact" (as a verb) as to do with dumping data and a storage structure option. There is nothing (that I c

Re: [libreoffice-users] Calc Compatibility with xlsm

On 12/30/2012 07:40 PM, mdov...@comcast.net wrote: My apologies if this may have been posted before. I searched back in the archives about four months and did not find anything. I am currently using LibreOffice 3.6.0.2 and have been trying to use the xlsm files featured here https://people.high

Re: [libreoffice-users] How to calculate a grand total for entire report

On 12/30/2012 04:13 PM, Dan Lewis wrote: On 12/30/2012 12:34 AM, Yahoo Account wrote: I am using LO 3.6.4 in Mac OS X 10.8.2. In Base I have a very simple, single table assets database. In a report, I am trying to calculate a grand total for all records. I have a text field for each record

Re: [libreoffice-users] How to calculate a grand total for entire report

On 12/30/2012 12:34 AM, Yahoo Account wrote: I am using LO 3.6.4 in Mac OS X 10.8.2. In Base I have a very simple, single table assets database. In a report, I am trying to calculate a grand total for all records. I have a text field for each record in the report which has a calculated amount

<    1   2   3   4   5   6   >