Re: [sc-dev] how can I reference a cell containing text with linebreaks ?

[Niklas Nebel]

Oliver Brinzing wrote:
this is true, if one acesses the cell via basic getString() method ...
        ' result: 10 -> ok
but if one uses a formula
=CODE(TEIL(A1;6;1))
the result is 32 ... :-(

Sure, different interfaces for different uses. This by itself is not a 
problem and was done on purpose.

so i cannot use formulas to split the string and put every part in a own cell 
...

What are you trying to do? You have multiple-paragraph content in one 
cell and want to use each paragraph in a separate formula? How does the 
content get into the first cell?

in excel the code() formula returns 10 and i can format the result cell to show 
the linebreak ...

There certainly is a compatibility issue here, but so far we've 
considered it a minor one.

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]