https://bugs.documentfoundation.org/show_bug.cgi?id=37755
--- Comment #25 from gui <[email protected]> --- (In reply to ady from comment #24) > (In reply to gui from comment #23) > > Comment on attachment 55722 [details] > > Demo document with a clear example > > The problem, as you know, is that cell A3 is still in Number format. The > display of "###" depends on it. > > A simple workaround is for cell A3 to be formatted either as Text, or as > General/Standard, with a formula such as: > > A3: > > =CONCATENATE("Cell with number ";TEXT(A2;"0.0000");" (the same as upper) and > a long text format that should split in many lines as A1 cell") > > HTH. Yes, that's how we changed it in the documents in which we were relying on the number format wrapping, functional until version 3.3 or so. That's why I marked it as a (old ':) regression. The ### behaviour has a sense when talking about numbers: you don't want a number to be splitted as it became easy to visualize it as two stacked numbers, for example. But it seems inadequate (for me) when there are text strings, or text units trailing or leadings, as they can easily be interpreted as part of the same number description, as well as you never split the number itself. So, the desired behaviour (again, just for me) would be: split the text as needed (hyphenate as per format configuration), format the number but never hyphenate it, and if the number hasn't room enough, print the number as ### but keep the rest of the text splitted around. So, with enough room, it should print as (p.e. a 0,000000000000000000"gr" format, with Spanish locale used with coma as decimal separator): 12,345746732345234645gr Or: 12,345746732345234645 gr But without enough room, it could look as: ###gr Or: ### gr I know there's no way to hyphenate a number; said just to clearly expose the criteria. -- You are receiving this mail because: You are the assignee for the bug.
