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

2006-06-22 Thread Oliver Brinzing
-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]



Re: [sc-dev] Disabling cell updates

2006-06-22 Thread Kohei Yoshida

On 6/20/06, Niklas Nebel [EMAIL PROTECTED] wrote:


You can use lockControllers / unlockControllers from the document's
XModel interface.


It amazingly works well.  Thanks a lot!

Kohei

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



[sc-dev] Contribution to OpenOffice

2006-06-22 Thread Gerrow, Darryl








I am looking to contribute to the projects of:



- OpenOffice.org Calc: Validation of
spreadsheet functions

- OpenOffice.org Platform Technology:
Layout Manager Widget





Please let me know how I can join and help in these
projects. Thanks.





Darryl Gerrow, BMath 
Accountant
Assurance and Business Advisory Services

Grant
Thornton LLP 
P.O. Box 1054
4th Floor - 570 Queen Street
Fredericton, NB E3B 5C2

T (506) 458 - 8200
F (506) 453 - 7029
E [EMAIL PROTECTED] 
W www.GrantThornton.ca 










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

2006-06-22 Thread 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]