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

[Peter Eberlein]

Hi Oliver,

Oliver Brinzing schrieb:

-----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

This is a known issue (30781),

Peter

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