[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