Re: email address formatting in Calc

[Don Daugherty]

On 3/31/2014 7:21 PM, phalbe henriksen wrote:

Hi.

I have a Calc spreadsheet that contain about 400 email addresses. They are
formatted as plain text, hyper-linked in blue and underlined, and
hyper-linked in blue, underlined with a gray background.

How can I change the special formatting and make them all plain text?
Nothing I've tried works.

Thanks.

Phalbe Henriksen
working on 50th class reunion


You might try using Paste Special, i.e.,
1.  Create a new sheet in the same spreadsheet file
2.  On the page containing the email addresses select the block of cells 
containing the addresses and press Ctrl+C.
3.  Then go to the new page and press Shift+Ctrl+V (or Click Edit > 
Paste Special...).  This brings up the Paste Special dialog box.  Under 
Select, check Text, Numbers, and Date&Time, and uncheck all other 
choices.  Under Options nothing should be checked; under Operations only 
None should be dotted, and under Shift Cells only Don't Shift should be 
dotted.  Click OK.


If this does what you want, you can replace step 3 with
3'.  Press Shift+Ctrl+V (or Click Edit > Paste Special...).  This brings 
up the Paste Special dialog box.  Under Select, check Text, Numbers, and 
Date&Time, and uncheck all other choices.  Under Options nothing should 
be checked; under Operations only None should be dotted, and under Shift 
Cells only Don't Shift should be dotted. Click OK.  In other words, you 
can Paste Special back into the original cells, thus  converting them to 
the desired  format.



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

[upscope]

On Wednesday, April 02, 2014 05:16:52 PM Daleep Koshal wrote:
> Hi
> 
> I have just down loaded Openoffice.
> 
> How do I open spreadsheets in the QuattroPro with extension .wb3 with
> open office?
> 
> Please revert
> 
> Regards
> 
> Daleep Koshal
> 
> 
> ---
> List Conduct Guidelines:
> http://openoffice.apache.org/list-conduct.html To unsubscribe,
> e-mail: users-unsubscr...@openoffice.apache.org For additional
> commands, e-mail: users-h...@openoffice.apache.org
Does Qpro allow you to save your spreadsheet as a .wb2 file? If it does 
check Openoffice and see if allows you to open .wb2 files. I use 
LibreOffice and it will open a wb2 file. Another choice would be save 
your spreadsheet as a .csv file then use OO to open it.

