[Libreoffice-bugs] [Bug 59312] AUTOFILTER: in non functional after 'Copy Sheet' in new sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #10 from b. <newbie-02 at gmx.de> ---
for the Bug Hunting Session 7.0.0.0.a1+: 

OP behaviour still repro, 

same action (copy sheet with defined autofilter) with some other data works
ok!, you gain functioning autofilters in the copied sheet, e.g.
http://bugs.documentfoundation.org/attachment.cgi?id=56922 from #45958, 

difference: 

the file 'source.ods' for this bug has! a 'defined range' which the filter is
'mapped'? to, 

('forfilters' defined with '<table:database-range table:name="forfilters"
table:target-range-address="Tabelle21.A1:Tabelle21.I9"
table:display-filter-buttons="true" table:orientation="column"/>' in
content.xml)

while 'example.ods' from #45958 doesn't have such a definition, and the filter
is mapped to an '__Anonymous_Sheet_DB__0', 

(such database ranges are defined automatically when you apply an autofilter
which doesn't find a defined range to apply to, '<table:database-range
table:name="__Anonymous_Sheet_DB__0"
table:target-range-address="Hoja1.A1:Hoja1.C1048574"
table:display-filter-buttons="true"/>' in content.xml)

(forfilters does have a 'xml_tag'? table:orientation="column" which is applied
- mostly? - when re-saving a file after save-load cycle and is relevant for
other misinterpretations, e.g.
https://bugs.documentfoundation.org/show_bug.cgi?id=132488 - dunno if that
steps in here too) 

and! forfilters is a 'defined range' which is a name 'global to a document'?
and can: 
- neither have multiple definitions with different 'scopes' like 'named ranges'
may have, 
- nor is a 'per sheet' definition, as '__Anonymous_Sheet_DB__0' is, which as
well can have multiple definitions within one document, one per sheet, thanks
@Eike for clarification, 

thus it's logically impossible to create an identical fully working copy of a
sheet with an autofilter defined referencing a 'defined range', 

unless you e.g. work with new names like e.g. 'forfilters_01' ..., or define
and set 'scopes' for defined ranges, or other creative solutions, 

be aware that the behaviour of #132488 messing around with the .field values
might step in for any development and tests of this problem ... i can't judge
this reg. very small knowledge about the structures and the code (in fact i
just stumbled across this bug when i was looking for the steps in which
'table:field-number=' and 'table:orientation="column"' are defined for the save
to file and are read back for runtime representation, any tips for that would
be highly appreciated - in #132488 o.c.), 

all above looked for and said by a 'newbie', i apologize for any mistakes I may
have made ... 

as well i apologize for the length of my contribution, I try to analyze and
present the situation clearly, i hope for 'old bugs' such an approach is
allowed, 

maybe you should introduce a new category: 'currently not solveable' and
declare such bugs as enhancement requests? 

simply omitting the filter buttons as suggested by the OP would not be a
solution in my opinion, the copy of the sheet would be incomplete,

-- 
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/20200514/d5583671/attachment-0001.htm>