Created attachment 90106 [details] Stock Chart of type "Volume Open High Low Close" Steps to reproduce : 1] Open attached .docx document 2] Do save_as 3] Open saved file MS office 4] File does not get open Expected behavior : File should get opened. Current behavior : Pops up a dialog box showing "File cannot be opened because there are problems with the contents"
Problem area : In chart1.xml under, <c:chart> <c:plotArea> <c:stockChart> there are four types of series as Open,Low,High and Close. For Open series, <c:ser> <c:idx val="0" /> <c:order val="0" /> an attribute val should start from 1 and not from 0. If val changed to either 4 or 1(do appropriate changes for idx of Low,High,Close) then file opens in MSoffice 2010 without error.
I can reproduce this behavior, tested using Mac OSX 10.9 with LibreOffice Version: 4.2.0.0.beta2 Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d Opened the file using Word for Mac 2011. Kind regards, Joren
Pallavi Jadhav committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e516f8be79ddc9d845d8141075f7d558c25c1636 fdo#72226: Fix for Stock chart Invalid RT The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified on Build : libo-master~2013-12-18_05.10.32_LibreOfficeDev_4.3.0.0.alpha0_Win_x8. File is exported properly after RT.
(In reply to comment #4) > Verified on Build : > libo-master~2013-12-18_05.10.32_LibreOfficeDev_4.3.0.0.alpha0_Win_x8. > File is exported properly after RT. I can confirm that the file is opened after roundtriping in LibreOffice Version: 4.3.0.0.alpha0+ Build ID: 5be7ec4193b892e5643ff5f3f2e6755319569190 TinderBox: Win-x86@39, Branch:master, Time: 2013-12-27_23:55:02 Opened using MS Word 2010. I do see some differences when opening original chart and roundtripped one. Not sure it's already reported somewhere? (I see good work from synerzip passing by :-) ), so not sure what's already reported, what not with your available test documents. Kind regards, Joren
Created attachment 91303 [details] Comparison in Word, original left; after roundtrip right - No border anymore - Double x-axis - Extra lines in the chart which were not visible before Thanks for your great job :).
Hi Joren, Yes there are visual discrepancy issues that you mentioned. It occurs while "opening" the Word document in Libreoffice. So I guess there is some code at import side ,responsible for such behavior. I fixed it for corruption only. As you must have observed, it was previously opening as corrupt document in MS Office but after this fix, it opens up without corruption.
(In reply to comment #7) > Yes there are visual discrepancy issues that you mentioned. > It occurs while "opening" the Word document in Libreoffice. So I guess there > is some code at import side ,responsible for such behavior. Indeed :). Lets create other bug reports for each problem separately. > I fixed it for corruption only. As you must have observed, it was previously > opening as corrupt document in MS Office but after this fix, it opens up > without corruption. Correct, so this bug is RESOLVED FIXED and VERIFIED in comment 4 and by me. Lets mark it as such. Thanks for fixing :)! Joren