Description: When I open an (new) document I enter a new sparkline (Source data is on tab 2, and sparklin on main tab 1), save the document en reopen the sparkline is gone. And also not possible to enter a new data input, the buton OK is disabled (see screenshot) Actual Results: Empty place where the sparkline was Expected Results: An sparkline Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 4; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: nl-NL Calc: threaded
Created attachment 192435 [details] Step 1 add sparkline
Created attachment 192436 [details] Step 2 see the sparkline(on tab1) and save en close calc
Created attachment 192437 [details] Step 3 open the document and sparkline is gone
Created attachment 192438 [details] Step 4 config the sparkline but the inputdata is gone also when reset i can not click on ok
What file format do you use to save?
Just the normal .ods file
(In reply to idserttimmer from comment #6) > Just the normal .ods file I might be wrong, but I think that creating ods files with sparklines is not yet supported. Even using xlsx, I'm not sure that you can create sparklines on one worksheet when the data is on another worksheet. Both items should be tested; please don't just take my word for it. As a first step, I would start with an xlsx file created in Excel that already contains sparklines, a test whether Calc can open it and render the same result. Only then I would test whether it is possible for Calc to create (anew, from scratch) such xlsx file.
I found something interesting; first of all saving in xlsx is not working. But saving in ods I found this: -When the data input of the sparkline is in the same tab the sparkline works -When the data is on the FIST (tab1) and sparkline is on an other tab the sparkline works -When the data is NOT on the fist tab and the sparkline is NOT on the same tab, than the sparkline disappears.
(In reply to idserttimmer from comment #8) > I found something interesting; first of all saving in xlsx is not working. * IIRC, importing from xlsx was implemented before anything else. * You have not mentioned whether an xlsx file containing the simplest (line) sparklines (e.g. all data and sparklines in the same_and_only first_and_only worksheet) that was _created_in_Excel_ can be correctly _opened_ by Calc. > -When the data is NOT on the fist tab and the sparkline is NOT on the same > tab, than the sparkline disappears. I admit that I don't know of each specific feature/limitation that is yet to be implemented. I only know that the basic feature was initially introduced for LO 7.4. (Tomaž Vajngerl, Collabora). I wonder... Perhaps this is still at the "import from xlsx" status and nothing else is really fully supported yet (including not saving)(?)
(In reply to idserttimmer from comment #8) > But saving in ods I found this: > [...] > -When the data is NOT on the fist tab and the sparkline is NOT on the same > tab, than the sparkline disappears. I could reproduce this, but to be more precise: the sparkline does not survive a save-reload if the output range is in a sheet placed before the sheet that contains the input range. (It _does_ work if the input range is in a sheet _before_ the sheet with the output range.) Let's focus this report on this issue. Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Seems the issue exists since sparkline support was implemented in 7.4, I can reproduce in libreoffice-7.4.0.0.alpha1 (linux-64-releases bibisect repo). Quikee, what do you think?