Bug 136173

Summary:	Calc: No text displayed if part of merged cells where not all cells are visible
Product:	LibreOffice	Reporter:	necros2k7 <necros2k7>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	minor	CC:	79045_79045, alex_polkovnik, buzea.bogdan, timur
Priority:	low
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108320
Attachments:	sample

Description necros2k7 2020-08-27 10:15:50 UTC

Description:
Reappears only after doubleclicking into the cell, scrolling down then up, disappears after saving file again
No text in Print preview either

Steps to Reproduce:
1. open attached file
2. step into 12A cell 
3. see text appear

Actual Results:
no text after opening file

Expected Results:
text should be visible in 12A cell and visible in Print preview


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.0.2 (x86)
Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
Потоков ЦП: 12; ОС: Windows 10.0 Build 19041; Отрисовка ИП: Skia/растр; VCL: win
Locale: ru-RU (ru_RU); ИП: ru-RU
Calc: threaded

same bug on LO 6.4 x32, 7.0.0.3 x32, 7.1 daily build x86 (in safe mode also)

Comment 1 necros2k7 2020-08-27 10:22:45 UTC

Created attachment 164741 [details]
sample

Comment 2 Roman Kuznetsov 2020-08-27 10:38:32 UTC

Confirm in

Version: 7.1.0.0.alpha0+ (x64)
Build ID: <buildversion>
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

and in 4.4.7.2 on Windows too

Comment 3 Roman Kuznetsov 2020-08-27 10:39:43 UTC

It does not depend on Skia

Comment 4 BogdanB 2020-08-27 11:25:58 UTC

If you press Ctrl+M over that cell the text will appear

Comment 5 BogdanB 2020-08-27 11:26:42 UTC

Ctrl+M = shortcut for Clear Direct Formatting

Comment 6 Alexander Polkhovskiy 2020-08-28 07:39:03 UTC

To my mind the problem is that A9-A14 are merged, and A9-A11 are hidden. If you unhide them, you'll see the text.

Comment 7 Alexander Polkhovskiy 2020-08-28 07:46:43 UTC

*A10-A14, not A9-A14. Show A10 and it works.

Comment 8 necros2k7 2020-08-29 03:50:12 UTC

it`s not a fix it`s a workaround right?

Comment 9 Alexander Polkhovskiy 2020-08-30 09:36:41 UTC

If the content must be visible in this case, then it's a bug and the way is workaround of course. MS Excel shows it, by the way.

Comment 10 Timur 2022-08-12 11:07:22 UTC

No text displayed in A12 if part of merged cells A10-A14 where only A12 cell visible.

(In reply to Alexander Polkhovskiy from comment #6)
> To my mind the problem is that A10-A14 are merged, and A9-A11 are hidden. If
> you unhide them, you'll see the text. Show A10 and it works.

Well explained. 
So this is a rather large text in a small cell, Center hor. and Middle vert. aligned in cells A10-A14 where only A12 is visible. 
I set Low-Minor.

Comment 11 Timur 2022-08-12 11:28:07 UTC

Seems duplicate.

*** This bug has been marked as a duplicate of bug 126208 ***