Hi all!
I will give Andreas solution a try and also will check the other link.
Because I guess this goes out to everyone on the list everytime. I usually
don't like mailing lists. I prefer the forum style a lot more.
I had hoped that there is a simpler solution than go for formulas, because
with
Hi Andreas,
I thought I had posted loads of trivial example data. What could be a
problem is that you read this in your email program and I am writing the
posts in Nabble, where I can format the example texts and the show nicely,
because I have formatted them with a fixed length font by using the
Hi Paul!
So I did some more testing with the latest version and I still persist:
LibreOffice uses the visible width of the column to determine the fixed
width!
Here is what I did:
- Followed your instructions on how to format the cells (had done this
before already!).
- Included some text columns
Hi Andreas,
As I said, it is not a problem about editing the text file.
I need to export the data of a spreadsheet into a certain ASCII format. The
file has 1000-2000 columns and 350 rows. I don't see how a text editor can
help with this. But maybe I just don't know thos editors well enough.
Bes
Hi Paul!
I am not sure if I can follow.
In my few tests Libreoffice exportet interpreted the fixed length as the
width of the cell showing in CALC.
Unfortunately for me CALC somehow gives a little space to the left when
presenting the data and thus in the export there is a space. When I manuall
Hi!
I am running on Windows.
I am sure that with a script this could be solved easily. Actually I have
found some Excel-Macros that are supposed to do this as well. And I have
found a solution with an additional software. But as this is something any
assistent/intern here should be able to do, I
Thanks for your response.
I have tried CSVed before. Actually, I don't really want to work with the
csv files. Actually doesn't even need to be a csv file. Any ASCII text file
probably does.
It just has to have the correct format. So my client sends me a data map
where he specifies the exact widt
I just did some additional testing and it actually seem to be a formatting
problem with the LibreOffice Tables!
Before I had minized the columns to the width of each column (highlighted
and doubleclicked the columns so they would adjust). But somehow they never
adjust perfectly. There is always a
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.