Hope this helps.
Russ
-- 
openSUSE 13.1(Linux 3.11.10-7-desktop x86_64|
Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3|
GeForce 8400GS (NVIDIA-Linux-x86_64-331.49)|KDE 4.12.3


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Impossibility to open documents

[Christelle]

I have noticed that it's impossible to open registered documents. And this is 
not the first time. What's the problem ?Rgrds   

Re: Impossibility to open documents

[johnny smith]

On Thu, 03 Apr 2014 19:16:39 -, Christelle  
wrote:


I have noticed that it's impossible to open registered documents. And this is 
not the first time. What's the problem ?Rgrds


please give more info. what do 'registered documents' mean? how is it 
impossible to open them (by double clicking, dragging, through the open 
dialogue etc.)? what message does openoffice give to inform you that opening is 
impossible? is anything opened after all (e.g. a mess of symbols, or strings of 
squares, or nothing at all)? please be more specific. as of now, nothing is 
clear.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Impossibility to open documents

[Martin Groenescheij]

On 4-4-2014 6:16, Christelle wrote:

I have noticed that it's impossible to open registered documents.

And how did you notice it?

And this is not the first time.

So is there a pattern?

What's the problem ?
How could we know if you don't tell us what application you use, which 
Operating System, what document type etc?

Rgrds   



---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

border line for total

[Chris Dowling]

Hi


How do I put a line under a number to indicate it is a total or subtotal?

Thanks and regards

Chris






Sent from Windows Mail

Re: border line for total

[Alan B]

On Thu, Apr 3, 2014 at 6:13 PM, Chris Dowling wrote:

> How do I put a line under a number to indicate it is a total or subtotal?
>

Ctrl+u  will underline a selection in pretty much every program I know of.
So select the number and press Ctrl+u

If you're using Calc and mean to put a bottom border on the cell containing
the number rather than underlining the number itself then do the
following...
- select the cell
- pick "Format | Cells..." from the menu
- click the "Borders" tab
- set the attributes for the underline from the options displayed

Re: border line for total

[Brian Barker]

At 22:13 03/04/2014 +, Chris Dowling wrote:

How do I put a line under a number to indicate it is a total or subtotal?


That depends on where you are!  Are you in a text (Writer) document, 
in a table in a text document, or perhaps in a spreadsheet?


In a spreadsheet:
o Select the relevant cell.
o Go to Format | Cells... | Borders (or right-click | Format Cells... 
| Borders).
o Under Line arrangement | User-defined, click at the bottom to 
indicate that you want the border only at the bottom of the cell.

o Under Line | Style, select your preferred line style and thickness.

Alternatively, you can click the down-arrow next to the Borders icon 
in the Formatting toolbar and select the icon for bottom border 
only.  This will give you the line but no option to select its 
style.  In addition, at Format | Cells... | Font Effects | 
Underlining you can select various styles of underlining.  Or you can 
use the Underline icon in the Formatting toolbar.  But note that 
underlining underlines only the value in the relevant cell, whereas a 
border extends the fill width of the cell - which I'd guess is what you want.


Underlining is also available in a text document, of course.  In a 
table in a text document, underlining of the value is available, but 
again you can alternatively apply a bottom border to a entire cell.


I trust this helps.

Brian Barker


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Product Key

[Philippe Liniere]

Hi,
I've been using open office for a while now but it keeps asking me for a 
product key to continue everytime I want to go back into a document to 
either edit or change it.

How do I get a product key? or what can I do to rectify this problem?
Looking forward to having your assistance, Thank you
Kind Regards,
Philippe

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Problems with files

[Philippe Liniere]

Hi,
Why is microsoft word hijacking my files? it appears that when I save a 
file it saves it in word as an odt file and then when I want to retrieve 
it and open the file it ask me for a product key. Can you help me out? 
Thank you

Kind regards,
Philippe

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Typo in your EUL

[Susannah Goldberg]

Hi,
I noticed a typo in your EUL. I don't know if you care, but I thought I'd
let you know just in case.

In the "COOKIES" section, you have a sentence that reads:

"Although marketing company manages the information generated from the
Site, controls how that data may and may not be used."

Thanks for the great software!

Sincerely,
 *Susannah Goldberg*



*Don't forget to SMILE *
*Don't be afraid to SING*
*&**Remember to LAUGH!*
*---*
*"Charity never faileth."* ~Mormon & Paul (Moroni
7:46;
1 Corinthians 13:8 )

Re: Product Key

[James Knott]

Philippe Liniere wrote:
> Hi,
> I've been using open office for a while now but it keeps asking me for
> a product key to continue everytime I want to go back into a document
> to either edit or change it.
> How do I get a product key? or what can I do to rectify this problem?
> Looking forward to having your assistance, Thank you
> Kind Regards,
> Philippe

There is no product key for OpenOffice, if you downloaded it from
www.openoffice.org.  You must have got it from somewhere else.  Did you
by chance pay for it?  It should be a free download.


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Product Key

[Alan B]

On Thu, Apr 3, 2014 at 8:07 PM, Philippe Liniere
wrote:

> I've been using open office for a while now but it keeps asking me for a
> product key to continue everytime I want to go back
>

It should not do that.

Download and install OpenOffice from the official site and you won't
encounter such problems. OpenOffice from this site, the actual
publisher/maintainer of the product, is free and doesn't have any
license/activation features in it.
https://www.openoffice.org/

If you did get it from the official site then... I'm stumped.

Re: Typo in your EUL

[Steve Ahlers]

I searched the Apache License for the word "cookies" and did not find it.

Did you download your software from the official site www.openoffice.org, where 
it is free or did you download it from some other site?

Steve
Sent from my iPad

On Apr 3, 2014, at 6:36 PM, Susannah Goldberg  
wrote:

> Hi,
> I noticed a typo in your EUL. I don't know if you care, but I thought I'd
> let you know just in case.
> 
> In the "COOKIES" section, you have a sentence that reads:
> 
> "Although marketing company manages the information generated from the
> Site, controls how that data may and may not be used."
> 
> Thanks for the great software!
> 
> Sincerely,
> *Susannah Goldberg*
> 
> 
> 
> *Don't forget to SMILE *
> *Don't be afraid to SING*
> *&**Remember to LAUGH!*
> *---*
> *"Charity never faileth."* ~Mormon & Paul (Moroni
> 7:46;
> 1 Corinthians 13:8 )

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

help! unlock my file

[Sumera Shakir]

Hello,

I don’t know what to do.  This is the second time I am writing a paper and when 
I go to open it. It won’t open in OpenOffice.
It will open in TextEditor but it only shows part of it.

I don’t know whats going on.  I have a Mac.

Please help me.  

thank you
Sumera Shakir
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

unlock my file part 2

[Sumera Shakir]

Hello again,

I wrote earlier about my paper not opening.  It is an .rtf file.  When I go to 
open it, it says there is a General input/output error.  I tried a Command -I 
and it shows that the file is not locked.

Please respond as soon as possible..

Thank you very much again
Sumera Shakir
201-618-8850
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: unlock my file part 2

[Tubular]

Howdy, I do not use a mac; however, the .rtf is a MS priority format.  
Are you running Windows something on your Mac?  If so, have you tried 
opening Open Office under the Windows application then search / open 
your document?


Is it possible this document was saved as .doc (example) then renamed 
via an Explorer type program?   As you can tell, I am a Windows user.


Sorry, I could not be more helpful . . .




Sumera Shakir wrote:

Hello again,

I wrote earlier about my paper not opening.  It is an .rtf file.  When I go to 
open it, it says there is a General input/output error.  I tried a Command -I 
and it shows that the file is not locked.

Please respond as soon as possible..

Thank you very much again
Sumera Shakir
201-618-8850
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2241 / Virus Database: 3722/6792 - Release Date: 04/03/14



  

pasting a document!

[Thomas Radovnikovic]

Hello,my right click  facility  to paste has vanished.Please help!
Regards Thomas

Re: Problems with files

[Tubular]

Philippe, I am not sure if someone responded to your request yet.

If I were you, I would uninstall the version of OpenOffice, scan my 
entire system for virus, Trojan, spywear and other unwanted programs 
that interfere with your system. 

Next, I would go to the OpenOffice home page 
(http://www.openoffice.org/) - download OpenOffice as this is the 
original program and does not contain extra programs, requests for 
product code, request for product key . . .





Philippe Liniere wrote:

Hi,
Why is microsoft word hijacking my files? it appears that when I save 
a file it saves it in word as an odt file and then when I want to 
retrieve it and open the file it ask me for a product key. Can you 
help me out? Thank you

Kind regards,
Philippe

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org