On Wed, Sep 8, 2010 at 11:00 PM, kalinix <calin.kalinix.co...@gmail.com>wrote:
> On Wed, 2010-09-08 at 22:37 +1000, L wrote: > > On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko <ed.gres...@greshko.com> 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
