Arch Linux

andre.ramaciotti

Member

From: Brazil

Registered: 2007-04-06

Posts: 649

[solved] OpenOffice 3.0 Calc formatting problem

I installed OOo 3.0 and everything went fine, so I started to test and see what is new. As I'm learning genetics, I did a simple table with:

AA    |    25%
Aa    |    50%
aa    |    25%

But when I type "Aa" or "aa", it changes to "AA". Is there a way to turn this "feature" off?

Last edited by andre.ramaciotti (2008-10-11 16:10:50)

---

(lambda ())

Radek

Member

From: Warsaw in Poland

Registered: 2006-08-20

Posts: 23

Website

Re: [solved] OpenOffice 3.0 Calc formatting problem

Yes. Choose Tools -> AutoCorrect -> Options tab.

---

"Physics is like sex: sure, it may give some practical results, but that's not why we do it."
Richard P. Feynman.

andre.ramaciotti

Member

From: Brazil

Registered: 2007-04-06

Posts: 649

Re: [solved] OpenOffice 3.0 Calc formatting problem

It didn't work.

The problem is that when you type something that has already been written on the same column before, it uses the same case that was used in the first time.

If you type:

About
ABOUT
about

It will show:

About
About
About

---

(lambda ())

Radek

Member

From: Warsaw in Poland

Registered: 2006-08-20

Posts: 23

Website

Re: [solved] OpenOffice 3.0 Calc formatting problem

You can start word with apostrphe ('). Then 'ABOuT, 'aBOuT will be ABOuT, aBOuT.

---

"Physics is like sex: sure, it may give some practical results, but that's not why we do it."
Richard P. Feynman.

andre.ramaciotti

Member

From: Brazil

Registered: 2007-04-06

Posts: 649

Re: [solved] OpenOffice 3.0 Calc formatting problem

That did the trick. Thank you

---

(lambda ())