Bug 166326 - FORMATTING: Japanese "long vowel" character is not rotated in vertical cells when displaying XSLX
Summary: FORMATTING: Japanese "long vowel" character is not rotated in vertical cells ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Sheet
  Show dependency treegraph
 
Reported: 2025-04-24 15:38 UTC by Dmitry
Modified: 2025-05-01 08:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot showing expected and actual behavior (138.54 KB, image/png)
2025-04-24 15:49 UTC, Dmitry
Details
ODS file, displays properly (13.38 KB, application/octet-stream)
2025-04-24 15:49 UTC, Dmitry
Details
XSLX file, displays wrong (5.91 KB, application/octet-stream)
2025-04-24 15:50 UTC, Dmitry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dmitry 2025-04-24 15:38:50 UTC
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
Comment 1 Dmitry 2025-04-24 15:49:00 UTC
Created attachment 200497 [details]
Screenshot showing expected and actual behavior
Comment 2 Dmitry 2025-04-24 15:49:43 UTC
Created attachment 200498 [details]
ODS file, displays properly
Comment 3 Dmitry 2025-04-24 15:50:15 UTC
Created attachment 200499 [details]
XSLX file, displays wrong
Comment 4 Mateusz Wlazłowski 2025-04-30 19:17:58 UTC
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
Comment 5 Saburo 2025-04-30 23:52:53 UTC
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.