https://bugs.documentfoundation.org/show_bug.cgi?id=93123
Bug ID: 93123
Summary: VIEWING: Split/frozen sheet not redrawn properly when
formula with manual range selection causes page to
scroll
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A certain combination of conditions causes part of the screen to not redraw
properly:
* Window is split or frozen
* Inputting data in the last visible row (so that pressing enter causes the
window to scroll)
* Input a formula which then uses the cursor to select a range (for instance,
click sum, then select the cells using the mouse)
Steps to reproduce:
1 Create a new spreadsheet
2. Insert some numbers anywhere on the sheet
3. Freeze the sheet
4. In the bottom right pane, click a cell in the last visible row (so that
pressing enter will move the cursor down to the next row and force the screen
to redraw.)
5. Press the sum button
6. Use the mouse to drag a range around the numbers you inserted earlier
7. Press enter
Pressing enter should calculate your sum formula and move the cursor down one
cell. Since the selected cell was the bottommost visible cell, this will cause
our view to scroll down one cell.
Expected:
Our newly inserted formula and the region that was drawn when the screen
scrolled should be redrawn correctly.
Actual:
Our newly inserted cell appears completely blank, but selecting the cell shows
the correct formula in the formula bar.
Notes:
The entire new bottom row of cells (the region redrawn by the window scrolling)
is also not redrawn properly and will show blank values for cells with existing
data. That region will also be corrupted by other items, such as the animated
"marching ants" copy region overlay and the magenta outline of our formula's
manual range selection.
This is extremely irritating if a user is keying a long list of values since
each row will be corrupted as they key the formulas down the screen.
This is probably another edge case caused by some change to normal calc code
that wasn't implemented in split/frozen panes.
I can confirm that this bug affects LO 4.4.5.2 and 5.0.0.4. I went ahead and
bibisected using the 4.4 repo, but had to skip some versions because they
crashed on launch.
Bibisect:
There are only 'skip'ped commits left to test.
The first bad commit could be any of:
23eae1c9e288ecd9bb5e66a00f9bfc346982ae55
b74dafb5d92d445ce1f441eeb81e717a1a78fb03
5e858479245b1764a924407670bf449d5cd06890
We cannot bisect more!
$ git bisect log
git bisect start 'latest' 'oldest'
# good: [5d0dfb8e62ae61a240f8313c594d4560e7c8e048]
source-hash-0c6cd530de13f80795881f61064f1bf1dcc4ea81
git bisect good 5d0dfb8e62ae61a240f8313c594d4560e7c8e048
# bad: [7dfacd0b8bd828331d74c0f79de6e8924bc4e6a5]
source-hash-f93ce4f7eb90093d0ea3115d0a1c614612676dbd
git bisect bad 7dfacd0b8bd828331d74c0f79de6e8924bc4e6a5
# bad: [1a63057f6378db7c6b8af1171b7b140f7583f246]
source-hash-59f84b4a2c082382767f12e0c7a06a3f0b52e721
git bisect bad 1a63057f6378db7c6b8af1171b7b140f7583f246
# good: [3787e4f82e47eaf4fa454afdca671272e50f875b]
source-hash-0e09134a4a4cbb0639fc586c560c6fb2765487be
git bisect good 3787e4f82e47eaf4fa454afdca671272e50f875b
# good: [13c63ebe51bd9151757981f75b62271c00a47bf1]
source-hash-5ccb510ef7dd6688b86038b37563583f64107936
git bisect good 13c63ebe51bd9151757981f75b62271c00a47bf1
# good: [2e44b89901b3478fac6251ab4fa87311bb8c256f]
source-hash-91ebd8825bf0ac6bf3daaba54cefc1a11a64451d
git bisect good 2e44b89901b3478fac6251ab4fa87311bb8c256f
# skip: [b74dafb5d92d445ce1f441eeb81e717a1a78fb03]
source-hash-87cb919c7ccf5aacda27b36781d5896eebbd182b
git bisect skip b74dafb5d92d445ce1f441eeb81e717a1a78fb03
# skip: [23eae1c9e288ecd9bb5e66a00f9bfc346982ae55]
source-hash-2e6abb5d910f4813b75f86860c0b84ca01d98093
git bisect skip 23eae1c9e288ecd9bb5e66a00f9bfc346982ae55
# good: [743a6cc47f93aca3478e55e63cd29cdccfdcc3aa]
source-hash-9dd5caac62083f7162d83319284df68ee83e3777
git bisect good 743a6cc47f93aca3478e55e63cd29cdccfdcc3aa
# bad: [5e858479245b1764a924407670bf449d5cd06890]
source-hash-589ca2a5e88a976bb10e60fcb1e3e75f4aa2504e
git bisect bad 5e858479245b1764a924407670bf449d5cd06890
# only skipped commits left to test
# possible first bad commit: [5e858479245b1764a924407670bf449d5cd06890]
source-hash-589ca2a5e88a976bb10e60fcb1e3e75f4aa2504e
# possible first bad commit: [23eae1c9e288ecd9bb5e66a00f9bfc346982ae55]
source-hash-2e6abb5d910f4813b75f86860c0b84ca01d98093
# possible first bad commit: [b74dafb5d92d445ce1f441eeb81e717a1a78fb03]
source-hash-87cb919c7ccf5aacda27b36781d5896eebbd182b
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
