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 exporti
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 t
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 wh
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 b=co
Thu, 31/5/12, berritorre wrote:
From: berritorre
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 the other link.
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
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
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 mor
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
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 jus
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
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
My response was partially to the statement quoted by Miguel Angel
"
Fixed column width:
Exports all data fields with a fixed width.
/The width of a data field in the exported text file is set to the
current width of the corresponding column. /
Values are exported in the format as currently seen
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 :)
Aaargh!! Why not Emacs or Vi? or Gedit or SciTe? I'm quite enjoying Gedit at
the moment but used to prefer SciTe.
Regards from
Tom :)
--- On Wed, 30/5/12, Andreas Säger wrote:
From: Andreas Säger
Subject: [libreoffice-users] Re: Problem when exporting exporting from CALC
Hi :)
Isn't there an option for "tab delimiter"? Would that help? I'm not sure it
would tbh but it might be what 'they' are looking for.
Regards from
Tom :)
--- On Wed, 30/5/12, berritorre wrote:
From: berritorre
Subject: [libreoffice-users] Re: Problem
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
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
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
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 a
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
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
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: http://wiki.documentfou
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
25 matches
Mail list logo
