https://bugs.documentfoundation.org/show_bug.cgi?id=158890
--- Comment #8 from [email protected] --- (In reply to ady from comment #7) > I just performed a test. Whether it is of any utility or validity, IDK. > > 1. In Calc: > A1: =1&UNICHAR(HEX2DEC(2007))&1 > A2: =1&UNICHAR(HEX2DEC(20))&1 > > Note that the result is text containing U+2007 and U+0020 respectively, not > a formatted numeric value using "?" as part of its number format code. > > 2. Select both cells and copy them. > 3. Open some simple text editor. On MS Windows this could be notepad.exe. > 4. Paste the previously-copied cells into the text editor. > 5. For the text editor, select the (previously-pasted) text and apply a > basic font that doesn't support U+2007. On MS Windows, this could be, for > instance, the old "Courier" (not to be confused with "Courier New"). > > The result in the text editor shows a special symbol in place of the > original U+2007 character. > > IDK whether this procedure shows some kind of potential problem when either > exporting or importing data when the rendered characters would include > U+2007 (instead of the common space character U+0020). I just wanted to > share the results, just in case. > > I still don't know what other spreadsheet tools do (or rather, how the > result is rendered) with the "?" format code when using "proportional" > fonts. This is important, so users won't complain about seeing different > rendered results (or exported formats, such as in PDFs or HTMLs). This would not be a problem with custom formats (which is being discussed here) where this is applied as a spacing character for display purposes (including the current way it is) since it is Only visual formatting. When copying a cell, formatting is Not copied at all, only the actual inputted value that the cell contains. For example, if a cell is formatted to represent negative values with round brackets (commonly referred to as parenthesis marks), when you copy a cell containing "-23" as a value — displayed as "(23)" in the cell — and then paste it into a text editor, what was copied and then pasted is cells value of "-23", not the formatted/displayed "(23)". -- You are receiving this mail because: You are the assignee for the bug.
