Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread mike scott
On 25 Jul 2008 at 22:53, Jason Cipriani wrote:

  Jason Cipriani wrote:
 
  How do I type a hyphen - or a double hyphen -- in a cell without
  wrestling with auto-complete? Once I type it, if I click anywhere else
  or move the arrows, it fills in the cell numbers.
 
 On Fri, Jul 25, 2008 at 11:44 AM, Dennis Sledge
 [EMAIL PROTECTED] wrote:
  Hit -ENTER- prior to leaving the cell.
 
 Thanks. Is there some way to configure it to advance to the right
 instead of down when I hit enter?

Yes. You can also turn off movement. See Tools|Options|OpenOffice.org 
Calc|General.

It looks as though any of '=', '-' or '+'  is taken as indicating 
that the user is starting a formula.


-- 
Permission for this mail to be processed by any third party in 
connection
with marketing or advertising purposes is hereby explicitly denied.
http://www.scottsonline.org.uk lists incoming sites blocked because 
of spam
[EMAIL PROTECTED]Mike Scott, Harlow, Essex, England



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



Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread David Lowe

On Jul 25, 2008, at 19:53 , Jason Cipriani wrote:


Thanks. Is there some way to configure it to advance to the right
instead of down when I hit enter?



	That would be under Tools - Options - OpenOffice.org Calc -  
General.  It's the 1st line of 'Input settings'.



--
Using a rusty Amiga 4000T, a shiny PowerMac G5,  a homebuilt Ubuntu box

Well shucky darn and slop the chickens.

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



Re: [users] search for text strings in multiple documents

2008-07-26 Thread mike scott
On 26 Jul 2008 at 8:39, Rob Clement wrote:

 I am trying to find an article I have lost among a lot of other news 
 articles I kept in ODF format. Is there any way on Windows to do a 
 search of the contents of an ODF file. I tried Windows Vista Search and 
 that ignored most of the files.

Normal windows contents search (I assume vista is similar to XP) 
isn't much help as the odf contents are compressed. There's a python 
program around called loook  (3 o's there!) that should help. Try 
googling for loook.py



-- 
Permission for this mail to be processed by any third party in 
connection
with marketing or advertising purposes is hereby explicitly denied.
http://www.scottsonline.org.uk lists incoming sites blocked because 
of spam
[EMAIL PROTECTED]Mike Scott, Harlow, Essex, England



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



Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread Brian Barker

At 11:28 25/07/2008 -0400, Jason Cipriani wrote:
How do I type a hyphen - or a double hyphen -- in a cell without 
wrestling with auto-complete? Once I type it, if I click anywhere 
else or move the arrows, it fills in the cell numbers.


You probably realise that this behaviour is caused by Calc's 
interpreting the hyphen as a minus sign and consequently as the start 
of a formula instead of as text.  One way that you can avoid this is 
to precede the hyphen by an apostrophe - as you would for entering 
text that Calc would misinterpret as numbers.  The apostrophe does 
not appear as part of the text in the cell, but merely prevents the 
interpretation that you are trying to avoid.


Note that this technique is complicated somewhat if you have Custom 
Quotes enabled, since the apostrophe will then be converted and will 
become part of the text in the cell.  Either disable Custom Quotes 
(in Tools | AutoCorrect...), or else type apostrophe Ctrl+Z hyphen: 
here the Ctrl+Z undoes the effect of AutoCorrect, leaving the plain 
apostrophe as typed.


Another workaround would be to enter some alternative symbol to 
represent your hyphen and hyphen pair, and then to carry out a global 
replace to change them to the text you actually need - perhaps just 
preceding them by a space?  Or just to change the design of your 
spreadsheet to use other text that doesn't start with plus, minus, or equals.


I trust this helps.

Brian Barker


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



Re: [users] search for text strings in multiple documents

2008-07-26 Thread Peter Hillier-Brook

Rob Clement wrote:
I am trying to find an article I have lost among a lot of other news 
articles I kept in ODF format. Is there any way on Windows to do a 
search of the contents of an ODF file. I tried Windows Vista Search and 
that ignored most of the files.


The current version of Copernic Desktop Search (2.3) is very effective - 
and free ;-)

http://www.copernic.com/en/products/desktop-search/

