Bug 140127 - Impossible to reach content because oversized cell caused by Wrap
Summary: Impossible to reach content because oversized cell caused by Wrap
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Regressions-row-height
  Show dependency treegraph
 
Reported: 2021-02-03 15:12 UTC by Telesto
Modified: 2024-03-04 03:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file (8.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-03 15:13 UTC, Telesto
Details
Bibisect log (3.56 KB, text/plain)
2021-02-03 18:35 UTC, Telesto
Details
Bibisect log (2.90 KB, text/plain)
2021-02-03 18:37 UTC, Telesto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2021-02-03 15:12:47 UTC
Description:
Impossible to reach content because oversized cell caused by Wrap

Steps to Reproduce:
1. Right Click Format cell D9
2. Check Alignments tab -> Wrap text automatically
3. Select column D and drag it to left (say where column H is before the drag)
4. Scroll down

Actual Results:
Large white space (cell not adjusted). Scroll down.. well skipping the whole cell

Expected Results:
If wrap would function the skip extremely large cell with be more trivial.. but not the case


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 66013201749df7d5ac5ddaf377a7b3732518a93b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL
Comment 1 Telesto 2021-02-03 15:13:01 UTC
Created attachment 169438 [details]
Example file
Comment 2 Telesto 2021-02-03 18:35:36 UTC
Created attachment 169449 [details]
Bibisect log

Empty space before note content after resizing since:
author	Tomaž Vajngerl <tomaz.vajngerl@collabora.co.uk>	2015-05-07 14:18:37 +0900
committer	Jan Holesovsky <kendy@collabora.com>	2015-05-07 09:57:50 +0200
commit dca01def7885ad69cf66edd75cf8207a5adb64f9 (patch)
tree f3b43717ab058b677c68614bcb2953beb7c7d1a0
parent 7a11ec1992bf877f42edce8d1d930c5b00bd3d48 (diff)
refactor ListBox/ComboBox to use RenderContext

https://cgit.freedesktop.org/libreoffice/core/commit/?id=dca01def7885ad69cf66edd75cf8207a5adb64f9
Comment 3 Telesto 2021-02-03 18:37:49 UTC
Created attachment 169450 [details]
Bibisect log

All note content visible (creating extreme long cell) instead of 'hiding' at certain spot.. Whereas scrolling causes a skip (because long cell and cell based scrolling (different bug), since:

authorVasily Melenchuk <Vasily.Melenchuk@cib.de>	2018-04-06 20:19:10 +0300
committer	Katarina Behrens <Katarina.Behrens@cib.de>	2018-10-22 23:30:23 +0200
commit 693953dd4699887bd3f5bca2c3582b5fae1d6992 (patch)
tree 2091b2fe8d997ef84f149ace1e6a1f00fd8e08fe
parent fad764c02c7a9cd210bfa44ea0ce1ac5354d6427 (diff)
tdf#62268: allow row height recalculation on document load
During document load rows with style:use-optimal-row-height="true"
should recalculate it's height.

 * includes: Row height tolerance level increase for unittest
 * tdf#118086: calc: invalid row autoheight fixed

https://cgit.freedesktop.org/libreoffice/core/commit/?id=693953dd4699887bd3f5bca2c3582b5fae1d6992
Comment 4 mulla.tasanim 2021-02-05 17:10:44 UTC
Thank You for reporting the bug.

I can confirm the bug present in

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

Version: 7.2.0.0.alpha0+ (x64)
Build ID: 761a672d62df1891b9f4f367a499b220ab2b33fa
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 5 Justin L 2022-02-24 08:33:15 UTC
The glaring issue with this is the inability to scroll down the cell when the cell is larger than the entire screen. That has been true since at least LO 3.5.

Two ways to get to the content:
1.) zoom out so the cell fits on the screen.
2.) double-click in the cell to get into edit mode.

Until we can scroll past the starting point of a cell, I don't see any point in doing anything with this bug report.
Comment 6 QA Administrators 2024-03-04 03:12:59 UTC
Dear Telesto,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug