On 2012-06-01 06:07, Andreas Säger wrote:
OK, this comes from the Nabble interface and from your example data I come to the conclusion that all data are integers. A generic solution for up to 1024 columns may look like this: Assumed data in Data.A1:AMJ999 A1000: =MAX(LEN(A$1:$A$999)) [this is an array formula to be entered with Ctrl+Shift+Enter rather than Enter] Copy&paste A1000 to B1000:AMJ1000 (drag&drop won't do what I want in this case). Now we have an additional row with the maximum lenghts of each data column in A1:AMJ999. Other_Sheet.A1: =IF(LEN($Data.A1)<$Data.A$1000;REPT(" ";$Data.A$1000-LEN($Data.A1));"")&$Data.A1 Copy Other_Sheet.A1 to Other_Sheet.A1:AMJ999 For formatted numbers (dates, times, percent etc) replace $Data.A1 with TEXT($Data.A1;"format_string") in the respective column. Now all the cells are left padded with spaces having the same lenght as the calculated maximum lenght. Save that sheet as delimited text but with no column delimiter nor text delimiter. Clear the respective export options. -- View this message in context: http://nabble.documentfoundation.org/Problem-when-exporting-exporting-from-CALC-to-a-fixed-length-csv-tp3986825p3987174.html Sent from the Users mailing list archive at Nabble.com.
Nice solution Andreas. Steve -- For unsubscribe instructions e-mail to: firstname.lastname@example.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