When creating a string out of several components using something like: =CONCATENATE("A string";B10;"another string") neither the
Sorry, accidentally clicked 'Submit' while still typing the description. Here again the complete description: When creating a string out of several components using something like: =CONCATENATE("A string";B10;"another string") the string cannot be formatted partially like it can be done with regular text in cells, where something like this is easily possible (using HTML markup to describe the formatting): This is a <span style="font-style: italic;">long and partially formatted</span> string. This doesn't work at all for concatenated strings.
@Elias Probst: Please attach a sample document demonstrating your needs with a "real life" example!
Created attachment 46125 [details] Example spreadsheet document using concate This is a document I quickly put together. It basically resembles the idea of a large configuration guide document we're using in a company project, where some centrally defined information (username, hostnames, certificate IDs, ...) are used over and over again during the whole configuration process. Formatting is used to highlight the relevant information in the instructions. The 2nd section in the example document which actually uses =CONCATENATE() is way harder to read due to the partially missing highlights of the relevant information than the 1st section which just uses plain text withouth any cell functions.
@Elias Probst: May I summarize that you would like to set formatting separately for each element A,B,C in the =concentrate(A;B;C)?
I'm afraid that's a current known limitation. A formula result cannot be rich rext, and text that contains several formatting runs is considered rich text.
(In reply to comment #4) > @Elias Probst: > May I summarize that you would like to set formatting separately for each > element A,B,C in the =concentrate(A;B;C)? That's correct!
(In reply to comment #5) > I'm afraid that's a current known limitation. A formula result cannot be rich > rext, and text that contains several formatting runs is considered rich text. Hmm, yes... I remember another restriction which I stumbled upon some days ago, which may be related to the general handling of formula results. Having line breaks in =CONCATENATE() is also impossible, when doing something like this: =CONCATENATE("Some text including line breaks"; A5; "And some more line- breaks") So it looks like this is a WONTFIX at the moment and needs some basic refactoring of the formula result stuff - maybe even clarification through OpenDocument standards, whether something like this is defined at all in the standard.
Might be useful for particular applications, but currently I can not see important applications used by many users. May be you should file another report for the line break observation and we will see to where that will lead?
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian