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
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.
Ability to Edit Sparkline Group, Delete Sparkline Group and Delete Sparkline from right-click context menu or from menu, Format > Sparklines.
User Profile Reset: No
Works fine again once cells are unmerged.
Version: 22.214.171.124 / 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
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.
* 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.