Bug 159713

Summary:	On a sparkline, empty cells can't be taken as "gap"
Product:	LibreOffice	Reporter:	David García <vivadavid>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, miguelangelrv
Priority:	medium
Version:	24.2.0.3 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	150884
Attachments:	Spreadsheet Sample file Screenshot

Description David García 2024-02-13 23:44:29 UTC

Description:
When you create a sparkline, there's a setting called "Display empty cells as", which offers you the possibility of selecting "gap". However, when I select "gap", I get the same result as if I had selected "zero".

Steps to Reproduce:
1. I create a new sparkline.
2. I select "gap" under "Display empty cells as".


Actual Results:
The sparkline displays a zero value for the empty cells.

Expected Results:
The sparkline should display nothing for the empty cells.


Reproducible: Always


User Profile Reset: No

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

Comment 1 David García 2024-02-13 23:44:49 UTC

Created attachment 192551 [details]
Spreadsheet

Comment 2 m_a_riosv 2024-02-15 13:09:00 UTC

Created attachment 192582 [details]
Sample file

Works for me
Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
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

Comment 3 David García 2024-02-15 15:17:24 UTC

(In reply to m_a_riosv from comment #2)
> Created attachment 192582 [details]
> Sample file
> 
> Works for me
> Version: 24.2.0.3 (X86_64) / LibreOffice Community
> Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
> 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

I've opened your file, but "Display empty cells as" is set to "zero", not "gap". In any case, as you can see on my screenshot, there are no gaps on the sparkline.

Comment 4 David García 2024-02-15 15:17:48 UTC

Created attachment 192588 [details]
Screenshot

Comment 5 m_a_riosv 2024-02-16 12:32:16 UTC

You are a right, too quick on my view.
Reproducible:
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 125fc2ce861c82592b261f2992c893b414396e56
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