alternative to openoffice

Discussions Regarding Software

Moderator: Moderators

alternative to openoffice

Postby johnlvs2run » Wed Dec 10, 2008 3:30

Openoffice is autocorrecting everything that I type and it's driving me batty.
I've spent hours trying to turn off the annoying feature and it keeps persisting regardless.

What would be an easy to use alternative, for word processing and spreadsheets?

Thanks.
biostar tf8200 | nvidia graphics | sabayon 5.5 lxde | sabayon 3.5 kde
| 2gb ddr2 800 dual channel sdram | 2x seagate barracuda 7200 250gb sata 3gb/s
| amd be2350 brisbane 2.1ghz 45w dual-core | hannsg hw192 monitor | earthwatts
johnlvs2run
Growing Hen
 
Posts: 132
Joined: Wed Sep 03, 2008 1:00
Location: north america

Re: alternative to openoffice

Postby WarraWarra » Wed Dec 10, 2008 3:40

Think kde office is similar but could end up doing the same.
just remove all the languages from openoffice or the dictionary's or set it to train and accept a mispelled word as default then it would not mess with that word again.
WarraWarra
Sagely Hen
 
Posts: 1989
Joined: Wed Jan 03, 2007 21:01
Location: 31.324270, -113.585511

Re: alternative to openoffice

Postby johnlvs2run » Wed Dec 10, 2008 3:59

WarraWarra wrote:Think kde office is similar but could end up doing the same.
just remove all the languages from openoffice or the dictionary's or set it to train and accept a mispelled word as default then it would not mess with that word again.



Thanks, I'll try that.

Below are examples of how it is changing my typing.
2 .......................... changes to 2.0000 or 000002.
5.629 ............. changes to 5.63 ... or 6
- 6.4 ............... changes to -6.4 ... keeps removing the space
nov08 ............. changes to 11/08/2008 ... keeps capitalizing the "n"

If anyone comes up with a way to turn the auto functions all OFF please let me know.
biostar tf8200 | nvidia graphics | sabayon 5.5 lxde | sabayon 3.5 kde
| 2gb ddr2 800 dual channel sdram | 2x seagate barracuda 7200 250gb sata 3gb/s
| amd be2350 brisbane 2.1ghz 45w dual-core | hannsg hw192 monitor | earthwatts
johnlvs2run
Growing Hen
 
Posts: 132
Joined: Wed Sep 03, 2008 1:00
Location: north america

Re: alternative to openoffice

Postby Fitzcarraldo » Wed Dec 10, 2008 5:03

From the examples you give, you appear to be having trouble mainly with OpenOffice Calc. If you want to enter text, as opposed to numerical data or date data, in all the cells of a Calc spreadsheet then do the following:

1. Left-click on the little white box above Row 1 and to the left of Column A. This will highlight all the cells on the worksheet.
2. Right-click anywhere in the highlighted area and select 'Format Cells...' from the drop-down menu.
3. On the Numbers tab, scroll down the list in the Category box and select 'Text', then click 'OK'.

Now everything you type in the spreadsheet cells will be exactly as you typed it, because it has the Text data type, not the Numerical data type or Date data type.

If you want to do this to only one or a few cells, not all cells, then just highlight the cell or cells you want and right-click on it/them and select 'Format Cells...' etc. as above.

If you want to enter a number, as opposed to text, in a cell and you want it to appear to the same number of decimal places as you entered it, then select 'Number' from the list in the Category box and 'General' from the list in the Format box and adjust the number of decimal places and leading zeros under Options. Similarly, if you want to enter a date in a cell, select 'Date' in the list in the Category box and select the format you wish for the date in the Format box.


Some additional pointers from OpenOffice Help:

Turning Off AutoFormat and AutoCorrect

By default, OpenOffice.org automatically corrects many common typing errors and applies formatting while you type.

To quickly undo an automatic correction or completion, press Ctrl+Z.

To turn off most AutoFormat features, remove the check mark from the menu Format - AutoFormat - While Typing.

To remove a word from the AutoCorrect list:
1. Choose Tools - AutoCorrect.
2. Click the Replace tab.
3. In the AutoCorrect list, select the word pair that you want to remove.
4. Click Delete.

To stop replacing quotation marks:
1. Choose Tools - AutoCorrect.
2. Click the Custom Quotes tab
3. Clear the Replace check box(es).

To stop capitalizing the first letter of a sentence:
1. Choose Tools - AutoCorrect.
2. Click the Options tab.
3. Clear the Capitalize first letter of every sentence check box.

To stop drawing a line when you type three identical characters:
OpenOffice.org automatically draws a line when you type three of the following characters and press Enter: - _ = * ~ #
1. Choose Tools - AutoCorrect.
2. Click the Options tab.
3. Clear the Apply border check box.


Turning Number Recognition On or Off in Tables
OpenOffice.org can automatically format dates that you have entered into a table, according to the regional settings specified in your operating system.
Do one of the following:
Right-click in a table cell and choose Number recognition. When this feature is on, a check mark is displayed in front of the Number recognition command.
Choose Tools - Options - OpenOffice.org Writer - Table, and select or clear the Number recognition check box.
User avatar
Fitzcarraldo
Sagely Hen
 
Posts: 7978
Joined: Sat Mar 10, 2007 5:40
Location: United Kingdom

Re: alternative to openoffice

Postby johnlvs2run » Wed Dec 10, 2008 6:36

Fitzcarraldo, that solved the issue right away.

You're a wealth of great information, thanks for sharing. :)
biostar tf8200 | nvidia graphics | sabayon 5.5 lxde | sabayon 3.5 kde
| 2gb ddr2 800 dual channel sdram | 2x seagate barracuda 7200 250gb sata 3gb/s
| amd be2350 brisbane 2.1ghz 45w dual-core | hannsg hw192 monitor | earthwatts
johnlvs2run
Growing Hen
 
Posts: 132
Joined: Wed Sep 03, 2008 1:00
Location: north america


Return to Software in General

Who is online

Users browsing this forum: No registered users and 3 guests