Re: [users] style organizer in separate window?

2008-04-15 Thread Brian Barker

At 23:05 14/04/2008 -0400, Kenn Goutal wrote:
Perhaps my memory is faulty, but I thought *sure* that OO.o writer 
used to have a way to bring up the style organizer in a separate 
window. Did it?


I cannot find a way to do this at this time -- whenever I bring it 
up, it always shows up as a sort of sidebar to the main text window.


I can minimize is to that it takes up nearly no room at all, but if 
I want to use it, it uses up maybe 2 of the width of the window. 
(Give or take, depending on how I resize it, but 2 is about the 
minimum necessary.)


I looked in the help menu, but it just told me how to start the 
style organizer such that it comes up in that same fashion.


Am I missing something obvious?


I'm not sure I would call this obvious, in fact.  The way to dock 
such a window (and what you presumably must have done by mistake) is 
to double-click a vacant area (or, in this case, the grey area around 
the icons) whilst holding down Ctrl.  Apart from dragging a docked 
window back off the edge (as has been suggested), you can 
alternatively repeat Ctrl plus double-click to undock a window.


Two more things:

o  How are you minimising this window?  You may be just dragging the 
boundary, in which case you need to drag it again to get it back so 
that the window is useful.  But there is a Hide/Show button at the 
centre of the window edge, with which you can quickly hide or reveal 
the side window.


o  And here's another trick that you may find useful: try hiding the 
window with the button but then clicking on the just-visible window 
edge somewhere *other than* on the button.  This also shows the 
window again - but there is a difference.  Now, once you have done 
whatever you need to do in the side window and return to (and click 
in) the main window, the side window hides automatically.  This could 
be a convenient way of having the side window easily available but 
not obscuring your text whilst you are working.


Oh, and all this applies to the Navigator window, too - or even to 
both at once.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: OOXML

2008-04-15 Thread Urbane Tiger
On Mon, 14 Apr 2008 21:33:52 -0400, James Knott
[EMAIL PROTECTED] wrote:

Urbane Tiger wrote:
 Now that OOXML has been accepted by the ISO as a standard can we
 expect OOo will adopt it its the preferred format.

 Please no rants - there are plenty of soapboxes that are very much
 more visble to the world at large than is this mailing list.

   

This is no rant, but anyone who knows anything about OOXML would never 
suggest such a thing.  From a technical perspective, it's an absolute 
disaster, the sole purpose of which, is to further MS lockin.

Same goes for USB v Firewire.  Can you buy a 500G WD Firewire hard
disk at the Post Office for $AU179 -- no.  Can you buy a 500G WD USB
hard disk at the Post Office for $AU179 -- yes.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: OOXML

2008-04-15 Thread Urbane Tiger
On Tue, 15 Apr 2008 16:27:39 +1200, Michael Adams
[EMAIL PROTECTED] wrote:

On Tue, 15 Apr 2008 09:06:20 +1000
Urbane Tiger wrote:

 Now that OOXML has been accepted by the ISO as a standard can we
 expect OOo will adopt it its the preferred format.
 
 Please no rants - there are plenty of soapboxes that are very much
 more visble to the world at large than is this mailing list.
 

Actually if you knew the issues you would know how stupid this question
really is.
 * ISO accreditation will put OOXML on a par with ODF, not above it.
 * ISO accreditation for OOXML is not finalised.
 * OOXML is not finalised.
 * Office 2007 XML (.docx etc.) is not OOXML.
 * The Default format in OO.o can be set by the user.
 * Sun, the developers, many governments and most OO.o users see ODF as
a better format for Office files.

Micheal everything you say is true, and I am in accordance with your
sympathies, but its not a perfect world.

Most contributors to this forum live in democratic, capitalist
societies; Churchill said something like - it maybe a lousy system but
its the best we have.  If you don't believe it read Under Two
Dictators: Prisoner of Stalin and Hitler by Margarete Buber-Neumann,
or ask a Tibetan and an Iranian.  

As for which is best I have already drawn attention to Firewire  v
USB, where the Intel backed USB won the day.

But take heart, back in the 80's we had Token Ring v Ethernet, TR was
a far superior technology.  I just did a shopping engine search - 500+
ethernet adapters, 0 token ring adapters.  Who was the major backer of
TR, IBM, on that occasion the minnows, Xerox-Parc  DEC, won.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Re: OOXML

2008-04-15 Thread Ganesha Bhaskara



Urbane Tiger wrote:

On Mon, 14 Apr 2008 20:30:22 -0700, Ganesha Bhaskara
[EMAIL PROTECTED] wrote:



Urbane Tiger wrote:

Now that OOXML has been accepted by the ISO as a standard can we
expect OOo will adopt it its the preferred format.
I hope OOo does NOT do it. I would be extremely cautious about OOXML as 
I do not trust Microsoft to play fair.


That said, OO 3.0 will support import and export to OOXML.



Please no rants - there are plenty of soapboxes that are very much
more visble to the world at large than is this mailing list.

I resisted from starting the reply with MUWHAHAHAHAHA.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Ganesha, Do you really mean Import  Export a'la PDF; or do you mean
Open  Save.

Open and Save . check out pre-beta version of OO 3.0.
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: OOXML

2008-04-15 Thread Urbane Tiger
On Mon, 14 Apr 2008 20:30:22 -0700, Ganesha Bhaskara
[EMAIL PROTECTED] wrote:



Urbane Tiger wrote:
 Now that OOXML has been accepted by the ISO as a standard can we
 expect OOo will adopt it its the preferred format.

I hope OOo does NOT do it. I would be extremely cautious about OOXML as 
I do not trust Microsoft to play fair.

That said, OO 3.0 will support import and export to OOXML.


 
 Please no rants - there are plenty of soapboxes that are very much
 more visble to the world at large than is this mailing list.

I resisted from starting the reply with MUWHAHAHAHAHA.

 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 

Ganesha, Do you really mean Import  Export a'la PDF; or do you mean
Open  Save.
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Re: OOXML

2008-04-15 Thread Harold Fuchs
On 15/04/2008, Ganesha Bhaskara [EMAIL PROTECTED] wrote:

snip


Ganesha, Do you really mean Import  Export a'la PDF; or do you mean
  Open  Save.
 
 Open and Save . check out pre-beta version of OO 3.0.


I've read stuff that *suggests* that OOo 3.0 will be able to read .docx etc.
files but *not* save them. Is this true or have I been reading the wrong
stuff?  Would someone point me at some sort of official feature list,
please?



-- 
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org


[users] [moderated]

2008-04-15 Thread Michel Godron
Bonjour,

Openoffice s'est planté sans que je comprenne pourquoi : lorsque je clique 2 
fois sur le nom d'un fichier .odt, le voyant du disque dur s'allume pendant 
quelques secondes, mais rien ne s'affiche sur l'écran.

J'ai essayé de charger la version la plus récente d'Openoffice par Internet : 
l'assistant d'installation me demande environ 35 minutes pour copier les 
fichiers, puis il me dit de cliquer sur Terminer mais, après quelques 
minutes, l'indicateur d'avancement se bloque aux 3/4 de son parcours et tout 
s'arrête.

Pourrez-vous accuser réception de ce message dès qu'il sera lu, même si vous ne 
pouvez pas répondre immédiatement.
Merci

[users] Re: I am using the 3.0 Mac alpha version of Open office and, unlike the Windows version, it is NOT compatible with LULU self publishing web site

2008-04-15 Thread William Hale
When I converted a simple text file from Open Office using only English
fonts, to PDF and uploaded it, LULU so far has indicated it has been
accepted.

On Sun, Apr 13, 2008 at 7:19 PM, William Hale [EMAIL PROTECTED] wrote:

 [image: Chat Information]Welcome to Lulu.com! An online representative
 will be with you shortly. Your wait time will be approximately 0 minute(s)
 and 2 seconds. Thank you for waiting.

 [image: Chat Information]You are now chatting with 'Shane A'

 Shane A: Welcome to Lulu.  How can I help you today?

 [EMAIL PROTECTED]: I uploaded a test file, but evidently some it cannot
 be converted. Is that rights?
 ...

 Shane A: I have checked your file and you have uploaded a file which is
 not supported by Lulu.

 Shane A: Here is a list of all supported file types:

 Shane A: http://www.lulu.com/help/index.php?fSymbol=upload_filetypes

 [EMAIL PROTECTED]: OK, but that's weird, because LULU recommends the
 Open Office software. Maybe because I downloaded the beta 3.0 version for
 Macs???

 Shane A: Yes, that may cause the problem.

 [EMAIL PROTECTED]: Yeah, OPEN office IS in the list of supported file
 formats [thn] but LULU may still only be compatible with the WINDOWS
 versions of open office, because the Mac ersion is new?

 [EMAIL PROTECTED]: So, should I contat the Open Office people and let
 them know? Would you do that too?

 Shane A: I'm sorry I can' t to that. You can let them know.

 [EMAIL PROTECTED]: So I guess Parallels.com and Open office for windows
 should work then.

 [EMAIL PROTECTED]: Sorry you can't let them know. But I will.

 Shane A: Yes, that is correct.

 [EMAIL PROTECTED]: Can THEY [thn] contact YOU about the issue?

 Shane A: I'm afraid they can't because we don't have any phone support.

 [EMAIL PROTECTED]: OK, well they probably know you all through the
 grape vine and prayer lines anyway...

 [EMAIL PROTECTED]: Mac users sure are out in the cold, eh?

 [EMAIL PROTECTED]: I'll let Apple know too.

 Shane A: Ok.

 [EMAIL PROTECTED]: OK, thanks for being kind about it. I really want to
 use your system a lot.

 [EMAIL PROTECTED]: Thanks again. Good night. Good luck, and feel free
 to let me know if things change.

 Shane A: You're welcome

 Shane A: My pleasure to help you!

 Shane A: Thank you for using Live Chat! If you find that you need
 additional assistance, please refer to our Help Knowledge Base.

 Shane A: http://www.lulu.com/help/

 Shane A: Have a good one!



Re: [users] TOC entries and links

2008-04-15 Thread Uwe Fischer

Hi,

Twayne wrote:

 Hi,

OOo 2.4.0 on XP Pro SP2+:

This one is probably my own fault but I haven't done anything knowingly 
to cause it.  I recently switched from 2.3 to 2.4 so I'm not sure 
whether it ever worked in the 2.4 version I have.


Problem:
TOC does not include links to the page they reference.

Tried:
Help, and the LE/ES (or whatever it was) settings and clicking to 
set ALL.  Followed instructions as perfectly as I could; no help, so it 
would appear I'm missing something.



You can apply the LS (Link Start) and LE (Link End) entries to the TOC 
levels 1 to 10. There is no ALL entry.

If you see an ALL entry in the Levels box, something is messed up.



1.  HOW do I get the TOC to include links?
   Please, don't just copy the Help paragraphs here; I've read them over 
and over without getting the links to work.  Layman's terms please? 
Some of that Help is a little confusing so I'm probably misnterpreting 
something.  I'm not new to Word or to Writer so you needn't assume I'm a 
complete newbie either.



please explain what confuses you, so we can find a better help text.




And, these further questions arose from that effort:

2.  Is there a way to RESET *everything* in Writer,  or even the entire 
OOo?  Remove/reinstall doesn't seem to accomplish that.
Either would be OK with me as I still have 2.3 installed and 
functional.  I'm just getting 2.4 set up so don't mind starting over 
from scratch.  Oh, and yes, I removed 2.3 also when I reinstalled 2.4, 
just in case there was something clnflicting.




please see the OpenOffice.org Tips 'n' Tricks blog entry Starting over 
with a clean installation 
http://blogs.sun.com/oootnt/entry/starting_over_with_a_clean

There you find steps and an explanation.

