The data from a dates field are converted in text dates, not in calc dates, and i guess for this it can't be grouped.
This occurs with a file created from scratch with a few rows data.
Created attachment 56049 [details]
It is a regression.
I'll keep it for now.
This is already broken in 3.4 for me. Did it work for you in 3.4?
Ah nevermind it works in 3.4.
I'll look into it.
Fixed on master.
I'll ask for a review for backporting this to 3.5.
Note that even with this fix applied, you'll still need to delete and re-create the pivot table output that has this problem. Simply refreshing the table won't fix it.
It is also broken in 3.4.5.
I'm pretty sure it works with 3.4.4 and previous.
Is it possible to backport this fix for 3.4.6 ?
(In reply to comment #7)
> See https://bugs.freedesktop.org/show_bug.cgi?id=45164
> It is also broken in 3.4.5.
> I'm pretty sure it works with 3.4.4 and previous.
> Is it possible to backport this fix for 3.4.6 ?
Nope. Sorry. We may not be able to backport to 3.5 either. 3.4 is out of the question.
First of all, thanks for your so good work and efforts.
Understanding the difficulties to fix the bug in time, seems to me that the regression bugs, like this, many times invisibles to the user in a first instance, are the worst and carry to a very bad impression on the software, because they make to fall the confidence in the product. You can't be thinking about if the things that worked before, works now.
IMHO it's much better delay the release, when regression are there, specially with those what can interfere in the work without notice.
The 3.5 can be a very good and best release if was reachable to eliminate the regression bugs.
Delay is not happening on a time-based release. Period.
Ok. At least I've come up with a non-invasive fix for this. Let's see if we can get this piece included in 3.5.0. If not, I hope it to be at least in 3.5.1.
Nice to see a solution for this bug.
The fix works => pushed into 3-5 branch for 3.5.1, see
Two more approvals are needed to get it into 3-5-0 branch for 3.5.0-rc3
Pushed to 3-5-0. Will be fixed in 3.5.0RC3
Indeed, works well with this patch. Tested in LO 3.5.0 rc2+ under Ubuntu 11.10.
Thank you Kohei and all others who make possible to get it in 3.5.0 :-)
Best regards. JBF
Just stumbled against same issue in 184.108.40.206 - in the attached example trying to use groupping (F12) causes adding extra column.
Also (I'll add another example) - if the cell formatting for date contains any text string (i.e. DD" / "MMM" / "YYYY) then pivot table based on that formatting is converted to text thus resulting in lack of grouping.
Created attachment 75899 [details]
example of formatting breking pivot table grouping
Please file a new bug. It's not a good practice to reopen a very old bug which was filed against a very old version.
regression keyword set from comment #1 and comment #4.