On Monday 31 December 2007 10:47:47 [EMAIL PROTECTED] wrote:
> Dan Lewis wrote:
> > On Monday 31 December 2007 08:49:10 [EMAIL PROTECTED] wrote:
> >> Hi all,
> >>
> >> I am migrating *.txt data from one system to another. There are a lot of
> >> columns with numbers in them (e.g. "1.80")
> >> When I open it with Calc, it converts it to a date (01.01.80). 1.62
> >> becomes 01.01.62, and 2.12 becomes 02.12.07
> >>
> >> How do I shut this off?! I hate automation! I dropped excel, because it
> >> is worse, it was automating everything, like dropping leading zeros,
> >> etc.
> >>
> >> With the txt or csv import I ensure all fields are defined as "text" and
> >> not as "standard", but Calc displays it as dates despite my definition.
> >>
> >> TIA
> >>
> >> :-)
> >>
> >> Al
> >>
> >>
> >> I wish all a Prosperous New Year - a quick help will start mine as
> >> prosperous al well.
> >
> > Is there a way to define these columns as numbers when you import
> > the file?
> >
> > Dan
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> Hi Dan,
>
> yes, it is. I have the problem that I am porting French, German and
> English characters all in one file, with the numbers that uses dot for
> the decimal. In the imported system there the comma is used for decimal.
> Besides that, I have to use utf8 for exporting the code pages correctly,
> but the import system only understands M$ ('*°°&%$%) code pages. I have
> now managed to export a file in just *.txt, and avoided using any office
> products. It worked for now. There are more language dependent pages to
> do next week or so. I will then come back to the problem.
>
> The auto conversion seems also different when using OO-Calc on Windows
> or Linux. The code pages are different for Linux, which does not seem to
> be able to convert the M$ ('*&$§/&") stuff. I will look into it more
> closely when the going live pressure is low next month.
>
> Thanx for the help so far. We are now close to new year here in the EU.
> Must go now; lots of wine and snacks waiting ....
>
> !! Have a peaceful and blessed new year ye all !!
>
> :-)
>
> Al
When you complete your holiday celebration, could you send me an example
of a file with these problems? I would like to see if I can find a way to
apply styles to the Calc sheet and solve the problem. I can not promise that
anything I try will work, but it might be worth a shot.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