Uwe
--
  [EMAIL PROTECTED]  -  Technical Writer
  StarOffice - Sun Microsystems, Inc. - Hamburg, Germany
  http://wiki.services.openoffice.org/wiki/Documentation
  http://user.services.openoffice.org/en/forum
  http://blogs.sun.com/oootnt


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] I need to convert an e-mail attachment

2008-04-15 Thread David Zehr
How do I convert an open office document to a format that my clients can
open  read with microsoft word.


[users] [moderated] YOU MUST GIVE A SUMMARY HERE latest version of open office 2.4.... cannot even read the support info as it comes up microsoft word trial (2007)

2008-04-15 Thread Catherine Hicks
all support info is coming up microsoft office...trial. unable to read any 
of it

also i was under the impression that openoffice would read microsoft office 
files

thank you for any assistance you can give me..

cathie

[users] Re: Re: Weird numerotation (top/bottom)

2008-04-15 Thread Michelle Konzack
Am 2008-04-12 01:59:33, schrieb Harold Fuchs:
 Motion seconded. If I get 3 spams in a day to this email account it's a 
 lot. And Googlemail filters them out *very* effectively.

I have already tried Google, but get to high False-Positives.

And of course, since I am working for the french military, I can not
use Google Legal since its indexing stuff is definitivly spionage.

And since Goolge give it self the right to do whit this data what they
want, it is definitivly NO OPTION.

Thanks, Greetings and nice Day
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
# Debian GNU/Linux Consultant #
Michelle Konzack   Apt. 917  ICQ #328449886
+49/177/935194750, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France   IRC #Debian (irc.icq.com)


signature.pgp
Description: Digital signature


Re: [users] OR and AND in regular expressions

2008-04-15 Thread Régis POTELLE
Thank you again for your help. But I think I can fix my problem without AND
for the moment, after all. I'll remember your trick, however

kindest regards


2008/4/13, Harold Fuchs [EMAIL PROTECTED]:

 On 12/04/2008 17:31, Régis POTELLE wrote:

  Thank you for your quick answer. Using OR as you tell me may be
  helpfull.
  For the AND, I'll see later
 
  kindest regards
 
 
 
 
 In fact I just thought of a way to do AND but the solution is based on a
 facility in Writer which may or may not exist in other word processors. As
 an example, assume you want to find lines containing a and b and c but
 in any order:
 1. Find, using Regular Expressions, .*a.*. Use Find All. This will
 highlight all the lines containing an a.
 2. Select Currently selection only and Find All .*b.*. This will leave
 highlighted all the lines containing a and b in either order.
 3. Keep Current selection only ticked (checked) and Find All .*c.*.
 Done. Only lines with a and b and c, in any order, will remain
 highlighted.

 The problem with this method is that, while it will find abc or bac
  or bca or ..., it will also find aqwercghjkb which has an a, a b
 and a c within it. This may not be what you want ...

 The RE .*a.* means any number of any character followed by an a
 followed by any number of any character. Here any number includes zero. Of
 course the a being found can be replaced by any string/RE.

 snip


 --
 Harold Fuchs
 London, England
 Please reply *only* to users@openoffice.org





[users] Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread solveig
Hi,

Does anyone know of an extension or macro or other feature that would allow a 
user to set up just the names and reporting relationships of an organization, 
then generate an org chart? It can of course be done in Draw with connector 
lines but when the number of names increases, it's more work to do all the 
box-drawing.

I guess it could be an add-on for OpenOffice.org or another open source type 
product, as long as the result is usable in an OpenOffice.org document.

Btw, followup on the last question--I was wrong. Word doesn't have the ability 
to leave change bars on when accepting changes, according to my class. I got 
the wrong impression from one of the students.

Thanks,
Solveig
~
[EMAIL PROTECTED]

Training, Consulting, and Learning Materials 
for OpenOffice.org and StarOffice

http://www.getopenoffice.org
http://openoffice.blogs.com

Making the Right Decision Easy

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Component questions

2008-04-15 Thread Sterling Nichols

I was wondering which component of OpenOffice.org is the equivalent of 
Microsoft Access (for those who don't have MS Access on their computer).
 
I would also like to know which component of OpenOffice is used as the 
equivalent for XML documents.
 
I don't want to subscribe, I just would like to find out the answers to my 
questions.

[users] OPEN OFFICE.ORG

2008-04-15 Thread warren chadwick
Hi
Came across your excellent product on line because I could not open my excel 
spreadsheet files. Can now open but for some reason the dates of entries have 
been deleted and replaced with xxx. Also when I try to open excel message comes 
up about installing 2000 SR-1Premium. Any advice would be appreciated.

Thanks Warren Chadwick


[users] OpenOffice

2008-04-15 Thread Todd Monson
How does your program work with Mac OS X 5.2? Is the install for X11  
the same?


I need OpenOffice for the database programs for my Masters program. I  
have Mac OS X 10.5.2 Processor 2GHz memory 2GB 667 MHz


Thanks
Dawn Monson

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Forced to install MS office so boss can sync phone, any alternative?

2008-04-15 Thread Ray Bagby

Greetings OOU,

   Last week I had to install MS office for the owner of the shop so he 
can sync

his phone.
   I know OO doesn't have an e-mail client but it's frustrating because 
I had just
about eradicated MS office from the entire business when I lost ground 
because
of the sync the smart phone deal. It was the calendar and tasks sync 
that was most

needed.
   Is there any other alternative? Are the phone manufacturers bowing 
at the alter

of MS or do they have no viable alternative either?

--
Ray Bagby


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Calc question - sorting data.?

2008-04-15 Thread James Elliott - WA Rural Computers
I import my transactions from my Internet Banking account as a *.csv file 
and then open it with OOo Calc  (currently ver 2.4 running under Windows XP 
SP2)


The problem is that I keep my bookkeeping spreadsheets with the earliest 
date at the top of the worksheet and the newest entry at the bottom, but the 
online bank transaction list has the most recent at the top and the oldest 
at the bottom.


No problems - I can sort according to the date column

This worked, except that transactions with the same date (for example you 
could have several transactions on the 3rd March 2008) were not in the same 
order as they appear on the bank list - let me explain with this example:


Bank List Sorted List
04/03/08   $50 02/03/08   $99
03/03/08   $80 03/03/08   $80
03/03/08   $20 03/03/08   $20
03/03/08   $60 03/03/08   $60
02/03/08   $99 04/03/08   $50

As you can see, the dates have sorted into reverse order but the amounts 
have not, when the date is the same for each amount.


No problems, if I add another column and number the transactions 1,2,3,4,5,6 
... etc, and then:

--- do a primary sort on Date, and
--- a secondary sort on transaction number

I can not only sort into DATE order, but also keep the transactions in BANK 
sequence  (which is important if you want the Balance shown on each line of 
my spreadsheet to match the corresponding line balance on the Bank 
transaction list).


All of the above works - SO HERE IS THE REASON I AM POSTING:

If I download 100 transactions it is tedious to type into a spare column:
1
2
3
4
5
6
7
...
...
99
100

So, I used a formula where Cell C76 contained a 1
C77=C76+1  and copied this formula so
C78=C77+1
C79=C78+1
...
etc

Then I sorted first by the DATE column and then by Column C, but I found 
that formulas do not sort in exactly the same way as integer numbers, so I 
have gone back to typing: 1,2,3,4,5,6,7 ... 99,100!


Any suggestions or advice o how to simplifiy and expedite this sorting 
process?


Many thanks,  James


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Unable to open .ods document

2008-04-15 Thread Jerry Jennings
I am using Open Office version 2.4  Attached are screenshots of what happens
when I try to open my spreadsheet. Pic 1 is when I try to open the file from
within Open office and pic 2 is what happen when trying to open it from my
desktop location. I have 2 spreadsheets that this occurs on and 2 other
spreadsheets that open with no problem.

Thank you
Jerry Jennings
[EMAIL PROTECTED]faint_grain.jpg-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] [moderated]

2008-04-15 Thread Roger Higgs
Greetings!

I am wondering if the update is able to open documents with .docx or not.

Thanks you!

Fran

[users] A question about the links on Open Office

2008-04-15 Thread Kathy Fronton

Hello,

I have a question concerning open office impress 2.0.4, i'd like to know 
how can i put a link on an icon to say back to the last view. 
Actually, i want to know if it's possible to put this line of 
programmation language or computer code (i don't know what is the word 
in english) : a href  :  javascript :history.go(-1);.

Thank you in advance for your help.

Sincerely,

Kathy Fronton

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Word and Excel

2008-04-15 Thread mailingwinny
Can I open/use/change/save Word and Excel documents in Open Office? And can
I open/use/change/save Open Office documents in Word and Excel?



[users] Unsubscribing Info

2008-04-15 Thread R M COSGROVE
Several times, I tried to unsubscribe, but was unsuccessful.  
After I added the unsubscribe address to my address book, I 
was able to unsubscribe from users@openoffice.orgmailto:[EMAIL PROTECTED].

Suggest this information be added to your unsubscribe information .

Robert Cosgrove

[users] Re my inquiry ,trouble downloading open office

2008-04-15 Thread Athol
Attention Guy.  Thanks for reply. I use Windows, I am in my 83rd year, just 
learning how to use my Compaq 2007 model.

Received another reply,suggestions how to overcome my problem; one was try to 
purchase the C D of the programme, gave me site for list of suppliers; was 
successful, cost $5.00c delivered. 

I will persist with trying to download programmes, I think I might be a little 
impatient!! 
  Thank you Guy
  Athol ALLPRESS

Re: [users] Re: OOXML

2008-04-15 Thread Uwe Fischer

Hi,

Harold Fuchs wrote:

On 15/04/2008, Ganesha Bhaskara [EMAIL PROTECTED] wrote:

snip


Ganesha, Do you really mean Import  Export a'la PDF; or do you mean

Open  Save.


Open and Save . check out pre-beta version of OO 3.0.



I've read stuff that *suggests* that OOo 3.0 will be able to read .docx etc.
files but *not* save them. Is this true or have I been reading the wrong
stuff?  Would someone point me at some sort of official feature list,
please?


a feature list of planned features for 3.0 is here:
http://wiki.services.openoffice.org/wiki/Features#Planned_Features_for_3.0_Release
There you can read that only import filters are planned for the OOXML 
formats, which makes sense because OOo saves already in an open ISO 
standard format ;-)


Uwe
--
  [EMAIL PROTECTED]  -  Technical Writer
  StarOffice - Sun Microsystems, Inc. - Hamburg, Germany
  http://wiki.services.openoffice.org/wiki/Documentation
  http://user.services.openoffice.org/en/forum
  http://blogs.sun.com/oootnt

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Auto-increment ID in a database

2008-04-15 Thread kafka1

I have created a table containing my music collection by importing an Excel
Spreadsheet. After a lot of trial and error, almost everything is working
fine, however when I create a new record I have to manually enter a number
in the ID (Primary key) field. This is a bit of a nuisance as it means I
have to determine the ID number of the last record. I have done what has
been suggested in another forum, i.e. set the AutoValue for ID to Yes,
however all that happens that a zero is placed in the ID field. It was also
suggested that I set the Auto-increment statement to IDENTITY, however I
don't have that option in Field properties.

I have also typed ALTER TABLE Table1 ALTER COLUMN ID IDENTITY in the SQL
window, but without success. Is there any other way I can have the ID
automatically insert the next number?
-- 
View this message in context: 
http://www.nabble.com/Auto-increment-ID-in-a-database-tp16698582p16698582.html
Sent from the openoffice - users mailing list archive at Nabble.com.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] default fonts again

2008-04-15 Thread [EMAIL PROTECTED]
There appears to be a way to change the default fonts and size of fonts 
for new documents under

Tools | Options | OpenOffice.org Writer | Basic Fonts (Western)

However anything set here appears to be largely ignored even if Current 
document only is not ticked.


