Download it now!
Bug 118190 - EDITING Pasting font formatted cells in a new sheet skews new text (with Japanese locale)
Summary: EDITING Pasting font formatted cells in a new sheet skews new text (with Japa...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.2.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cut-Copy CJK-Japanese
  Show dependency treegraph
 
Reported: 2018-06-16 11:41 UTC by Emil Tanev
Modified: 2020-05-11 14:36 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Emil Tanev 2018-06-16 11:41:49 UTC
Write some text in range A1 - C2
Select all
Format cells - Font - Size to 36
While all is selected, Cut
Paste in another sheet
Write some new text

Issue: The new text is not displayed properly

https://screencast-o-matic.com/watch/cF1DX4FQmX
Comment 1 raal 2018-06-16 13:45:19 UTC
I can not confirm with Version: 6.2.0.0.alpha0+ (x64)
Build ID: 2c85607101e2e04e870e3b87362f39f9a9148e6c
CPU threads: 1; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-06-16_00:12:37

Please check with dev version. Thank you

http://dev-builds.libreoffice.org/daily/master/
Comment 2 Emil Tanev 2018-06-17 06:06:18 UTC
Reproducible with

Version: 6.2.0.0.alpha0+ (x64)
Build ID: bf1f49c837264c8f59197b9487d40e32821526c3
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-06-16_23:03:41
Locale: ja-JP (ja_JP); Calc: group threaded

https://screencast-o-matic.com/watch/cF1b1eF6Fk
Comment 3 Xisco Faulí 2018-06-17 15:37:27 UTC
I can't reproduce it in

Version: 6.2.0.0.alpha0+
Build ID: d60d695fcc5064e1f16842387fdce23456a64694
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

Nor in

Version: 6.2.0.0.alpha0+
Build ID: 6fcc60b49215acb28edac46bb605767840abd122
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-06-17_00:25:35
Locale: es-ES (es_ES); Calc: group threaded

Could you please try in safe mode?
Comment 4 Xisco Faulí 2018-06-18 15:22:36 UTC
> Could you please try in safe mode?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the issue is still present
Comment 5 Emil Tanev 2018-06-30 08:24:06 UTC
Reproducible in 
Version: 6.2.0.0.alpha0+ (x64)
Build ID: 7696d1d217b6cff63490e7f98403d0e499c33d17
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-06-30_01:51:45
Locale: ja-JP (ja_JP); Calc: group threaded

I reproduce it in Safe mode as well.
Comment 6 Susan Gessing 2018-07-01 14:45:09 UTC
Not reproducible in:

Version: 6.0.5.2 (x64)
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU threads: 4; OS: Windows 6.3; UI render: GL; 
Locale: en-US (en_US); Calc: CL

Windows 8
Comment 7 champi 2018-07-02 01:34:12 UTC
Reproducible in

バージョン: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS:Windows 10.0; UI render: default; 
ロケール: ja-JP (ja_JP); Calc: CL
Comment 8 Emil Tanev 2018-07-02 07:47:32 UTC
Locale: ja-JP (ja_JP) ?
Comment 9 champi 2018-07-02 08:19:23 UTC
Yeah sorry 

Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS:Windows 10.0; UI render: default; 
Locale: ja-JP (ja_JP); Calc: CL
Comment 10 Emil Tanev 2018-07-02 14:18:07 UTC
I meant, it is reproducible in JP locale only?
Comment 11 Buovjaga 2018-07-03 05:27:33 UTC
(In reply to Emil Tanev from comment #10)
> I meant, it is reproducible in JP locale only?

Emil: is it possible for you to try with a different locale?
Comment 12 Emil Tanev 2018-07-07 05:51:40 UTC
Nope, it does not happen in English. I suspect it is the font family? Also, notice how only the cells that have text are font-resized in Japanese (second 22 in the video) - this does not happen in English where all the cells get bigger after the resize. So you cut and paste bigger cells in English and the new text is not hidden.
It is a language specific bug it seems.

https://screencast-o-matic.com/watch/cF1DX4FQmX



Tested
Version: 6.2.0.0.alpha0+ (x64)
Build ID: 2986f4baa8bdef1f9ab9108240ea890075321be1
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-07-06_23:43:30
Locale: en-US (en_US); Calc: group threaded
Comment 13 Buovjaga 2018-07-07 07:12:08 UTC
Might be interesting for you to install older versions and see, if the problem existed in them. Champi already confirmed it in 6.0.2.

Here is a tool to make such installation simpler: https://dev-builds.libreoffice.org/kotlin-si-gui/main/si-gui-desktop-2018.06.08-0744-all.jar

https://flosmind.wordpress.com/2018/04/25/please-say-hello-to-the-new-si-gui/

From its settings you can define the installation folder.
Comment 14 QA Administrators 2019-11-16 03:41:26 UTC Comment hidden (obsolete)
Comment 15 Naruhiko Ogasawara 2020-05-11 13:42:03 UTC
This could be a specification I guess.

It is caused when the different sizes of fonts specified to Western Text Font and Asian Text Font (see 0:19 on the screencast https://screencast-o-matic.com/watch/cF1DX4FQmX). If I set same size both Western and Asian, the problem does not happen.
Comment 16 Naruhiko Ogasawara 2020-05-11 14:08:27 UTC
Alternatively, there may be an improvement in determining cell height based on the largest font size in western text and ancient text (or even complex layout text).
Comment 17 Naruhiko Ogasawara 2020-05-11 14:13:01 UTC
(In reply to Naruhiko Ogasawara from comment #16)
> Alternatively, there may be an improvement in determining cell height based
> on the largest font size in western text and ancient text (or even complex
> layout text).

sorry, s/ancient/asian/
Comment 18 Shinji Enoki 2020-05-11 14:36:32 UTC
I reproduced in the following environment:

Version: 7.0.0.0.alpha1
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 4; OS: Linux 3.16; UI render: default; VCL: x11; 
Locale: ja-JP (ja_JP.utf8); UI: en-US
Calc: threaded

As Ogasawara-san wrote, if the size of "Asian Text Font" ​​is enlarged and set to the same size, this will not be reproduced

Problems occur when only enlarging "Western Text Font" size.