Bug 159713 - On a sparkline, empty cells can't be taken as "gap"
Summary: On a sparkline, empty cells can't be taken as "gap"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sparklines
  Show dependency tree / graph
 
Reported: 2024-02-13 23:44 UTC by David García
Modified: 2024-02-17 05:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Spreadsheet (22.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-13 23:44 UTC, David García 		Details
Sample file (21.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-15 13:09 UTC, m_a_riosv 		Details
Screenshot (13.68 KB, image/png)
2024-02-15 15:17 UTC, David García 		Details
View All 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 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