https://bugs.documentfoundation.org/show_bug.cgi?id=106197
Bug ID: 106197
Summary: xlsx import: support Body Properties "upright"
Product: LibreOffice
Version: unspecified
Hardware: All
URL: https://msdn.microsoft.com/en-us/library/documentforma
t.openxml.drawing.bodyproperties(v=office.15).aspx
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 83672
https://cgit.freedesktop.org/libreoffice/core/commit/?id=1abc0695d770eebd21256a86aeee14a5384d84c7
> don't rotate calc shapes if twoCellAnchor, partial fix bnc#762542
fixed an issue with rotated shapes. an unit test was added in:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=b99c869c4361c7d5f51462c922fd7e9d64e1433b
> bnc#762542: Unit test for 1abc0695d770eebd21256a86aeee14a5384d84c7
this introduced the regression described in bug 83672.
I think the fix only works by chance. The shapes in the bugdoc are rotated by
90° but also have the attribute "upright" in the Body Properties "bodyPr"
> <a:bodyPr vertOverflow="clip" vert="horz" wrap="square" lIns="0" tIns="0"
> rIns="0" bIns="0" anchor="ctr" upright="1"/>
https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.bodyproperties(v=office.15).aspx
>Specifies whether text should remain upright, regardless of the transform
>applied to it and the accompanying shape transform. If this attribute is
>omitted, then a value of 0, or false is implied.
>
>[Example: Consider text that has been rotated within the text body but has
>the upright flag set.
>
><p:txBody>
> <a:bodyPr upright="1" rot="5400000" …/>
> … (Some text) …</p:txBody>
>
>This text appears as though no transform has been applied to it. end example]
>
>The possible values for this attribute are defined by the W3C XML Schema
>boolean datatype.
I could not find a way to create shapes with "upright" property in Excel2016
but maybe some Excel SmartArt set the property in their shapes.
For a demo document take attachment 113662 from bug 83672.
Could someone with access to bnc#762542 can tell how the bugdoc was created?
(Note: This issue looks a bit like bug 104290 but that shape has a
vert="vert270" attribute which turns the text by an additional 270° to the 90°
shape rotation which results in a upright text in Excel.)
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=83672
[Bug 83672] FILEOPEN: .xlsx Rotated Images No longer Rotated
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
