Description: If using Sparkline to visualize series of data in rows, copy+paste does not provide updated graph. Instead, only the previous graph is copied. Expect that once will define a sparkline graph, copying and pasting the cell with sparkline will copy the formula(range, style) of graph which will be updated to new row of data. IMO this is the core of Sparkline (and why use it instead of standard graph). This works in MS Excel. Steps to Reproduce: 1. Enter series of data in matrix of rows and columns 2. Create a Sparkline graph for first row of data - see valid graph 3. Copy/paste Sparkline graph to the following rows Actual Results: Sparkline graph itself is copied Expected Results: Expect to see updated graphs in next rows, that represent current data in each row. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: pl-PL Calc: threaded
Please can you attach a sample file.
Created attachment 183148 [details] Calc sparkline Copy/Paste issue Example file to illustrate the issue. To reproduce the problem, Copy the sparkline in D1 cell, and paste it to D2. Expected: sparkline will update to 2nd row of data (4,3,2) Actual: sparkline is copied graphically (representing the original image from the copied sparkline).
The spark line range it's copied without take care if the range reference is relative. Still happens with Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5a1f41a0d3aab15c113651f2edc9d4137ae99063 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
My tests show that it's not the range that is copied, but the graphics snapshot. Im my test case, if someone will copy/paste sparkline from D1 to D2, both will look identical. Then if the Row1 data is changed, e.g. B1 from 3 to 1, the sparkline in D1 will be updated to reflect the change and it's copy from D2 will not. So it seems like sparkline copy in D2 lost it's data connection at all.
(In reply to fred4u from comment #4) If I copy the sparkline cell, one down, it copied with the same address. You can see it with Right-click / Sparkline / Edit Sparkline The copied doesn't update after change data on row-1 but if you do a Menu/Data/Calcuate/Recalculate hard, it is updated. So the bug is that at copy, relative address are not updated. And the copy needs a hard recalc.
And after save and reopening the copy it's not there.