Description: 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.
Reproduced in: Version: 7.4.0.3 / 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.
* 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.