I have many tab delimited sheets. In some, there are columns with space delimited data such as "123 S MAIN ST #5B". Wanting to split this column on the spaces: - select column - copy - add new sheet - right-click - paste special..., unformatted text - select space separator - OK Data is pasted as expected; but when I try to scroll down, if the visible rows are say 1-30, scrolling will only work until row 30 is no longer visible. Scrolling will not go lower. Amount of available scrolling varies based on number of visible rows. If I select a cell at the bottom of the visible area, and press down-arrow a few times to get past this limit, full scrolling is now available.
No repro, tested with master 7.5+ in Windows. Please paste Help-About and try with user profile folder delete. If bug persists, please attach sample file and make a screencast.
Just downloaded the latest 7.5 a few minutes ago... Here are the exact steps to reproduce: - opened new calc document - entered aaaa bbbb cccc into cells A1 B1 C1 (default: Liberation Sans, 10pt) - clicked on cell A1 - highlighted text in Input line - middle-clicked on cell A2, pastes aaaa -- A1 is still selected - clicked on cell A2 (font = Noto Sans, 7.2pt) -- bug - selected row 2 - changed font/size to Liberration Sans, 12pt -- A2 visible text does not change Bonus: :) - clicked on B1, Ctrl+C -- B1 is still Liberation Sans, 10pt - clicked on B2, empty cell is Liberation Sans, 12pt - Ctrl+V -- B2 = "bbbb" and is Liberation Sans, 10pt as expected - select row 2 - changed font to Liberation Sans, 12pt - B2 "bbbb" size visibly increases - A2 "aaaa" does not change -- bug
[Automated Action] NeedInfo-To-Unconfirmed
I cannot test this nor is this related to initial report about scrolling. You may add a screencast. Note that middle click is not generally available, you should use menu commands to explain what you do.
Pierre, are you on Linux using GTK3? I think it might have to do with a change in the GTK scrollbar. Please paste here the information copied from Help > About LibreOffice.
Almost forgot about this issue... I haven't seen this in a while, so closing. The following has surely changed since the original report too... Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 28ff4647e9dac8eebe3a169e828bacc8dc78e363 CPU threads: 20; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Jumbo
Thank you Pierre. I think this issue is still present and simpler to test: 1. Open Calc 2. Enter "1" in A1 cell, drag corner down to fill in a bunch of cells with a sequence (maybe 200 to be safe) 3. Copy whole column 4. In new sheet, paste in column A 5. Scroll down with the mouse: gets stuck at the end of the original range. This GTK3-specific issue was bibisected in bug 153049, so marking as duplicate of the newer one. *** This bug has been marked as a duplicate of bug 153049 ***