-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

how can I reference a cell containing text with linebreaks ?

example:

Cell A1:    Hello  <- linebreak (Strg) (Enter)
               World

Cell B1:   =A1

result:     Hello World

in B1 the linebreak char *changed* into a space char (code 32) !!!

In excel it is possible to get the correct result if you format B1 with the 
linebreak option ....
this also affects import/export ...

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

iD8DBQFEmjYOTiyrQM/QSkURAgf7AJ4ueCp0Tns7PcWzlcwSa7nJ7YGb/wCfXIQy
Fk4D4T6BUQYxGGaspvIzjbI=
=hE3B
-----END PGP SIGNATURE-----

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

Reply via email to