Description: Japanese Chōonpu character "ー" should be oriented vertically in vertical texts. However, when I load an Excel file which includes a vertical cell with Japanese text containing this symbol, it is not rotated. There are two ways to make LibreOffice display it rotated: - mark the cell as vertical in LibreOffice (initially the cell shows neither vertical not horizontal) - in Cell Format / Text Orientation, under the "Vertically Stacked" checkbox, additionally check "Asian Layout Mode" However, both ways assume manual actions after the document is loaded, AND are not persisted when the document is saved as XSLX. Steps to Reproduce: 1.Create a new spreadsheet, using LibreOffice Calc 2. Put "キョン君、電話ー" in a cell and mark it as Vertical. Note that the long vowel symbol displays vertically 3. Put "キョン君、電話ー" in another cell and format its text as "Vertically Stacked, Asian Layout Mode". Note that the long vowel symbol displays vertically 4. Save, using Excel 2007-365 format, then re-open in Calc Actual Results: In both vertical cells, the long vowel symbol displays horizontally, NOT OK Expected Results: In both vertical cells, the long vowel symbol displays vertically Reproducible: Always User Profile Reset: No Additional Info: Open the same document in MS Excel; the long vowel symbol displays vertically
Created attachment 200497 [details] Screenshot showing expected and actual behavior
Created attachment 200498 [details] ODS file, displays properly
Created attachment 200499 [details] XSLX file, displays wrong
Confirm from 7.2.0.1 (my oldest version) Version: 7.2.0.1 / LibreOffice Community Build ID: 32efc3b7f3a71cfa6a7fa3f6c208333df48656cc CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Reproduce LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 but, xls file is works fine. Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded When I open an xlsx file, "Asian Layout Mode" is unchecked. This seems to be due to the open filter.