Bug 75015 - FILEOPEN: Vertically Aligned Chart Title displayed backwards
Summary: FILEOPEN: Vertically Aligned Chart Title displayed backwards
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: 4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 75057
  Show dependency treegraph
 
Reported: 2014-02-15 10:27 UTC by Luke
Modified: 2014-10-08 05:41 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Show the issue with vertical titles in Charts (10.65 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-02-15 10:27 UTC, Luke
Details
PDF export using Excel 2010 (166.19 KB, application/pdf)
2014-10-08 05:39 UTC, Beluga
Details
PDF export using 4.3.2.2 (16.14 KB, application/pdf)
2014-10-08 05:41 UTC, Beluga
Details

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.