Bug 160199 - FORMATTING Making text size inside Comments in LibreOffice Calc permanently changeable (Issue opening xlsx files)
Summary: FORMATTING Making text size inside Comments in LibreOffice Calc permanently c...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: XLSX-Comments
  Show dependency treegraph
 
Reported: 2024-03-14 09:33 UTC by Adriano M
Modified: 2024-05-20 17:41 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample docx file with formatted text in comments (6.57 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-03-16 10:12 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Adriano M 2024-03-14 09:33:39 UTC
Description:
Why isn’t it possible to customize and then permanently save the font size within a Comment in LibreOffice Calc? Currently the font size is set to a default 10 which apparently is not changeable. For example if you reduce it to 8, then save and close the spreadsheet, and later reopen that same spreadsheet the font size is automatically reset again to 10. Can you please fix this bug so that the user, and not Calc, sets the chosen font size permanently? Thanks.

Steps to Reproduce:
1. Set a new font size inside a Comment in LibreOffice Calc.
2. Save and close the spreadsheet with the font size of your choosing.
3. Reopen said spreadsheet, and your font size is reset by Calc to standard 10.

Actual Results:
After reopening a spreadsheet with the user's previously chosen text size in Comments (for example 8) Calc eliminates it and resets it to default 10.

Expected Results:
Text size in Comments is automatically reset to default 10.


Reproducible: Always


User Profile Reset: No

Additional Info:
Text size in Comments should be left to size 8.
Comment 1 DuyN 2024-03-14 15:29:49 UTC
Thank you for reporting the bug. I've followed the steps you provided but I can not reproduce the bug in

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3ba85b7786663da4f2de1a3c2fe7ee9a27657293
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 2 m_a_riosv 2024-03-16 10:12:54 UTC
Created attachment 193139 [details]
Sample docx file with formatted text in comments

What file format do you use to save, it works saving in ods format but not with docx format.

Opening on Excel shows the formatted comments. So seems the issue is at opening with LibreOffice saved as docx format.

Reproducible:
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3ba85b7786663da4f2de1a3c2fe7ee9a27657293
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Version: 24.2.2.1 (X86_64) / LibreOffice Community
Build ID: bf759d854b5ab45b6ef0bfd22e51c6dc4fb8b882
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Opens fine with:
Microsoft® Excel® para Microsoft 365 MSO (versión 2402 compilación 16.0.17328.20124) de 64 bits
Comment 3 m_a_riosv 2024-03-16 10:14:07 UTC
(In reply to m_a_riosv from comment #2)
> Created attachment 193139 [details]
> Sample docx file with formatted text in comments
> 
> What file format do you use to save, it works saving in ods format but not
> with docx format.
sorry xlsx format.
Comment 4 Adriano M 2024-03-19 08:11:15 UTC
Thank you very much m_a_riosv. You're right, if the file is saved in LibreOffice’s native .ODS format than the text size remains as I set it. Unfortunately, this doesn't work with the traditional .XLSX format. Let’s hope this limitation will be solved in the future. Thanks again.