Bug 160199

Summary:	FORMATTING Making text size inside Comments in LibreOffice Calc permanently changeable (Issue opening xlsx files)
Product:	LibreOffice	Reporter:	Adriano M <maggioadriano>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, miguelangelrv
Priority:	medium	Keywords:	filter:xls, filter:xlsx
Version:	7.6.5.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	127172
Attachments:	Sample docx file with formatted text in comments

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.