Bug 163998 - Font style transparency lost upon save and reopen calc file
Summary: Font style transparency lost upon save and reopen calc file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
 
Reported: 2024-11-22 20:22 UTC by fa.libreoffice
Modified: 2025-11-05 22:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Style-font-transparency-lost-upon-reopen.ods (16.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-11-22 22:55 UTC, fa.libreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description fa.libreoffice 2024-11-22 20:22:06 UTC
Description:
Changing a font style to a transparency percentage does not survive closing and reopening the document: the font transparency percentage is reset to zero upon reopening the saved calc doc.

Steps to Reproduce:
1. Edit style Default (or any custom style) > Font Effects > Font colour: blue (or any colour), transparency 80 % (any %).
2. Klick ok. The blue font is correctly shown as [80 %] transparent.
3. Save and close document.
4. Reopen same document. The transparency is now lost.

Actual Results:
Font transparency is lost after reopening a saved calc doc.

Expected Results:
Font transparency is permanent upon saving calc doc.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-CH (en_GB.UTF-8); UI: en-GB
Debian package version: 4:24.8.3-1~bpo12+1
Calc: threaded

---->
Reconfirmed by user Hrbrgr, see 
https://ask.libreoffice.org/t/114216
on ANOTHER OS: 
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Comment 1 Henry G. 2024-11-22 22:10:10 UTC
Hello, I was not able to reproduce the issue you described. I am using the same version. I had text set to color blue and transparency 70%. I closed out and reopened the document to find nothing had changed.

Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 2 fa.libreoffice 2024-11-22 22:55:39 UTC
Created attachment 197732 [details]
Style-font-transparency-lost-upon-reopen.ods

Sample calc file that always reproduces non permanent font transparency.
Comment 3 fa.libreoffice 2024-11-22 22:59:25 UTC
(In reply to Henry G. from comment #1)
> Hello, I was not able to reproduce the issue you described. I am using the
> same version. I had text set to color blue and transparency 70%. I closed
> out and reopened the document to find nothing had changed.
> 

Interesting and strange, that so far only two users can always reproduce. Apparently not everyone. So, I'm at a loss what else it could be.

Just in case, I added the calc file I used including a description. Your steps to not reproduce, Henry G., seem to be identical, though. But thanks for testing.
Comment 4 m_a_riosv 2024-11-23 04:14:43 UTC
Reproducible with
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c06de26c4b83edad29a70a454dea20dcd0261a33
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 5 BogdanB 2024-11-23 20:20:40 UTC
Repro with
Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 662c6a6d70bab6b1a6ae8048457907be97f447ca
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Repro with
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

In version 7.3.7 when transparency is applied, you can not see the result on pressing OK, neither after File-Reload.
Comment 6 Regina Henschel 2025-11-05 22:48:08 UTC
I see the applied transparency in Calc, when the cell is in edit mode. But after editing is finished, the text is rendered without transparency.

The transparency is not written to the file. It should be an loext:opacity attribute. If I insert the attribute manually, it is not read.