openoffice oocalc import weird erorr

[L]

On Wed, Sep 8, 2010 at 11:23 PM, Ed Greshko <Ed.Greshko at greshko.com> wrote:
>  On 09/08/2010 08:37 PM, L wrote:
>> On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko <Ed.Greshko at greshko.com> wrote:
>>>
>>> Open up OpenOffice Help and read the entry about "date formats /
>>> avoiding conversion to".
>> could you show more details? I can't find this entry
>>
>> thank
>
>
>  Deactivating Automatic Changes
>
> By default, OpenOffice.org automatically corrects many common typing
> errors and applies formatting while you type. You can immediately undo
> any automatic changes with Ctrl+Z.
>
> The following shows you how to deactivate and reactivate the automatic
> changes in OpenOffice.org Calc:
>
>
>    Automatic text or number completion
>
> When making an entry in a cell, OpenOffice.org Calc automatically
> suggests matching input found in the same column. This function is known
> as *AutoInput*.
>
>   1.
>
>      To turn the AutoInput on and off, set or remove the check mark in
>      front of *Tools - Cell Contents - AutoInput*
>      <vnd.sun.star.help://scalc/text/scalc/01/06130000.xhp?Language=en-US&System=UNIX&UseDB=no&DbPAR=scalc>.
>
>
>    Automatic conversion to date format
>
> OpenOffice.org Calc automatically converts certain entries to dates. For
> example, the entry *1.1* may be interpreted as January 1 of the current
> year, according to the locale settings of your operating system, and
> then displayed according to the date format applied to the cell.
>
> To ensure that an entry is interpreted as text, add an apostrophe at the
> beginning of the entry. The apostrophe is not displayed in the cell.
>
>
>    Quotation marks replaced by custom quotes
>
> Choose *Tools - AutoCorrect Options*. Go to the *Custom Quotes* tab and
> unmark *Replace*.
>
>
>    Cell content always begins with uppercase
>
> Choose *Tools - AutoCorrect* *Options*. Go to the *Options* tab. Unmark
> *Capitalize first letter of every sentence*.
>
>
>    Replace word with another word
>
> Choose *Tools - AutoCorrect* *Options*. Go to the *Replace* tab. Select
> the word pair and click *Delete*.
>
>
thanks a lot, that answered some of my other questions too.

how to change default at import. It hurts a lot unless I do check
column every import.




> --
> Q: What do agnostic, insomniac dyslexics do at night? A: Stay awake and
> wonder if there's a dog. 葛斯克 愛德華 / 台北市八德路四段
>
>
> --
> users mailing list
> users at lists.fedoraproject.org
> To unsubscribe or change subscription options:
> https://admin.fedoraproject.org/mailman/listinfo/users
> Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
>
>



-- 
Linux Toys
http://linuxishbell.wordpress.com/