Created attachment 67477 [details] test case I have created xls file with diagram (chart) as described in Bug 38746 using Calc 3.6.1. Then opened it in Calc again and saved as xlsx, then reopened. Chart becomes without bars. Steps to reproduce: 0. Open first attachment in Calc 1. File->Save as, select Excel2007 xlsx 2. File->Reload Expected: correct chart Actually: chart without bars xlsx file, produced in step 1 correctly opens in Excel 2007. If save this file with Excel and open in Calc, it again becomes without bars in chart If create such diagram in Calc or Excel from scratch (not open xls file), then chart opens correctly. Reproduced (problem from step 2) in 3.3.4, 3.5.5, 3.6.1 on Fedora 64 bit
Created attachment 67478 [details] first attachment, saved as xlsx using 3.6.1 (opens in Calc incorrectly)
Created attachment 67479 [details] second attachment, modified and saved by Excel2007 (opens in Calc incorrectly)
Created attachment 67480 [details] xlsx, created in Excel2007 from scratch (opens in Calc correctly)
The general behavior of the xlsx files is weird . When opening an existing file it will be opened normally for a few seconds then the system will show as busy as the screen will be hanged for over 10 seconds and the screen turn the color into light gray and comeback again until I try to make any move (whatsoever). Also, when opening a new sheet and press the save button, it will not accept the save and the screen will be hanged and the application closes unexpectedly. After opening the application again a screen will appear that the last sheet need to be recovered, and it will be recovered correctly and saved normally.
@ Ibrahim Hammad Thanks for interesting in this bug. Please, do not change pickers. "Version", for example, is most early version where bug is reproducible. Not current version of LO. Changing back to 3.3.4
I can confirm most of the problem in Version 4.0.0.0.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0) on Ubuntu 12.04 (x86) Opening the two files "first attachement..." and "second attachment...", gives a broken diagram. Although I can't reproduce the problem by saving "test case" as XLSX-file and reloading, this one looks fine to me.
I can confirm all problems still persist on LO 4.0.3.3 (Win7 32bit)
Tested with Version: 4.4.0.0.alpha0+ TinderBox: Win-x86@42, Branch:master, Time: 2014-08-30_23:06:34 > 2. File->Reload 4.4 Result: Pass > xlsx file, produced in step 1 correctly opens in Excel 2007. If save this file with Excel and open in Calc, it again becomes without bars in chart 4.4 Result: Pass Both issues are fixed with the latest 4.4. Nice work dev team!
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/92b37ecdef6ca915698d91cdfd053bb3950a0f98 crashtesting: exception on reexport of fdo55178-3.xlsx to xlsx It will be available in 7.1.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.