Another way that is somewhat more successful is to create a default 
document and then save it as a template
File | Templates | Save | My Templates and give the new template a name 
and click OK.

Then make that template the default template
File | Templates | Organise | select the template under My Templates | 
Commands | Set as default template


However that only works when you create a new file under File | New | 
Text Document


If you go to Windows Explorer (obviously only under Windows - I have no 
idea what the equivalent of this is on Linux or Mac)
and go to File | New | OpenDocument Text to create a new document it 
will not only ignore any settings under Tools | Options | etc but will 
also ignore any default templates.


This would appear to be a significant oversight.

Neil

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Calc question - sorting data.?

2008-04-15 Thread Brian Barker

At 16:41 15/04/2008 +0800, James Elliott wrote:

If I download 100 transactions it is tedious to type into a spare column:
1
2
3
4
5
6
7
...
...
99
100


You are making heavy weather of this.  Spreadsheets are designed to 
make your life easy!


To enter these numbers, either:

o  Enter the number 1 where it is required.
o  Select the relevant cell.
o  Click on the small rectangle at the bottom right of the cell (the 
fill handle) and drag this down the column as required.


or:

o  Select the range of cells that you need filled.
o  Go to Edit | Fill  | Series... .
o  Enter 1 for Start value and press OK.


So, I used a formula where Cell C76 contained a 1
C77=C76+1  and copied this formula so
C78=C77+1
C79=C78+1
...
etc

Then I sorted first by the DATE column and then by Column C, but I 
found that formulas do not sort in exactly the same way as integer 
numbers, [...]


You can also use the fill technique on formulae, of course.  And a 
workaround here would be to copy the block of formulae and then use 
Edit | Paste Special... to paste them back into the same 
cells.  Remove the tick from Paste all, and then make sure that 
Formulas is *not* ticked but Numbers is.  Then you'll have the plain 
numbers that you want in the cells.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] OpenOffice

2008-04-15 Thread Guy Voets
2008/4/15, M Henri Day [EMAIL PROTECTED]:

 
  snip

 Guy, little OT, but do you have any idea when a 64-bit version of the 3.0
 beta will become available ?...


 Henri


That more of a question for the Mac developing team...
I'm just a user of the Mac version.

-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] Spelling checker

2008-04-15 Thread Guy Voets
2008/4/14, mailingwinny [EMAIL PROTECTED]:

 Do I automatically get a spelling checker, when I download Open Office?
 And
 can I choose extra languages? So, if I download the Dutch version of Open
 Office, do I get the Dutch spelling checker and can I also get the English
 one? And how up-to-date is the spelling checker?

 Hello again,

It's good practice to do as you did, post different questions in different
mails. But you are not subscribed to the users list and might not get all
answers provided here.

OpenOffice.org comes with some spell dictionaries included, and you can
install more if you need them. See this tutorial about spell checking:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=67

-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] Word and Excel

2008-04-15 Thread Guy Voets
2008/4/14, mailingwinny [EMAIL PROTECTED]:

 Can I open/use/change/save Word and Excel documents in Open Office? And
 can
 I open/use/change/save Open Office documents in Word and Excel?

 Hello,

OpenOffice.org reads, edits and saves MS Word, Excel, Powerpoint files, but
not yet the new 2007/2008 MS formats (docx, xlsx, ppsx).
MS Word, Excel, Powerpoint doesn't recognise the ISO approved Open Document
Format that are OOo's default file formats (ods, odt, etc.). If you prepare
files in OOo to be read by MS Word etc, you have to save them in the doc,
xls, pps formats

Find all you need to know about OOo at the www.openoffice.org site.
Free download available at all times from http://download.openoffice.org
There's a Dutch language project at OOo: http://nl.openoffice.org

-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] I need to convert an e-mail attachment

2008-04-15 Thread Alan Boba
On Mon, Apr 14, 2008 at 6:50 PM, David Zehr [EMAIL PROTECTED] wrote:

 How do I convert an open office document to a format that my clients can
 open  read with microsoft word.



Several options. The one I've used...

If the file is already created then:
1. open the file in Writer
2. select File  Save As... from the menu
3. open the Save as type: list box in the Save As dialog box
4. select the Microsoft Word 97/2000/XP (*.doc) option
5. make certain the Automatic file name option extension option is ticked
6. click OK

You now have a Word document you can attach to your email.

I'll leave it to others to provide alternatives or, if you wish, you can
also refer to the links below for additional options.
The Writer Guide
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide
Options for loading and saving documents
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Options_for_loading_and_saving_documents
How to send as Word document from Writer's menu
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/E-mailing_Writer_documents


Re: [users] Unable to open .ods document

2008-04-15 Thread Guy Voets
2008/4/14, Jerry Jennings [EMAIL PROTECTED]:

I am using Open Office version 2.4  Attached are screenshots of what
 happens when I try to open my spreadsheet. Pic 1 is when I try to open the
 file from within Open office and pic 2 is what happen when trying to open it
 from my desktop location. I have 2 spreadsheets that this occurs on and 2
 other spreadsheets that open with no problem.

 Thank you
 Jerry Jennings
 [EMAIL PROTECTED]



Hello Jerry,

Pictures usually don't make it to the list, stripped for security and weight
reasons... (unless they're odt, ods ?)
Please try and explain what happens, error messages, etc. You may also make
the files that cause problems available if they're not confidential.

-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] OpenOffice

2008-04-15 Thread Guy Voets
2008/4/15, Todd Monson [EMAIL PROTECTED]:

 How does your program work with Mac OS X 5.2? Is the install for X11 the
 same?

 I need OpenOffice for the database programs for my Masters program. I have
 Mac OS X 10.5.2 Processor 2GHz memory 2GB 667 MHz

 Thanks
 Dawn Monson


Hello,

The Leopard installation (unlike Tiger's previously) includes X11 by
default. Please be sure to update Leopard (now 10.5.3) and X11, since there
were problems with the initial (new) version of X11 on Leopard.

To use Base you will have to use OpenOffice.org 2.4 at least (the English-US
version has passed the tests, other versions are also available, but not
always dependable for 'serious' work).

I'm working with the OOo 3.0.0 Aqua Beta (without X11) and it's doing fine -
but it's still a Beta, so not fully tested.

HTH
-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] OpenOffice

2008-04-15 Thread M Henri Day

 snip
 Hello,

 The Leopard installation (unlike Tiger's previously) includes X11 by
 default. Please be sure to update Leopard (now 10.5.3) and X11, since
 there
 were problems with the initial (new) version of X11 on Leopard.

 To use Base you will have to use OpenOffice.org 2.4 at least (the
 English-US
 version has passed the tests, other versions are also available, but not
 always dependable for 'serious' work).

 I'm working with the OOo 3.0.0 Aqua Beta (without X11) and it's doing fine
 -
 but it's still a Beta, so not fully tested.

 HTH
 --
 Guy
 using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
 and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
 -- please reply only to users@openoffice.org --
 Dodoes can't afford to have headaches


Guy, little OT, but do you have any idea when a 64-bit version of the 3.0
beta will become available ?...

Henri


Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE latest version of open office 2.4.... cannot even read the support info as it comes up microsoft word trial (2007)

2008-04-15 Thread Guy Voets
2008/4/14, Catherine Hicks [EMAIL PROTECTED]:

 all support info is coming up microsoft office...trial. unable to read
 any of it


I don't understand this question. Can you open OpenOffice.org? Can't you
open the Help pages in OpenOffice.org?

also i was under the impression that openoffice would read microsoft office
 files


OpenOffice.org reads, edits and saves MS Word/excel/powerpoint files, unless
they're in the new 2007/2008 format (docx, xlsx, ppsx). Previous versions of
MS Word/Excel /Powerpoint are also excluded from the new lock-in MS
format...
OpenOffice.org 3.0 will be able to work with the docx, xlsx, ppsx format.

thank you for any assistance you can give me..

 cathie


And please, put a summary in the subject of the mail, not half the
message...

Hope this helps
-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] A question about the links on Open Office

2008-04-15 Thread Uwe Fischer

Hi,

Kathy Fronton wrote:

Hello,

I have a question concerning open office impress 2.0.4, i'd like to know 
how can i put a link on an icon to say back to the last view. 
Actually, i want to know if it's possible to put this line of 
programmation language or computer code (i don't know what is the word 
in english) : a href  :  javascript :history.go(-1);.

Thank you in advance for your help.


if you really want to program Impress you should ask at the developer 
mailing list [EMAIL PROTECTED] - see 
http://www.openoffice.org/mail_list.html


if you just want to know how to add an interaction to an object on a 
slide, this is how to do that:


Right-click the object on the slide,
choose Interaction,
select Go to previous slide

Uwe
--
  [EMAIL PROTECTED]  -  Technical Writer
  StarOffice - Sun Microsystems, Inc. - Hamburg, Germany
  http://wiki.services.openoffice.org/wiki/Documentation
  http://user.services.openoffice.org/en/forum
  http://blogs.sun.com/oootnt


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Word and Excel

2008-04-15 Thread James Knott

mailingwinny wrote:

Can I open/use/change/save Word and Excel documents in Open Office? And can
I open/use/change/save Open Office documents in Word and Excel?


  
You can read and write Word  Excel documents in OpenOffice, other than 
the new Office 2007 formats (.DOCX  .XLSX).  Microsoft Office cannot 
open the default ODF file formats, unless you install the Sun ODF 
plugin, which adds ODF support to Microsoft Office.  Otherwise, you'll 
have to save in Word or Excel format, to open files in Microsoft Office.


Sun ODF Plugin:
http://www.sun.com/software/star/odf_plugin


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE latest version of open office 2.4.... cannot even read the support info as it comes up microsoft word trial (2007)

2008-04-15 Thread James Knott

Catherine Hicks wrote:

all support info is coming up microsoft office...trial. unable to read any 
of it

also i was under the impression that openoffice would read microsoft office 
files

thank you for any assistance you can give me..

cathie
  
I assume you bought a new computer, which included a time bombed version 
of Microsoft Office and your documents are now trapped, because the 
trial period expired.  OpenOffice can read  write Microsoft Office 
files, except those created in Office 2007, so it can't read yours.  
What you can do, is install the free Microsoft viewers  compatibility 
pack, which will allow you you read those files or cut  paste the 
contents into OpenOffice.  Please note, installing the viewers will make 
the viewers the default application for Microsoft Office files, so 
you'll have to reset the file associations, using the instructions below.


Word 2007 Viewer and Compatibility Pack:
http://office.microsoft.com/en-us/downloads/CD102258581033.aspx

PowerPoint 2007 Viewer:
http://www.microsoft.com/downloads/details.aspx?familyid=048DC840-14E1-467D-8DCA-19D2A8FD7485displaylang=en

Excel 2003 Viewer and Compatibility Pack:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0displaylang=en


Changing file associations

Right click on file icon
Select Open With  Choose Program...
Check Always use the selected program to open this kind of file and 
choose the desired application.

If that method is not available, follow the directions listed here:
http://support.microsoft.com/kb/307859


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] I need to convert an e-mail attachment

2008-04-15 Thread James Knott

David Zehr wrote:

How do I convert an open office document to a format that my clients can
open  read with microsoft word.

  
OpenOffice, by default, saves in the ISO standard ODF file formats, 
which Microsoft refuses to support.  This means you'll have to save in 
Word format, by selecting it from the drop down list in Save as.  Also, 
ensure automatic file name extension is selected.  Another method is to  
email directly from OpenOffice, by clicking on File  Send  E-mail as 
Microsoft Word.


You can also get your friends to install OpenOffice or the Sun ODF 
plugin, which adds ODF support to Microsoft Office.


Sun ODF Plugin:
http://www.sun.com/software/star/odf_plugin


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] [moderated]

2008-04-15 Thread James Knott

Roger Higgs wrote:

Greetings!

