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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
