Apache OpenOffice (AOO) Bugzilla – Issue 114944
AutoFilter don't work with RTL sheets
Last modified: 2017-05-20 10:33:53 UTC
It seems that AutoFilter doesn't work when the sheet is set RTL. Clicking on the AutoFiler list doesn't expand the list of values to choose from. When changing the sheet to LTR, the AutoFiler expands the list properly. Notice that this isn't affected by the UI direction or the language (happens with English and RTL UI). Only the sheet is RTL. Step to reproduce: 1. Open a new sheet, type some text in a few cells. 2. Data -> Filer -> AutoFilter. 3. Check that the AutoFilter expands the value list. 4. Right click on the sheet's name and set it to RTL. 5. Repeating step #3 will fail. 6. Right click on the sheet's name and set it to back to RTL. 7. Repeating step #3 will succeed. This issue was verified on both 3.2.1 (OOO320m19) and 3.3 beta (OOO330m7). Setting to P2, as filters are quite important for working with calc.
This is a regression between: oo320m18 (build 9502) [OK] >>> ooo330m3 (build 9519) [BUG]. In order to isolate the problem, are there any available builds between those two?
Oh, my mistake. According to Kaplan version report, this is a regression between oo320m18 and oo320m19. Sorry for the noise.
"According to Kaplan version report, this is a regression between oo320m18 and oo320m19." I never wrote that... I could also verify this issue with oo320m12 (3.2.0).
According to Kaplan, his versions test is based on GO-Oo version, while my test is based on the mainline versions. In conclusion, the bug was created between oo320m18 (build 9502) and ooo330m3 (build 9519), and a clue to find the correct change is that this is a change which was inserted earlier in Go-Oo (at least in oo320m12) and then in the mainline.
In any case, this issue is present in 3.3 beta (OOO330m7) from oo.org.
The issue may be related to the change in the positon of the arrow in the cell, in ooo320m18 - RTL sheet, the arrow is in the left side of the cell (as it has to be), and all is OK. In ooo330m3 - RTL sheet, the arrow is in the right side of the cell (which is wrong) and the list couldn't be expanded. Screenshots attached. Maybe the wrong position of the arrow is the reason of the issue.
Created attachment 71975 [details] ooo320m18 - arrow is in the left side of the cell and the list could be expanded
Created attachment 71976 [details] ooo330m3 - arrow is in the right side of the cell, list couldn't be expanded
BTW, I find a code-change in the code of the arrows in autofilter, it may be realted to the issue. http://hg.services.openoffice.org/cws/calcselectioncursor/rev/7ba13f4a900e
Hi Niklas, please have a look
@netanel_h: That specific change was not in any OOO320 build and also was not part of previous Go-oo versions, it was introduced for DEV300/OOO330, see issue 109553, and in this case is part of a rebase of CWS calcselectioncursor.
Issue has been accepted as stopper for 3.3, adjusting target accordingly
Fixed in CWS "ooo33gsl10".
reassigning to QA for verification
verified in build cws_ooo33gsl10