-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Niklas,
> The first cell doesn't contain a line break character. It contains two
> paragraphs.
this is true, if one acesses the cell via basic getString() method ...
example:
A1 = Hello
World
Sub Test()
Dim s as String
s =
ThisComponent.getCurrentController().getActiveSheet().getCellRangeByName("A1").getString()
msgbox asc(mid(s,6,1))
' result: 10 -> ok
End Sub
but if one uses a formula
=CODE(TEIL(A1;6;1))
the result is 32 ... :-(
so i cannot use formulas to split the string and put every part in a own cell
...
in excel the code() formula returns 10 and i can format the result cell to show
the linebreak ...
regards
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFEnCADTiyrQM/QSkURArlIAJwNOhJNM9DOiD7AuM0XVvrPz9H2dACgvelQ
i/SpAeNT9s1x79N6q9zmElw=
=2QER
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
