[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Cor Nouws  changed:

   What|Removed |Added

 CC||na+lo...@nicapicella.com

--- Comment #37 from Cor Nouws  ---
*** Bug 77681 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Cor Nouws  changed:

   What|Removed |Added

 CC||gtre...@ville-saintdie.fr

--- Comment #36 from Cor Nouws  ---
*** Bug 91221 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Cor Nouws  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |FIXED

--- Comment #35 from Cor Nouws  ---
@Joel: seeing the commit in comment #32, fixed is proper here, I think?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Yan Pashkovsky  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #34 from Yan Pashkovsky  ---
tested on linux and windows 7 v 5.0.1. Everything seems to work fine. Formats,
empty headers, numeric headers, special symbol headers - all works fine.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Joel Madero  changed:

   What|Removed |Added

 Resolution|FIXED   |WORKSFORME

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #33 from Yan Pashkovsky  ---
tested on 5.0.1.2, seems to work fine. Someone test please too. Tommorow I will
perform more tests and close as fixed

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Yan Pashkovsky yanp...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=91
   ||305

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Commit Notification libreoffice-comm...@lists.freedesktop.org changed:

   What|Removed |Added

 Whiteboard|BSA |BSA target:5.0.0

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #32 from Commit Notification 
libreoffice-comm...@lists.freedesktop.org ---
scito committed a patch related to this issue.
It has been pushed to master:

http://cgit.freedesktop.org/libreoffice/core/commit/?id=00836605a441b8b1d548d8c32f63535f3240ac61

tdf#63416 Do not sort header in autofilter if user has chosen one in dialog

It will be available in 5.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #31 from Heiko Tietze heiko.tie...@user-prompt.com ---
Postponed to next week

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #30 from mahfiaz mahf...@gmail.com ---
I think I belong more to the i...@scito.ch camp with smart behavior. Which
means ux-advise probably needs to talk this through next Wednesday.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #29 from Heiko Tietze heiko.tie...@user-prompt.com ---
To put it all together:

1. First row with text only
- make it a header, do not sort, do not hide on filter

2. First row with empty cells only
- make it a header using 'col XY' or the like, do not sort, do not hide on
filter

3. First row with mixed content (text, numbers, and empty cells)
- make it a header, (temporarily) convert numbers into text, fill empty cells
with col XY or the like, do not filter, do not sort

4. First row with numbers only
- make it a header, (temporarily) convert numbers into text, do not sort, do
not filter

Alternatively we could 
a) keep the current behavior, 
b) just add a first row, 
c) disable sort/filter if no header is present, 
d) move the autofilter stuff to the table header (column 'A' would be 'A' with
a dropdown menu), or 
e) have the autofilter stuff somewhere else e.g. at the sidebar. 
But for consistency I'd use the same behavior in all cases, probably like Excel
does (haven't one at hand).

The question whether or not the first row should become the header would be
obsolete.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #28 from i...@scito.ch ---
I've compared autofilters with Excel 2010. There is always a header row, i.e.
only data rows without header are not possible. Thus, the second case of
comment 21 does not exist in Excel 2010.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

 CC||vinc...@nexedi.com

--- Comment #26 from i...@scito.ch ---
*** Bug 65178 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #27 from i...@scito.ch ---
I've submitted a patch for review: https://gerrit.libreoffice.org/#/c/15277/
Hopefully, it will be accepted by the reviewers.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #21 from i...@scito.ch ---
Proposition for new behaviour:

1. If there is a header row (detect with pDBData-HasHeader())
* do not sort the first row (aSortParam.bHasHeader = true)
2. else if there is no header row
* first row will be sorted too (aSortParam.bHasHeader = false), but
autofilter buttons should stay at the first row

Currently, the autofilter buttons will be moved too, if there is no header row.
In large files, the autofilter buttons disappear somewhere in the sheet. This
is not good.

In the second case (no header row), I propose to change the code as follows
a. Remove autofilter buttons
b. Sort rows
c. Add autofilter buttons again to the new first row.

I think this would be the correct solution. It would meet the expectations of
the users.

What do you think about my proposition?
Is moving of the first row necessary? (comment 13)
How can autofilter buttons be removed/added in a correct way?

Additionally, I propose to enhance the Test::testAutofilter() in ucalc.cxx:
1. non-string column headers (empty cells and numbers)
2. with and without header row

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #22 from Yan Pashkovsky yanp...@gmail.com ---
I want to add something. If the first row contains numbers, but has cell-type
text it should not be sorted. For example I have a journal of students, where
the first row looks like: Name, Subgroup, 1 (week number), 2 (week number), 3,
4... And below the week numbers are marks. I do not want week numbers were
mixed with marks.

And if the first row contains any empty cell it should not be sorted too.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #24 from Yan Pashkovsky yanp...@gmail.com ---
This dialog doesn't work :) Whatever I choose all data will be mixed with
header

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #23 from i...@scito.ch ---
I assumed that the Do you want the first line to be used as column header?
dialog remains. That's why the user has the choice. The result of this dialog
is then asked with pDBData-HasHeader(). See also bug 65178.

Thus, your case should be handled fine, if you set the header row with the
dialog.

Sorry, my proposition was not detailed enough.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #25 from i...@scito.ch ---
 This dialog doesn't work :) Whatever I choose all data will be mixed with 
 header

Because it's not yet fixed. It will be respected with the patch of attachment
114291. Locally, on my computer it works and this decision is respected. But
this patch is not enough for a full solution without a header row (i.e. first
line contains also data), since the autofilter buttons move with the data line.
Thus, my proposition for a new behaviour in comment 21.

In comment 18, I proposed to commit this little patch. Then we gain already a
lot, even if the second case (no header, i.e. first row with data), does not
work properly. But I assume, most of the time we have a header row.
(80-20-rule)

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

 CC||LibreOffice@bielefeldundbus
   ||s.de

--- Comment #20 from i...@scito.ch ---
*** Bug 41781 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=65
   ||178

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

 CC||canavarosk...@gmail.com

--- Comment #19 from i...@scito.ch ---
*** Bug 86968 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=41
   ||781

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #17 from Yan Pashkovsky yanp...@gmail.com ---
In bug 89277 headers containing numbers were sorted too. So everything that is
no text will not be recognized as header and thus sorted

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

 CC||yanp...@gmail.com

--- Comment #16 from i...@scito.ch ---
*** Bug 89277 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #18 from i...@scito.ch ---
Created attachment 114741
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114741action=edit
Screenshot: Autofilter-button remains  if header is moved

I've noticed with the current master (f8976c4) the clicked autofilter button
remains sometimes after the header is moved, see screenshot. This does not
happen with version 4.3.6.2.

How to reproduce:
1. At least 3 Columns, in the middle an empty one, see screenshot.
2. Add autofilter on first column
3. Sort asc and desc with autofilter.
4a. The clicked button remains sometimes.
4b. Repeat step 3 if problem does not occur.

I think this behaviour is not a cause of this bug report, it just a new
secondary effect of moving autofilter buttons.

This behaviour appears also if the proposed solution of comment 13 is applied.

Thus, I propose to submit a patch to gerrit for review, as proposed in comment
13. This patch is probably not the final solution, but it is a big improvement.
The user decision of having a header or not is respected. It will be far better
than the current behaviour.

If this small patch would be committed, another bug report could be written for
the GUI update problem. This GUI issue could be solved independently.

Do you agree with my proposition?

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #15 from i...@scito.ch ---
Issue 89277 seems to be a duplicate. Should it be marked as duplicate?

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org
  Component|Calc|ux-advise

--- Comment #14 from Joel Madero jmadero@gmail.com ---
Let's ask UX for input on that default behavior.

My sense is that many people do sort without headers (even if that is silly)
and that making it default will likely piss a lot of users off ;) But that's
not too new so let's see what UX has to say.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #13 from i...@scito.ch ---
Created attachment 114291
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114291action=edit
Patch respecting user decision for autofilter header

