Created attachment 94115 [details] Show the issue with vertical titles in Charts This bug was found in a LO 4.3 running in windows 7. LibreOffice reverses up the text orientation when importing MS Office Open XML .docx and .xlsx files with vertical allign. I have attached an example. Steps to reproduce the bug: 1. Open attached VerticalChartTitle.xlsx document in Calc 2. Open attached VerticalChartTitle.xlsx document in Excel2007/2010/365 3. Compare the documents. Note that MSO displays the title top-down, while Calc displays it bottom-up. Here are the results of other title alignments that I tested and the associated MS Office Open XML: Vertical (top-down) Rot - LO FAIL <a:bodyPr vert="eaVert" rot="0"/> 90 Rot (top-down)- LO PASS <a:bodyPr vert="horz" rot="5400000"/> 270 Rot (bottom-up) - LO PASS <a:bodyPr vert="horz" rot="-5400000"/> Can anyone tell from the OXML spec if <a:bodyPr vert="horz" rot="5400000"/> is equivalent to <a:bodyPr vert="eaVert" rot="0"/> ?
I can confirm this behavior, tested using Mac OSX 10.9 with LibreOffice Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b (In reply to comment #0) > Can anyone tell from the OXML spec if <a:bodyPr vert="horz" rot="5400000"/> > is equivalent to <a:bodyPr vert="eaVert" rot="0"/> ? Not sure about that. This is the only information I found on the internet: http://officeopenxml.com/drwSp-text-bodyPr-columns.php Probably there is more information in the specifications. Kind regards, Joren
Created attachment 107534 [details] PDF export using Excel 2010
Created attachment 107535 [details] PDF export using 4.3.2.2 The vertical title and the border around the chart are invisible in 4.3.2.2 Win 7 64-bit. Same result with 4.4.0.0.alpha0+ dev build from Oct 06.
So the import proble around the chart title seems to be fixed in master. I'm hijacking this bug report however for the export issue with the same document.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bee3934bb68f38e89bb33f75f405099ca08d59a9 first part for axis title manual position export, tdf#75015 It will be available in 5.0.0. 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d55cb0845a094601dcc0149e9a59e360021d231c export title rotation, tdf#75015 It will be available in 5.0.0. 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=af46ffafb73ff305e53be8768033d69ca9e6e5e1 add test for tdf#75015 It will be available in 5.0.0. 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e9fbe1f7cd28de2a9da8089d89e903406165eb56 also add a test case for title rotation, tdf#75015 It will be available in 5.0.0. 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.
There are a few more layout problems around that file: manual layouting of plot area, ... but I will use different bug reports to track them. The title layout issue has been mostly fixed. There are minor positioning differences that I need to revisit in the future. For now it looks quite good.