Peter HB

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



Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread Jean Lear
Go to Tools - Options - Open OfficeorgCalc - General - Input Settings - Put
tick in 'Press Enter to move selection'
and in the drop down to the right of that choose whether you want to move to
the cell to the left, right, down or up, -
click OK and enter will move you to the way you have chosen.
[EMAIL PROTECTED]

On Sat, Jul 26, 2008 at 5:49 PM, Brian Barker [EMAIL PROTECTED]wrote:

 At 11:28 25/07/2008 -0400, Jason Cipriani wrote:

 How do I type a hyphen - or a double hyphen -- in a cell without wrestling
 with auto-complete? Once I type it, if I click anywhere else or move the
 arrows, it fills in the cell numbers.


 You probably realise that this behaviour is caused by Calc's interpreting
 the hyphen as a minus sign and consequently as the start of a formula
 instead of as text.  One way that you can avoid this is to precede the
 hyphen by an apostrophe - as you would for entering text that Calc would
 misinterpret as numbers.  The apostrophe does not appear as part of the text
 in the cell, but merely prevents the interpretation that you are trying to
 avoid.

 Note that this technique is complicated somewhat if you have Custom Quotes
 enabled, since the apostrophe will then be converted and will become part of
 the text in the cell.  Either disable Custom Quotes (in Tools |
 AutoCorrect...), or else type apostrophe Ctrl+Z hyphen: here the Ctrl+Z
 undoes the effect of AutoCorrect, leaving the plain apostrophe as typed.

 Another workaround would be to enter some alternative symbol to represent
 your hyphen and hyphen pair, and then to carry out a global replace to
 change them to the text you actually need - perhaps just preceding them by a
 space?  Or just to change the design of your spreadsheet to use other text
 that doesn't start with plus, minus, or equals.

 I trust this helps.

 Brian Barker



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




Re: [users] Information

2008-07-26 Thread Jerry Feldman
On Mon, 21 Jul 2008 08:32:45 +0700
[EMAIL PROTECTED] wrote:

  I am trying to find a way to scan a document,send as a PDF file so I can
 type into it and than print it. I know there is software that will do
 this but it is very expensive,and way out of my price range,that is why I
 am wondering if you have any thing like this that will [EMAIL PROTECTED]

