[Bug 85170] FillAuto doesn't fill formulas in hidden columns

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 4 06:38:51 UTC 2025


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

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org
             Status|REOPENED                    |UNCONFIRMED
           Keywords|                            |needsUXEval
     Ever confirmed|1                           |0

--- Comment #19 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(In reply to vic from comment #18)
> (In reply to Andreas Heinisch from comment #16)
> > Imho it is a feature. Imagine a table with hidden rows where you store some
> > information and you may forget about it. Then you do an autofill either via
> > GUI or macro and overwrite it. After the save you have no chance to recover
> > your overwritten data anymore. You don't even know that you have overwritten
> > something. The same holds for filtered data.
> 
> Then that calls for a warning before or after autofill, to ask you whether
> you accept overwriting - just like it warns you when you paste data onto
> cells that already contain data.
> Or - an option in Tools > Options to customize this behaviour.
> 
> Instead, you eliminated an important feature to intentionally work with
> hidden rows/cols. 
> Imagine you have hundreds or thousads of rows - would you find it practical
> to keep them all unhidden/ungrouped in order to autofill?

Let's loop in UX. So the proposal is to stay with the original request, but
with the condition that a warning is implemented at the same time (an option is
dangerous because as we have seen countless times, people set options, forget
about them and then scream about losing data).

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list