https://bugs.documentfoundation.org/show_bug.cgi?id=37268
Regina Henschel <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #24 from Regina Henschel <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
