Bug 151142 - UI: Font Preview in the Styles sidebar is not working for Calc
Summary: UI: Font Preview in the Styles sidebar is not working for Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 152201 166824 (view as bug list)
Depends on:
Blocks: Sidebar-Styles
  Show dependency tree / graph
 
Reported: 2022-09-23 05:02 UTC by Kevin Suo
Modified: 2025-12-01 00:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2022-09-23 05:02:33 UTC 
Steps to Reproduce:

1. New Calc. Go to the Styles sidebar. Observe that the Show Previews checkbox is checked.

Current Behaviour:

The fonts, background color etc are not applied to the styles for a preview.
For instance, Heading 1 is "Liberation Sans" 18pt + bold if you apply this style to a cell, but it shows normal font and font style in the styles sidebar.

Expected Result:

The font preview should be working similar as what we have in Writer.

Version: 7.4.3.0.0+ / LibreOffice Community
Build ID: afdc5430770825cbbb3389a0897e7afbdaa772e2
CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2022-09-23 17:28:00 UTC 
Reproducible with calc, works with writer.

Version: 7.4.1.1 (x64) / LibreOffice Community
Build ID: 0a046a10cbf1679eea5538bd3ab63156caa3a036
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: bfb0dbee201a69c26293947c78356f320ff62a0b
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); Interfaz: es-ES Calc: CL
Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 19044; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: CL
Comment 2 m_a_riosv 2022-11-26 22:39:15 UTC 
*** Bug 152201 has been marked as a duplicate of this bug. ***
Comment 3 Stéphane Guillou (stragu) 2022-11-27 08:21:27 UTC 
Updating fields according to duplicate.
Note we have style previews in the tabbed UI.
Comment 4 LeroyG 2023-09-04 18:58:48 UTC 
Same with:

Version: 7.6.0.2 (x86) / LibreOffice Community
Build ID: 41d6f628ba3f046f16b5fa9fa8db8d4c2ab3b582
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: es-MX (es_MX); UI: en-US
Calc: threaded
Comment 5 nobu 2025-06-02 14:08:38 UTC 
*** Bug 166824 has been marked as a duplicate of this bug. ***
Comment 6 russell 2025-11-30 23:44:36 UTC 
Description:

Sidebar Styles -> Show previews

Ok in Writer.
Not Ok in Calc. No Style previews.

When the Show previews option is checked, the top and bottom spacing on each Style increases but the attributes of the Styles do not appear.

Environment:

Version: 25.8.3.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
25.8.3-2
Calc: threaded
Comment 7 m_a_riosv 2025-12-01 00:26:13 UTC 
Reproducible
Version: 26.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 620(Build:0)
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded

The first version with the option has a problem with Calc, in the ones I have installed.
Versión: 5.4.7.2
Id. de compilación: c838ef25c16710f8838b1faec480ebba495259d0
Subprocs. CPU: 16; SO: Windows 6.2; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: C
Latest version that works on the ones I have installed.