Issue 124193 - Data pilot: 'rightclick - refresh' ignores "Ignore empty rows"
Summary: Data pilot: 'rightclick - refresh' ignores "Ignore empty rows"
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: regression
Depends on:
Reported: 2014-02-05 22:32 UTC by aparat2
Modified: 2014-02-06 18:09 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

pivot table ingores "Igore empty rows" on refresh (10.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-05 22:32 UTC, aparat2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description aparat2 2014-02-05 22:32:17 UTC
Created attachment 82509 [details]
pivot table ingores "Igore empty rows" on refresh

While "Ignore empty rows" is checked:
action: r-click -> Edit layout -> OK
result: no (empty) in pivot table

action: r-click -> refresh
result: an (empty) row appears in data pilot
Comment 1 Rainer Bielefeld 2014-02-06 05:03:14 UTC
Reproducible with "AOO 4.0.1 – German UI / German locale [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor versions:

1. From AOO Start Center open reporter's sample document
2. On Pivot Table cell A5: 'Rightclick -> Refresh'
   Bug: below "IDReceptury" in E4 a new line with "(empty)" in E5 will be
        created, although in cell A5: 'Rightclick -> Edit-Layout -> More 
        - Result' "Ignore empty rows" is checked

Additional Info:
(a) Still Reproducible with server installation of "AOO 4.1.0-Dev – English UI
    / German locale - [AOO410m1(Build:9750) - Rev. 1562493 - 2014-01-30]" 
    on German WIN7 Home Premium (64bit)", own separate user profile.
(b) Already Reproducible with sever installation of "OOo 3.3.0 English UI 
    / German locale [OOO330m20 (Build 9567)]" on WIN7 Home Premium (64bit) DE
(c) Was still ok with sever installation of "OOo 3.2.1 English UI 
   / German locale [OOO320m18 (Build 9502)]" on WIN7 Home Premium (64bit) DE
(d)  Already reproducible with  Pre-3.4.0 (OOo 3.3.0), but because of crippled  
     Version selector (Bug 123063) no useful info can be contributed
Comment 2 Rainer Bielefeld 2014-02-06 05:25:05 UTC
Comment 3 Edwin Sharp 2014-02-06 09:25:06 UTC
OK with 3.0.1
Win 7
Comment 4 Oliver Brinzing 2014-02-06 18:09:58 UTC