Bug 150245 - Font size is reset to a default setting in Calc cell comment
Summary: Font size is reset to a default setting in Calc cell comment
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2022-08-03 07:56 UTC by machwell
Modified: 2024-01-10 22:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description machwell 2022-08-03 07:56:36 UTC
Description:
This problem exists long time. I only take an example to show how to reproduce it here.
My software: libreoffice 7.3.5.2, ubuntu 22.04, CPU AMD Ryzen 7 2700.



Steps to Reproduce:
1. Open libreoffice Calc and create a new xlsx file.
2. In cell A1 insert comment with several words and set font size 12pt. In cell A2 insert comment with several words and set font size 8pt and close the commnt.When I move mouse to A1, the font size is 12pt. When I move mouse to A2, the font size is 8pt. It is fine now.
3. Close and save the document and re-open it again. When I move mouse to A1, the font size is 12pt. When I move mouse to A2, the font size is 8pt. It looks OK.But When I try to edit comment in A2, the font size is 12pt, not 8pt. Do some changes in A2 comment and close the comment block. When move mouse to A2, the font size is still 8pt. font size is partially reset so far.
4. Close and save the document and re-open it again. When I move mouse to A2, the font size is 12pt. When I try to edit it, the font size is 12pt. font size is reset to 12pt completely. It means initial user 8pt setting is overwritten.
5. When more cell comments are inserted and modified serveral times, all the font sizes are reset, and user's settings cannot work. With different Calc versions and languages, the default font sizes may be different, but font size reset problems are same.

Actual Results:
The font sizes in Calc comment are reset to default value after the comments are edited several times and xlsx document is close and reopen.

Expected Results:
The font sizes user set in Calc cell comment can be kept, even several font sizes are used in a sanme cell comment.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.5.2 / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: en-US
Calc: threaded
Comment 1 Buovjaga 2023-01-27 10:21:44 UTC
I don't reproduce this even with 7.3. Do you still see this?

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 435cc6f4b2d61df932a1006222b699e367e4fed7
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 27 January 2023
Comment 2 machwell 2023-01-28 08:23:57 UTC
Yes. Same problem can be reproduced with exactly same test steps on my PC now. The only differece is default comment font size is 10 now, not 12.
My current libreoffice calc is v7.3.7.2. The version when I reported this case was 7.3.5.2.
Comment 3 Buovjaga 2023-01-28 10:45:10 UTC
Apologies, I was testing carelessly. I reproduce.

I bibisected the change with linux-50max repo to
https://git.libreoffice.org/core/commit/8865ed2efecd03722d10e522265f31c99b13b2bb
tdf#90812: rPr is not exported after roundtrip.

However, the change was fixing a real issue and just moved one line around, so I will not call this a regressin.