Bug 150816 - Sparklines in merged cells are missing options
Summary: Sparklines in merged cells are missing options
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Calc-Merge-Split Sparklines
  Show dependency treegraph
Reported: 2022-09-05 22:02 UTC by Skip Masonsmith
Modified: 2024-02-27 16:28 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-05 22:02:18 UTC
When a sparkline is merged into a group of cells, it loses the option to have the Sparkline Group edited

Steps to Reproduce:
1. Create data in a new spreadsheet: A1: 1, B1: 2, C1: 3
2. Insert a sparkline using A1-C1 as the input range
3. Select the cell with the sparkline and at least one other cell and right-click and select Merge Cells
4. Right-click on Sparkline and look at the options under Sparkline or from the menu choose Format > Sparklines

Actual Results:
Context right-click menu is missing Edit Sparkline Group, Delete Sparkline Group and Delete Sparkline options.  Those same options are greyed out in the menu, Format > Sparklines.

Expected Results:
Ability to Edit Sparkline Group, Delete Sparkline Group and Delete Sparkline from right-click context menu or from menu, Format > Sparklines.

Reproducible: Always

User Profile Reset: No

Additional Info:
Works fine again once cells are unmerged.
Comment 1 Stéphane Guillou (stragu) 2022-09-06 07:16:55 UTC
Reproduced in:

Version: / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

I think this is most noticeable with the following:
- you have an existing sparkline group
- one cell from the group is merged with another cell that is not part of the group
- context menu on the merged cell > Sparlines: no group options.

It's also unclear to me what should happen when merging cells that contain a sparkline: should the sparkline use the whole space, like text would? Also, there isn't a Merge Cells dialog opening when several sparkline cells are merged. Only the sparkline of the first cell remains visible.
Comment 2 aplatypus 2022-09-17 14:41:06 UTC
* This bug might be related to the 'Sparkline rules' (or limits) that I've seen.  

* 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

* The merged cell probably doesn't look like a contiguoue range
* If you include the formerly merged (unmerged cells) as a range,it might work.
* You might also need to recalc to see results/changes.