<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Pilot and sheet local defined named range insert menu entry inactive"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=37268">bug 37268</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>rb.henschel@t-online.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Pilot and sheet local defined named range insert menu entry inactive"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=37268#c24">Comment # 24</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Pilot and sheet local defined named range insert menu entry inactive"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=37268">bug 37268</a>
from <span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=161209" name="attach_161209" title="Document with local named range">attachment 161209</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161209&action=edit" title="Document with local named range">[details]</a></span>
Document with local named range
Open attached document.
Press Ctrl+F3 to open 'Manage Names' dialog.
Make sure, that MyNamedRangeLocal has scope Sheet1 in the list at the top.
Cancel or repair if necessary. (Causion: 'global' is preselected in the Scope
field at the bottom.)
Insert Pivot Table by:
Data > Pivot Table > Insert or Edit
In the dialog take option 'Named range' and select the only entry. It is
'Sheet1'.MyNamedRangeLocal.
OK
In the dialog drag 'Person' to 'Row Fields' and 'Value' to 'Data Fields'. OK.
Save.
Inspect file
You find in content.xml
table:name="MyNamedRangeLocal" as attribute in <table:named-range> in
<table:named-expresseions> in first <table:table>.
table:name="'Sheet1'.MyNamedRangeLocal" in <table:source-cell-range> in
<table:data-pilot-table> in <table:data-pilot-tables>.
Both table:name attributes must have the same values, see section 19.677.12 in
part 3, ODF 1.3.
Reopen the file, click into the pivot table and use 'Properties...' from its
context menu. Open + from 'Source and Destination'.
Notice option 'Named range' has empty value and is disabled.
The current solution for local named ranges in pilot tables does not work.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>