I'm not sure if you really meant printing then  scanning the document,
or reading the PDF document into software that you can use for editing.
In the past, I have used kword (http://www.koffice.org/kword/) that has
the capability to read and edit a pdf. I believe that this is available
on both Windows and Linux. There are a few other OpenSource products
that will also allow you to edit a PDF. Additionally, there are some
programs available that convert PDF to PS format. In the past, I did
find Kword to be ok, but not great. 


-- 
--
Jerry Feldman [EMAIL PROTECTED]
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846


signature.asc
Description: PGP signature


[users] Maintaining macro compatibility between OO.o basic and VBA

2008-07-26 Thread Jerry Feldman
At work, we have a spreadsheet that serves as a specification for the
C++ product that I am working on. The previous maintainer of the spec
implemented the math as forulae, and was very compatible with OO.o. I
work exclusively on Linux, and I need the spec in OO.o. The new
maintainer of the spec wants to convert this to be macro based (which
is better than the old spec for a number of reasons), but he wants to
maintain it in Excel because he knows VBA, and the spec will be sent
out to other people within the company and to some customers.  While we
have agreed that he will also maintain an OO.o document, I was
wondering if there is a good document that compares OO.o basic to VBA.
My premise at work is that the document must be available as an OO.o
document because Excel does not run under Linux. 

-- 
--
Jerry Feldman [EMAIL PROTECTED]
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846


signature.asc
Description: PGP signature


Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread Jason Cipriani
On Sat, Jul 26, 2008 at 2:46 AM, mike scott [EMAIL PROTECTED] wrote:
 On 25 Jul 2008 at 22:53, Jason Cipriani wrote:
 Thanks. Is there some way to configure it to advance to the right
 instead of down when I hit enter?

 Yes. You can also turn off movement. See Tools|Options|OpenOffice.org
 Calc|General.

Ah there it is, thanks guys!

Jason

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



[users] Printing Bug

2008-07-26 Thread atnberte
I posted this to the OO.org forum, but have gotten no replies.  It appears to 
be a bug with Calc.  It appears that one cannot print a newly added worksheet 
in Calc if the file orginated in Excel.  Note that I have Calc set to save 
files in xls format so I can handle work files at home.
Steve

I am a new user of OoO, but not new to spreadsheets. I have worked a lot in 
Excel and have converted all my Excel sheets to OoO Calc format. I am having 
problems printing individual sheets in a workbook. Here are symptoms: 
1-Spreadsheet workbook created in Excel with multiple worksheets 
2-Converted to Calc and set program to save as an XLS file. 
3-Entered Calc, copies a sheet in workbook to use as a template for some new 
data 
4-Edited copied sheet and attempt to print 
5-Print option is set to print selected sheet 
6-What prints is one of the original worksheets, not the new sheet I copied and 
modified. What goes to printer is the worksheet I copied to create the new one. 
7-This also happens if I just create a new blank worksheet and try to print it. 
8-It appears I cannot print any new worksheet if it is in a workbook that 
originated in Excel. 
9-I can print the new sheet IF I create a new Calc workbook file, return to the 
Excel-Calc file and copy the sheet I copied/modified in the old file into the 
new one. 
Is there some setting I'm missing that is causing this problem? 
Thanks for any help you can give on this,
Steve

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



[users] How does one set the default font and font size on your product... it is a sweet product however,

2008-07-26 Thread 1st Place
many Microsoft Word features are missing. Uhmm. HELP!!!

-- 
What you make happen for others, God will make happen for you.


[users] [moderated]

2008-07-26 Thread Lorette Heil
I've been attempting to open an email containing a powerpoint show and it will 
not allow me to open it.  I just purchased your product and so thought I would 
be able to do this.  It is asking for code numbers to be input, which your 
product did not contain.   If you cannot fix this or tell me how to do this, I 
would like a refund of my purchase please, as this is why I bought your 
product.  Thank you.
Lorette Heil


  

[users] Running multiple instances of OOo for UNO API

2008-07-26 Thread David Roe
I have read somewhere that the OOo API doesn't work properly when you have
more than one process using the API at the same time. Therefore I have been
trying to get a program written in Python to start up its own instance of
OOo. I have written a little function that finds a spare port and then
starts OOo listening on that port. I use the -env:UserInstallation switch to
point it at a temp directory for that instance, then I use UNO to connect to
it and edit documents.

I have run into two problems when doing this. Firstly, I want to avoid
having to have an X server but when I start it with any combination of the
following flags -headless, -invisible or -nodefault, some of my code stops
working. The code in question is a function to search for a given string
inside a cursor. In most cases it does that by using
compareRegionStarts/compareRegionEnds but those don't work for matches
inside tables and generate an exception. When that happens I simply
enumerate all the things inside the cursor and check if any one of them is
the table associated with a match. Without the aformentioned startup flags,
the enumeration of a test document returns 4 items and one of them matches
the table I'm looking for. With the flags, the enumeration only returns 1
item and it's not the one I'm trying to search for. Is there a reason that
tables are ignored/missing from the enumeration when one of those flags is
given? Or is this a bug? The code for the search function is given below:

def findInCursor(self, searchDescriptor, cursor, callback):
Finds all text that matches a given search descriptor and for
every
   match that lies within the specified cursor, the callback
function
   is invoked. If there were matches then true is returned,
otherwise
   false is returned

document = self.getUnoDocument()
text = document.Text
matches = document.findAll(searchDescriptor)

matched = False

# Iterate over matches
for i in xrange(0, matches.Count):
match = matches.getByIndex(i)
# Check if the match is within the given cursor
try:
if text.compareRegionStarts(match, cursor) = 0 and \
text.compareRegionEnds(match, cursor) = 0:
callback(match)
matched = True
except:
# If it's a table then we have to see if the table is in the
# text instead (note, this should probably be recursive)
if match.TextTable != None:
searchEnum = cursor.createEnumeration()
while searchEnum.hasMoreElements():
elem = searchEnum.nextElement()
if elem == match.TextTable:
callback(match)
matched = True
else:
raise

return matched

The second issue that I'm having is that despite running (what I thought
was) two seperate instances using different UserInstallation directories and
listening on different ports, when one copy of OOo exits, it causes the next
API operation on the other copy to generate a RuntimeException with message
illegal object given!. How do I concurrently run more than one instance of
OOo, or have more than one connection to the API?

