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
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
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: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy