https://bugs.documentfoundation.org/show_bug.cgi?id=158890
--- Comment #7 from ady <adylo811...@gmail.com> --- 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). -- You are receiving this mail because: You are the assignee for the bug.
