| Summary: | FILEOPEN: text flow parameters incorrectly set in .XLSX causing some labels to disappear | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Joey Reid <joeyisdamanya> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | barta, erack |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=85491 https://bugs.documentfoundation.org/show_bug.cgi?id=122091 |
||
| Whiteboard: | target:4.4.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 75057, 108542 | ||
| Attachments: |
Problem with Overlap and Break import settings with XLS on Left and XLSX on right
Sample XLSX chart with missing labels Same file but saved as XLS correctly imported |
||
Created attachment 107296 [details]
Sample XLSX chart with missing labels
Created attachment 107297 [details]
Same file but saved as XLS correctly imported
confirmed under Win7x64 using 4.3.2.2 and 4.4.0.0.alpha0+ Build ID: 268b9c10c9ff27c74678ace99762f28d58d33012 TinderBox: Win-x86@42, Branch:master, Time: 2014-10-02_23:35:24 it seems that 50% of the labels in the x axis are not shown same issue even with older LibO release (tried with 3.4.3) and in AOO 4.1.0 as well so the bug is likely to be inherited from OOo Sushil Shinde committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4027bc476a1df9df1924447795ddc2d8b7744e20 fdo#84647 : Fixed default value for TickLableSkip value. 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. Steps to reproduce: 1. Create a chart in Excel with long label names (2 or more lines) 2. Save as .XLS and .XLSX 3. Open in Calc When Calc imports Excel XLS charts, it correctly sets: Text FLow:Break-enabled But for XLSX charts it sets Text FLow:Break-DISABLED This causes as the labels in XLSX to overlap and makes them unreadable. @Joey Reid have you tested that with recent 4.0.x daily builds? those are the only LibO versions featuring that bugfix Tommy, Yes, Sushil fixed the Text Flow:Overlap default. I verified that's it's working now with the latest 4.4 builds. Instead of messing up this report, I just now created Bug 85491 for the Text FLow:Break default. Sushil, Should this bug report be reopened? In recent builds Text Flow:Overlap is not being set any more. Hi Luke, This issue was fixed in two parts, 1. https://gerrit.libreoffice.org/#/c/11901/ 2. https://gerrit.libreoffice.org/#/c/12213/ Second patch is not yet merged to master. If possible, Please apply these patches and verify. If this issue still reproducible then reopen it. I will look into it. Thanks. What's going on here? It was fixed perfectly with Sushil's patch, but now is broken again. We are back to using the wrong OOXML defaults for: Text Flow:Overlap-enabled Text FLow:Break-enabled These incorrect values cause the every other label disappear. Could someone explain why we went back? Unless there's a good reason, could we please restore them? Since we're back to the using old bad values, I've reopened this bug. I have merged two patches and resubmitted it. Please review. Link : https://gerrit.libreoffice.org/#/c/12213/ ** 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.5 or 5.1.2 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: 2016-04-16 We are still ignoring the OOXML text flow parameters causing charts with long label names to render incorrectly. Verified on: Version: 5.2.0.0.alpha1+ Build ID: 23ad336bfe61316b08f85e827b98fc593ac6908a ** 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 text flow parameters still not imported correctly in Version: 6.2.0.0.alpha0+ Build ID: 29306111ecaff2f66d4d53c990eef83cf97d1a65 This report seems to be based on an incorrect assumption that there is an XML tag in the OOXML standard that maps to the ODF text flow parameter. There is no mapping for OOXML's automatic label settings. WFM in Version: 6.3.0.0.alpha0+ (x64) Build ID: f548dfa29239913fd71be67eadc2905010cabd95 and WFM in Version: 6.1.1.2 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b |
Created attachment 107295 [details] Problem with Overlap and Break import settings with XLS on Left and XLSX on right When Calc imports Excel XLS charts, it correctly sets: Text Flow:Overlap-enabled Text FLow:Break-enabled But for XLSX charts it sets Text Flow:Overlap-DISABLED Text FLow:Break-DISABLED This causes visual data loss, as the labels disappear. In the screenshot, you can see every other label is missing in the XLSX file.