Description: I am unable to view the entire text in the cell. Steps to Reproduce: 1.Insert a large block of text into a cell. In my case, it was a walkthrough text for the game Shadowgate (2014). This text should be longer than what can fit on the monitor screen. 2.Right-click on the row number where the cell is located and select 'Optimal Height'. Check the 'Default value' box so that the cell expands and more text becomes visible. Actual Results: I tried to enter the cell to edit the end of the text, but I can’t reach it. I’m unable to scroll through the text. Scrolling the mouse wheel skips the entire cell instead of gradually moving through it. The PgUp/PgDn keys do the same. I also tried navigating with the arrow keys, but without success. I can’t see the end of the cell on the screen. I only see its beginning, and when I try to scroll, the next cell appears on the screen while the cell with the text moves up and out of view. Expected Results: There should be an option to gradually scroll through the cell from start to finish using the mouse wheel. The end of the cell should be visible on the screen. This should work both when editing the cell and when simply viewing it. Reproducible: Always User Profile Reset: No Additional Info: My screen resolution is Full HD, if that helps. In the mouse settings, 'Roll the mouse wheel to scroll' is set to 'Multiple lines at a time'.
Only by-row scroll is provided, pixel based "smooth scroll" requested bug 40917 However comment 0 "Description: I am unable to view the entire text in the cell." is not valid. Rather, the Formula bar "Input Line" in calc provides non-styled text editing for IIANM 64,000 chrs in a calc cell. More than sufficient for those not abusing a spreadsheet. More of the text/formula is made visible simply by dragging the bottom edge of the input line downward, max of 25 lines--but text of the entire cell will be editable with simple text cursor, home, end and pgDn, pgUp movements. Also a scroll bar at right, but that has some issues. *** This bug has been marked as a duplicate of bug 40917 ***
Hi Ekron, (under 25.2.5.2 (X86_64)/LibreOffice) I put your description 6 times into A1 (via the text box above the cells) and did your point 2 (for whatever). Neither scrolling right nor down (after a double click on A1) showd the end, right, but in both cases you can hit ctrl+end to get there ("...viewing it.") and add something (which I did). (Hit return or click on the hook to keep it). Just a work around, OC. I too want smooth scrolling!