I am wondering if the update is able to open documents with .docx or not.

Thanks you!

Fran
  


Not yet.

--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Component questions

2008-04-15 Thread James Knott

Sterling Nichols wrote:

I was wondering which component of OpenOffice.org is the equivalent of 
Microsoft Access (for those who don't have MS Access on their computer).
 
I would also like to know which component of OpenOffice is used as the equivalent for XML documents.
 
I don't want to subscribe, I just would like to find out the answers to my questions.
  
The OpenOffice equivalent of Access is called Base.  OpenOffice 
already supports the Office 2003 XML format and the native ODF file 
formats are also XML.


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Forced to install MS office so boss can sync phone, any alternative?

2008-04-15 Thread James Knott

Ray Bagby wrote:

Greetings OOU,

   Last week I had to install MS office for the owner of the shop so 
he can sync

his phone.
   I know OO doesn't have an e-mail client but it's frustrating 
because I had just
about eradicated MS office from the entire business when I lost ground 
because
of the sync the smart phone deal. It was the calendar and tasks sync 
that was most

needed.
   Is there any other alternative? Are the phone manufacturers bowing 
at the alter

of MS or do they have no viable alternative either?

Unfortunately, many consider Outlook to be the only email app.  However, 
depending on where the calendar is located, you may be able to use 
Thunderbird  Lightning, both of which can be found at www.mozilla.org.  
I sync my Nokia N800  Thunderbird with Google Calendar.


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Component questions

2008-04-15 Thread Dave Barton

 Original Message 
From: Sterling Nichols [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 12:54:46 EST


I was wondering which component of OpenOffice.org is the equivalent
of Microsoft Access (for those who don't have MS Access on their
computer).


Base is the database component of OOo (OpenOffice.org) which uses the 
HSQLDB engine (see http://hsqldb.org). While Base is not an Access 
clone, it can open Access tables, but it cannot utilize Access queries, 
reports, etc.



I would also like to know which component of OpenOffice is used as
the equivalent for XML documents.


I am not clear in which context you are referring to the equivalent for 
XML documents. Hopefully another list subscriber can answer this for you.



I don't want to subscribe, I just would like to find out the answers
to my questions.


You don't have to, somewhat controversially, this list accepts moderated 
posts from non-subscribed posters. However it is advisable for 
non-subscribed posters to request to be cc'd with any replies.


Hope this helps.

Dave

--
This is a mailing list which exists to support users of OpenOffice.org
All answers are given by other users who volunteer their time.
If you are not subscribed to this mailing list you may not see all the
replies to your query. Please reply to users@openoffice.org only.
You should also be aware that all details of messages posted to this
list are publicly available to anyone with an Internet connection
For mailing list info see: http://www.openoffice.org/mail_list.html
For on-line support see: http://support.openoffice.org/index.html
For a knowledge base see: http://mindmeld.cybersite.com.au/



signature.asc
Description: OpenPGP digital signature


Re: [users] Unable to open .ods document

2008-04-15 Thread Dave Barton

 Original Message 
From: Jerry Jennings [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 07:28:16 EST

I am using Open Office version 2.4  Attached are screenshots of what 
happens when I try to open my spreadsheet. Pic 1 is when I try to open 
the file from within Open office and pic 2 is what happen when trying to 
open it from my desktop location. I have 2 spreadsheets that this occurs 
on and 2 other spreadsheets that open with no problem.
 
Thank you

Jerry Jennings


Sorry Jerry, but for security purpose attachments are normally removed 
from posts to this list, so we did not receive your screen captures and 
are unable to determine the cause of the problem you claim to have.


Can you put them on a web server somewhere and resubmit your question 
with url links to your screen captures. If you don't have your own web 
space you could use one of the many free file hosting services 
available. eg. http://myfreefilehosting.com (no endorsement, just first 
on a quick Google search list).


Hope this helps.

Dave

--
This is a mailing list which exists to support users of OpenOffice.org
All answers are given by other users who volunteer their time.
If you are not subscribed to this mailing list you may not see all the
replies to your query. Please reply to users@openoffice.org only.
You should also be aware that all details of messages posted to this
list are publicly available to anyone with an Internet connection
For mailing list info see: http://www.openoffice.org/mail_list.html
For on-line support see: http://support.openoffice.org/index.html
For a knowledge base see: http://mindmeld.cybersite.com.au/



signature.asc
Description: OpenPGP digital signature


Re: [users] Re: OOXML

2008-04-15 Thread James Knott

Urbane Tiger wrote:

On Tue, 15 Apr 2008 16:27:39 +1200, Michael Adams
[EMAIL PROTECTED] wrote:

  

On Tue, 15 Apr 2008 09:06:20 +1000
Urbane Tiger wrote:



Now that OOXML has been accepted by the ISO as a standard can we
expect OOo will adopt it its the preferred format.

Please no rants - there are plenty of soapboxes that are very much
more visble to the world at large than is this mailing list.

  

Actually if you knew the issues you would know how stupid this question
really is.
* ISO accreditation will put OOXML on a par with ODF, not above it.
* ISO accreditation for OOXML is not finalised.
* OOXML is not finalised.
* Office 2007 XML (.docx etc.) is not OOXML.
* The Default format in OO.o can be set by the user.
* Sun, the developers, many governments and most OO.o users see ODF as
a better format for Office files.



Micheal everything you say is true, and I am in accordance with your
sympathies, but its not a perfect world.

Most contributors to this forum live in democratic, capitalist
societies; Churchill said something like - it maybe a lousy system but
its the best we have.  If you don't believe it read Under Two
Dictators: Prisoner of Stalin and Hitler by Margarete Buber-Neumann,
or ask a Tibetan and an Iranian.  


As for which is best I have already drawn attention to Firewire  v
USB, where the Intel backed USB won the day.

But take heart, back in the 80's we had Token Ring v Ethernet, TR was
a far superior technology.  I just did a shopping engine search - 500+
ethernet adapters, 0 token ring adapters.  Who was the major backer of
TR, IBM, on that occasion the minnows, Xerox-Parc  DEC, won.

  


A huge difference. Neither of those were forced through ISO by blatant 
tampering. There is plenty of evidence of that from around the world, 
such as in Norway where an 80% vote against OOXML suddenly became a yes 
vote or the Swedish committee that admitted to being bought by 
Microsoft. I don't know much about Firewire vs USB, but token ring, 
while an excellent technology, tended to be expensive and lost many of 
it's advantages when ethernet switches became available.


Take some time to study the complaints against OOXML and you'll find 
that in addition to many technical flaws (why does a new file format 
have to maintain a leap year bug in spread sheets?) that it's tightly 
bound to Microsoft Office and Windows, with many vague specs and other 
things, which will make it virtually impossible for anyone other than 
Microsoft to produce truly compliant applications. Then there's the 
issue of patents and Microsoft being very vague about what you can and 
cannot use.


--
Use OpenOffice.org http://www.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Exporting to MS .doc discards page styles?

2008-04-15 Thread Dejan Čabrilo
I have the following problem:

I created a document. For the First Page style, I added a header. On
all other pages, which have the Default style, I don't have a header.

However, when I save it as MS .doc file (or rather, when I use Send
E-mail as Microsoft Word), I get the header on all pages, and the first
page has the Default style (instead of Front Page).

Am I doing something wrong and is there a way around this problem?

Dejan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] OPEN OFFICE.ORG

2008-04-15 Thread Dave Barton

 Original Message 
From: warren chadwick [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 00:04:33 EST

This is an OOo (OpenOffice.org) free support mailing list. Your question 
appears to have nothing to do with OOo and should be addressed to 
Microsoft (for payment), or some other support forum. However, as a 
matter of courtesy I am replying.


Hi Came across your excellent product on line because I could not 
open my excel spreadsheet files. Can now open but for some reason the

dates of entries have been deleted and replaced with xxx.


Are you sure they are being replaced with xxx? If they are being 
replaced with ###, then it is simply that the column width is to small.



Also when I try to open excel message comes up about installing 2000
SR-1Premium.


It sounds like you have Microsoft Office 2000 Premium installed, which 
is seriously out of date and needs to be updated with the latest service 
packs. Check the Microsoft website for this.



Any advice would be appreciated.

Thanks Warren Chadwick


Hope this helps.

Dave
--
This is a mailing list which exists to support users of OpenOffice.org
All answers are given by other users who volunteer their time.
If you are not subscribed to this mailing list you may not see all the
replies to your query. Please reply to users@openoffice.org only.
You should also be aware that all details of messages posted to this
list are publicly available to anyone with an Internet connection
For mailing list info see: http://www.openoffice.org/mail_list.html
For on-line support see: http://support.openoffice.org/index.html
For a knowledge base see: http://mindmeld.cybersite.com.au/



signature.asc
Description: OpenPGP digital signature


[users] Copy and Paste Question / Problem

2008-04-15 Thread Frank Häusler

Hello !

I'm using Firefox as e-mail client.
Since I used OOO 2.0.1 it was nice when I copied a cell-area containing 
text and numbers from CALC into a new email in Firefox, that the pasted 
cells where formatted in HTML, therfore all attributes like cell-color 
etc. where accessible in the e-mail to edit or change.


Now the Problem:
Since I use OOO 2.3.1 or 2.4.0 this does not function anymore. Now there 
is only the raw content of the cells in my e-mail and I have to fiddle 
around with whitespaces to format the the Text from the cells - don't 
speaking from the color attributes.
Even when copying within a spreadsheet only the _raw_ data without 
stylographic formatting like 'bold' is pasted into the target-area.


What has changed ???

Best regards

Frank Häusler


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread Adrian Try
Hi Solveig

On Tue, Apr 15, 2008 at 6:56 AM, [EMAIL PROTECTED] wrote:

 Does anyone know of an extension or macro or other feature that would
 allow a user to set up just the names and reporting relationships of an
 organization, then generate an org chart?


Google recently introduced a gadget to produce an org chart from a Google
spreadsheet using a method similar to (but not quite the same as) the one
you mentioned.

It's not open source, but you may find it useful.

You can learn more about it here:
http://documents.google.com/support/spreadsheets/bin/answer.py?hl=enanswer=91597

Adrian


Re: [users] Unsubscribing Info

2008-04-15 Thread Rodney D. Myers

On Apr 14, 2008, at 9:53 AM, R M COSGROVE wrote:

Several times, I tried to unsubscribe, but was unsuccessful.
After I added the unsubscribe address to my address book, I
was able to unsubscribe from users@openoffice.orgmailto:[EMAIL PROTECTED] 
.


Suggest this information be added to your unsubscribe information .

Robert Cosgrove


Welcome to the club. That mechanism, is broken for some (me), but  
works for others.


--
Rodney D. Myers [EMAIL PROTECTED]
ICQ#: AIM#:YAHOO:
18002350  mailman452   mailman42_5

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
Ben Franklin - 1759





PGP.sig
Description: This is a digitally signed message part


Re: [users] [moderated] Opening .docx files

2008-04-15 Thread Dave Barton

 Original Message 
From: Roger Higgs [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 09:10:29 EST


Greetings!

I am wondering if the update is able to open documents with .docx or not.

Thanks you!

Fran


The current stable version (2.4.0) cannot open OOXML (Office Open 
Extensible Markup Language) .docx, although it is proposed as an 
option for a future release.


As a temporary (maybe permanent) option, you might consider the enhanced 
version of OOo called Oxygen Office Professional. This is still OOo, 
but this edition includes a number of extras and enhancements, one of 
them being the ability to open MS Office 2007 .docx, .xlsx files. The 
conversion is not 100% perfect, but then neither is Microsoft's own 
Compatibility Pack for earlier versions of MS Office [1].


Oxygen Office Professional can be downloaded from:
http://sourceforge.net/projects/ooop

It is a fairly large download (approx. twice the size of the official
edition) and you will need to completely uninstall any existing version
of OOo before you install Oxygen Office Professional.

[1] http://office.microsoft.com/en-us/word/HA100444731033.aspx

Hope this helps.

Dave
--
This is a mailing list which exists to support users of OpenOffice.org
All answers are given by other users who volunteer their time.
If you are not subscribed to this mailing list you may not see all the
replies to your query. Please reply to users@openoffice.org only.
You should also be aware that all details of messages posted to this
list are publicly available to anyone with an Internet connection
For mailing list info see: http://www.openoffice.org/mail_list.html
For on-line support see: http://support.openoffice.org/index.html
For a knowledge base see: http://mindmeld.cybersite.com.au/



signature.asc
Description: OpenPGP digital signature


Re: [users] restart download

2008-04-15 Thread Guy Voets
2008/4/15, Sebastian van Gass [EMAIL PROTECTED]:

 Thanks Guy

 I'll shure try the FireFox to resume-- it's quite a few ruble's worth of
 airtime sitting downloaded in the clam's belly! Safari download normally
 resumes interrupted transfers most admirably. Maybe its a thunderstorm or
 something similar en route that scramled things this time round (??)


 Regards

 Sebastian
 _
 Mac OS X 10.5.2 Intel
 On 14 Apr 2008, at 12:46 PM, Guy Voets wrote:

 2008/4/14, Sebastian van Gass [EMAIL PROTECTED]:
 
  Hi
 
  I am in the process of downloading OpenOffice from the Virgin mirror,
  UK.
 
  Just a few Mbyte short of the full 158, the 'OOo 2.4.0
  MacOSXIntel_install_en-US.dmg.download' file with a Safari-like icon
  tranformed itself into 'OOo 2.4.0 MacOSXIntel_install_en-US.dmg' with an
  image file icon.
 
  The Mac does not recognize it as an image file though.
 
  Is there any way I can transform this file back to a download file and
  resume the download?
 
  Regards
 
  Sebastian
  _
  Mac OS X 10.5.2 Intel


 Hello,

 Before, there were problems with download thru Safari, so maybe it's wise
 to use Firefox.
 I also had some instances where the download never finished on my Intel
 iMac and I had to do the download elsewhere...
 There's a Mozilla (Firefox) Add-on that will help download and resume.
 Or try another mirror?

 HTH
 --
 Guy
 using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
 and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
 -- please reply only to users@openoffice.org --
 Dodoes can't afford to have headaches


 You can always come back to the list (plz not to me personally) if things
continue to be adversily inclined...

-- 
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches


Re: [users] default fonts again

2008-04-15 Thread Dave Barton

 Original Message 
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 19:20:31 EST

There appears to be a way to change the default fonts and size of fonts 
for new documents under

Tools | Options | OpenOffice.org Writer | Basic Fonts (Western)

However anything set here appears to be largely ignored even if Current 
document only is not ticked.


Another way that is somewhat more successful is to create a default 
document and then save it as a template
File | Templates | Save | My Templates and give the new template a name 
and click OK.

Then make that template the default template
File | Templates | Organise | select the template under My Templates | 
Commands | Set as default template


However that only works when you create a new file under File | New | 
Text Document


Or by simply starting Writer (swriter.exe) from a shortcut/icon.

If you go to Windows Explorer (obviously only under Windows - I have no 
idea what the equivalent of this is on Linux or Mac)
and go to File | New | OpenDocument Text to create a new document it 
will not only ignore any settings under Tools | Options | etc but will 
also ignore any default templates.


This would appear to be a significant oversight.

Neil


This is an extremely unusual and cumbersome method of creating a new 
document and not one that many users would normally employ, but the 
document generated by this method does revert to the original Writer 
defaults, not to the user defined default template.


I don't have time to pull up the source code and find out how the 
document is being generated from the Explorer menu. So I would suggest 
you submit an issue to http://qa.openoffice.org


Sorry I can't be of more help.

Dave




signature.asc
Description: OpenPGP digital signature


[users] periods in column headings in calc and mail merge

2008-04-15 Thread H.S.

Hello,

Just wanted to share the experience that the presence of any periods in 
the title row of a spread sheet may mess up the mail merge fields. For 
example, P.C. title of a column creates weird problems in mail merge 
but changing it to Postal Code fixes it. It appears that since periods 
are used as separators in the address book fields, the periods in the 
title row may be messing things up.


Can anybody confirm this or give more information regarding this?

thanks,
-HS


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Import/Export vs Open/Save ?

2008-04-15 Thread Harold Fuchs
OpenOffice currently uses Open/Save to handle MS office documents but
*export* to handle PDF.

Documentation and authoritative sources like Uwe Fischer use the word
Import to describe OpenOffice's forthcoming ability to read MS Office 2007
(OOXML) documents.

Please, what is the difference between Open/Save on the one hand and
Import/Export on the other?

-- 
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org


Re: [users] Re: OOXML

2008-04-15 Thread Ganesha Bhaskara



Uwe Fischer wrote:

Hi,

Harold Fuchs wrote:

On 15/04/2008, Ganesha Bhaskara [EMAIL PROTECTED] wrote:

snip


Ganesha, Do you really mean Import  Export a'la PDF; or do you mean

Open  Save.


Open and Save . check out pre-beta version of OO 3.0.



I've read stuff that *suggests* that OOo 3.0 will be able to read 
.docx etc.

files but *not* save them. Is this true or have I been reading the wrong
stuff?  Would someone point me at some sort of official feature list,
please?


a feature list of planned features for 3.0 is here:
http://wiki.services.openoffice.org/wiki/Features#Planned_Features_for_3.0_Release 

There you can read that only import filters are planned for the OOXML 
formats, which makes sense because OOo saves already in an open ISO 
standard format ;-)

http://www.oooninja.com/2008/03/openofficeorg-30-new-features.html
this site says other wise . might be wrong. check out Microsoft 
Office 2007 file format support section


-G


Uwe


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] OOXML

2008-04-15 Thread Robin Laing

Urbane Tiger wrote:

Now that OOXML has been accepted by the ISO as a standard can we
expect OOo will adopt it its the preferred format.

Please no rants - there are plenty of soapboxes that are very much
more visble to the world at large than is this mailing list.






Some reading
http://tech.slashdot.org/tech/08/04/13/1519216.shtml

The certification is not finalized yet.  There is a lot of work before 
it is finalized.


One issue with adopting OOXML is the patent issues.  There are still 
ties to closed source items.  Hopefully ISO will resolve them before the 
final approval.


Of course that depends on protests and further investigation into 
irregularities in the process.


The biggest issue will be after ISO fixes the standard, will Microsoft 
then support OOXML as the standard or do their own thing and not follow 
the standard as always in the past?


If ISO makes changes and Microsoft follows their history, there will be 
compatibility issues again.  Note that there are many reports that MS 
Office doesn't follow the present OOXML format as submitted for 
standardization already.


So this brings the question, will following OOXML improve a bad situation?
--
Robin Laing

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Import/Export vs Open/Save ?

2008-04-15 Thread Johnny Rosenberg
2008/4/15, Harold Fuchs [EMAIL PROTECTED]:

 OpenOffice currently uses Open/Save to handle MS office documents but
 *export* to handle PDF.

 Documentation and authoritative sources like Uwe Fischer use the word
 Import to describe OpenOffice's forthcoming ability to read MS Office
 2007
 (OOXML) documents.

 Please, what is the difference between Open/Save on the one hand and
 Import/Export on the other?


 --
 Harold Fuchs
 London, England
 Please reply *only* to users@openoffice.org


Ok, let's say that the native format is ODS and we want to work with a
XLSX file in one way o the other.

Open/Save: You open the file, work with it and save it. All the time we are
working with the XLSX format.

Import: Well, pretty much like opening. However, the document is probably
converted before we can work with it.

Export: Maybe we are working with an ODS file. If we export it to XLSX
and then want to continue our editing, we are still editing the ODS
file, not the XLSX file.

That's at least what I think is the difference...

J.R.


Re: [users] Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread JOE Conner

[EMAIL PROTECTED] wrote:

Hi,

Does anyone know of an extension or macro or other feature that would allow a 
user to set up just the names and reporting relationships of an organization, 
then generate an org chart? It can of course be done in Draw with connector 
lines but when the number of names increases, it's more work to do all the 
box-drawing.

I guess it could be an add-on for OpenOffice.org or another open source type 
product, as long as the result is usable in an OpenOffice.org document.

Btw, followup on the last question--I was wrong. Word doesn't have the ability 
to leave change bars on when accepting changes, according to my class. I got 
the wrong impression from one of the students.

Thanks,
Solveig
~
[EMAIL PROTECTED]

Training, Consulting, and Learning Materials 
for OpenOffice.org and StarOffice


http://www.getopenoffice.org
http://openoffice.blogs.com

Making the Right Decision Easy

  


Actually you can use CALC to do this.  Just use the BORDERs for defining 
your lines.  When you need to expand a section inserting more 
rows/columns to facilitate placement works with a bit of tidy-up afterward.


If you want I can send you a CALC spreadsheet to illustrate this.

Joe Conner, Poulsbo, WA USA

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] fonts for certificates (Calligraphic or Gothi?)

2008-04-15 Thread H.S.

Hello,

I am looking for fonts to make a bunch of certificates. Where can I find 
these? I think these are called Calligraphic or Gothic fonts? Any good 
resource for these?


Also, I think I read someplace that we cannot embed any fonts in OOo 
documents. Is that correct?


thanks.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] fonts for certificates (Calligraphic or Gothi?)

