Re: openoffice oocalc import weird erorr
On Wed, Sep 8, 2010 at 11:23 PM, Ed Greshko wrote: > On 09/08/2010 08:37 PM, L wrote: >> On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko 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* > > . > > > 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@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/ -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Re: openoffice oocalc import weird erorr
On Wed, Sep 8, 2010 at 11:00 PM, kalinix wrote: > On Wed, 2010-09-08 at 22:37 +1000, L wrote: > > On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko wrote: > > On 09/08/2010 07:31 PM, L wrote: > >> hi > >> my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. it is > >> very weird when I import a csv file into openoffice calc > >> > >> the csv file looks like this > >> > >> gasdd,MON05-2 > >> jxcv,MON05-18 > >> > >> > >> after imported into calc it becomes > >> > >> gasdd 05/02/10 > >> jxcv 05/18/10 > >> > >> > >> I spent many hours, finally identified this. it hurts > >> > >> anyone has explanation and fix? > > > > 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 > > > > > > > > > > > -- > > Rap is to music what Etch-a-Sketch is to art. 葛斯克 愛德華 / 台北市八德 > > 路四段 > > > > > > -- > > users mailing list > > users@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 Toyshttp://linuxishbell.wordpress.com/ > > > When you import a csv into oocalc you have the option to select your column > data type. You just select text for the second column and that's all. > > thanks, to import this text file use the oocalc default, MON060240 Roslyn MOM06-240 MON050042 Roslyn MON05-42S MON050018 Roslyn MOM05-18 MON050002 Roslyn MON05-2 MON050032 Roslyn MON05-32 MON050060 Roslyn MON05-60 MON050008 Roslyn MON05-8 MON050028 Roslyn MON05-28 M0N050040 Roslyn MON05-40S I got this MON060240 Roslyn MOM06-240 MON050042 Roslyn MON05-42S MON050018 Roslyn MOM05-18 MON050002 Roslyn 05/02/10 MON050032 Roslyn 05/01/32 MON050060 Roslyn 05/01/60 MON050008 Roslyn 05/08/10 MON050028 Roslyn 05/28/10 M0N050040 Roslyn MON05-40S Change the 3rd column from standard to Text, get the right form. I don't want this 'intelligent' changes how to change the default? -- > > > Calin > > Key fingerprint = 37B8 0DA5 9B2A 8554 FB2B 4145 5DC1 15DD A3EF E857 > > = > greenpeace free'd the mallocs > > -- > users mailing list > users@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/ -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Re: openoffice oocalc import weird erorr
On 09/08/2010 08:37 PM, L wrote: > On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko 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* . 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*. -- Q: What do agnostic, insomniac dyslexics do at night? A: Stay awake and wonder if there's a dog. 葛斯克 愛德華 / 台北市八德路四段 signature.asc Description: OpenPGP digital signature -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Re: openoffice oocalc import weird erorr
On Wed, 2010-09-08 at 22:37 +1000, L wrote: > On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko wrote: > > On 09/08/2010 07:31 PM, L wrote: > >> hi > >> my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. it is > >> very weird when I import a csv file into openoffice calc > >> > >> the csv file looks like this > >> > >> gasdd,MON05-2 > >> jxcv,MON05-18 > >> > >> > >> after imported into calc it becomes > >> > >> gasdd 05/02/10 > >> jxcv 05/18/10 > >> > >> > >> I spent many hours, finally identified this. it hurts > >> > >> anyone has explanation and fix? > > > > 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 > > > > > > > > > > > -- > > Rap is to music what Etch-a-Sketch is to art. 葛斯克 愛德華 / 台北市八德 > > 路四段 > > > > > > -- > > users mailing list > > users@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/ When you import a csv into oocalc you have the option to select your column data type. You just select text for the second column and that's all. -- Calin Key fingerprint = 37B8 0DA5 9B2A 8554 FB2B 4145 5DC1 15DD A3EF E857 = greenpeace free'd the mallocs -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Re: openoffice oocalc import weird erorr
On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko wrote: > On 09/08/2010 07:31 PM, L wrote: >> hi >> my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. it is >> very weird when I import a csv file into openoffice calc >> >> the csv file looks like this >> >> gasdd,MON05-2 >> jxcv,MON05-18 >> >> >> after imported into calc it becomes >> >> gasdd 05/02/10 >> jxcv 05/18/10 >> >> >> I spent many hours, finally identified this. it hurts >> >> anyone has explanation and fix? > > 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 > > > > > -- > Rap is to music what Etch-a-Sketch is to art. 葛斯克 愛德華 / 台北市八德 > 路四段 > > > -- > users mailing list > users@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/ -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Re: openoffice oocalc import weird erorr
On 09/08/2010 07:31 PM, L wrote: > hi > my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. it is > very weird when I import a csv file into openoffice calc > > the csv file looks like this > > gasdd,MON05-2 > jxcv,MON05-18 > > > after imported into calc it becomes > > gasdd 05/02/10 > jxcv 05/18/10 > > > I spent many hours, finally identified this. it hurts > > anyone has explanation and fix? Open up OpenOffice Help and read the entry about "date formats / avoiding conversion to". -- Rap is to music what Etch-a-Sketch is to art. 葛斯克 愛德華 / 台北市八德 路四段 signature.asc Description: OpenPGP digital signature -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
openoffice oocalc import weird erorr
hi my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. it is very weird when I import a csv file into openoffice calc the csv file looks like this gasdd,MON05-2 jxcv,MON05-18 after imported into calc it becomes gasdd 05/02/10 jxcv05/18/10 I spent many hours, finally identified this. it hurts anyone has explanation and fix? Y -- Linux Toys http://linuxishbell.wordpress.com/ -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines