Description: Format column chart date format to dd, save file as .xlsx and reopen. X-axis format is source format. Steps to Reproduce: 1.Using Date and Data columns 2.Insert column chart 3.Format x-axis, Numbers, clear Source format and use format code dd 4. Save as TestChart.xlsx 5. Reopen TestChart.xlsx and Source format is reselected Actual Results: Custom Format code is lost Expected Results: x-axis format with custom format code Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Issue does not occur with ods format
Please attach sampel ods file where to reproduce the issue when saving as xlsx.
Created attachment 159545 [details] Calc Chart X-axis format lost with xlsx Test File Save the file as ods and xlsx. Reopen both files - Custom date Format code is lost in the xlsx file.
Confirmed with test file on: Version: 7.0.0.0.alpha0+ Build ID: 95dbfd517240666e5b9a9fd7ac1d47d799235a62 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: hu-HU (hu_HU.UTF-8); UI-Language: en-US Calc: threaded
Created attachment 159551 [details] Screenshot of the exported file side by side in Calc master and Excel Turns out this is an import problem, since the date format appears correctly in Excel. Version: 7.0.0.0.alpha0+ (x64) Build ID: bc898e2c2784e36ad4d4cdf6d962e39069d2c82d CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL Also the saved file exported by versions back to 5.0 also appears correctly in Excel, but not in Calc.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/75156c6fd73dc202df541306e1636727d51d6fc3 tdf#132076 Chart OOXML: fix lost date format of X axis It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.0.0.0.alpha0+ Build ID: 4ba1909f12b49f020195b5e767045340717ce6df CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded @Balázs Varga, thanks for fixing this issue!!
Doesn't seems to be a recent problem. Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.19; Render: default;