how can I reference a cell containing text with linebreaks ?

-----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/wCf
XIQy
Fk4D4T6BUQYxGGaspvIzjbI=
=hE3B
-----END PGP SIGNATURE-----

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

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: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

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

Hi Peter,

>This is a known issue (30781),

thanks, next time i will ask you before asking the community


IMHO this should be treated as a bug, cause the linebreak
char is
changed into a space (code 32) ...

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


iD8DBQFEm/3wTiyrQM/QSkURAg7SAKCfRSofr+7IkzHd0jmlUtVq7fMbcACf
buhf
KSykZbJ9Vt22W70SbBhqcRk=
=+CAJ
-----END PGP SIGNATURE-----

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

Oliver Brinzing wrote:
> IMHO this should be treated as a bug, cause the
linebreak char is
> changed into a space (code 32) ...

The first cell doesn't contain a line break character. It
contains two 
paragraphs.

Niklas

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

-----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().getCel
lRangeByName("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/QSkURArlIAJwNOhJNM9DOiD7AuM0XVvrPz9H2dACg
velQ
i/SpAeNT9s1x79N6q9zmElw=
=2QER
-----END PGP SIGNATURE-----

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

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: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

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

Hi Niklas,

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

the main purpose is to fill a (merged) cell with address
data, the user selects the address data using
an java addon, the addon itself gets the data from an
external database

for some forms we have to print special drafts, so we have
to copy the address data into the draft
(e.g. another sheet in the calc document) ...

the easiest way to do so, would be, simply to reference the
address data field (the user would even
be able to edit the address data)

we don't want to split the address data into single lines,
cause we get one string (containing
paragraphs)
from the database, and we put the same string into address
frames in writer documents too ...

at the moment i am thinking about writing my first calc
addin to solve the problem 

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


iD8DBQFEnC8HTiyrQM/QSkURAlm8AJ9UY3tIg08wwwl3hpVWyXeju3/WJQCf
RmPc
1EewWw82zJCW52a+UdkCkF0=
=bOuI
-----END PGP SIGNATURE-----

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org