Inbetween I've setup a libreoffice development environment. I've written a
little patch, which uses the hasHeader information chosen by the user in
ScDBFunc::ToggleAutoFilter().

But does it make sense to have autofilters without headers?
Maybe for filters, but not for sorting. For sorting the autofilter buttons are
always moving around.

Should the header in ScGridWindow::UpdateAutoFilterFromMenu() always be set to
true?
aSortParam.bHasHeader = true;

Currently the attached patch respecting the user decision (sc_63416_1.diff) has
a GUI refresh problem. If the user has chosen to have no headers, the clicked
button remains visible. This could be fixed if this patch is the right
approach.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #12 from i...@scito.ch ---
Created attachment 114181
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114181action=edit
Code parts responsible for current behaviour

Thanks for your explanation according to priorities. Since there is a
workaround (fill empty column headers with a space) the priority is minor.

I've analysed the code by using the online git view since I do not have a LibO
development environment.

Basically, the following lines of code are responsible for the current
behaviour:

void ScGridWindow::UpdateAutoFilterFromMenu(AutoFilterMode eMode) {
...
bool bHasHeader = pDoc-HasColHeader(
aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2,
nTab);

aSortParam.bHasHeader = bHasHeader;



bool ScTable::HasColHeader( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol,
SCROW /* nEndRow */ ) const
{
for (SCCOL nCol=nStartCol; nCol=nEndCol; nCol++)
{
CellType eType = GetCellType( nCol, nStartRow );
if (eType != CELLTYPE_STRING  eType != CELLTYPE_EDIT)
return false;
}
return true;
}

I've attached the relevant code parts responsible for autofilter sorting, see
attachment.

Lacking an IDE, I do not know how often ScTable::HasColHeader is used and what
the impact of a change of this method would be.

This autofilter sorting feature was added with commit
http://cgit.freedesktop.org/libreoffice/core/commit/?id=2a755c0cd61b619ed14e023ad34fc7596eafdf34

Currently, I do not know what a correct solution would be.

Additionally, there is a warning dialog shown if the autofilter is applied with
empty cells in the header: The range does not contain column headers.
Do you want the first line to be used as column header? This behaviour should
be considered too.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

--- Comment #11 from Joel Madero jmadero@gmail.com ---
No - it's not a good candidate. Although it's annoying, it's not equal to loss
of data and crashers. Ideally we hope to move away from the MAB list completely
and adding these kinds of bugs will just keep that list going. We're going to
move to strictly using priority/severity as soon as we can lock these fields
from manipulation.

That being said - if you have a suggestion as to how this bug should
*objectively*[1] be prioritized, please look at this chart, and give your
feedback for what you think and why: 

https://wiki.documentfoundation.org/File:Prioritizing_Bugs_Flowchart.jpg

[1] Please be objective. For instance, if there is a workaround then *by
definition* it's a minor bug. Note that this has very little impact on if the
bug is actually resolved - if a developer finds a minor or trivial bug
annoying, god chance they'll volunteer to fix it, despite the low
priority/severity setting.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63416

i...@scito.ch changed:

   What|Removed |Added

 CC||i...@scito.ch

--- Comment #10 from i...@scito.ch ---
LibO 4.3.6.2 is affected by this problem.

Is this bug a candidate for the most annoying bug (MAB) list?
Rationale: It is not uncommon that empty columns are used and autofilter is
applied.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

Kevin Suo suokunl...@gmail.com changed:

   What|Removed |Added

 CC||philomo...@gmail.com

--- Comment #8 from Kevin Suo suokunl...@gmail.com ---
*** Bug 76010 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

Kevin Suo suokunl...@gmail.com changed:

   What|Removed |Added

 CC||suokunl...@gmail.com

--- Comment #9 from Kevin Suo suokunl...@gmail.com ---
It's worth mentioning that: when sort using the normal method (menu Data -
Sort), it works as expected.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

