Re: [sc-dev] Contribution to OpenOffice

2006-06-23 Thread Niklas Nebel
Gerrow, Darryl wrote: 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. Validation of spreadsheet

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

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

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

2006-06-23 Thread Niklas Nebel
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

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

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

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

2006-06-23 Thread Niklas Nebel
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

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

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