https://bugs.documentfoundation.org/show_bug.cgi?id=85170
--- Comment #29 from Colin <[email protected]> --- (In reply to Heiko Tietze from comment #28) > We discussed the topic in the design meeting. > > > For people who do the same operation repeatedly we could add an option to > set some default. Like "[x] Do Ask Again", and if unchecked we default to > either Yes or No, depending on what is being clicked. Since such an option > is dangerous it could be blocked if the variable is read only in the expert > setting, for instance. I use it regularly (LOCALC has nothing that compares to Excel or GSheet dynamic tables). Obviously, I'm aware of the current limitation, so I regularly unhide multiple columns over numerous sheets and drag fill. It's a pain, but it works, and if forgotten, easily identified and remediated. It's also often impossible to get LOCALC to fulfil the task in hand without "hidden helper columns", so it's essential to replicate formulae as the array expands. I think the default should NOT be a potential double negative. I agree that if the user's choice was to replicate the formulae, the [x] factor should then signify not just the desire not to be pestered again with the question but also ensure the replicate/don't replicate choice remains "Set in Stone". BIG ISSUE: There will probably be the need for somebody to later change their mind and either decide they do want to be pestered or they don't want replication. Is that achievable without making it horribly complex? Perhaps also consider setting the parameter locality as Sheet-specific or file-specific. Probably best to avoid application-specific. -- You are receiving this mail because: You are the assignee for the bug.
