Bug 49225 - FILESAVE: Some diagrams are empty while saving as MS Office Excel format xls or xlsx
Summary: FILESAVE: Some diagrams are empty while saving as MS Office Excel format xls ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-27 07:39 UTC by Mindaugas Baranauskas
Modified: 2013-12-04 21:31 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
ods file with diagrams (312.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-04-27 07:39 UTC, Mindaugas Baranauskas
Details
MS Excel xls file (60.50 KB, application/vnd.ms-excel)
2012-04-27 07:40 UTC, Mindaugas Baranauskas
Details
MS Excel xlsx file (47.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-04-27 07:41 UTC, Mindaugas Baranauskas
Details
xls saved in Windows (60.00 KB, application/vnd.ms-excel)
2012-04-27 07:48 UTC, Mindaugas Baranauskas
Details
xlsx saved in Windows version of LibreOffice Portable (48.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-04-27 07:48 UTC, Mindaugas Baranauskas
Details

Description Mindaugas Baranauskas 2012-04-27 07:39:01 UTC
Created attachment 60681 [details]
ods file with diagrams

Problem description: 
I have LibreOffice Calc document .ods with very similar diagram, made allmost the same way. Then I save it as xls or xlsx format, these diagrams in MS Office file format are empty.

Steps to reproduce:
1. Create diagram with LibreOffice Calc
2. Copy this diagram to new file of LibreOffice Calc
3. Save in LibreOffice format
4. Save as in MS Excel format xls and xlsx
5. Open MS Excel format xls and xlsx files

Current behavior:
Diagrams may be empty

Expected behavior:
Diagrams allways are with data

Platform (if different from the browser): 
openSUSE Linux 12.1 64 bit
              
Browser: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E; OfficeLiveConnector.1.5; OfficeLivePatch.1.3)
Comment 1 Mindaugas Baranauskas 2012-04-27 07:40:35 UTC
Created attachment 60682 [details]
MS Excel xls file
Comment 2 Mindaugas Baranauskas 2012-04-27 07:41:15 UTC
Created attachment 60683 [details]
MS Excel xlsx file
Comment 3 Mindaugas Baranauskas 2012-04-27 07:47:29 UTC
Tested to save as ODS file in MS Windows (with LibreOffice Portable 3.5.2). The rezult is similar as with Linux: 
in xlsx file "LDK ir ADK santykis (Furje)" sheet has no diagram,
in xls file there is empty images instead of diagrams.
Comment 4 Mindaugas Baranauskas 2012-04-27 07:48:12 UTC
Created attachment 60684 [details]
xls saved in Windows
Comment 5 Mindaugas Baranauskas 2012-04-27 07:48:57 UTC
Created attachment 60685 [details]
xlsx saved in Windows version of LibreOffice Portable
Comment 6 bfoman 2012-07-17 13:16:43 UTC
Confirmed with:
LO 3.5.5.3 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Excel 2010 results:
xls - missing pictures
xlsx - pictures are present, but wrong formatting, legend displacement, scaling, axis titles and other problems, similar as in attached files.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.