[users] Attach a bullet style to the bullet button

2006-06-08 Thread Gert Blij
I have created a bullet style that I want to use as a standard. How can I get to use this particular bullet style every time I click on the Bullet button in the Formatting Toolbar. TIA Gert Blij - To unsubscribe, e-mail: [EMAIL

[users] Merge to email

2006-04-24 Thread Gert Blij
OOo 2.0.2 on WinXP Merge to email was promised for 2.0. I checked the manuals and the KB but couldn't find anything. Checking the archives shows an enormous amount of frustration and one article describing a scarily techie solution using some Python stuff. Can anybody point me (a none-techie) to

[users] Change delete selection in Calc

2006-01-26 Thread Gert Blij
When I press the delete key in Calc I get a number of default pre-ticked selection options. Is it possible to set OOo up in such a way that as the default only Delete All is ticked and all the other options are un-ticked? TIA Gert ---

[users] Strange behaviour after saving odt file as MS Word file

2005-12-21 Thread Gert Blij
I have a Writer file with a picture, draw object on top of the picture followed by text. When I save this a an MS Word file and open it in Word, the picture does not show in Normal view, but shows fine in Print view. Can anyone explain this? Cheers Gert --

RE: [users] Save as MS Word *.doc looses graphics?

2005-12-15 Thread Gert Blij
ld have something to do with how you've > anchored the graphic's and drawing objects. > > Have a play around with this and reply to the list is the > issue still happens. > > /paul > > On 12/15/05, Gert Blij <[EMAIL PROTECTED]> wrote: > > I have a Writ

[users] Dave as MS Word *.doc looses graphics?

2005-12-14 Thread Gert Blij
I have a Writer file with an inserted picture on the first page. On top of the picture I have put objects via the Drawing toolbar. The page is Landscape. The I have inserted a page break to a page style with portrait. On this page I have normal text. When I save this file as an MS Word document a

[users] Set cell padding in tables to zero

2005-12-09 Thread Gert Blij
How do I set the cell padding to zero. Right now if I have left aligned text followed by a table, the first letter in the table is slightly indented vis a vis the non table text. TIA Gert - To unsubscribe, e-mail: [EMAIL PRO

[users] Change the name of a template. Bug???

2005-12-02 Thread Gert Blij
Thanks Les > -Original Message- > From: Leslie Danks [mailto:[EMAIL PROTECTED] > Sent: Thu 01 December 2005 05:50 PM > To: users@openoffice.org > Subject: Re: Change the name of a template > > Gert Blij wrote: > > > How do I do that? > > Open it, c

RE: [users] Re: List 1 default numbering style

2005-12-02 Thread Gert Blij
Hi Guido > > Gert Blij icon.co.za> writes: > > > How can I set my "List 1" numbering style as the default > style when > > > I create a new document? > > > > You can modify the default style using Format /Styles and > Formatting,

[users] Change the name of a template

2005-12-01 Thread Gert Blij
How do I do that? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] RE: [dba-users] importing table in OOdb

2005-12-01 Thread Gert Blij
> -Original Message- > From: Joep L. Blom [mailto:[EMAIL PROTECTED] > Sent: Wed 30 November 2005 02:17 PM > To: [EMAIL PROTECTED] > Subject: RE: [dba-users] importing table in OOdb > > > Gert, > Thanks for your reply. I tried it immediately. > However, when I tried it, it gave me the 'f

[users] List 1 default numbering style

2005-11-30 Thread Gert Blij
How can I set my "List 1" numbering style as the default style when I create a new document? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] List 1 default numbering style

2005-11-29 Thread Gert Blij
How can I set my "List 1" numbering style the default style when I create a new document? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [users] Like operator in Calc IF function

2005-11-16 Thread Gert Blij
Thanks David, That last one is working fine and solves my problem. Cheers Gert > -Original Message- > From: David Chapman [mailto:[EMAIL PROTECTED] > Sent: Tue 15 November 2005 03:42 PM > To: users@openoffice.org > Subject: Re: [users] Like operator in Calc IF function > > Or rathe

[users] Like operator in Calc IF function

2005-11-15 Thread Gert Blij
I am trying to do something like this: =if(a1 like '*sometext';"YES";"NO") But keep getting the #NAME error. What am I doing wrong? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAI

[users] RE: importing data into databases

2005-11-09 Thread Gert Blij
Hi Jim, > -Original Message- > From: Jim Wagner [mailto:[EMAIL PROTECTED] > Sent: Tue 08 November 2005 06:45 AM > To: users@openoffice.org > Subject: importing data into databases > > I've been starting to learn the Database function for OO2. > It seems incredibly easy, in one way, tho

[users] How to set default printer in OOo

2005-11-08 Thread Gert Blij
I have two users on my laptop, Administrator at home and "CompanyUser" at work. When I use "CompanyUser" OOo still recognises the Administrator profile's default printer. How do I get OOo to recognise my default printer at work? Cheers Gert ---

[users] Calc - sort on more than 3 columns

2005-11-04 Thread Gert Blij
Is this possible? Or is there a trick? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

FW: [users] how do I export query results from Base 2.0 to Calc 2.0?

2005-10-30 Thread Gert Blij
On 10/28/05, Gert Blij <[EMAIL PROTECTED]> wrote: > On 10/26/05, Nicholas Sushkin <[EMAIL PROTECTED]> wrote: > I set up a JDBC query in the Base application, but I can't get the > data out to a spreadsheet. Cut and paste doesn't work. There is no > optio

[users] OOoWikiPedia does not work for secondary user

2005-10-21 Thread Gert Blij
I just downloaded the OOoWikipedia Addon. I am a mobile user with a laptop with two users, Administrator and OfficeUser. I installed the addon as instructed as Administrator and it works fine. However, when I log in as OfficeUser, I don't see the two W icons and neither do I see the toolbar unde

RE: [users] RC1 and 2 problems with Base

2005-10-14 Thread Gert Blij
about this with the final release. Cheers Gert > -Original Message- > From: CPHennessy [mailto:[EMAIL PROTECTED] > Sent: Fri 14 October 2005 02:39 AM > To: users@openoffice.org > Subject: Re: [users] RC1 and 2 problems with Base > > On Wed October 12 2005 11:07, Gert

[users] RC1 and 2 problems with Base

2005-10-12 Thread Gert Blij
WinXP, MySQL. I am having tremendous problems with Base all of a sudden. In RC2 Base could not find the JDBC driver at all (although properly set up in Options|Java|Classpath) I uninstalled RC2 and re-installed RC1. While I now can work again with my databases it is exceptionally mercurial. F

RE: [users] Base connection problem

2005-10-11 Thread Gert Blij
Hi Andrew, > -Original Message- > From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED] > Sent: Tuesday 11 October 2005 12:39 AM > To: users@openoffice.org > Cc: [EMAIL PROTECTED] > Subject: Re: [users] Base connection problem > > [EMAIL PROTECTED] wrote: > > > I am sorry to bother y

[users] RE: Drag and Drop

2005-10-03 Thread Gert Blij
Hi Chaitanya, Dragging and dropping in OOo is quite different in many ways than you might be used to in other applications. Check the KB at http://mindmeld.cybersite.com.au/ and search for drag and drop. Cheers Gert > -Original Message- > From: Chaitanya Soni [mailto:[EMAIL PROTECTED]

RE: [users] Funny network behaviour with OOo?

2005-10-03 Thread Gert Blij
Hi Alex, > -Original Message- > From: Alex Thurgood [mailto:[EMAIL PROTECTED] > Sent: Fri 30 September 2005 10:43 PM > To: users@openoffice.org > Subject: Re: [users] Funny network behaviour with OOo? > > Le vendredi 30 septembre 2005 à 16:52 +0200, Gert Blij a

[users] Funny network behaviour with OOo?

2005-09-30 Thread Gert Blij
Something funny started happening as per yesterday. (It happens in both 128 and 2.0 rc on WinXP). Whenever I am on the network OOo (definitely Calc and Writer) slow down dramatically. All my OOo files are on my local drive, but when I open a spreadsheet or a document, or copy and paste between doc

RE: [users] Wrap picture to the right of text?

2005-09-30 Thread Gert Blij
Thanks Doug > -Original Message- > From: Doug Thompson [mailto:[EMAIL PROTECTED] > Sent: Wed 28 September 2005 06:12 PM > To: users@openoffice.org > Subject: Re: [users] Wrap picture to the right of text? > > Gert Blij wrote: > > How can I do this? > >

[users] Wrap picture to the right of text?

2005-09-28 Thread Gert Blij
How can I do this? What I am trying to achieve is something like: ___ TEXT: | | | Picture | |___| I can get the text *following* the picture to wrap to the rig

RE: [users] (Open) Office sounds

2005-09-27 Thread Gert Blij
> -Original Message- > From: CPHennessy [mailto:[EMAIL PROTECTED] > Sent: Tue 27 September 2005 01:07 AM > To: users@openoffice.org > Subject: Re: [users] (Open) Office sounds > > On Mon September 26 2005 14:50, Gert Blij wrote: > > One thing I miss in OO

[users] (Open) Office sounds

2005-09-26 Thread Gert Blij
One thing I miss in OOo vs. MS Office is feedback with sound. MS Office had an extension called officesounds.exe Is there a similar extension somewhere for OOo. TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additiona

RE: [users] Dialog printing, "Show fields option is checked, Do you want to print ..."

2005-09-26 Thread Gert Blij
> -Original Message- > From: DT [mailto:[EMAIL PROTECTED] > Sent: Fri 23 September 2005 05:37 PM > To: users@openoffice.org > Subject: Re: [users] Dialog printing, "Show fields option is > checked, Do you want to print ..." > > David Teague(T-bird acct) wrote: > > > > > > OO.o Build

[users] Vertical align text in a callout box

2005-09-23 Thread Gert Blij
Is it possible to vertically centre text in callout box? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Group picture with call out boxes??

2005-09-21 Thread Gert Blij
OOo Beta 2 128 on Win XP I inserted a picture and created two call out boxes pointing to positions in that picture. Now I want to group these 3 objects. I can Ctl click on the two call out boxes and group them, but Ctl clicking on the two call out boxes and then on the picture has no effect on th

[users] New Beta 2 (1.9.130) - CAREFUL!!!!!

2005-09-19 Thread Gert Blij
Careful with this new beta. First time I used Calc it, out of nowhere, gave a msg that it was looking for the C runtime library to close Calc. It then closed Calc without saving any changes. Re-opening the spreadsheet did not recover it. Not nice, but OTOH this is the first time in many month that

[users] RE: Query in Base

2005-09-19 Thread Gert Blij
> -Original Message- > From: Fred Frazelle [mailto:[EMAIL PROTECTED] > Sent: Sun 18 September 2005 11:47 PM > To: users@openoffice.org > Subject: Query in Base > > www.fundacionanisa.org > > Does anybody know how to create a one to many query based o

[users] Where is the Knowledgebase?

2005-09-15 Thread Gert Blij
Is the Knowledgebase of the air? http://mindmeld.cybersite.com.au/ Gives: Bad Gateway The following error occurred: The requested address is not valid in its context. Cheers Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] F

[users] RE: Drag & Drop in OOo

2005-09-15 Thread Gert Blij
> -Original Message- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Wed 14 September 2005 08:09 PM > To: users@openoffice.org > Subject: Re: [users] Drag & Drop in OOo Text > > On Wed, 2005-09-14 at 18:01 +0100, Robert Pender wrote: > > Is it possible to drag and drop

[users] RE: import data on ooo2.0 base

2005-09-08 Thread Gert Blij
> hy, is the first time i write on this list, i'm italian so > please sorry my poor english No worry, I am Dutch and I could understand you, so your English is quite ok :-) > i would like to know how to > import data,( saved in a format like csv or spreadsheet or > sylk or tab separated value

[users] "Filter by form" stopped working. Form Filter toolbar gone???

2005-09-07 Thread Gert Blij
I had set up a form and was searching for records using "Filter by Form". It worked beautifully for quite a while. Then all of a sudden it stopped working. I can click on the Filter by Form icon and enter a filter criteria, but the Form Filter toolbar is not there anymore (that's the one with the

RE: [users] mail-merge by e-mail: How to activate?

2005-09-06 Thread Gert Blij
Thanks Roderick, > -Original Message- > From: G. Roderick Singleton > Sent: Mon 05 September 2005 06:11 > To: OOUsers List > Cc: [EMAIL PROTECTED] > Subject: RE: [users] mail-merge by e-mail: How to activate? > > On Mon, 2005-09-05 at 13:09 +0200, Gert Blij wr

RE: [users] mail-merge by e-mail: How to activate?

2005-09-05 Thread Gert Blij
> Subject: Re: [users] mail-merge by e-mail: How to activate? > > > Since you like experimenting with pre-releases, please see > http://www.openoffice.org/issues/show_bug.cgi?id=51638 for a > possible solution. Is there a way to get this to work for Ooo for Windows? TIA Gert --

[users] Apologies: RE: [dba-users] The Row Holding the Maximum of a Certain Column

2005-08-31 Thread Gert Blij
Apologies to the list. Finger trouble caused this to go to the general list iso the dba-users. Gert > -Original Message- > From: Gert Blij [mailto:[EMAIL PROTECTED] > Sent: Tue 30 August 2005 04:51 > To: 'Alex Thurgood' > Cc: OpenOffice > Subject: RE: [db

[users] Show field commands option

2005-08-29 Thread Gert Blij
When printing a document I often gat the message: "Show field commands option is checked". Where can I uncheck it? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Edit a report

2005-08-19 Thread Gert Blij
OOo 2.0,122, Base on a MySQL db. I am a total newbie to Reports and am completely stuck. I want to report on a Base query that produces: CatNo, CatDesc, ItemNo, Price There is a one to many relationship by CatNo to ItemNo I want the report to look like this: CatNo 1, Description1 Item No P

[users] How to move fields around in Reports

2005-08-19 Thread Gert Blij
OOo 2.0,122, Base on a MySQL db. I have created a report with the Report Wizard on a Base query. 1 - How can I move the headings around? 2 - How can I move the field content around? 3 - Is it possible to move a line field into a group header? 4 - Can I add fields that are in the query, but were

[users] Create a report without the wizard

2005-08-19 Thread Gert Blij
Ooo 2.0, 122 Base on a MySQL db. I understand that it is possible to create a report without the wizard. I go into Writer and open a database as a data source. I can now drag and drop the row headings (column names) into the work space and they appear there is field codes. What do I need to do

RE: [users] Search in a Base form

2005-08-06 Thread Gert Blij
s. Cheers Gert > -Original Message- > From: Dan Lewis [mailto:[EMAIL PROTECTED] > Sent: Fri 05 August 2005 07:18 PM > To: users@openoffice.org > Subject: Re: [users] Search in a Base form > > On Friday 05 August 2005 09:43 am, Gert Blij wrote: > > How do I

[users] RE: 1.9.122 under Windows: UI very slow

2005-08-05 Thread Gert Blij
I am also using 122 and it is definitely not slower than any of the previous versions. If anything it's faster and very usable (I suspect a lot of debug code has been dumped). Don't file a bug. I supect your problem to be local. Cheers Gert > -Original Message- > From: Severin Greimel

[users] Search in a Base form

2005-08-05 Thread Gert Blij
How do I search in a Base form. Say it opens at the first number in the table 100. How do I "jump" to number 199. TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Base form for changing data??

2005-08-05 Thread Gert Blij
I have created and saved a form in Base. Now whenever I open it, it opens in Read Only Mode. How do I open (or create) a form that allows me to change data. TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

RE: [users] Problem with number outline in Word

2005-08-05 Thread Gert Blij
I have found that Outline Numbering is very sensitive to the settings in the Numbering Style dropdown box in the various styles a paragraph is subject to. If you use Outline Numbering, make sure the both the relevant Heading style and the paragraph style have the Numbering Style set to "None". Ch

[users] Base and forms??

2005-08-03 Thread Gert Blij
Anyone know whether ther is any doumentation, tutorial, etc. that explains how to edit a form for a table in a database? FE: 1 - In design mode I can't find how to add a Table or fields 2 - Having created a form using the wizard I can only see the first caracter of a 6 digit field and can't work

[users] Filter unique records in Base

2005-08-02 Thread Gert Blij
I want to filter out duplicate records based on a field, or multiple fields in the table. How can I do that. Example: I have an address table with the fields Address1 and Address2. To prevent duplicating to family members, I need and extraction, or an update into a new table, that filters out all

[users] Re-opening a database opens in Read Only mode

2005-08-02 Thread Gert Blij
I created and populated a database. I closed it. Now when I open it again I cant edit anything, no tables, no query, nothing. All options in the top left pane are greyed out and dead. How do I open a database in Edit mode? TIA Gert ---

[users] SQL statements other than Select

2005-08-02 Thread Gert Blij
The HSQLDB documentation says it supports the Update statement, but how do I generate one in OOo Base? When I write one in the SQL syntax, rather than using the Wizard where I can't find any reference to Update, it won't run with an error message that says "This is not a select statement". TIA Ge

[users] Multiple field index for Base

2005-08-02 Thread Gert Blij
How does one create a multiple field index in Base? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Create relationship in Base

2005-07-29 Thread Gert Blij
How do I create relationships in Base? Somewhere is mentioned to use Edit | Database | Advanced Settings, but the latter is greyed out, as are Properties and Connection Type. So how do I activate these options? TIA Gert - To uns

RE: [users] Multiply 2 fields in Base Query

2005-07-29 Thread Gert Blij
t; To: users@openoffice.org > Subject: Re: [users] Multiply 2 fields in Base Query > > Bottom post > > G. Roderick Singleton wrote: > > >On Thu, 2005-07-28 at 12:50 +0200, Gert Blij wrote: > > > > > >>Is it possible to multiply 2 fields in a query? > &

[users] How to edit an existing database

2005-07-28 Thread Gert Blij
I created a database with some tables and queries and closed it. Now when I open the database all edit options are greyed out. All I can do is open the tables and run the queries, but I can't edit them. The KB says that this "normal behavious at present". Can that be true? Because that would rende

RE: [users] Multiply 2 fields in Base Query

2005-07-28 Thread Gert Blij
July 2005 01:23 > To: [EMAIL PROTECTED] > Cc: OpenOffice > Subject: Re: [users] Multiply 2 fields in Base Query > > On Thu, 2005-07-28 at 12:50 +0200, Gert Blij wrote: > > Is it possible to multiply 2 fields in a query? > > > > FE, I have three fields, ItemNo, Qty a

[users] Multiply 2 fields in Base Query

2005-07-28 Thread Gert Blij
Is it possible to multiply 2 fields in a query? FE, I have three fields, ItemNo, Qty and Price which I query, but I want to display the extended price as well. In Access the syntax is [Qty]*[Price] TIA Gert - To unsubscribe, e-

RE: [users] Tab character in Table of Contents

2005-07-27 Thread Gert Blij
age- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Tue 26 July 2005 03:07 > To: [EMAIL PROTECTED] > Cc: OpenOffice > Subject: Re: [users] Tab character in Table of Contents > > On Tue, 2005-07-26 at 13:03 +0200, Gert Blij wrote: > > I am using 2.0.

RE: [users] Table of Contents, no spave between Chapter number and Title text

2005-07-27 Thread Gert Blij
esday 26 July 2005 11:59, Gert Blij wrote: > > Using 2.0, when I insert a TOC it generates as: > > > > 1Chapter 1 > > 1.1Chapter 1.1 > > 1.2Chapter 1.2 > > > > I.e. without a space between the chapter no and the chapter > title text. > &g

[users] Table of Contents, no spave between Chapter number and Title text

2005-07-26 Thread Gert Blij
Using 2.0, when I insert a TOC it generates as: 1Chapter 1 1.1Chapter 1.1 1.2Chapter 1.2 I.e. without a space between the chapter no and the chapter title text. How can I include a space? TIA Gert - To unsubsc

[users] Tab character in Table of Contents

2005-07-26 Thread Gert Blij
I am using 2.0. According to the documentation it is possible in a Table of Contents to change the fill character between the Title text and the page number on the right from . to - or or nothing. (Stylist | Content * | Tab | Fill character), however no matter what I change it to, it k

[users] Outline numbering for headers

2005-07-22 Thread Gert Blij
What is the most elegant way to set up outline numbering for headers. What I want to achieve is" 1 Heading 1 1.1 Heading 2 1.1.1 Heading 3 I got something going, but it was an incredibly complex hack using Tools | Outline Numbering and the Stylist for the Heading 1-3 Paragraph and L

[users] Styles don't migrate to a Master Document

2005-07-22 Thread Gert Blij
According to the manual all styles in a sub-ducument are migrated to a master document on insert of the sub-document. However, when I insert a sub-document I loose all the outline numbering for my headers (levels 1 to 3). Also, using the stylist in the master document to re-create the styles as pe

[users] How to reset a page number to 1

2005-07-22 Thread Gert Blij
I have a header page without a header and footer, then on the next page I introduce the header and footer and through Insert | Field | Pagenumber put a page number in the footer. However this page number now shows as 2. Where do I reset it back to 1? TIA Gert ---

RE: [users] Applying styles

2005-07-22 Thread Gert Blij
enoffice.org > Subject: Re: [users] Applying styles > > Gert Blij wrote: > > I am slowly beginning to understand the concept of OOo > styles and I am > > loving it. > > > > However, why do style changes sometimes get applied as I am making > > chang

[users] Applying styles

2005-07-20 Thread Gert Blij
I am slowly beginning to understand the concept of OOo styles and I am loving it. However, why do style changes sometimes get applied as I am making changes to a style in the Stylist and other times I have to physically apply the style to a paragraph for changes to take effect? TIA Gert ---

RE: [users] Title case

2005-07-19 Thread Gert Blij
; On Tuesday, July 19, 2005 5:12 AM Gert Blij [mailto:[EMAIL PROTECTED] > wrote: > > Subject: [users] Title case > > > In Format|Change Case I only see Upper and Lower Case. > > > > Is there a way to change to Title Case? > > > > TIA > > Gert > >

[users] Title case

2005-07-19 Thread Gert Blij
In Format|Change Case I only see Upper and Lower Case. Is there a way to change to Title Case? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [users] Mail merge wizard alternative?

2005-07-19 Thread Gert Blij
[EMAIL PROTECTED] > Sent: Mon 18 July 2005 10:35 > To: users@openoffice.org > Subject: Re: [users] Mail merge wizard alternative? > > Gert Blij wrote: > > Is there and alternative to the Mail Merge Wizard for mail merging > > (like the Mail Merge tool bar in Office)?

[users] Mail merge wizard alternative?

2005-07-15 Thread Gert Blij
Is there and alternative to the Mail Merge Wizard for mail merging (like the Mail Merge tool bar in Office)? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Javamail for OpenOffice

2005-07-14 Thread Gert Blij
To do an email merge OOo advises that I need Javamail. I have downloaded Javamail 1.3.2, but I can't find any installation instructions for XP. Anyone know how to do this? TIA Gert Blij - To unsubscribe, e-mail: [

[users] Named cell ranges won't delete

2005-07-14 Thread Gert Blij
I had named a few cell ranges. In Data|Define Ranges I delete all of them, however, the Source Data Range drop down box in the Consolidate function still shows them. Even to the extent that when I add them again In Define Ranges, they now show twice in Consolidate. What am I doing wrong? TIA Ge

[users] Skip blank fields in mail merge

2005-07-11 Thread Gert Blij
I merge 6 fields. The fourth and fifth are often blank. They all print on separate lines. Is it possible to *not* to pront these blank lines? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[users] Trend line in charts

2005-07-07 Thread Gert Blij
How do I add a trend line to a chart in 2.0. The Help for Calc has a link for Trend lines but the text beneath the link doesn't mention it. TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [

[users] UK Thesaurus

2005-07-06 Thread Gert Blij
The distribution of the 2.0 Beta so far only includes a thesaurus for English US. Anyone know if there is one out there for English UK? (En terwijl we hiermee bezig zijn, bestaat er een voor Nederlands?) TIA Gert - To unsubscri

[users] IF statement with "Blank Cell" condition

2005-06-30 Thread Gert Blij
How can I create an IF statement that says: If a cell is blank (null (?)) do something else do something else. TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Line spacing in Impress

2005-05-19 Thread Gert Blij
Even the "Single Line" spacing in Impress is quite large. Is there a way to get the lines closer together? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Editing labels

2005-05-19 Thread Gert Blij
Once I have set up a label page through File | New | Labels, is it possible to edit the setup. So far all I found is to close and discard the page and restart through File | New | Labels and edit there. TIA Gert - To unsubscribe

[users] Printing Form Letters question

2005-05-19 Thread Gert Blij
To get labels to print the data from the data source, you need to anser yes to the question "Is this a Form Letter". However there is a tick box that says "Do not ask this question" again, which, when ticked, indeed does not ask the question again, but assumes the answer to be "No", causing the l

[users] Default paragraph numbering formatting

2005-05-10 Thread Gert Blij
I set my Default paragraph to the List 1 numbering style. But no matter how I change the List 1 numbering style in Styles and Formatting (F11), nothing changes. What am I doing wrong? TIA Gert - To unsubscribe, e-mail: [EMAIL PR

[users] Move user settings to later version

2005-05-10 Thread Gert Blij
When I upgrade from one build to the next, which files do I need to transfer from the c:\Program File\OpenOffice.org 1.9.* hierarchy to keep the settings I set in Tools|Options? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTE

[users] Latest Beta - Sections of documents missed by spell checker???

2005-04-26 Thread Gert Blij
What could cause a section in a document to be completely skipped by spell checker? Words both before and after the particular section are checked fine. Words typed in or added to the section are all missed by spell checker. TIA Gert -

[users] Change standard number format (more info)

2005-04-22 Thread Gert Blij
The standard number format I meant is the one in Calc that in the number formatting table is called "Standard". I would like the "Standard" format to be -#,##0.00, can I do that? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTEC

[users] Beta 2.0 - Change standard number format

2005-04-21 Thread Gert Blij
Is it possible to change standard number format. TIA Gert Blij - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Convert alpha to numeric (Ooo Beta 2)

2005-04-12 Thread Gert Blij
How do I convert a range of alpha cell contents (i.e. a numeric value preceded by ' (single quote)) to numerics. In Excell the trick was to put a 1 in an empty cell and copy it. Then highlight the range of cells to be converted and Paste Special|Multiply. TIA Gert --

[users] Beta 2.0 - How to delete a database

2005-04-05 Thread Gert Blij
Testing Beta 2 I created a database in MySQL and linked it to Base. It all worked fine. Then I deleted the database in MySQL, but now whenever I log in, Openoffice is "successfully" restoring the database. When I go into base it is still there. The database is not registered. How can I get rid of

[users] Base query does not see table colums (2.0 Beta)

2005-04-01 Thread Gert Blij
In Base I open a MySQL database. When I start the query editor I do not see any column name, all I see is the * (for "all" colums). Any suggestions? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[users] Beta 2.0 - Change fonts in chart axis

2005-03-17 Thread Gert Blij
Is it possible to change the fonts in a chart's axis? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Beta 2.0 - Mofify data range in chart

2005-03-17 Thread Gert Blij
In MS Office it is possible to click on a chart, which then show the data ranges in the sheet. These data ranges can then be changed by dragging the edges of the colored borders around the data ranges. In Calc, I can see the ranges, but somehow can't seem to "grab" the borders. Is there a way to

[users] Beta 2.0 - Calc - Header Fonts

2005-03-15 Thread Gert Blij
Where can I set the fornts for the header and footer that Calc prints? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Moving data labels in charts

2005-03-10 Thread Gert Blij
Often data labels for line charts are placed in such a way that they are obscured by the line. In MS Office I could move individual data labels. Is this possible in OOo Calc. (I am using 2.0 Beta) TIA Gert - To unsubscribe, e-

[users] 2.0 Beta - Crash reporting after recovery crashes

2005-03-09 Thread Gert Blij
When a 2.0 beta crashes an application, the recovery process works well. AT the end of this process one can choose to send an error report to the developers, which is great of course. But my Windows XP comes up with a crash message that says that "crashrep.exe" crashed. Where do I take this proble

RE: [users] reinstalling spellcheckers

2005-03-08 Thread Gert Blij
Is it correct that this does not work properly under 2.0 Beta. I had it going beautifully and then it just went haywire. I have now uninstalled all but one dictionary and the works a little bit. Another problem that remains is that it seems one can spell check any one document only *once* and afte

[users] Euro symbol

2005-03-07 Thread Gert Blij
I am in South Africa, i.e. outside the Euro zone. I use 2.0 Beta. I can see the US dollar, pound and yen symbols in the Special Character table, but not the Euro symbol. Does it exist anywhere? TIA Gert - To unsubscribe, e-mail