off-list Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv

Hi :)
Don't worry.  Almost everyone uses an imperfect email client and the list can't always cope with 
all the foibles.  So, we have all fallen foul of some nasty trap that is outside of our control.  
No apology is  necessary but it's nice to see.  

Nicely handled!
Many thanks and regards from
Tom :) 


--- On Thu, 31/5/12, Paul D. Mirowsky <p_mirowsky@bentaxna.com> wrote:

From: Paul D. Mirowsky <p_mirowsky@bentaxna.com>
Subject: Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv
To: users@global.libreoffice.org
Date: Thursday, 31 May, 2012, 1:10

Feel like idiot

e-mail strips end spaces.
Dohhh!!!

Generate the same data in calc, save it as a cvs with fixed format.  I'm pretty sure when you open 
it with either Notepad or Writer (don't forget to change it to a .txt document for writer) you'll 
get same results.

On 5/30/2012 8:01 PM, Paul D. Mirowsky wrote:
> The following is the output of a Calc test document.
> Clicked on upper left block to select entire sheet.
> Right click on top of column and selected <Format cells>
> Font tab - font to fixed length font, Letter Gothic.
> Border tab - spacing to font set at zero (0)
> Clicked on upper left block to select entire sheet.
> Menu: <Format><Column><optimal width>Add 0"
> The results copied here show that there is definitely 2 spaces being added after each column.  
> Although you can't see it, go to the end of the last column and you can backspace twice.
> It is not accurate to say that Calc uses the width of the column.
>
> test_column-A1   test_column-B25  Test_column-C50  Test_column-D75
> test_column-A2   test_column-B26  Test_column-C51  Test_column-D76
> test_column-A3   test_column-B27  Test_column-C52  Test_column-D77
> test_column-A4   test_column-B28  Test_column-C53  Test_column-D78
> test_column-A5   test_column-B29  Test_column-C54  Test_column-D79
> test_column-A6   test_column-B30  Test_column-C55  Test_column-D80
> test_column-A7   test_column-B31  Test_column-C56  Test_column-D81
> test_column-A8   test_column-B32  Test_column-C57  Test_column-D82
> test_column-A9   test_column-B33  Test_column-C58  Test_column-D83
> test_column-A10  test_column-B34  Test_column-C59  Test_column-D84
> test_column-A11  test_column-B35  Test_column-C60  Test_column-D85
> test_column-A12  test_column-B36  Test_column-C61  Test_column-D86
> test_column-A13  test_column-B37  Test_column-C62  Test_column-D87
> test_column-A14  test_column-B38  Test_column-C63  Test_column-D88
> test_column-A15  test_column-B39  Test_column-C64  Test_column-D89
> test_column-A16  test_column-B40  Test_column-C65  Test_column-D90
> test_column-A17  test_column-B41  Test_column-C66  Test_column-D91
> test_column-A18  test_column-B42  Test_column-C67  Test_column-D92
> test_column-A19  test_column-B43  Test_column-C68  Test_column-D93
> test_column-A20  test_column-B44  Test_column-C69  Test_column-D94
> test_column-A21  test_column-B45  Test_column-C70  Test_column-D95
> test_column-A22  test_column-B46  Test_column-C71  Test_column-D96
> test_column-A23  test_column-B47  Test_column-C72  Test_column-D97
> test_column-A24  test_column-B48  Test_column-C73  Test_column-D98
> test_column-A25  test_column-B49  Test_column-C74  Test_column-D99
>
>
> On 5/30/2012 2:21 PM, berritorre wrote:
> > I need to generate a fixed-length ascii/text file from a table that I have.
> > Fixed length ascii seems to be the format to import in a software my client
> > uses.
> >
> > So I was fiddeling around and hat a lot of problems. Excel would export to
> > .prn just as I need it, but only for for 255 characters per line. I have a
> > few thousand columns in my spreadsheet with quite a few columns with more
> > than one character.
> >
> > In LobreOffice I found the option to export to csv with fixed length and
> > actually this would be what I am looking for. However, Libreoffice seems to
> > add a space to separate columns, which just doesn't fit with fixed-length
> > ascii, as they shouldn't have separators/delimiters. I can't just replace
> > the spaces with "nothing", as there need to be spaces in the file to fill up
> > the columns when in a column there can be for example up to 5 characters,
> > but sometimes there are less.
> >
> > So here would be a csv file with delimiter:
> >
> >
> > As a fixed length ascii file it should look like this:
> >
> >
> > But unfortunately, LibreOffice inserts some a space in front of each column.
> >
> >
> > I hope this will show up correctly now.
> >
> > -- View this message in context: 
> > http://nabble.documentfoundation.org/Problem-when-exporting-exporting-from-CALC-to-a-fixed-length-csv-tp3986825.html
> > Sent from the Users mailing list archive at Nabble.com.

-- For unsubscribe instructions e-mail to: users+help@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


-- 
For unsubscribe instructions e-mail to: users+help@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