Bug 150831 - Sparklines Display empty cells as change does not save
Summary: Sparklines Display empty cells as change does not save
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Sparklines
  Show dependency treegraph
Reported: 2022-09-06 15:29 UTC by Skip Masonsmith
Modified: 2022-09-17 14:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Skip Masonsmith 2022-09-06 15:29:50 UTC
When setting the properties of a sparkline, if only changing the "Display empty cells as" option, it will not update the properties of the sparkline when clicking OK.

Steps to Reproduce:
1. Create data for sparkline: A1: 1, B1: 2, C1: 3
2. Select the data and right-click and choose Sparklines > Insert Sparkline
3. Note the current "Display empty cells as" option.  Change it to something else and do not change the Type.
4. Select an empty cell for output range and click ok
5. Right-click on sparkline and choose Sparklines > Edit Sparkline Group

Actual Results:
Display empty cells as value is unchanged

Expected Results:
Display empty cells as value should be changed to new value

Reproducible: Always

User Profile Reset: No

Additional Info:
If you also change the Type, the Display empty cells as value will be saved with the sparkline group properties.
Comment 1 raal 2022-09-06 17:18:37 UTC
Confirm with Version: / LibreOffice Community
Build ID: 64f673238cf9b645a751e8f8137ca14e595a779a
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 2 aplatypus 2022-09-17 14:14:57 UTC
* I have had different examples of what I think of as valid formulae Not work with Sparklines.
* I have determined that Sparkline only work for...

* A contiguous cell range
* Must include worksheet name
* cell reference must be absolue:
  x "'daily summary'!U76:X76" -- worked, but:
  x "$U$76:$X$76" -- fails
  x "$U$76,$V$76,$W$76,$X$76" -- fails
  x "U76,V76,W76,X76" -- fails
Comment 3 aplatypus 2022-09-17 14:44:15 UTC
* this bug reports missed data in a calculation
* It cannot be considered "minor" im humble opinion