Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
-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/WJQCfRmPc 1EewWw82zJCW52a+UdkCkF0= =bOuI -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
-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().getCellRangeByName("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/QSkURArlIAJwNOhJNM9DOiD7AuM0XVvrPz9H2dACgvelQ i/SpAeNT9s1x79N6q9zmElw= =2QER -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
-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+7IkzHd0jmlUtVq7fMbcACfbuhf KSykZbJ9Vt22W70SbBhqcRk= =+CAJ -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] how can I reference a cell containing text with linebreaks ?
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]