Noelson Duarte wrote: > Hi, > > I'm linking a fixed lenght txt file, without string delimiters, to a > spreadsheet by macro. In one column exist text and numbers, so I'm using the > Standard type. All it is ok, except when a field start with = character. In > this case, diferent kinds of errors are displayed into cells (eg: Error > 510). > > Is there a way, other than setting the type to String, to avoid this?
I'm not a Calc expert but I assume that a cell starting with a "=" is automatically interpreted as a cell containing a formula. So I think that it's necessary to tell it that the cell actually contains a string. Ciao, Mathias -- Mathias Bauer (mba) - Project Lead OpenOffice.org Writer OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't reply to "[EMAIL PROTECTED]". I use it for the OOo lists and only rarely read other mails sent to it. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
