Created attachment 87299 [details] Screencaps Problem description: When i tried to convert a xlsx file one graphic gets disorted; it's a compound of an image, a text field and an Office2010-AutoForm-Arrow. Steps to reproduce: 1. Make a xlsx in Office 2010 as i described 2. Open it in Libreoffice and save as different file formats 3. Observe what happens to the AutoForm-Arrow Current behavior: gets disorted in different ways, even disappears Expected behavior: Stay as it showed up first when opening the xlsx first time Operating System: Windows 8 Version: 4.1.2.3 rc
please upload a test .xlsx file for those who don't have MS Office.
(In reply to comment #1) > please upload a test .xlsx file for those who don't have MS Office. The problem is: I don't use MS Office anymore. Have to get to another pc first
Created attachment 87630 [details] where error occurs (File Created in MS Excel 2010.) When saving this file in LibreOffice as different file formats, it behaves strangely. Reopening the saved file often shows disortions etc.
Created attachment 87631 [details] another xls saveing this file, as ods, for instance, even makes the whole graphic disappear.
I confirm bug. Any LibO version and OOo 3.3.0 and AOO 4.0.0 are affecter by this bug and result in various degrees of distortion when saving. set status to NEW and version to INHERITED FROM OOo adding Calc expert to CC-list.
** 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.0.1 or preferably 5.0.2.2 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-10-14
(In reply to owezahra from comment #4) > Created attachment 87631 [details] > another xls > > saveing this file, as ods, for instance, even makes the whole graphic > disappear. still reproducible with LibO 5.1.0.0.alpha1+ Build ID: f830600ece806ec365a4839e79afabe183c5e36d TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-06_22:49:09 Locale: it-IT (it_IT)
** 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.6 or 5.2.3 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-20161108
Yep, still an issue. (Changed version from "Windows" to "all", as i've moved to Ubuntu) Version: 5.2.3.2 Build ID: 1:5.2.3~rc2-0ubuntu1~xenial1 CPU Threads: 2; OS Version: Linux 3.19; UI Render: default; Locale: de-AT (en_US.UTF-8); Calc: group
Still no progress Version: 5.3.0.3 Build ID: 1:5.3.0~rc3-0ubuntu1~xenial1.1 CPU Threads: 2; OS Version: Linux 3.19; UI Render: default; VCL: x11; Layout Engine: new; Locale: de-AT (en_US.UTF-8); Calc: group
** 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
Still an issue, 4 years after initial report: ZERO progress on any of the file formats Any chance someone gets assigned, or is this just another dead-in-the-water bug? Version: 5.4.4.2 Build ID: 1:5.4.4~rc2-0ubuntu0.16.04.1~lo1 CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group
(In reply to owezahra from comment #12) > Still an issue, 4 years after initial report: ZERO progress on any of the > file formats > > Any chance someone gets assigned, or is this just another dead-in-the-water > bug? > > > Version: 5.4.4.2 > Build ID: 1:5.4.4~rc2-0ubuntu0.16.04.1~lo1 > CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; > Locale: en-US (en_US.UTF-8); Calc: group there are over 13000 bugs in status NEW and only 50 active developers that want to eat still repro for saving to xlsx and xls, but not for saving to ODS. in Version: 6.3.0.0.alpha0+ Build ID: ed707a4806a489467c6d9be7d1b787dab94b5f78 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
Created attachment 161519 [details] Minimized document about the disappearing border When saving to xlsx there are several problems: - The grouped state of the objects is lost - Text box border has "automatic" color which is lost, also other "custom" colors are lost too. - The arrow has red color, which is retained (Excel groups this as "basic" color), but its position shifts lower. This may be related to bug #103050 This file contains the text box outlined with some basic and some custom colors.
Created attachment 161520 [details] The example file saved with Calc
Created attachment 161521 [details] Screenshot of the example file and its Calc-saved version side by side in Excel and Calc Import looks good, but export loses the "custom" colors. Version: 7.1.0.0.alpha0+ (x64) Build ID: 75eeb423196c1e94a0189b7eccff37aed5765853 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Grouping of shapes is not retained intentionally on xlsx export: https://cgit.freedesktop.org/libreoffice/core/commit/?id=c323e601
(In reply to NISZ LibreOffice Team from comment #14) > When saving to xlsx there are several problems: > - The grouped state of the objects is lost Let's keep this bug focusing on this problem. Adjusting title. > - Text box border has "automatic" color which is lost, also other "custom" > colors are lost too. The automatic color text border is the same as bug #77236 The custom colors being lost in Calc (but not in Excel) is bug #136566 > - The arrow has red color, which is retained (Excel groups this as "basic" > color), but its position shifts lower. This may be related to bug #103050 Position change on save is bug #123613
Seems mostly fixed (Arrows), however the circle becomes a fat, not tall oval: - the circle is slightly squeezed on import - saving as .ods makes it even "fatter" after reopening - other formats seem to stay constant Version: 7.1.4.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1 Calc: threaded
Tibor Nagy committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c4d7b9c3ec6e44b96134fdfb036be7f9fcf39f9d tdf#70293 XLSX export: fix lost grouping of shapes It will be available in 7.5.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.
Tibor Nagy committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/916bf965bf69784da68311040ba5520e58ca8321 tdf#70293 XLSX export: fix lost grouping of shapes It will be available in 7.4.4. 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.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5b18eebc2c95321ce7e6edf10f4df81557382a48 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL threaded