Bug 136173 - Calc: No text displayed if part of merged cells where not all cells are visible
Summary: Calc: No text displayed if part of merged cells where not all cells are visible
Status: RESOLVED DUPLICATE of bug 126208
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency tree / graph
 
Reported: 2020-08-27 10:15 UTC by necros2k7
Modified: 2022-08-12 11:28 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
sample (10.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-08-27 10:22 UTC, necros2k7 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***