2008-04-15 Thread JOE Conner

H.S. wrote:

Hello,

I am looking for fonts to make a bunch of certificates. Where can I 
find these? I think these are called Calligraphic or Gothic fonts? Any 
good resource for these?


Also, I think I read someplace that we cannot embed any fonts in OOo 
documents. Is that correct?


thanks.


GOOGLE is your friend.

http://www.1001freefonts.com/

http://simplythebest.net/fonts/

http://www.free-fonts.com/

http://www.searchfreefonts.com/

*1-10 of 140,000* for *FREE 
http://www.google.com/url?sa=Xoi=dictei=Ut0ESJuBA42ogQT44fCACQsig2=CQ3kMbq298jUimfSM2zP_Qq=http://www.answers.com/free%26r%3D67usg=AFQjCNFeddomeTArjF5WpA5qBboXgjSenA 
FONTS 
http://www.google.com/url?sa=Xoi=dictei=Ut0ESJuBA42ogQT44fCACQsig2=jJvc8CzlkbI1jC73hLQ_jQq=http://www.answers.com/fonts%26r%3D67usg=AFQjCNHpqPMwfJCKtXLmx_94ob-06nwzpQ*. 
(*0.21* seconds)


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Invisibility of a font

2008-04-15 Thread Bob Dowling

Summary:

One particular combination of fonts isn't appearing in my OpenOffice.org 
font selector, even though all its variant forms are.


In the font selector (for the paragraph style) I select DejaVu Sans 
for the font.  The list of typefaces I am presented in the middle column 
is then:

ExtraLight
Book
Condensed Oblique
Bold
Bold Oblique

but not simply Condensed.  However, I do have that font/typeface 
installed.  How can I get at it?



Details:

I am running OpenSuSE 10.3 and OpenOffice 2.3.0.1.2 from the OpenSuSE 
package set OpenOffice_org-*-2.3.0.1.2-10.3.  I have installed the 
DejaVu TrueType fonts from the SuSE package dejavu-2.19-14 and I have no 
reason to believe they are incorrectly installed.


The font files installed are these:

