Graph > Data Series > Format Data Series > Plot Options > Change "Assume Zero" to "Leave Gap" NOW SAVE. Close Spreadsheet then ReOpen Plot Options has NOT been saved as the option is "Assume Zero".
Please report what file format do you use to save and copy the information in Menu/Help/About LibreOffice
This is saving the file as .xlsx Hope this helps.
[Automated Action] NeedInfo-To-Unconfirmed
I have just try saving the file as .ods and closing and reopening retains the selected 'Plot Options' and works perfectly. Also saving as .xls works perfectly (as above) so it is only the .xlsx that has the problem.
Could you please attach an ods file that exhibits this problem upon saving to XLSX?
Created attachment 167904 [details] Example .ods sheet which loses plot options if saved as .xlsx Attached Spreadsheet as requested.
I can confirm with Version: 7.2.0.0.alpha0+ Build ID: 7673b027daed248d1be4dd1a773bfc0334a00c53 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Works in Version: 6.1.0.0.alpha1+
(In reply to Malcolm McFee from comment #0) > Graph > Data Series > Format Data Series > Plot Options > Change "Assume > Zero" to "Leave Gap" NOW SAVE. I'm sorry but I can't find the options 'Plot Options', not 'Assume Zero' nor 'Leave Gap' @zcrhonek could you please explain the correct steps to reproduce it ?
Created attachment 168088 [details] printscreen of Plot options open plot option (Data series options) see attached printscreen change to Assume zero save as xlsx, reload open plot option, change to Leave Gap save xlsx ,reload open plot option > Assume zero, should be Leave gap
Bibisected with linux-64-6.3 to https://git.libreoffice.org/core/commit/f684c074d5f66c8b1546a626766bc045c04cebc3 tdf#115012 XLSX chart import: workaround for no gap Adding Cc: to László Németh
Created attachment 174853 [details] Original file exported to xlsx with 6.2 seen in Excel an current Calc In: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: c7b5e6566d9b24a0a996c739a945004d9aadee2f CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL The display of the exported xlsx is the same as in Excel ("Közökkel" in this shot means "Leave gap"). The export of this c:dispBlanksAs val="gap"/> setting was correct even in 5.0. What is different the understanding of "Empty cells" by Excel and "missing values" by Calc. In this file these plotted cells are the result of a formula calculation in the B3:L27 range: =IF($Weight.B3="";"";($Weight.B3-$Weight.B$2)/$Weight.B$2) Calc considers these cells "empty" when the IF formula gives the empty string and plots them as gaps. Excel however does NOT consider them empty and plots them "with zero values" even if you have selected "with gaps" on it's UI. If you delete the formulae from the seemingly empty cells, then it really does not plot anything, just like Calc. The bibisected commit solved the visual difference by detecting whether there are "not really empty" calculated cells and changed the plotting option from "Leave gap" to "Assume zero", so when Excel cheats, Calc cheats as well. The downside of cheating is this bug: Leave gap option is not usable anymore when you load XLSX format.
Reproduced with attachment 167904 [details] and: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 45d1fca81991f0d6837c98d6be6fe0d21d566fa5 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Save as XLSX and reload results in lines extending at 0% all the way to the right of the plot.