Bug 75015

Summary: FILEOPEN: Vertically Aligned Chart Title displayed backwards
Product: LibreOffice Reporter: Luke <lukebenes>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: jorendc
Version: 4.2.0.4 release   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:
Bug Depends on:    
Bug Blocks: 75057    
Attachments: Show the issue with vertical titles in Charts
PDF export using Excel 2010
PDF export using 4.3.2.2

Description Luke 2014-02-15 10:27:48 UTC
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"/> ?
Comment 1 Jorendc 2014-02-17 09:34:47 UTC
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
Comment 2 Beluga 2014-10-08 05:39:47 UTC
Created attachment 107534 [details]
PDF export using Excel 2010
Comment 3 Beluga 2014-10-08 05:41:45 UTC
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.

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.