On Thu, 2005-01-20 at 08:40 +1100, Jonathon Coombes wrote: > On Wed, 2005-01-19 at 10:23 -0500, G. Roderick Singleton wrote: > > On Wed, 2005-01-19 at 06:12 -0600, Kent Tenney wrote: > > > That's it Jonathan. > > > > > > Fixed field length is evidently used very rarely, hence not > > > not a lot of effort in supporting it. > > > > > > Each row of the import file is 884 characters, comprising 82 columns. > > > Bringing it into Calc consists of setting each of the 82 column > > > dividers manually. > > > > > > > > > > Oh I see you want OOo to intuitively to know and understand the > > divisions when opening your file. I do not see how any program can do > > that as you must know and understand the table layout from which the > > fixed fields come. When you open your file in Calc as fixed field you > > must set the proper boundaries manually each time or get the source > > database to delimit the fixed fields. > > > > That would be nice, but not necessarily impossible. Microsoft Excel > for example does a text-to-columns feature when importing these > types of files and although not perfect, can be adjusted quickly to > the right effect. > > I understand that currently we have to set the fixed width details > when importing, its just a hassle when you are doing it to multiple > reports continuously during the day. An off the top of my head > example of enhancment - with the fixed-width option, allow the user > to load an xml file detailing the column widths or breakdown in some > way. This means that you do it once, and then simply load the two > files together when you import it next time. > > Regards > Jonathon
+1 Can I leave the RFE with you guys? Here is a quick howto get started: If you haven't already registered, do the following: To file an issue you must register with OOo by clicking the Register link at the top right of www.openoffice.org, filling in your information and replying to the confirmation email that will be sent to the address you provided. Once you have confirmed, go to www.openoffice.org again and click on the "Bugs & Issues" link in the General links box. Thanks for bringing this to our attention. It is important that you file the issue to ensure reproducibility with your examples. -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
