[Libreoffice-bugs] [Bug 107385] Autofilter sorting breaks rows data alignment without warning

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

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

--- Comment #11 from b. <newbie-02 at gmx.de> ---
@Mike, sorry, first part ot, relevant for the bug below, 

------------ 
@kokbira and @Luca: 

no backup no mercy, 

i suggest at least 'always create backup copy' and 'save auto recovery
information every xx minutes', 

and! a manual backup before! every important step at least every hour, 

if you don't want to go to the trouble of clicking it together yourself again
and again, the small macro below - e.g. placed on a shortcut via 'customize
keyboard' - can make your work much easier. it saves a timestamped copy in the
subdirectory 'backup' of the folder from which the document was loaded, without
affecting the current work, e.g. filename of current work is kept and undos are
still possible. 

sub save_a_timestamped_copy

' extract filename ----------------------------------------------------
  sParts      = Split(thiscomponent.getURL(), "/")
  filename    = sparts(UBound(sparts))

' insert "backup" to store in different folder ------------------------
  storeurl    = join(split(thiscomponent.getlocation, filename), "backup/" &
filename)

' append timestamp to name for the copy -------------------------------
  timestamp   = format(now,"\_yyyy-mm-dd\_hh-mm\.")
  storeurl    = join(split(storeurl, "."), timestamp)

' save a copy with the new name ---------------------------------------
  ThisComponent.StoreToURL(storeurl, Array())

end sub 'save_a_timestamped_copy
------------ 

for the bug: 

there are! use cases where (other) users don't want to sort or filter data
neighboured to that they want to act on, 

autofilter is quite aggressive in overriding users range-selection in plenty
cases, far too aggresive imho, e.g. automatically adding rows below selected or
defined ranges messing up users totals and footnotes, 

you have fallen into one narrow gap where autofilter takes the user's
instructions into account - which in your case did not correspond to the user's
intention :-(, 

changing te behaviour to throw a warning makes sense, 

a behaviour that gives the user more control is also desirable, 

and 'streamlining' the handling between data-sort, autofilter, autofilter-sort
and other filters would also produce happier users, (it's limited as filtering
acts on whole rows, i know), 

taking more control / influence away from the user imho is 'not good', 

perhaps there is one error in autofilter, might be ... it's intended to have
automatic extension into neighboured columns, and that is mistakenly applied to
rows?? #132488 suspects that something fundamental is odd in the handling of
'ByRow' and 'ByColumn'.

-- 
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/20200518/cd136a68/attachment.htm>