Re: openoffice oocalc import weird erorr

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Sep 8, 2010 at 11:23 PM, Ed Greshko <Ed.Greshko@xxxxxxxxxxx> wrote:
>  On 09/08/2010 08:37 PM, L wrote:
>> On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko <Ed.Greshko@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx
> 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/
-- 
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines


[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux