We have a Spotfire Dashboard that is using a Graphical Table. One of the columns, is Notes, that contains a long line of text. The text column is truncated at the column width and ends with '....'. We are looking for is the text to get word wrapped.
| Implemented in | 10.2 |
it looks like the column headers also cannot be wordwrapped. Can Tibco take the wordwrap functionality of the CrossTable and add it as an option, to the GraphicalTable?
Currently you need to wrap the text yourself. Create a calculated column and apply the expression below. In this example the text in the existing column YOUR_COLUMN wraps after maximum 50 characters (but not within a word) and does this as often as needed. In case there are already line breaks contained in the text, they are removed first with the substitute method to turn them into white spaces.
RXReplace(Substitute(Trim([YOUR_COLUMN]),"\r\n"," "),"(.{1,50})( +|$\n?)|(.{1,50})","$1\r\n","g")