The second problem is more important to me as I can work around the first by
using something like Xvfb (although I'd rather not).

Potentially useful information:
  OS: Fedora 9 x86_64
  Python: 2.5.1
  OpenOffice: 2.4.1 (RPMs from Fedora repository)

Thanks,
David Roe


[users] Cannot download

2008-07-26 Thread Gormankj
I'm having some trouble downloading from the website, keep getting this  
message...
 
NSIS Error...
The installer you are trying to use is corrupted or incomplete.
This could be the result of a damaged disk, a failed download or a  virus.
You may want to contact the issuer of this installer to obtain a new  copy.
It may be possible to skip this check using the /NCRC command line switch  
(NOT RECOMMENDED)
 
Any ideas??.
 
Kenny Gorman



   


[users] questions

2008-07-26 Thread DFGoodwin
Just wondering, is this legal?

http://www-openoffice.com/index.php

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



[users] PLEASE REMOVE THIS OFFICE SITE

2008-07-26 Thread Roy Fletcher
Can you remove this site from my computer as it is in no way compatable with 
Windows.
I can not use, or open, close my computer because of this office.
Give me the information as to how to remove this site.
I will have to report and inform my server of this situation because of the 
damage already done if you do not respond and resolve this siuation NOW.

This is my fourth attempt to resolve this situation.
I will be left with no other option than to report your site and to have it 
brought to all users attention.

Expecting a response with a positive solution herewith.

[users] Need OpenOffice 2.3

2008-07-26 Thread Geary Wootten

Hey there,

I'm on an older Mac OS 10.3.9 and I've just discovered I need 
OpenOffice 2.3 in combo with X11 .  However, I somehow cannot navigate 
to the proper download page for said version.   Would you please supply 
me that link for the OO 2.3?


Thanks very much!

~Gear


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



[users] [moderated]

2008-07-26 Thread Brian Reynolds
Hi - I have recently put Free Office onto my computer. Because I am on dial
up I obtained the programme from the Net. I was provided with 2 discs
-Install and a resource disc. I downloaded the Install disc and am delighted
with the result. Don't know what I can do with the resource  disc  Would be
obliged if you could tell me what it is and what it contains and should I
download it. Does it contain clip art etc. Would appreciate your advice.
Brian Reynolds



[users] Re: How does one set the default font and font size on your product... it is a sweet product however,

2008-07-26 Thread Larry Gusaas

1st Place, 2008/07/24 9:08 PM:

many Microsoft Word features are missing. Uhmm. HELP!!!
  


Actually , they are not. OO.o uses a different user interface than M$ 
Word. I would suggest downloading the following PDF files from 
http://documentation.openoffice.org/


   Getting Started Guide
   Writer Guide
   Migration Guide

The Migration Guide will help you make the transition from M$ Word.

BTW, you can set the default fonts in the preferences settings 
Tools/Options.


--
As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
users@openoffice.org.


Since you are not subscribed to this list you may not see all the 
replies to your query.To subscribe send an email to 
[EMAIL PROTECTED]

--
Larry I. Gusaas
Moose Jaw, Saskatchewan
Canada

Website: http://larry-gusaas.com


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



Re: [users] [moderated]

2008-07-26 Thread James Knott

Lorette Heil wrote:

I've been attempting to open an email containing a powerpoint show and it will 
not allow me to open it.  I just purchased your product and so thought I would 
be able to do this.  It is asking for code numbers to be input, which your 
product did not contain.   If you cannot fix this or tell me how to do this, I 
would like a refund of my purchase please, as this is why I bought your 
product.  Thank you.
Lorette Heil


  
  
1)  You did not have to pay for OpenOffice, as it's a free download from 
www.openoffice.org and no code number required


2)  Since you didn't pay us, we can't give you a refund.  You'll have to 
contact whoever you paid, for a refund.  Failing that, perhaps your 
charge card company can reverse charges.


3) OpenOffice has excellent compatibility with Microsoft Office, however 
it cannot open the newest Microsoft Office file formats, such as .PPTX etc.


