Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

Wow.  The Sunday response is warmly appreciated.

Re-copying from the spreadsheet into gedit
03/24/17    03/24/17        EPMT    p    $16.96    COMM Consumer Cellular
03/24/17    03/24/17        EPMT    p    $159.64    HOUS    Waste Management
03/24/17    03/29/17        EPMT    p    $330.65    COMM    Pair Networks

The copy and paste used tabs between items.  There are no spaces except 
in column H. Column B is empty and there are two tabs.  Any multiple 
spaces are probably coming through mail processing.

Selecting A418, a bare area, with a simple paste, the text import window 
comes up.
Unicode (UTF-16)
Default-English (USA)
From row 1  -+ (The -+ pair seems to be part of the background. Mousing 
them changes the "1" to another integer. I left it as 1.
Separator options Fixed width (set by the Text import window)

Separator options show "fixed width" and "tab"
I'm going to change the fixed width to "tab separated". The tab spot got 
brighter in the Text import window.
The little arrows disappeared and I now see columns easily including the 
blank C column. The import window will respond to a larger rectangle 
using the mouse.

There is also something called "text delimiter" which has been set to a 
" character. I'm going to turn that off.    But I can't, it's either ' or ".

Other options are "quoted field as text" and "detect special numbers".  
I have no idea but they are blank.

There is another option "Field column type" that doesn't seem to do 
anything.

Poking "OK"

It almost works!  The only remaining problem seems to be that the sum of 
the dollar amounts is zero. But taking the $ sign off is simple and the 
worksheet will put it back on if I repeat the currency display format.

03/24/17    03/24/17        EPMT    p    16.96    COMM    Consumer Cellular
03/24/17    03/24/17        EPMT    p    159.64    HOUS    Waste Management
03/24/17    03/29/17        EPMT    p    330.65    COMM    Pair Networks

That worked OK.

OK. I'll try to find a newer version of LibreOffice. I thought I would 
be notified by Ubuntu who wants to change stuff every morning.

In any case I think I'm happy. Thanks to all who helped.
And yes.  I would like to see "yyyy MM dd hh mm ss" here in the US of A. 
My real work is in physics where the MSB always comes first.



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted