Created attachment 168502 [details] source of xlsx with graph errors LO 7.04.2 x64 to Some basic functions in graphs are not converted to xlsx. So x and y axle legends disappear or change. See examples on the sheet like "AT" with graphs after saving of ods in xlsx. Saving of ods and xlsx is very slow in relation to xlsx in MSO 2016.
Created attachment 168503 [details] xlsx of source ods xlsx-file is signifikant smaller
Created attachment 168514 [details] Simple ODS example
I confirm the lost of legend in Version: 7.2.0.0.alpha0+ (x64) Build ID: ad9e04321df25824d2288a2ef1f4275f070f1cf7 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL Open Simple ODS example in LO, save it to XLSX and open XLSX in MS Excel => legens on chart are lost
Created attachment 168555 [details] The example file and its docx version in current master How it looks in: Version: 7.2.0.0.alpha0+ Build ID: 2577d9ecea199ca2c10d852cf279053a1b22faf7 CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3 Locale: hu-HU (hu_HU.UTF-8); UI: en-US Calc: threaded The X axis title should be exported, but this does not happen way back to: Verzió: 6.0.7.3 Build az.: 1:6.0.7-0ubuntu0.18.04.10 CPU szálak: 8; OS: Linux 5.0; Felületmegjelenítés: alapértelmezett; VCL: gtk3; Területi beállítások: hu-HU (hu_HU.UTF-8); Calc: group The secondary Y axis is different from Excel, there it is a different values axis and in Calc it's just a mirror of the primary axis.
Some users want also in single curve charts y-axles with numbers left and right. And that is also possible in MSO with XLSX. Loss of x-axle is here in action.
improved mostly but not perfect in LO 7.1.0.3 x64
Created attachment 172939 [details] other example (weather chart)
Created attachment 172940 [details] screenshot of the bad export of the chart only with secondary axis data seris Budapest is ok, but not Tokyo.
Created attachment 181047 [details] extended example paris tokyo budapest with budapest 2 Version: 7.3.4.2 (x64) / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (de_DE); UI: de-DE Calc: CL for me are Budapest and Budapest2 not ok. see attachment
Created attachment 181048 [details] extended example paris tokyo budapest with budapest 2 xlsx xlsx export with Version: 7.3.4.2 (x64) / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (de_DE); UI: de-DE Calc: CL for me are Budapest and Budapest2 not ok. see attachment