[Libreoffice-bugs] [Bug 113585] Auto Filter Columns are Treated Separately in the Attached ODS File

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 19 16:52:18 UTC 2020


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

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

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

--- Comment #7 from b. <newbie-02 at gmx.de> ---
30 months later ... 

hello @Kevin, 

you managed to have two overlapping data ranges in your file, 

one "workshop_consumption", manually set and covering A1:A3692, 

one "__Anonymous_Sheet_DB__0", such ranges / names are automatically created
when you apply an autofilter to a 'not-predefined' range, covering A1:B3692, 

this was not 'foreseen' by the developers, and or too complex for a programmer
to apply a non-conflicting handling for it, thus the two filters collide in a
similar manner as if you apply one to column A and one to columen C, by sorting
rows touching the other filters range they are in conflict, leftmost column
wins?,  

i'm unsure if 'notabug, user error', or if one can request an error handling
option against the construction of such situation ... 

your original definition: 

<table:database-range table:name="workshop_consumption"
table:target-range-address="'Source Data'.A1:'Source Data'.A3692"
table:orientation="column"/>

<table:database-range table:name="__Anonymous_Sheet_DB__0"
table:target-range-address="'Source Data'.A1:'Source Data'.B3692"
table:display-filter-buttons="true" table:orientation="column"/>

and it's not the first but a subsequent save of the file as you got - wrong -
'table-orientation' tags ...

-- 
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/20200519/c64d77c8/attachment.htm>


More information about the Libreoffice-bugs mailing list