/usr/share/fonts/truetype/DejaVuSans-Bold.ttf
/usr/share/fonts/truetype/DejaVuSans-BoldOblique.ttf
/usr/share/fonts/truetype/DejaVuSans-ExtraLight.ttf
/usr/share/fonts/truetype/DejaVuSans-Oblique.ttf
/usr/share/fonts/truetype/DejaVuSans.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed-Bold.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed-BoldOblique.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed-Oblique.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed.ttf
/usr/share/fonts/truetype/DejaVuSansMono-Bold.ttf
/usr/share/fonts/truetype/DejaVuSansMono-BoldOblique.ttf
/usr/share/fonts/truetype/DejaVuSansMono-Oblique.ttf
/usr/share/fonts/truetype/DejaVuSansMono.ttf
/usr/share/fonts/truetype/DejaVuSerif-Bold.ttf
/usr/share/fonts/truetype/DejaVuSerif-BoldItalic.ttf
/usr/share/fonts/truetype/DejaVuSerif-Italic.ttf
/usr/share/fonts/truetype/DejaVuSerif.ttf
/usr/share/fonts/truetype/DejaVuSerifCondensed-Bold.ttf
/usr/share/fonts/truetype/DejaVuSerifCondensed-BoldItalic.ttf
/usr/share/fonts/truetype/DejaVuSerifCondensed-Italic.ttf
/usr/share/fonts/truetype/DejaVuSerifCondensed.ttf

Note, specifically, that this includes the sans serif standard and 
condensed fonts:


/usr/share/fonts/truetype/DejaVuSans-Bold.ttf
/usr/share/fonts/truetype/DejaVuSans-BoldOblique.ttf
/usr/share/fonts/truetype/DejaVuSans-ExtraLight.ttf
/usr/share/fonts/truetype/DejaVuSans-Oblique.ttf
/usr/share/fonts/truetype/DejaVuSans.ttf

/usr/share/fonts/truetype/DejaVuSansCondensed-Bold.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed-BoldOblique.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed-Oblique.ttf
/usr/share/fonts/truetype/DejaVuSansCondensed.ttf


Both standard and condensed forms are visible to my X server:

$ xlsfonts -fn '-*-dejavu sans-*-*-*--0-0-0-0-p-0-adobe-*'
-misc-dejavu sans-bold-i-normal--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans-bold-o-normal--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans-bold-r-normal--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans-medium-i-normal--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans-medium-o-normal--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans-medium-r-normal--0-0-0-0-p-0-adobe-standard

$ xlsfonts -fn '-*-dejavu sans condensed-*-*-*--0-0-0-0-p-0-adobe-*'
-misc-dejavu sans condensed-bold-i-semicondensed--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans condensed-bold-o-semicondensed--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans condensed-bold-r-semicondensed--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans 
condensed-medium-i-semicondensed--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans 
condensed-medium-o-semicondensed--0-0-0-0-p-0-adobe-standard
-misc-dejavu sans 
condensed-medium-r-semicondensed--0-0-0-0-p-0-adobe-standard




So condensed oblique is making it through OO.o but condensed, 
condensed bold and condensed bold oblique aren't.


I would have expected OO.o to have offered me either an extra font 
(Deja Vu Sans Condensed alongside DejaVu Sans) or to have offered me 
the single font with nine typefaces (ExtraLight, Book, Bold, 
Oblique, Bold Oblique, Condensed, Condensed Bold, Condensed 
Oblique, Condensed Bold Oblique).  Instead I get a glimpse of a 
single condensed typeface, but not the rest.  It's truly bizarre.



I have root access to my system if required and I'm not afraid to 
experiment.  Suggestions welcome.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: Spreadsheet to word processor table

2008-04-15 Thread R N D Martin
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Ahromi
Irawan) wrote:

 *From:* Ahromi Irawan [EMAIL PROTECTED]
 *To:* users@openoffice.org
 *Date:* Tue, 15 Apr 2008 10:00:11 +0700
 
 Pada Tanggal 04/14/2008 09:26 PM, R N D Martin Menulis:
  In Lotus I am used to creating a table and then using cop and 
  paste  to
  batch paste direct to  the cells in the table, but in OO I seem 
  to have
  to paste special into the document as text, and then turn what I 
  have
  pasted into a table.  I find this rather long winded and awkward. 
   Have I
  missed something?
 
  Niall Martin

 Edit | Paste Special | Formatted Text
 
 HTH
 
 -- 
 Ahromi Irawan
 Cirebon
 
Thanks.  I'll try that again, but my  memory is that it pasted an image
of the bit of the spreadsheet  rather than distributing the items over
the fields.

Niall Martin


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: Component questions

2008-04-15 Thread Twayne
Dave,

I mean no offense in any way.   I'd just like to point out that if many 
others are like me they don't read attachments, especially without body 
text to explain why/what they are.   Even with the .asc TLD, it doesn't 
mean they aren't misnomers and stealthed malware.
   Perhaps those that know you well have no problems with it, which is 
fine.  You certainly are entitled to your own opinions and methods.

Just my 2 ¢,
-- 
Twayne



Dave Barton [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED] 




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: TOC entries and links

2008-04-15 Thread Twayne
Hi,
Appreciate the come back; some very useful information indeed.  At first 
I thought the ...clean link might be incomplete, but it's right on, 
lol!  Thanks much.  I'll be going back there to read some more but 
wanted to let you know your advice was well positioned.

I am now up and running again, with TOCs behaving correctly thanks to 
your assistance.  At least it took care of one of two total of my 
issues!  I hoped it'd get both, but alas ... g

Thanks again,

Twayne


 Hi,

 Twayne wrote:
  Hi,

 OOo 2.4.0 on XP Pro SP2+:

 This one is probably my own fault but I haven't done anything
 knowingly to cause it.  I recently switched from 2.3 to 2.4 so I'm
 not sure whether it ever worked in the 2.4 version I have.

 Problem:
 TOC does not include links to the page they reference.

 Tried:
 Help, and the LE/ES (or whatever it was) settings and clicking to
 set ALL.  Followed instructions as perfectly as I could; no help, so
 it would appear I'm missing something.


 You can apply the LS (Link Start) and LE (Link End) entries to the TOC
 levels 1 to 10. There is no ALL entry.
 If you see an ALL entry in the Levels box, something is messed up.


 1.  HOW do I get the TOC to include links?
Please, don't just copy the Help paragraphs here; I've read them
 over and over without getting the links to work.  Layman's terms
 please? Some of that Help is a little confusing so I'm probably
 misnterpreting something.  I'm not new to Word or to Writer so you
 needn't assume I'm a complete newbie either.


 please explain what confuses you, so we can find a better help text.



 And, these further questions arose from that effort:

 2.  Is there a way to RESET *everything* in Writer,  or even the
 entire OOo?  Remove/reinstall doesn't seem to accomplish that.
 Either would be OK with me as I still have 2.3 installed and
 functional.  I'm just getting 2.4 set up so don't mind starting over
 from scratch.  Oh, and yes, I removed 2.3 also when I reinstalled
 2.4, just in case there was something clnflicting.


 please see the OpenOffice.org Tips 'n' Tricks blog entry Starting
 over with a clean installation
 http://blogs.sun.com/oootnt/entry/starting_over_with_a_clean
 There you find steps and an explanation.

 Uwe





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Unsubscribing Info

2008-04-15 Thread Harold Fuchs

On 15/04/2008 14:18, Rodney D. Myers wrote:

On Apr 14, 2008, at 9:53 AM, R M COSGROVE wrote:

Several times, I tried to unsubscribe, but was unsuccessful.
After I added the unsubscribe address to my address book, I
was able to unsubscribe from 
users@openoffice.orgmailto:[EMAIL PROTECTED].


Suggest this information be added to your unsubscribe information .

Robert Cosgrove


Welcome to the club. That mechanism, is broken for some (me), but 
works for others.


Some (most?) mail clients [can be configured to] regard as junk/spam 
messages from addresses which are *not* in your address book. Perhaps 
this is what has happened, with the consequence that you are not being 
shown the reply that comes back to you when you send the unsubscribe 
message.


--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread Harold Fuchs

On 15/04/2008 14:06, Adrian Try wrote:

Hi Solveig

On Tue, Apr 15, 2008 at 6:56 AM, [EMAIL PROTECTED] wrote:

  

Does anyone know of an extension or macro or other feature that would
allow a user to set up just the names and reporting relationships of an
organization, then generate an org chart?




Google recently introduced a gadget to produce an org chart from a Google
spreadsheet using a method similar to (but not quite the same as) the one
you mentioned.

It's not open source, but you may find it useful.

You can learn more about it here:
http://documents.google.com/support/spreadsheets/bin/answer.py?hl=enanswer=91597

Adrian

  

Forwarding to unsubscribed OP.


--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org



Re: [users] Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread Harold Fuchs

On 15/04/2008 17:28, JOE Conner wrote:

[EMAIL PROTECTED] wrote:

Hi,

Does anyone know of an extension or macro or other feature that would 
allow a user to set up just the names and reporting relationships of 
an organization, then generate an org chart? It can of course be done 
in Draw with connector lines but when the number of names increases, 
it's more work to do all the box-drawing.


I guess it could be an add-on for OpenOffice.org or another open 
source type product, as long as the result is usable in an 
OpenOffice.org document.


Btw, followup on the last question--I was wrong. Word doesn't have 
the ability to leave change bars on when accepting changes, according 
to my class. I got the wrong impression from one of the students.


Thanks,
Solveig
~
[EMAIL PROTECTED]

Training, Consulting, and Learning Materials for OpenOffice.org and 
StarOffice


http://www.getopenoffice.org
http://openoffice.blogs.com

Making the Right Decision Easy

  


Actually you can use CALC to do this.  Just use the BORDERs for 
defining your lines.  When you need to expand a section inserting more 
rows/columns to facilitate placement works with a bit of tidy-up 
afterward.


If you want I can send you a CALC spreadsheet to illustrate this.

Joe Conner, Poulsbo, WA USA

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Forwarding to unsubscribed OP.

--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] BASE - Form-Problem

2008-04-15 Thread Frank Häusler

Hello !

I created a simple database from an excel-sheet.
Now I created a form with the wizard == ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the title-bar the name I gave to the 
form and the additional text (schreibgeschützt) english: (read only).
I did not set any option in the wizard that the data is for read only 
use. The database-file and the spreadsheet-file are not write-protected 
and I have full write-access through the filesystem to them.


I'm using OOO 2.4.0 ; Windoze XP 64

Has anyone any idea ?? You are welcome.

Best regards

Frank Häusler


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: fonts for certificates (Calligraphic or Gothi?)

2008-04-15 Thread Jim Allan

JOE Conner wrote:

H.S. wrote:

Hello,

I am looking for fonts to make a bunch of certificates. Where can I 
find these? I think these are called Calligraphic or Gothic fonts? Any 
good resource for these?


Also, I think I read someplace that we cannot embed any fonts in OOo 
documents. Is that correct?


thanks.


GOOGLE is your friend.

http://www.1001freefonts.com/

http://simplythebest.net/fonts/

http://www.free-fonts.com/

http://www.searchfreefonts.com/

*1-10 of 140,000* for *FREE 
http://www.google.com/url?sa=Xoi=dictei=Ut0ESJuBA42ogQT44fCACQsig2=CQ3kMbq298jUimfSM2zP_Qq=http://www.answers.com/free%26r%3D67usg=AFQjCNFeddomeTArjF5WpA5qBboXgjSenA 
FONTS 
http://www.google.com/url?sa=Xoi=dictei=Ut0ESJuBA42ogQT44fCACQsig2=jJvc8CzlkbI1jC73hLQ_jQq=http://www.answers.com/fonts%26r%3D67usg=AFQjCNHpqPMwfJCKtXLmx_94ob-06nwzpQ*. 
(*0.21* seconds)


And to answer your other question: no, you cannot embed fonts in 
OpenOffice.org documents.


However, you can embed fonts in a PDF document created by 
OpenOffice.org. Perhaps that will be satisfactory to you.


