| Summary: | FILESAVE: Chart from data table, copied from other file, empty when saved as XLS | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | opensuse.lietuviu.kalba |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | bfo.bugmail, timur |
| Priority: | medium | Keywords: | filter:xls |
| Version: | Inherited From OOo | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=82218 https://bugs.documentfoundation.org/show_bug.cgi?id=101711 |
||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 109072 | ||
| Attachments: |
ods file with diagrams
MS Excel xls file MS Excel xlsx file xls saved in Windows xlsx saved in Windows version of LibreOffice Portable original OSD with data table and chart for it ODS with pasted chart XLS with pasted chart re-saved once in XLS in LibreOffice 5.4.2.2 re-saved twice in XLS in LibreOffice 5.4.2.2 |
||
Created attachment 60682 [details]
MS Excel xls file
Created attachment 60683 [details]
MS Excel xlsx file
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. Created attachment 60684 [details]
xls saved in Windows
Created attachment 60685 [details]
xlsx saved in Windows version of LibreOffice Portable
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. ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT *Update the version field *Reply via email (please reply directly on the bug tracker) *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-18 BUG still exist in LibreOffice 4.4.2.2, System: openSUSE Linux 13.2 64 bit LO installed from LibreOffice site RPM packages ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920 BUG still exist in LibreOffice 5.2.1.2: - for XLS – no images - for XLSX - images exist, but some distortions exist System: openSUSE Linux 13.2 64 bit LO installed from LibreOffice site RPM packages OK, let's get back to basics, so called triaging. 1. No need for multiple tabs or same diagrams, minimum test case is needed. 2. Xls and Xlsx have different results because they have different filters. Let this one be for XLS only. Added keyword. 3. Those are charts, not diagrams. 4. "made almost the same way" How was this chart created? In Calc or copied from somewhere or exported? You normally get those when creating a chart without data, and enter data after. 5. Can you write step-by-step how to reproduce with a singe chart created from scratch? Created attachment 127602 [details]
original OSD with data table and chart for it
In this document chart newly created from data, that exist in same sheet.
(P.S. I use Lithuanian interface, were „chart“ is named as international word „diagrama“; and my dictionary says, that meanings of „diagram“ and „chart“ overlap).
Created attachment 127603 [details] ODS with pasted chart This is new document, I only pasted chart from other ODS (i.e. https://bugs.documentfoundation.org/attachment.cgi?id=127602 ). Chart is OK. Created attachment 127604 [details] XLS with pasted chart Document with pasted chart saved as XLS is broken. Thus steps to reproduce remained same as described in comment #0 (In reply to Mindaugas Baranauskas from comment #0) > <...> > 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 <...> > 5. Open MS Excel format xls <...> > Please excuse, I had some other bugs, and I wasn't careful to read that you already wrote everything in the first post. Copying to new file. So, the title is now fine. For the sake of clarity of the bug for other readers, I'll remove last comments. For XLSX please search other bugs and if not already reported, submit a new bug, and set See also to this one. ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug I can reproduce bug in LibreOffice 5.4.2.2 (ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4, Installed via RPM packages from LibreOffice website in openSUSE Leap 42.3 64-bit Linux) Just opening example ODS and re-saving it as XLS file also results into empty graphics Created attachment 137304 [details]
re-saved once in XLS in LibreOffice 5.4.2.2
example image
Created attachment 137306 [details]
re-saved twice in XLS in LibreOffice 5.4.2.2
re-saving _twice_ results even in more worse scenario
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug Comment on attachment 60681 [details]
ods file with diagrams
No errors. Simple laptop, Win 10, 4 G memory, processor with 4 cores, SSD-HD
Bug for XLS reproduced in LO 6.3+. This is about an XLS file, so changing meta bug. Dear opensuse.lietuviu.kalba, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug Still reproduces in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 46dc9f3bbac67e9240adc44ab017f905482ef786 CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Simple reproducer: 1. Open ODS file from attachment #127603 [details] (comment #13) 2. Save in XLS format 3. Restart LibreOffice and open XLS file saved in step 2 4. Graph gone (i.e., white) |
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)