Created attachment 127675 [details] 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.
Created attachment 127676 [details] Calc spreadsheet showing the result of the bug: cells containing more than one font effect are partly in Liberation Sans font.
Repro. This is kind of expected as it is risky to mix styles with direct formatting. (In reply to David F Smith from comment #0) > 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. Go to Styles and formatting in the sidebar, right-click Default (in Cell styles view), Modify, go to Font tab and change away. Win 7 Pro 64-bit Version: 5.3.0.0.alpha0+ Build ID: e2f6c7f0d0cc14f851d7028ff846c5dc658a81c6 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-10-10_23:08:02 Locale: fi-FI (fi_FI); Calc: group LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This bug is still present, with exactly the same symptoms as in the original report. Version: 5.3.6.1 Build ID: 686f202eff87ef707079aeb7f485847613344eb7 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group
This bug is still present, with exactly the same symptoms as in the original report. Version: 6.0.5.2 (x64) Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: en-US (en_US); Calc: group
Dear David F Smith, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 171222 [details] Calc spreadsheet showing the result, as of 15-Apr-2021 (worse results than originally) See in particular row 2, in which the italics and bold effects were not copied. These cells, which contained text in one single format (not two formats, as in later rows) lost that formatting.
The behavior is now WORSE than it was before. In my original report, the cells in row 2 of the spreadsheet copy were in italics (col A) and bold (col B), but now both cells are in normal Times New Roman, losing the special effects. The behavior in the remaining cells is similar: text with an effect (bold, italics, or bold italics) appears in the copy as normal Times New Roman, losing the effect, while the rest of the text in the cell becomes Liberation Sans font. The exception is the last two rows, in which, as reported originally, the underlined, subscript, and superscript text is correct. In summary, even in cells containing text all of which has a single font effect (bold, italics, or bold italics), that effect is lost in the Paste Special. I have attached a new spreadsheet showing this behavior. I don't know if this change has something to do with the change in Paste Special options. Originally there was an option "Formatted Text [RTF]", but now that option is gone and there's one called "Rich text formatting (RTF)". Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to David F Smith from comment #8) > Created attachment 171222 [details] > Calc spreadsheet showing the result, as of 15-Apr-2021 (worse results than > originally) > > See in particular row 2, in which the italics and bold effects were not > copied. These cells, which contained text in one single format (not two > formats, as in later rows) lost that formatting. I don't reproduce this worsening. Arch Linux 64-bit Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 5348b3946b8f2b9581cdd8b40fa774c2a9d23868 CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 16 April 2021
Buovjaga's Comment 10 prompted me to try again. Starting from my original text document, I got the same (worse) results that I reported on 15-Apr. But when I recreated the table from scratch in a new text document, then copied and pasted that into Calc, the formatting was copied (mostly) correctly. ("Mostly" means that the bold text turned into a super-wide bold format. I don't understand that.) So my original bug is now pretty much fixed, and my updated report from 15-Apr seems to be due to sometime weird in my text document. I'm changing the status to WORKSFORME. Thanks.