Bug 155714 - Calc: when selecting the whole row and change the font size, some contents covered by other styles wouldn't be changed
Summary: Calc: when selecting the whole row and change the font size, some contents co...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
 
Reported: 2023-06-07 06:02 UTC by Franklin Weng
Modified: 2023-07-15 04:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file for this issue (23.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-07-06 05:07 UTC, Franklin Weng
Details
Screenshot (255.65 KB, image/png)
2023-07-06 05:08 UTC, Franklin Weng
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Franklin Weng 2023-06-07 06:02:50 UTC
Description:
In the sample file (attach later), when I just selected the cell E2 and set its font to 20 or other size, all the words in it would be changed.  However if I selected the whole row 2 and set its font to 20, you would see some words in E2 (and J2, L2, V2) didn't change to 20.

Steps to Reproduce:
1. Select the whole row 2
2. Change the font size to 20
3.

Actual Results:
Some words in certain cell (E2, J2, L2, V2) wouldn't be changed.

Expected Results:
All the words should be changed to font size 20


Reproducible: Always


User Profile Reset: No

Additional Info:
Earliest version test: 版本 3.6.7.2 (組建 ID:e183d5b), might be an issue inherited from OOo.

Interestingly, after version 7.3 (my testing version is 7.3.4.2), when I select the single cell (E2, J2, L2, V2) and change the font size to 20, all the words will be changed.  But before 7.2 even I select the single cell and change the font size, those words will not be changed as well.

Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW
Calc: threaded

Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW
Calc: threaded
Comment 1 ysui2022 2023-07-06 00:21:46 UTC
Could you attach a sample file? I didn't see any.
Comment 2 Franklin Weng 2023-07-06 05:07:52 UTC
Created attachment 188224 [details]
Example file for this issue

Sorry, forgot to attach the file.

In this file, select the whole row 1, and set the font size to 20, you can see in column E, J, L, N, V there are words not changing.
Comment 3 Franklin Weng 2023-07-06 05:08:14 UTC
Created attachment 188225 [details]
Screenshot
Comment 4 ady 2023-07-06 12:01:14 UTC
(In reply to Franklin Weng from comment #2)
> In this file, select the whole row 1, and set the font size to 20, you can
> see in column E, J, L, N, V there are words not changing.

Row 2 (not 1) shows some cells with partial formatting; for instance, within a cell, _part_ of the text is bold. That partially-formatted text is not modified by selecting the whole row (header) and changing the font size.

Probably there are other reports with similar context/case and similar resulting behavior. Setting to NEW for now.
Comment 5 ady 2023-07-06 12:05:50 UTC
(In reply to ady from comment #4)
> Row 2 (not 1) shows some cells with partial formatting; for instance, within
> a cell, _part_ of the text is bold. That partially-formatted text is not
> modified by selecting the whole row (header) and changing the font size.

BTW, if this behavior is changed, there is a chance that some users will complain, expecting that "partial" formatting within a cell should not be modified when applying a format to a broad range of cells.