Try downloading the free version from www.openoffice.org and see if that 
helps.  If the file is in that new version, you'll have to arrange to 
have it sent in an older .PPT format.  An alternative is to download the 
free PowerPoint viewer from Microsoft, which will enable you to open 
those new files.


Hopefully this helps.  If you need more assistance, please contact us again.

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

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



[users] Re: Need OpenOffice 2.3

2008-07-26 Thread Larry Gusaas

Geary Wootten, 2008/07/25 12:18 PM:

Hey there,

I'm on an older Mac OS 10.3.9 and I've just discovered I need 
OpenOffice 2.3 in combo with X11 .  However, I somehow cannot navigate 
to the proper download page for said version.   Would you please 
supply me that link for the OO 2.3? 


Actually, you need OO.o 2.1.0. You can get it here:
http://porting.openoffice.org/mac/download/x11-103.html

--
As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
users@openoffice.org.


Since you are not subscribed to this list you may not see all the 
replies to your query.To subscribe send an email to 
[EMAIL PROTECTED]

--
Larry I. Gusaas
Moose Jaw, Saskatchewan
Canada

Website: http://larry-gusaas.com


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



Re: [users] [moderated]

2008-07-26 Thread James Knott

Brian Reynolds wrote:

Hi - I have recently put Free Office onto my computer. Because I am on dial
up I obtained the programme from the Net. I was provided with 2 discs
-Install and a resource disc. I downloaded the Install disc and am delighted
with the result. Don't know what I can do with the resource  disc  Would be
obliged if you could tell me what it is and what it contains and should I
download it. Does it contain clip art etc. Would appreciate your advice.
Brian Reynolds


  
If it's the one described on the OpenOffice site, it contains additional 
documentation, the Open Clip Art library, dictionaries and a selection 
of templates.


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

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



Re: [users] PLEASE REMOVE THIS OFFICE SITE

2008-07-26 Thread James Knott

Roy Fletcher wrote:

Can you remove this site from my computer as it is in no way compatable with 
Windows.
I can not use, or open, close my computer because of this office.
Give me the information as to how to remove this site.
I will have to report and inform my server of this situation because of the 
damage already done if you do not respond and resolve this siuation NOW.

This is my fourth attempt to resolve this situation.
I will be left with no other option than to report your site and to have it 
brought to all users attention.

Expecting a response with a positive solution herewith.
  
Would you please properly describe what you're talking about?  
OpenOffice is an office suite, comparable to Microsoft Office and the 
Windows version is most certainly compatible with Windows.  What is it 
that's happening?  What damage are you talking about?



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

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



Re: [users] questions

2008-07-26 Thread James Knott

DFGoodwin wrote:

Just wondering, is this legal?

http://www-openoffice.com/index.php

  


Provided they meet the requirements, yes.  However, many of those sites 
do not meet the requirements.  Some even claim to provide support and 
then send users here.  Unless they provide something significant for the 
money, you're better off getting OpenOffice for free from 
www.openoffice.org.


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

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



Re: [users] [moderated]

2008-07-26 Thread James Knott

James Knott wrote:

Lorette Heil wrote:
I've been attempting to open an email containing a powerpoint show 
and it will not allow me to open it.  I just purchased your product 
and so thought I would be able to do this.  It is asking for code 
numbers to be input, which your product did not contain.   If you 
cannot fix this or tell me how to do this, I would like a refund of 
my purchase please, as this is why I bought your product.  Thank you.

Lorette Heil



1)  You did not have to pay for OpenOffice, as it's a free download 
from www.openoffice.org and no code number required


2)  Since you didn't pay us, we can't give you a refund.  You'll have 
to contact whoever you paid, for a refund.  Failing that, perhaps your 
charge card company can reverse charges.


3) OpenOffice has excellent compatibility with Microsoft Office, 
however it cannot open the newest Microsoft Office file formats, such 
as .PPTX etc.


Try downloading the free version from www.openoffice.org and see if 
that helps.  If the file is in that new version, you'll have to 
arrange to have it sent in an older .PPT format.  An alternative is to 
download the free PowerPoint viewer from Microsoft, which will enable 
you to open those new files.


Hopefully this helps.  If you need more assistance, please contact us 
again.




