<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<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#c29">Comment # 29</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>Whether a name is local or not is determined by the position of the
<table:name-expressions> Element in file (9.4.11 in ODF 1.2 and ODF 1.3).
>From that definition, a local named range as source cannot work with a pivot
table, which is located on a different sheet. So the UI should only list local
named ranges as source, which belong to the target of the pivot table. The
current default target for a pivot-table is a new sheet, so in this case no
local named ranges should be listed as source.
If I make a document with local named range, put the pivot table on the same
sheet as the local named range and manually change the file so, that the names
are identical, then it still doesn't work.
For me the problem is not in the implementation of local named ranges, but the
way the pivot table interprets <table:source-cell-range>.
(In reply to Eike Rathke from <a href="show_bug.cgi?id=37268#c28">comment #28</a>)
<span class="quote">> However, I consider ODF 1.3 part 3 section 19.677.12 to be insufficiently
> defined, it (likely, didn't check now) was already defined such way in ODF
> 1.2 before sheet-local names were even implemented.</span >
It might be necessary to add a note, that for getting the cell range from the
table:name attribute the local named ranges of that sheet, which is given by
the table:target-range-address attribute, has to be considered too.
Sheet-local names already exist in ODF 1.2, new in ODF 1.3 is the possibility
to use a named range as source for a pivot table.</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>