[Libreoffice-bugs] [Bug 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #9 from Roman Kuznetsov <79045_79...@mail.ru> ---
verified in

Version: 6.3.0.0.alpha0+ (x64)
Build ID: 2e3b0c5d42d60d46cd9f8b8eda9424b095c63418
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-14_00:37:08
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

but there is another problem, I wrote about it in bug 124736

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

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

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

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

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.3.0

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #8 from Commit Notification 
 ---
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/b082998401e37e6c7534906601bc481423a6ded0%5E%21

tdf#113908: Implement exporting pivot tables' groups fields to XSLX

It will be available in 6.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://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
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #7 from Roman Kuznetsov <79045_79...@mail.ru> ---
https://gerrit.libreoffice.org/#/c/69653/

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

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

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

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

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #6 from Roman Kuznetsov <79045_79...@mail.ru> ---
still repro in

Version: 6.3.0.0.alpha0+
Build ID: ed707a4806a489467c6d9be7d1b787dab94b5f78
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

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

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Attachment #137836|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Attachment #137835|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #5 from kompilainenn <79045_79...@mail.ru> ---
(In reply to Bartosz from comment #4)
> How I could edit filter of grouped date in MS Excel?
> 
> I would like to recreate similar document by ownself.
> How I could create such grouped filter?


0. create table with date in one column and any data in another columns
1. insert pivot table
2. In dialogue Pivot Table Layout: move field "date" from "Available fields" to
"Row fields", another field move to you need. Push "OK"
3. In pivot table right click on any cell with date and press F12 on keyboard.
Opens dialogue "Grouping"
4. Select Intervals (checkbox) "Months" and "Years". Press "OK"
5. On pivot table right click and select from context menu "Edit layout"
6. In dialogue Pivot Table Layout: move fields "date" and "Years" from "Row
fields" to "Page fields", another field move to you need. Push "OK"
7. In top of pivot table must creates two filter

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #4 from Bartosz  ---
How I could edit filter of grouped date in MS Excel?

I would like to recreate similar document by ownself.
How I could create such grouped filter?

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords||dataLoss, filter:xlsx
 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1
   Severity|normal  |major

--- Comment #3 from Buovjaga  ---
Repro.

Win 8.1 32-bit
MSO 2013
LibO Version: 6.0.0.0.alpha1+
Build ID: a0ebba3d8855fee0bcec04a10137ae3a4f9f0e77
CPU threads: 4; OS: Windows 6.3; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-11-22_04:47:05
Locale: fi-FI (fi_FI); Calc: group threaded

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Blocks||112416


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX pivot table bugs
-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #2 from kompilainenn <79045_79...@mail.ru> ---
Created attachment 137836
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137836=edit
diss filter pivot table after LO 6.0 without change of data.xlsx

-- 
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 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon]

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

--- Comment #1 from kompilainenn <79045_79...@mail.ru> ---
Created attachment 137835
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137835=edit
diss filter pivot table.xlsx

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