Forgot the link for the PowerPoint viewer.

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



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

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



[users] Re: questions

2008-07-26 Thread Twayne
 DFGoodwin wrote:
 Just wondering, is this legal?

 http://www-openoffice.com/index.php



 Provided they meet the requirements, yes.  However, many of those
 sites do not meet the requirements.  Some even claim to provide
 support and then send users here.  Unless they provide something
 significant for the money, you're better off getting OpenOffice for
 free from www.openoffice.org.

Agreed, for sure.  They also make a few false claims if you read some of 
their tripe.  I wish I had lots of money; I'd love to see what their 
support is. 




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



Re: [users] Typing - in a cell in OpenOffice

2008-07-26 Thread Richard Detwiler

Jason Cipriani wrote:

On Fri, Jul 25, 2008 at 3:54 PM, Richard Detwiler [EMAIL PROTECTED] wrote:
  

Jason Cipriani wrote:


How do I type a hyphen - or a double hyphen -- in a cell without
wrestling with auto-complete? Once I type it, if I click anywhere else
or move the arrows, it fills in the cell numbers.

  

Jason -- can you be more specific about what you're trying to do? And what
specifically you're typing, with the hyphen?

I can't replicate a problem in this regard, so I assume I must be doing
something differently than you are.

What I tried is typing - test (without the quotes) in a cell.



Your test is not what I was trying to do. I am only typing a hyphen,
nothing else. The solution is to press enter before moving to another
cell (although enter moves the cursor down one cell). The reason I'm
clicking on other cells is because I'm quickly entering data into
various places in a spreadsheet, and sometimes I want to move to
another cell, so I click on it.

Jason


Interesting -- I still can't duplicate what you're seeing. When I type 
just a hyphen in a cell, then press an arrow key or click in another 
cell, it simply enters the hyphen as typed, and doesn't try to make it 
into a formula. Possibly it's a version difference -- I'm using OOo 
2.3.0, on Windows XP.


I've always taught (and been taught) in Excel that to make a formula, it 
always always has to start with an equal sign. And I had assumed (and 
found) that to be true in Calc as well. But possibly a more recent 
version of Calc enables starting formulas with + or - signs as well?



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



Re: [users] Printing Bug

2008-07-26 Thread Brian Barker

At 14:46 24/07/2008 +, Steve Noname wrote:
I posted this to the OO.org forum, but have gotten no replies.  It 
appears to be a bug with Calc.  It appears that one cannot print a 
newly added worksheet in Calc if the file originated in Excel.  Note 
that I have Calc set to save files in xls format so I can handle 
work files at home.


I am a new user of OoO, but not new to spreadsheets. I have worked a 
lot in Excel and have converted all my Excel sheets to OoO Calc 
format. I am having problems printing individual sheets in a 
workbook. Here are symptoms:

1-Spreadsheet workbook created in Excel with multiple worksheets
2-Converted to Calc and set program to save as an XLS file.
3-Entered Calc, copies a sheet in workbook to use as a template for 
some new data

4-Edited copied sheet and attempt to print
5-Print option is set to print selected sheet
6-What prints is one of the original worksheets, not the new sheet I 
copied and modified. What goes to printer is the worksheet I copied 
to create the new one.
7-This also happens if I just create a new blank worksheet and try 
to print it.
8-It appears I cannot print any new worksheet if it is in a workbook 
that originated in Excel.
9-I can print the new sheet IF I create a new Calc workbook file, 
return to the Excel-Calc file and copy the sheet I copied/modified 
in the old file into the new one.

Is there some setting I'm missing that is causing this problem?


This is only a guess, but does your copied original sheet have a 
print range defined?  In Calc, any defined print range operates for 
the entire spreadsheet - all its sheets, that is.  So if you define a 
print range somewhere in your document, only that part or those parts 
will ever print.  If there is a print range defined on your copied 
sheet but not on your new, modified one, you cannot print the new 
one.  Either add (part of?) the new sheet to your print range or else 
delete the existing defined range (using Format | Print Ranges  | 
Remove - from the relevant sheet).


I trust this helps.

Brian Barker


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



Re: [users] Downloaded install just loops to keep installing. What to do?

2008-07-26 Thread Jack D. Lewis

