https://bugs.freedesktop.org/show_bug.cgi?id=61520
--- Comment #24 from Anatoly Moskovsky <a...@ferrit.net> --- > In the XLS test file, Sheet2 contains the data range named data1 that is > defined as entire column A but actually it contains only four values. That > definition enables adding new values to the data range without the need to > redefine it, which is quite convenient. > > When user clicks to open a drop-down list in a validation cell I'd suggest > that Calc checks the data range in order to find the last non-empty value in > the range and then to work only with the real range of data. > > I'd say there is a function that finds the last non-empty value on a sheet > when you click Ctrl-End. Actually whole-column ranges worked fine in 3.5 (the dropdown was shown immediately if a few values only were at the beginning of the column). But now it hangs in 4.x. So it looks like a regression. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs