Re: openoffice oocalc import weird erorr

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

 



On Wed, 2010-09-08 at 22:37 +1000, L wrote:
On Wed, Sep 8, 2010 at 9:45 PM, Ed Greshko <Ed.Greshko@xxxxxxxxxxx> 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@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/

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@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]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux