Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.