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 <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


Relevant Pages

  • Re: openoffice oocalc import weird erorr
    ... my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. ... very weird when I import a csv file into openoffice calc ... Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines ...
    (Fedora)
  • Re: openoffice oocalc import weird erorr
    ... my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. ... very weird when I import a csv file into openoffice calc ...
    (Fedora)
  • openoffice oocalc import weird erorr
    ... my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. ... very weird when I import a csv file into openoffice calc ... To unsubscribe or change subscription options: ...
    (Fedora)
  • Re: openoffice oocalc import weird erorr
    ... my system is f13 2.6.34.6-47.fc13.i686 with latest openoffice. ... very weird when I import a csv file into openoffice calc ... To unsubscribe or change subscription options: ... MON060240 Roslyn MOM06-240 ...
    (Fedora)
  • Openoffice and Microsoft Office 2003 XML
    ... Microsoft Office 2003 XML files in Openoffice Calc. ... With the Openoffice version of Opensuse 10.2 this is not possible any ... Any ideas how I can get Openoffice open the XML files again? ...
    (alt.os.linux.suse)