Bug 142951 - The character string is displayed on the left outside of the cell
Summary: The character string is displayed on the left outside of the cell
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.0.beta1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-20 04:03 UTC by qve00761
Modified: 2024-02-24 03:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
The string is displayed on the left outside of the cell. (11.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-06-20 04:05 UTC, qve00761
Details
SnapShot LO7.2.0Beta1 (121.44 KB, image/png)
2021-06-20 04:06 UTC, qve00761
Details
SnapShot (120.53 KB, image/png)
2021-06-20 04:06 UTC, qve00761
Details
Vertical writing, with line breaks (29.00 KB, application/vnd.ms-excel)
2021-06-20 16:30 UTC, qve00761
Details
Snapshot on 7.2.0.0.beta1 (x86) (54.84 KB, image/png)
2021-06-21 03:20 UTC, qve00761
Details
Screnshoot with 7.6.0.1 (41.40 KB, image/png)
2023-07-27 16:34 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description qve00761 2021-06-20 04:03:36 UTC
Description:


When writing vertically in Japanese, the character string is displayed on the left outside of the cell.

In 7.1.3,these strings were displayed on the upper outside.
This error was repaired in 7.2.0.0.alpha1.
However, in 7.2.0.0.bata1, the string is now displayed on the left outside of the cell. 


Steps to Reproduce:
1.Read the attached ods file.
2.The string is displayed on the left outside of the cell.


Actual Results:
the character string is displayed on the left outside of the cell.

Expected Results:
The string is displayed on the inside of the cell.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.beta1 (x86) / LibreOffice Community
Build ID: c6974f7afec4cd5195617ae48c6ef9aacfe85ddd
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 1 qve00761 2021-06-20 04:05:20 UTC
Created attachment 173025 [details]
The string is displayed on the left outside of the cell.
Comment 2 qve00761 2021-06-20 04:06:07 UTC
Created attachment 173026 [details]
SnapShot LO7.2.0Beta1
Comment 3 qve00761 2021-06-20 04:06:50 UTC
Created attachment 173027 [details]
SnapShot
Comment 4 qve00761 2021-06-20 04:09:06 UTC
(In reply to qve00761 from comment #3)
> Created attachment 173027 [details]
> SnapShot

LibreOffice 7.2.0 alpha1
(Normal Case)
Comment 5 qve00761 2021-06-20 04:13:56 UTC
When I was investigating this phenomenon on another Windows 10 terminal,
 the character string disappeared and it crashed. 

Bug 142950 - Crash in: mergedlo.dll (edit)
Comment 6 m_a_riosv 2021-06-20 12:26:13 UTC
Opening your file, I see it on the cell of the top, not to the right.

Disabling the option in cell format alignment for Asian layout mode, shows it right.
Comment 7 qve00761 2021-06-20 16:30:15 UTC
Created attachment 173037 [details]
Vertical writing, with line breaks

I want the character string to be displayed in the cell even when Asian layout mode is ON.

The original data for attachment 173025 [details] was in xls format.
When you read a cell that is set to be written vertically in xls format, Asian layout mode is turned on.

In the xls format file, if the character string is broken in the cell in vertical writing, it cannot be displayed normally unless Asian layout mode is ON.

For reference, I will attach the sample data of the case where the character string is broken in the cell in vertical writing.

In LO7.2.0Beta1, the string is also displayed outside the left side of the cell in this file.
Comment 8 qve00761 2021-06-20 16:42:18 UTC
(In reply to m.a.riosv from comment #6)
> Opening your file, I see it on the cell of the top, not to the right.
> 
> Disabling the option in cell format alignment for Asian layout mode, shows
> it right.

If the string is displayed in a protruding state on the outside of the upper side of the cell,
I think you are using LO7.1.3 or an earlier version.
It have been solved in LO7.2.0Alpha1, but now it is displayed on the outside on the left side in LO7.2.0 Beta1.
Comment 9 m_a_riosv 2021-06-20 20:39:46 UTC
Seems the import of xls is even worse with
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5fb7f66d240fec32a4751d331a215307ad994cbb
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded.

Only the arrow of rebasing the cell is showed. Changing alignment to right shows fine, but the left arrow persist.
Comment 10 qve00761 2021-06-21 03:20:54 UTC
Created attachment 173046 [details]
Snapshot on 7.2.0.0.beta1 (x86)

When you load a file with 7.2.0.0.beta1 (x86), 
it will be displayed on the outside of the left side of the cell.
Reading a file with 7.2.0.0.beta1 (x64) causes the symptom of Comment # 9.
Comment 11 BogdanB 2023-05-15 18:22:30 UTC
Many improvements have been made since June 2021. Can you try a 7.5 version of LibreOffice to test if you can see this problem?
Comment 12 BogdanB 2023-07-27 15:26:12 UTC
We need more retesting here, after all this years.
Comment 13 m_a_riosv 2023-07-27 16:34:22 UTC
Created attachment 188598 [details]
Screnshoot with 7.6.0.1

Looks fine opening the original file without any modification.
Version: 7.6.0.1 (X86_64) / LibreOffice Community
Build ID: 776eaf34564cbf3f034a0ba1fd1d5c32ff9ccf1c
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Comment 14 ady 2023-07-27 16:53:27 UTC
FWIW, I cannot repro in versions 7.1.0.3, 7.2.7.2, so it is no surprise I cannot repro in current Dev 24.2 either.

Having said that, perhaps the specific (ja) fonts might be required in order to replicate the problem.
Comment 15 QA Administrators 2024-01-24 03:12:54 UTC Comment hidden (obsolete)
Comment 16 QA Administrators 2024-02-24 03:14:30 UTC
Dear qve00761,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp