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
: Problem when exporting exporting from CALC to
a fixed length csv
To: users@global.libreoffice.org
Date: Wednesday, 30 May, 2012, 20:15
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
when exporting exporting from CALC to
a fixed length csv
To: users@global.libreoffice.org
Date: Wednesday, 30 May, 2012, 19:35
Spreadsheets are horrible text editors.
Try this one instead: http://csved.sjfrancke.nl/
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
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.
Hello,
As already stated, spreadsheet programs are horrible text editors.
This is my fixed length output of a spreadsheet copied from a text editor:
000123 2012-05-130.57715one_char
000124 2012-05-140.58904two_char
000125 2012-05-170.86385three_char
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
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
On 2012-06-01 02:34, berritorre wrote:
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
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
Am 31.05.2012 20:07, Andreas Säger wrote:
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]
Small but important correction: =MAX(LEN(A$1:A$999))
By the way: http://user.services.openoffice.org is a
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
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
berrito...@gmail.com wrote:
From: berritorre berrito...@gmail.com
Subject: [libreoffice-users] Re: Problem when exporting exporting from CALC to
a fixed length csv
To: users@global.libreoffice.org
Date: Thursday, 31 May, 2012, 21:27
Hi all!
I will give Andreas solution a try and also will check
Hello berritorre
I have setmy email for fixed width in hopes that this test will be clearer.
The table below is a direct copy from Calc using the commands I spoke
of. Letter Gothic typeface.
No override of default in formatting. (assuming it is defined on import)
The headers are a=column1
Paul D. Mirowsky wrote
Sorry but must advise using a different program as filter for export.
I do not know if importing data to a Base file would export in fixed
length or if it did, would be correct.
Paul
Of course some database engine is by far more suitable, particularly when it
On 05/31/2012 09:17 AM, berritorre wrote:
Hi Andreas,
I thought I had posted loads of trivial example data. What could be a
Actually if you are referring to:
So here would be a csv file with delimiter:
As a fixed length ascii file it should look like this:
it didn't make it through to
On 05/31/2012 06:29 PM, NoOp wrote:
On 05/31/2012 09:17 AM, berritorre wrote:
...
I think Paul got my problem. LibreOffice shouldn't add any spaces in the
first place, as long as it is not told to do. Because the spaces actually do
not exist in the data and are only added for exporting the
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
Spreadsheets are horrible text editors.
Try this one instead: http://csved.sjfrancke.nl/
--
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:
Hi,
On 05/30/2012 02:27 PM, berritorre wrote:
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
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
On 2012-05-31 07:15, berritorre wrote:
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
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
El 30/05/12 21:15, berritorre escribió:
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
24 matches
Mail list logo