Jim Allan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: Import/Export vs Open/Save ?

2008-04-15 Thread Joe Smith

Harold Fuchs wrote:

...
Please, what is the difference between Open/Save on the one hand and
Import/Export on the other?


In OOo, the terms have very specific meanings--far more specific than 
the English words themselves.


When OOo has program code that supports both reading and saving in a 
particular file format, that format is included in the File  Open, File 
 Save lists.


When OOo has program code that supports only writing, but not reading, 
then OOo puts that format on the File  Export menu.


There is no File  Import menu, so I don't know what happens if OOo can 
only read a format. It comes under Insert  File or Picture, I guess.


The idea is, as J.R. already mentioned, that File  Open/Save should 
'remember' and preserve the original file format.


Likewise, when OOo allows writing in a format that cannot be read back, 
then the user should have to use a different menu. E.g. you File  
Export a drawing as an image, because there's no way to perform the 
reverse operation (image to drawing).


soapbox
I think this distinction is more confusing than helpful because it is 
based on an engineering concept that goes beyond the common 
understanding of the words. Does it make sense to Save a document in a 
format that doesn't preserve all of the current formatting? Do most 
users understand the distinction between file operations that OOo 
implements?

/soapbox

Joe


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Unsubscribing Info

2008-04-15 Thread Rodney D. Myers

On Apr 15, 2008, at 10:13 AM, Harold Fuchs wrote:

On 15/04/2008 14:18, Rodney D. Myers wrote:

On Apr 14, 2008, at 9:53 AM, R M COSGROVE wrote:

Several times, I tried to unsubscribe, but was unsuccessful.
After I added the unsubscribe address to my address book, I
was able to unsubscribe from users@openoffice.orgmailto:[EMAIL PROTECTED] 
.


Suggest this information be added to your unsubscribe information .

Robert Cosgrove


Welcome to the club. That mechanism, is broken for some (me), but  
works for others.


Some (most?) mail clients [can be configured to] regard as junk/spam  
messages from addresses which are *not* in your address book.  
Perhaps this is what has happened, with the consequence that you are  
not being shown the reply that comes back to you when you send the  
unsubscribe message.


--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org


Not so here, using Apple Mail.

I'm checking the online spam filters, to see if they are catching  
them, and looking into the local SPAM folder, and they are not there  
either.


That's what's frustrating.

Brad Rogers, in the UK can send an unsubscribe email, and I get the OO  
response. Yet when I reply to the response, it gets lost.


From this email address, and the want I want to subscribe to.

--
Rodney D. Myers [EMAIL PROTECTED]
ICQ#: AIM#:YAHOO:
18002350  mailman452   mailman42_5

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
Ben Franklin - 1759





PGP.sig
Description: This is a digitally signed message part


[users] Re: periods in column headings in calc and mail merge

2008-04-15 Thread NoOp
On 04/15/2008 08:10 AM, H.S. wrote:
 Hello,
 
 Just wanted to share the experience that the presence of any periods in 
 the title row of a spread sheet may mess up the mail merge fields. For 
 example, P.C. title of a column creates weird problems in mail merge 
 but changing it to Postal Code fixes it. It appears that since periods 
 are used as separators in the address book fields, the periods in the 
 title row may be messing things up.
 
 Can anybody confirm this or give more information regarding this?
 
 thanks,
 -HS

What sort of wierd problems? It's also helpful if you let us know what
version of OOo  Operating System...

I cannot recreate on OOo 2.4.0 (linux). I used an .ods that originally
used zip (postal code - zip code in US) in the column header and
changed it to P.C. I then opened a new mailmerge and pointed to the .ods
as the source  identified P.C as the Zip field. No problem - postal
code was put in the letter(s) properly.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: Invisibility of a font

2008-04-15 Thread NoOp
On 04/15/2008 09:42 AM, Bob Dowling wrote:
 Summary:
 
 One particular combination of fonts isn't appearing in my OpenOffice.org 
 font selector, even though all its variant forms are.
 
 In the font selector (for the paragraph style) I select DejaVu Sans 
 for the font.  The list of typefaces I am presented in the middle column 
 is then:
 ExtraLight
 Book
 Condensed Oblique
 Bold
 Bold Oblique
 
 but not simply Condensed.  However, I do have that font/typeface 
 installed.  How can I get at it?
 
 
 Details:
 
 I am running OpenSuSE 10.3 and OpenOffice 2.3.0.1.2 from the OpenSuSE 
 package set OpenOffice_org-*-2.3.0.1.2-10.3.  I have installed the 
 DejaVu TrueType fonts from the SuSE package dejavu-2.19-14 and I have no 
 reason to believe they are incorrectly installed.

Works for me. However I also have it installed in:

~$ locate DejaVuSansCondensed.ttf
/usr/share/fonts/truetype/ttf-dejavu/DejaVuSansCondensed.ttf
/home/user/.openoffice.org2/user/fonts/DejaVuSansCondensed.ttf
/home/user/fonts/truetype/ttf-dejavu/DejaVuSansCondensed.ttf
/var/lib/defoma/x-ttcidfont-conf.d/dirs/TrueType/DejaVuSansCondensed.ttf
/var/lib/defoma/gs.d/dirs/fonts/DejaVuSansCondensed.ttf

If you'd like I can remove from /home/user/.openoffice... and
/home/user/fonts/... to see if it's still picked up by OOo.

In OOo I'm also showing:
ExtralLight
Book
Condensed
Condensed Oblique
Oblique
Bold
Condensed Bold
Bold Oblique
Condensed Bold Oblique

[snip]
 
 
 So condensed oblique is making it through OO.o but condensed, 
 condensed bold and condensed bold oblique aren't.
 
 I would have expected OO.o to have offered me either an extra font 
 (Deja Vu Sans Condensed alongside DejaVu Sans) or to have offered me 
 the single font with nine typefaces (ExtraLight, Book, Bold, 
 Oblique, Bold Oblique, Condensed, Condensed Bold, Condensed 
 Oblique, Condensed Bold Oblique).  Instead I get a glimpse of a 
 single condensed typeface, but not the rest.  It's truly bizarre.
 
 
 I have root access to my system if required and I'm not afraid to 
 experiment.  Suggestions welcome.

Have you updated your font cache lately? You might try:

sudo fc-cache -f -v

to update all of your font cache.

Also see:
http://wiki.services.openoffice.org/wiki/Font-FAQ


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread NoOp
On 04/15/2008 10:18 AM, Harold Fuchs wrote:
 On 15/04/2008 14:06, Adrian Try wrote:
 Hi Solveig
[snip]

   
 Forwarding to unsubscribed OP.
 
 

Well that's got to be a first... Solveig not subscribed! :-)


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] BASE - Form-Problem

2008-04-15 Thread Brian Barker

At 19:43 15/04/2008 +0200, Frank Häusler wrote:

I created a simple database from an excel-sheet.
Now I created a form with the wizard == ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the 
title-bar the name I gave to the form and the 
additional text (schreibgeschützt) english: (read only).


I don't think this is a problem.  The read-only 
attribute applies, I think, to the *format* of 
the form, not its contents.  It prevents the user 
changing the appearance or layout of the form, 
but it doesn't prevent the insertion of data and 
its saving to tables in the database.


I don't suppose anyone can help you if all you 
say is that entering data does not work.  One 
possibility, of course, is that the combination 
of fields that you have included in the form 
prevents you from adding essential data.  If, for 
example, you have a field that is marked as 
Entry required but it does not appear in the 
form, then you will not be able to enter new 
records.  This applies in particular to the 
primary key; you can avoid the problem in that 
case by setting this to AutoValue.


I trust this helps.

Brian Barker



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Spreadsheet to word processor table

2008-04-15 Thread Brian Barker

At 15:26 14/04/2008 +0100, Niall Martin wrote:
In Lotus I am used to creating a table and then using copy and paste 
to batch paste direct to the cells in the table, but in OO I seem to 
have to paste special into the document as text, and then turn what 
I have pasted into a table.  I find this rather long winded and 
awkward. Have I missed something?


Possibly.  I think that, in Writer, this is even easier than you 
hope.  Don't create any table first.  Instead, copy the cells from 
your spreadsheet and then use Edit | Paste Special... (or 
Ctrl+Shift+V), selecting DDE link from the options.  This creates a 
table with your imported values, which you can then format as you require.


Note that this technique actually creates a link to the source 
spreadsheet instead of a copy - so the spreadsheet file must continue 
to be available and any subsequent change to it will be reflected in 
your Writer document.  If this is not what you need, after you have 
pasted the link, go to Edit | Links..., select the relevant link in 
the list, and press Break Link.  You will now have an independent 
text document.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] default fonts again

2008-04-15 Thread [EMAIL PROTECTED]
As per your suggestion I have submitted it to the qa - see 
http://qa.openoffice.org/issues/show_bug.cgi?id=88315



Dave Barton wrote:

 Original Message 
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 19:20:31 EST

There appears to be a way to change the default fonts and size of 
fonts for new documents under

Tools | Options | OpenOffice.org Writer | Basic Fonts (Western)

However anything set here appears to be largely ignored even if 
Current document only is not ticked.


Another way that is somewhat more successful is to create a default 
document and then save it as a template
File | Templates | Save | My Templates and give the new template a 
name and click OK.

Then make that template the default template
File | Templates | Organise | select the template under My Templates 
| Commands | Set as default template


However that only works when you create a new file under File | New | 
Text Document


Or by simply starting Writer (swriter.exe) from a shortcut/icon.

If you go to Windows Explorer (obviously only under Windows - I have 
no idea what the equivalent of this is on Linux or Mac)
and go to File | New | OpenDocument Text to create a new document it 
will not only ignore any settings under Tools | Options | etc but 
will also ignore any default templates.


This would appear to be a significant oversight.

Neil


This is an extremely unusual and cumbersome method of creating a new 
document and not one that many users would normally employ, but the 
document generated by this method does revert to the original Writer 
defaults, not to the user defined default template.


I don't have time to pull up the source code and find out how the 
document is being generated from the Explorer menu. So I would suggest 
you submit an issue to http://qa.openoffice.org


Sorry I can't be of more help.

Dave




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] default fonts again

2008-04-15 Thread [EMAIL PROTECTED]

Hi Dave

I am not sure on what research you base the statement This is an 
extremely unusual and cumbersome method of creating a new document and 
not one that many users would normally employ but it is certainly a way 
that I use at times and don't find cumbersome.


Regardless of the way the document is created it should be consistent.

Neil

Dave Barton wrote:

 Original Message 
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 19:20:31 EST

There appears to be a way to change the default fonts and size of 
fonts for new documents under

Tools | Options | OpenOffice.org Writer | Basic Fonts (Western)

However anything set here appears to be largely ignored even if 
Current document only is not ticked.


Another way that is somewhat more successful is to create a default 
document and then save it as a template
File | Templates | Save | My Templates and give the new template a 
name and click OK.

Then make that template the default template
File | Templates | Organise | select the template under My Templates 
| Commands | Set as default template


However that only works when you create a new file under File | New | 
Text Document


Or by simply starting Writer (swriter.exe) from a shortcut/icon.

If you go to Windows Explorer (obviously only under Windows - I have 
no idea what the equivalent of this is on Linux or Mac)
and go to File | New | OpenDocument Text to create a new document it 
will not only ignore any settings under Tools | Options | etc but 
will also ignore any default templates.


This would appear to be a significant oversight.

Neil


This is an extremely unusual and cumbersome method of creating a new 
document and not one that many users would normally employ, but the 
document generated by this method does revert to the original Writer 
defaults, not to the user defined default template.


I don't have time to pull up the source code and find out how the 
document is being generated from the Explorer menu. So I would suggest 
you submit an issue to http://qa.openoffice.org


Sorry I can't be of more help.

Dave




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Re: Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread Harold Fuchs