G ARNOLD wrote the following on 7/25/2008 11:58 AM:

Dear Owner,
  
OpenOffice.org 2.4 installs nicely.  It UNinstalls nicely. ..a total  
of 6 times.  The trouble is, when I click on Open it just keeps re- 
installing in a loop and will never open.  I then UNinstall and try  
again. No luck. Same result X 6 = Total frustration. Two weeks is a  
long time to wait for help.  Thought I'd try you before I finally  
uninstall and write off the whole program as a failure.

Oh, you'll want to know:
OS/Windows XP Professional
HD/ 330GB 65% available
RAM/768MB
PROCESSOR/ Pentium 4 2.4mhz
Make: DELL Dimension 8100
My experience level: 15 years and still a beginner.
Gary Arnold
825 Collyer Street
Longmont, Colorado 80501 USA
303-772-1749
[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]



It sounds like you are using the Open' option on the same program that 
you downloaded, which is the installation program. If that is the case, 
it's doing exactly what you are telling it to do, when that program 
Opens', it installs OpenOffice on your computer for you. If you want to 
run the programs that are installed by the installation file, look on 
your Start Menu under OpenOffice.org.


--
Jack


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



Re: [users] How does one set the default font and font size on your product... it is a sweet product however,

2008-07-26 Thread Michael Adams
On Thu, 24 Jul 2008 23:08:47 -0400
1st Place wrote:

 many Microsoft Word features are missing. Uhmm. HELP!!!
 

OpenOffice.org (OO.o) is not Microsoft Word. It is a different product.
It can never hope to be better than Word if all it does is copies it,
that would leave it forever in the realms of also-ran.

Re your subject:
OO.o utilises styles far more than Word does; having character,
paragraph, list, table and page styles. So what you want to do is to
reset the default paragraph style, then save your new document as a
template. You may also wish to set the default template to your newly
saved template.

You will find all the answers you need in the writers guide and the
migration guide. Both available from the website documentation page.
http://documentation.openoffice.org/
http://documentation.openoffice.org/manuals/oooauthors2/0200WG-WriterGuide.pdf
http://documentation.openoffice.org/manuals/oooauthors2/0600MG-MigrationGuide.pdf

If you then still have a, perhaps more specific, question. Please do not
hesitate to return to the users list with it.

NOTE: Cross posting to two lists will actually reduce the number of
replies you get as many will see this no-no as time wasting and
frivolous. The discuss list is not for asking help on. Please reply only
to the users list and please reply inline (interspersed). As you are new
i add links to the relevant pages:
http://www.openoffice.org/mail_list.html
http://www.openoffice.org/ml_guidelines.html
http://en.wikipedia.org/wiki/Posting_style


-- 
Michael

All shall be well, and all shall be well, and all manner of things shall
be well

 - Julian of Norwich 1342 - 1416

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



Re: [users] PLEASE REMOVE THIS OFFICE SITE

2008-07-26 Thread Michael Adams
On Sat, 26 Jul 2008 18:20:44 -0400
James Knott wrote:

 Roy Fletcher wrote:
  Can you remove this site from my computer as it is in no way
  compatable with Windows. I can not use, or open, close my computer
  because of this office. Give me the information as to how to
  remove this site. I will have to report and inform my server of this
  situation because of the damage already done if you do not respond
  and resolve this siuation NOW.
 
  This is my fourth attempt to resolve this situation.
  I will be left with no other option than to report your site and to
  have it brought to all users attention.
 
  Expecting a response with a positive solution herewith.

 Would you please properly describe what you're talking about?  
 OpenOffice is an office suite, comparable to Microsoft Office and the 
 Windows version is most certainly compatible with Windows.  What is it
 that's happening?  What damage are you talking about?
 

Is the OP misspelling suite as Site?

-- 
Michael

All shall be well, and all shall be well, and all manner of things shall
be well

 - Julian of Norwich 1342 - 1416

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



Re: [users] PLEASE REMOVE THIS OFFICE SITE

2008-07-26 Thread Mark Knecht
Depending on which version of windows you or running simply go to the
Add/Remove programs option in the control panel and remove the
program. After that, if you prefer, reboot. Viola!

