[Libreoffice-bugs] [Bug 37268] Data Pilot and sheet local defined named range insert menu entry inactive

[bugzilla-daemon at bugs.documentfoundation.org]

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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #24 from Regina Henschel <rb.henschel at t-online.de> ---
Created attachment 161209
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161209&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200523/3ab8c432/attachment.htm>