Bug 90781 - Changing font size for all cells does not change the size for extra formatted strings within cells
Summary: Changing font size for all cells does not change the size for extra formatted...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 108041 (view as bug list)
Depends on:
Blocks: Cell-Direct-Formatting-Parts
  Show dependency treegraph
 
Reported: 2015-04-22 10:18 UTC by Alex
Modified: 2023-05-22 16:20 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
File to reproduce (7.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-12-12 09:39 UTC, naitsirch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alex 2015-04-22 10:18:39 UTC
maybe this is something like #64905 but it is not closed yet.

fill two cells. first one "10", second one "10 20 10", where the numbers are the size of the text and the text itself does not matter.
press CTRL + A and enter a new font size, e.g. 8
the cells will be like "8" and "8 20 8"
Comment 1 raal 2015-04-22 16:45:10 UTC
I can reproduce with

Version: 5.0.0.0.alpha0+
Build ID: 89f5c1516fd3cf96488d97f62065b1ae0bdb9efa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-18_10:10:39

LibreOffice 3.5.0 
Build ID: d6cde02
Comment 2 QA Administrators 2016-09-20 09:31:52 UTC Comment hidden (obsolete)
Comment 3 Alex 2016-10-28 19:25:48 UTC
This bug is still present in the latest version. (Windows tested)
Comment 4 Buovjaga 2017-06-20 09:20:24 UTC
*** Bug 108041 has been marked as a duplicate of this bug. ***
Comment 5 Kevin 2017-06-20 09:31:56 UTC Comment hidden (no-value)
Comment 6 Kevin 2017-06-30 06:35:12 UTC
(In reply to Buovjaga from comment #4)
> *** Bug 108041 has been marked as a duplicate of this bug. ***

The "even simpler" version of 108041 is now fixed in 5.3.4. The main 108041 bug is still active.
Comment 7 naitsirch 2017-12-12 09:39:59 UTC
Created attachment 138394 [details]
File to reproduce

I have attached a small ODS file which could be used to reproduce this issue.

The file contains two cells with content. B1 contains three lines, with the second lined formatted with font size 20.

Now select all cells (Ctrl+A) and choose e.g. size 8. You will see that everything is changed to the new font size except for the line that has font size 20. 

I'm not sure if this is the desired behavior or a bug.

Maybe this is related to #99920 ?
Comment 8 QA Administrators 2018-12-13 03:50:22 UTC Comment hidden (obsolete)
Comment 9 Alex 2018-12-13 07:46:50 UTC
Version: 6.1.2.1
Build-ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU-Threads: 8; BS: Windows 6.1; UI-Render: GL; 
Gebietsschema: de-DE (de_DE); Calc: CL

If only one cell is selected, the cell with different font sizes, the size of all the text is changed correctly.

If more than one cell is selected, the behaviour is still wrong; the text size is not changed for all text in the mixed cell.

=> stil open
Comment 10 QA Administrators 2020-12-13 03:46:42 UTC Comment hidden (obsolete)
Comment 11 Alex 2020-12-13 15:57:51 UTC
Works as expected in version Version: 6.4.6.2 (x64)
Comment 12 naitsirch 2020-12-14 13:20:34 UTC
Yes, I can confirm, too, that this bug is fixed :-)
Tested with LibreOffice 6.4.7.2 with Debian Linux.

Thanks to the developer!
Comment 13 Stéphane Guillou (stragu) 2023-05-22 16:20:38 UTC
Following the OP steps, I only see it fixed in 7.5 as a side-effect of commit ac859a4c6a7fce4efee9cdd45821a0c9e40e9e9a, which reduces the Ctrl + A selection to only cells with data.

It made me realise that results depend on the selection. Up to LO 7.4, with attachment 138394 [details]:
- Ctrl + A: bug
- Row 1: works
- Columns A:B (or even just column B): bug
- Cell range A1:B1: works

... which might be relevant to other bugs in meta bug 108662.

This is unrelated to the number of cells selected, because there is no bug when the change is applied to selected rows 1:200 (more than 3 million cells) whereas the bug is present when the change is applied to column B (just above 1 million cells).

Described behaviour same in OOo 3.3, so inherited.