Hi :) Dohhh! That wasn't off-list after all! Apols and regards from Tom :)
--- On Thu, 31/5/12, Tom Davies <tomdavie...@yahoo.co.uk> wrote: From: Tom Davies <tomdavie...@yahoo.co.uk> Subject: off-list Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv To: users@global.libreoffice.org Date: Thursday, 31 May, 2012, 12:40 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_mirow...@bentaxna.com> wrote: From: Paul D. Mirowsky <p_mirow...@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+h...@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+h...@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