On Fri, Jul 25, 2008 at 4:10 PM, Roy Fletcher [EMAIL PROTECTED] wrote:
 Can you remove this site from my computer as it is in no way compatable with 
 Windows.
 I can not use, or open, close my computer because of this office.
 Give me the information as to how to remove this site.
 I will have to report and inform my server of this situation because of the 
 damage already done if you do not respond and resolve this siuation NOW.

 This is my fourth attempt to resolve this situation.
 I will be left with no other option than to report your site and to have it 
 brought to all users attention.

 Expecting a response with a positive solution herewith.

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



[users] Re: How does one set the default font and font size on your product... it is a sweet product however,

2008-07-26 Thread Tom Rushworth
On Thu, 24 Jul 2008 23:08:47 -0400, 1st Place [EMAIL PROTECTED]
wrote:

many Microsoft Word features are missing. Uhmm. HELP!!!

Open a text document, choose Tools - Options - OpenOffice.org Writer -
Basic Fonts (Western) 



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



Re: [users] [moderated]

2008-07-26 Thread jonathon
On Thu, Jul 24, 2008 at 6:05 PM, Lorette Heil  wrote:
 I've been attempting to open an email containing a powerpoint show and it 
 will not allow me to open it.

Are you using Solaris, BSD, Linux, AIX, ReactOS, or some unknown, and
little used operating system?  Which version of that operating system
are you using?

Are you using Elm, Thunderbird, KMail, Pine, Eudora, or some unknown,
and little used email client? Which version of that email client are
you using?

Which version of OOo are you using?

 It is asking for code numbers to be input, which your product did not contain.

Take that up with the organization that you purchased the product from.

I would like a refund of my purchase please,

You would need to take that up with the organization that you
purchased OOo from --- if indeed it was OOo.  From the description you
gave, it could be any of a plethora of programs.

What you have reached, is a mailing list whose subscribers are users
of OOo.  These subscribers voluntarily answer messages sent to the
list.  They are only able to provide support to issues and questions
that they have had either direct, or indirect experience with.

Issues regarding payments made to organizations for OOo, support, or
other products, or services,  are issues that the list subscribers are
not able to resolve, because OOo is not sold on the openoffice.org
website, nor does that site, or this list provide paid support.

Please send any response you might have to the mailing list
users@openoffice.org, which is where you sent the request I'm
responding to.

xan

jonathon
-- 
OOo can not correct for incompetence in creating documents from MSO.
Furthermore,OOo can not compensate for the defective and flawed
security measures used by Microsoft. As such, before using this
product for exams that require faulty and defective software, ensure
that you will not be unjustly penalized for the incompetence of the
organization that requires the use of software that is known to be
flawed, defective, bug-ridden, and fails to meet ISO file format
standards.

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



Re: [users] [moderated]

2008-07-26 Thread JOE Conner
OpenOffice is a FREE download from OpenOffice.org.  It does not require 
product numbers to install or use.



jonathon wrote:

On Thu, Jul 24, 2008 at 6:05 PM, Lorette Heil  wrote:
  

I've been attempting to open an email containing a powerpoint show and it will 
not allow me to open it.



Are you using Solaris, BSD, Linux, AIX, ReactOS, or some unknown, and
little used operating system?  Which version of that operating system
are you using?

Are you using Elm, Thunderbird, KMail, Pine, Eudora, or some unknown,
and little used email client? Which version of that email client are
you using?

Which version of OOo are you using?

  

It is asking for code numbers to be input, which your product did not contain.



Take that up with the organization that you purchased the product from.

  

I would like a refund of my purchase please,



You would need to take that up with the organization that you
purchased OOo from --- if indeed it was OOo.  From the description you
gave, it could be any of a plethora of programs.

What you have reached, is a mailing list whose subscribers are users
of OOo.  These subscribers voluntarily answer messages sent to the
list.  They are only able to provide support to issues and questions
that they have had either direct, or indirect experience with.

Issues regarding payments made to organizations for OOo, support, or
other products, or services,  are issues that the list subscribers are
not able to resolve, because OOo is not sold on the openoffice.org
website, nor does that site, or this list provide paid support.

Please send any response you might have to the mailing list
users@openoffice.org, which is where you sent the request I'm
responding to.

xan

jonathon
  



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