https://bugs.freedesktop.org/show_bug.cgi?id=61520
--- Comment #23 from rpr <[email protected]> --- (In reply to comment #20) > Hi, > Now that bug 58630 and bug 61948 are fixed, it looks clear for me that this > is not a bug but a particular problem when using a too long list (if anyone > can tell me who can choose an element among 1000000 ? - this is due to a > permissive use of Excel where you can select an entire column) > > [...] > > So, imho, there is nothing to do, just explain to users, or have an > improvement, eg: the drop-down arrow should not be shown when the list is > greater than a readable length 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. -- 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
