Red Hat Bugzilla – Bug 201740
Sort Lists don't seem to work
Last modified: 2013-04-02 00:21:20 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:220.127.116.11) Gecko/20060614 Fedora/18.104.22.168-1.2.fc5 Firefox/22.214.171.124 pango-text
Description of problem:
Neither the pre-seeded Sort Lists or custom lists that I create are working. For example, there is a built-in Sort List for months (January, February,...December). According to OO.org's documentation and user forums, I should be able to type 'January' into a cell and then drag the lower right corner (+) and have the months pre-filled based on this Sort List. That doesn't happen. Instead I always get the 'Fill Series' dialog.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Type 'January' into A1
2. Grab bottom right corner and drag the cell
'Fill Series' dialog appears
If the first value (A1) matches a Sort List, I expect the values in the Sort List to be filled into the selection.
"Red Hat reviews and scrubs its code for intellectual property issues. Our
approach has always been conservative, i.e., if there is any question, resolve
the issue or remove the code. Red Hat recently implemented a number of changes
in its distribution of OpenOffice to address such issues. These changes should
not be construed as implying any immediate intellectual property problem;
rather, they have been implemented to assure that no such immediate problems
arise. While implementing these changes in our own distribution of OpenOffice,
we have also made them available upstream to the OpenOffice project."
sucks, doesn't it. selecting "Formula" fill from that dialog is the closest fit.
*** This bug has been marked as a duplicate of 146883 ***