gibi g...@no-log.org changed:

   What|Removed |Added

 CC||g...@no-log.org

--- Comment #6 from gibi g...@no-log.org ---
This annoying bug still exists in 

Version: 4.2.1.1
Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

gibi g...@no-log.org changed:

   What|Removed |Added

 CC||john.pr...@cantab.net

--- Comment #7 from gibi g...@no-log.org ---
*** Bug 54382 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

--- Comment #5 from Stiftung Buehl supp...@stiftung-buehl.ch ---
This Bug still exit in Version 4.1.1.2-2, not nice!

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

 Whiteboard|BSA, bibisectrequest|BSA
   Keywords|regression  |

--- Comment #4 from Joel Madero jmadero@gmail.com ---
also removing bibisectrequest  regresion - neither confirmed to work. I went
through bibisect just to be sure using skip, every time it failed to get
correct lock of header with attached file.

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

Version|3.6.5.2 release |3.6.0.0.alpha1

--- Comment #3 from Björn Michaelsen bjoern.michael...@canonical.com ---
setting version to 3.6alpha as per last commit, this is not a regression in a
microrelease (that is: worked in 3.6.0, didnt in 3.6.Y).

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

--- Comment #1 from ebricca ebri...@gmail.com ---
Created attachment 77795
  -- https://bugs.freedesktop.org/attachment.cgi?id=77795action=edit
autofiler example image: after sort asc/desc

-- 
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

[Libreoffice-bugs] [Bug 63416] FILTER: autofilter -- first row lock

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63416

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

   Hardware|Other   |All
 OS|Windows (All)   |All
 Status|UNCONFIRMED |NEW
 Whiteboard|BSA |BSA, bibisectrequest
 CC||jmadero@gmail.com
Version|4.0.1.2 release |3.6.5.2 release
   Keywords||regression
 Ever confirmed|0   |1

--- Comment #2 from Joel Madero jmadero@gmail.com ---
First, thank you so much for reporting :) I knew that this was an issue but
couldn't figure out how to reproduce the issue. 

For the second issue you reported, please make a separate report, even though
they are related we try to keep the rule to 1 issue = 1 report

I have been able to confirm the issue on:
Version 3.6.5.2 
Platform: Bodhi Linux 2.2 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm this problem on an earlier release I am changing
the version number as version is the earliest version that we can confirm the
bug, we use comments to say that the bug exists in newer versions as well.

As I've been able to confirm this problem I am marking as:

New (confirmed)
Normal - can prevent high quality and/or professional work
Medium - seems appropriate, easy workaround is have a header



Note: I don't think that this is a regression, I tested all the way back to
3.6alpha (from bibisect) and I see the problem if I'm understanding it
correctly. Not changing version as I don't do this for bibisect

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed
(triaged) by human beings who mostly give their time for free. We invite you to
join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at
#libreoffice-qa

There are also other ways to get involved including with marketing, UX,
documentation, and of course developing - 
http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother,
please always provide reproducible steps (even if it seems easy) and attach any
and all relevant material

-- 
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