Description: Textbox in an Excel spreadsheet loses its “Vertical alignment: Center” property after saved as .xlsx and opened in Calc. Steps to Reproduce: 1. Create a textbox in an Excel spreadsheet 2. Type some text 3. Click left on the textbox border and choose “Size and properties” 4. In the toolbar on the right, open “Textbox” 5. Set the vertical alignment to Center. Attachment contains examples for all options available in this field, the other five works fine. 6. Save the document in XLSX format 7. Open the file in Calc Actual Results: The vertical alignment changed to Center Center. Expected Results: The vertical alignment should have stayed Center. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: 52a49f9e480ca03e231cfda82640a928393131c9 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded Not happening yet in: Version: 7.1.0.0.alpha0+ (x64) Build ID: bcf1917a0934417226d2357b514df398129a7fab CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL (latest verstion from bibisect-win64-7.1 repo, 13 days ago) Maybe it’s connected with https://bugs.documentfoundation.org/show_bug.cgi?id=129685.
Adding CC to Miklos Vajna
Created attachment 165813 [details] Screenshot of the original document side by side in Excel and Calc
Created attachment 165814 [details] Example file from Excel
I believe we can close this as a dupe of bug 137023 Both pptx and xlsx used the same oox code *** This bug has been marked as a duplicate of bug 137023 ***
Verified in: Version: 7.1.0.0.alpha1+ (x64) Build ID: d3cee4f3839e22754e167e89d25acd6ccacf0b6e CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded