https://bugs.documentfoundation.org/show_bug.cgi?id=102627

            Bug ID: 102627
           Summary: Paste Special of formatted text from a table can
                    change the font
           Product: LibreOffice
           Version: 5.1.5.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: davidjudysm...@gmail.com

Created attachment 127675
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127675&action=edit
Writer document containing a table with various font effects, all in Times New
Roman.

1. In a blank LibreOffice Writer document, create a table.
2. Select all rows and columns of the table, then set the Paragraph Style to
Default Style and the Font Name to Times New Roman.
3. Enter text in the table cells.  Some text must contain both normal and
italics, bold, subscript, or other special effects.  (The attached file is an
example.)
4. Select all rows and columns of the table, then copy (Ctrl+C or Edit > Copy).
5. Create a new LibreOffice spreadsheet.  Select cell A1, then choose Edit >
Paste Special (or Ctrl+Shift+V). From the Paste Special box, choose Formatted
Text [RTF] and click OK.
6. Examine the imported cells.  Any cell with a single text type (for example,
normal text, or italics, or bold) will appear in Times New Roman.  In any cell
with two text types (for example, normal and italics), the normal text will be
in the default spreadsheet font (Liberation Sans, in my copy), and the
"special" characters will be in Times New Roman.  (It's easy to distinguish the
two by the absence or presence of serifs on the letters.)

I think that this is a problem in the way Calc pastes formatted (RTF) material
rather than the way Writer stores it, because I see the same issue when I use
Microsoft Word in steps 1-4.

Variations:
In step 2, if the Paragraph Style for the table is set to (or left at) Table
Contents, then the import in step 6 is correct, with all cells in Times New
Roman.  There's something significant about Default Style.
In step 2, the Font Name can be set to any font, and the result is the same: on
import, the cells with only one font effect, or the "special" effect in cells
with two effects, are in the selected font, and the remainder of the text is in
Liberation Sans.
If a cell in the Writer table has three different text types (normal and
italics and bold), the normal text appears in Calc in Liberation Sans font and
the others are in Times New Roman.
I haven't figured out how to change the default font of a spreadsheet to
something other than Liberation Sans.  That might be an interesting experiment.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to