Bug 150933 - copy/paste between sheets changes font & size
Summary: copy/paste between sheets changes font & size
Status: RESOLVED DUPLICATE of bug 129890
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-13 16:48 UTC by Pierre Fortin
Modified: 2022-09-14 12:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot with comments (99.81 KB, image/png)
2022-09-13 16:48 UTC, Pierre Fortin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre Fortin 2022-09-13 16:48:40 UTC
Created attachment 182414 [details]
screenshot with comments

I have one Calc document open with all text = "Liberation Sans, 10pt".

Copy a cell, paste it into a new Calc document. Text appears much smaller as "Noto Sans, 7.2pt".

In this case, I was selecting certain column headers to copy into a new document to design a new layout.  So, after pasting a few column header labels, selected Row 1 and changed the font/size on the Formatting bar to "Liberation Sans, 12pt"; but the change did not change the visible text, even though the Formatting bar displayed as desired.  I have to select each cell in turn to force the desired font/size to display correctly.

When these column headers (the entire row) are set to "Liberation Sans, 12pt"; if I add another header cell, that cell is "Noto Sans, 7.2pt" and the Formatting bar font and size are blank as expected. 

Again, change the font/size of the row... Select the newly pasted cell, Formatting bar shows the desired font/size; but the _visible_ text is still "Noto Sans, 7.2pt"...

Now, with a cell displaying as "Noto Sans, 7.2pt" on a row set to "Liberation Sans, 12pt", right click on the cell and Clear Direct Formatting -- that cell is now "Liberation Sans, 10pt" (as from the source document)...

Result:
row:  "Liberation Sans, 12pt"
some cells:  "Liberation Sans, 12pt"; but displaying as "Noto Sans, 7.2pt"

Clear Direct Formatting on cell(s) displayed as "Noto Sans, 7.2pt":
- row:  font/size on Formatting bar now blank (cell(s) different from row)
- cells:  "Liberation Sans, 12pt"; some displaying as "Noto Sans, 7.2pt"
- cleared cell(s) format: "Liberation Sans, 10pt" displayed correctly

Select row, and set Formatting bar to "Liberation Sans, 12pt":
- "Liberation Sans, 10pt" cell(s) change display to "Liberation Sans, 12pt" 
- cells displaying as "Noto Sans, 7.2pt" do not change; likely due to already being "set" to "Liberation Sans, 12pt"
Comment 1 m_a_riosv 2022-09-13 17:19:18 UTC
Can you attach a sample file.
Comment 2 Pierre Fortin 2022-09-13 23:47:27 UTC
I just discovered another detail to reproduce it...

All you need is a plain text file (.csv) as source.
New s/s document not required; bug reproducible in same sheet:

Copy a cell and paste into another cell using various methods:
- Ctrl+c, Ctrl+v works
- Select a cell (cell is blue), middle-click paste works
- triple click a cell, Ctrl+v or middle-click paste works
- select a cell, then select the text in the Input line
   - Ctrl+v works
   - middle-click paste (bug)
Comment 3 QA Administrators 2022-09-14 03:39:22 UTC Comment hidden (obsolete)
Comment 4 Rafael Lima 2022-09-14 12:07:35 UTC
I could reproduce this using the middle-click paste.

For some reason the pasted value uses Noto Sans with size 5.8pt in my case (the source was Liberation Sans 10pt).

This is a duplicate of bug 129890.

*** This bug has been marked as a duplicate of bug 129890 ***