On 15/04/2008 22:53, NoOp wrote:

On 04/15/2008 10:18 AM, Harold Fuchs wrote:
  

On 15/04/2008 14:06, Adrian Try wrote:


Hi Solveig
  

[snip]
  
  
  

Forwarding to unsubscribed OP.





Well that's got to be a first... Solveig not subscribed! :-)

  

I don't think Solveig has ever been subscribed ...
Just to make sure I wasn't going mad, though, I checked the archive:
= begin snippet from original message 
SubjectOrg chart generator, as opposed to creating one from scratch 
in Draw


Return-Path: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Delivered-To: mailing list users@openoffice.org
Delivered-To: moderator for users@openoffice.org
 end snippet 

Note the 2nd Delivered-To header.

Perhaps she uses an unsubscribed e-mail address to send and then reads 
the results with a News reader to avoid spam etc. Or something ???


--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org



Re: [users] BASE - Form-Problem

2008-04-15 Thread Drew Jensen

Brian Barker wrote:

At 19:43 15/04/2008 +0200, Frank Häusler wrote:

I created a simple database from an excel-sheet.
Now I created a form with the wizard == ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the title-bar the name I gave to 
the form and the additional text (schreibgeschützt) english: (read 
only).


I don't think this is a problem.  The read-only attribute applies, I 
think, to the *format* of the form, not its contents.  It prevents the 
user changing the appearance or layout of the form, but it doesn't 
prevent the insertion of data and its saving to tables in the database.


I don't suppose anyone can help you if all you say is that entering 
data does not work. 


Hello Frank, Brian

Well, the bottom line is simply this. Base files that use spreadsheet 
data for the data source are read only. It has nothing to do with the 
use of a form - just opening a table object in this Base file would 
render a read only result set also.


What Brian describes regarding the 'Read-only-ness' of the form is 
absolutely correct but, as I say, in this specific case of not relevant.


Drew

--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] Re: Org chart generator, as opposed to creating one from scratch in Draw

2008-04-15 Thread JOE Conner

NoOp wrote:

On 04/15/2008 10:18 AM, Harold Fuchs wrote:
  

On 15/04/2008 14:06, Adrian Try wrote:


Hi Solveig
  

[snip]
  
  
  

Forwarding to unsubscribed OP.





Well that's got to be a first... Solveig not subscribed! :-)

  

+1
Joe Conner, Poulsbo, WA USA

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[users] Re: periods in column headings in calc and mail merge

2008-04-15 Thread H.S.

NoOp wrote:

On 04/15/2008 08:10 AM, H.S. wrote:

Hello,

Just wanted to share the experience that the presence of any periods in 
the title row of a spread sheet may mess up the mail merge fields. For 
example, P.C. title of a column creates weird problems in mail merge 
but changing it to Postal Code fixes it. It appears that since periods 
are used as separators in the address book fields, the periods in the 
title row may be messing things up.


Can anybody confirm this or give more information regarding this?

thanks,
-HS


What sort of wierd problems? It's also helpful if you let us know what
version of OOo  Operating System...


I was printing labels using the data. Initially, all the labels turned 
out to be the same. If I created the labels by using only the fields 
which had no period in them, then the data came out okay.


I then tried to delete the fields from the first label and synchronized 
others, and then added each field from the address source (got by 
pressing F4) by clicking on the field and dragging it. As long as I 
included fields with no periods, everything worked, but as soon as I 
included fields with periods, though I got all different data in each 
label, but the _first sample_ of data was missing from the columns with 
title including a period.


This was on OOo 2.4 on Windows as well on Debian Sid.




I cannot recreate on OOo 2.4.0 (linux). I used an .ods that originally
used zip (postal code - zip code in US) in the column header and
changed it to P.C. I then opened a new mailmerge and pointed to the .ods
as the source  identified P.C as the Zip field. No problem - postal
code was put in the letter(s) properly.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] BASE - Form-Problem

2008-04-15 Thread Brian Barker

At 18:12 15/04/2008 -0400, Drew Jensen wrote:

Brian Barker wrote:

At 19:43 15/04/2008 +0200, Frank Häusler wrote:

I created a simple database from an excel-sheet.
Now I created a form with the wizard == ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the 
title-bar the name I gave to the form and the 
additional text (schreibgeschützt) english: (read only).


I don't think this is a problem.  The 
read-only attribute applies, I think, to the 
*format* of the form, not its contents.  It 
prevents the user changing the appearance or 
layout of the form, but it doesn't prevent the 
insertion of data and its saving to tables in the database.


I don't suppose anyone can help you if all you 
say is that entering data does not work.


Hello Frank, Brian

Well, the bottom line is simply this. Base files 
that use spreadsheet data for the data source 
are read only. It has nothing to do with the use 
of a form - just opening a table object in this 
Base file would render a read only result set also.


What Brian describes regarding the 
'Read-only-ness' of the form is absolutely 
correct but, as I say, in this specific case of not relevant.


Drew


What you say certainly applies to a database 
created by *connecting* to a spreadsheet.  But I 
had taken the original questioner's description 
of creat[ing] a simple database from an 
excel-sheet to include the possibility that he 
had pasted spreadsheet data into the database to 
create a table.  In this case, the table itself 
should not be read-only and the form should allow 
data entry, I think.  My experimentation certainly suggests so.


And that may be his solution: he should copy the 
spreadsheet data and paste it in (into the Tables 
panel of the database so as to create a new 
table) rather than connecting the database to the original spreadsheet.


Brian Barker


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] default fonts again

2008-04-15 Thread Brian Barker

At 08:07 16/04/2008 +1000, Neil Jansons wrote:

Dave Barton wrote:

 Original Message 
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tue 15 Apr 2008 19:20:31 EST

There appears to be a way to change the default fonts and size of 
fonts for new documents under

Tools | Options | OpenOffice.org Writer | Basic Fonts (Western)

However anything set here appears to be largely ignored even if 
Current document only is not ticked.


Another way that is somewhat more successful is to create a 
default document and then save it as a template
File | Templates | Save | My Templates and give the new template a 
name and click OK.

Then make that template the default template
File | Templates | Organise | select the template under My 
Templates | Commands | Set as default template


However that only works when you create a new file under File | 
New | Text Document


Or by simply starting Writer (swriter.exe) from a shortcut/icon.

If you go to Windows Explorer (obviously only under Windows - I 
have no idea what the equivalent of this is on Linux or Mac)
and go to File | New | OpenDocument Text to create a new document 
it will not only ignore any settings under Tools | Options | etc 
but will also ignore any default templates.


This would appear to be a significant oversight.

Neil


This is an extremely unusual and cumbersome method of creating a 
new document and not one that many users would normally employ, but 
the document generated by this method does revert to the original 
Writer defaults, not to the user defined default template.


I don't have time to pull up the source code and find out how the 
document is being generated from the Explorer menu. So I would 
suggest you submit an issue to http://qa.openoffice.org


Sorry I can't be of more help.

Dave


Hi Dave

I am not sure on what research you base the statement This is an 
extremely unusual and cumbersome method of creating a new document 
and not one that many users would normally employ but it is 
certainly a way that I use at times and don't find cumbersome.


Regardless of the way the document is created it should be consistent.

Neil


For what it's worth (and this is not a flame), I agree that this 
method of creating new document files is in no way cumbersome: in 
fact, it is particularly convenient.  And I very much doubt whether 
it is at all unusual.  Indeed, for those users who clearly find 
locating the program menu entries in Windows in order to start 
OpenOffice a challenge, I suspect that this would be their standard 
way of creating a new document.  They would open My Computer, browse 
to the appropriate folder, and either double-click an existing 
document file or else create a new one first by this technique, 
rename it suitably, and then double-click that.


Brian Barker


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [users] default fonts again

2008-04-15 Thread Dave Barton

 Original Message 
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wed 16 Apr 2008 08:07:51 EST


Hi Dave


Hi Neil

I am not sure on what research you base the statement This is an 
extremely unusual and cumbersome method of creating a new document and 
not one that many users would normally employ but it is certainly a way 
that I use at times and don't find cumbersome.


I wouldn't describe my experience as research. It's just that over 
many years I have trained or assisted hundreds of people, with varying 
degrees of experience, in the use of computer software, including OOo. 
In the process I have had the opportunity to study the various options 
users choose to perform similar actions. While I am aware of the method 
you describe to create a new writer document, I have never seen any of 
these people voluntarily choose this option.


I describe this method as cumbersome, because it first creates a a 
file which offers to be (re)named and then has to be opened (eg double 
click). The same is true for MS Word documents created by this method. 
To me it just seems much more straight forward to open swriter.exe 
from a shortcut, but it's the user's choice, so each to their own.



Regardless of the way the document is created it should be consistent.


I am partly in agreement with you on this, but I don't know what 
function Windows is calling when it creates the file to be opened. By 
the time the file is loaded into Writer, the document structure is 
already established. From my cursory perusal of and experimentation with 
the OOo command line parameters, I cannot find anything that creates a 
file with the original OOo default document structure. Hopefully one of 
the developers will pick up your issue and explain how this is happening.


Dave



signature.asc
Description: OpenPGP digital signature


[users] Proof Reading

2008-04-15 Thread Robert Dailey
Hi,

I'm fairly new to Open Office Writer, so bare with me. I'm hoping this is
just a situation where I do not know the correct terminology.

I remember in Microsoft Word there was a way to leave notes that pointed
to specific lines of text in a document so you can leave comments. One
specific thing I need to do is review a document someone has given me and
without actually changing the content, simply label things and say Change
this or This needs to say that This way when they read the document
that I've added notes in, they will see those suggestions and be able to
edit the changes in themselves.

Any suggestions on how to easily do this?


[users] Microsoft's OOXML trophy is conditional

2008-04-15 Thread Fred A. Miller

Those that giveth can also taketh away

By Mark Ballard 
http://www.theinquirer.net/articles/flameAuthor/gb/inquirer/news/2008/04/15/ooxml-trophy-conditional: 
Tuesday, 15 April 2008, 1:24 PM


*THE COVETED* international standard gong which the ISO awarded to 
Microsoft's OOXML could be retracted if the software giant starts 
getting mean over patents it has invested in the standard, the 
organisation said today.


Otherwise, the body expects Microsoft's OOXML and the open source ODF 
document formats to face one another in a direct competition for 
survival. The outcome will be decided by the market, it said.


In the wake of Microsoft's promise 
http://www.microsoft.com/interop/osp/default.mspx to make its OOXML 
specification freely http://standardslaw.com/wordpress/ available (a 
move that has been met with scepticism), the International Standards 
Organisation issued a statement 
http://www.iso.org/iso/pressrelease/faqs_isoiec29500.htm today that 
said how it would hold Microsoft to its promise, with the most severe of 
penalties for any shirking.


The ISO said how its patent policy 
http://isotc.iso.org/livelink/livelink/fetch/2000/2122/3770791/customview.html?func=llobjId=3770791objAction=browse 
demanded that licences were awarded on RAND (reasonable and 
non-discriminatory) terms.


If, after publication of the standard, it is determined that licences 
to all required patents are not so available, one option would be to 
withdraw the International Standard, it said.


If Microsoft doesn't misbehave, the standards body said that the 
standards would be left to prove themselves: After a period of 
co-existence, it is basically the market that decides which survives, a 
spokesman said.


The market had already determined through the ISO voting procedures that 
OOXML would become an official international standard, it said.


The statement also said that it had put OOXML into its fast-track for 
adoption after it was proposed by Ecma International, the commercial 
custodian of the standard. µ



http://www.theinquirer.net/gb/inquirer/news/2008/04/15/ooxml-trophy-conditional


--
Q: what's the difference between a teddy bear and Steve Ballmer?
A: they both have sawdust for brains but one is smart enough to
   keep his mouth shut.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]