https://bugs.documentfoundation.org/show_bug.cgi?id=153495
Bug ID: 153495
Summary: Make an easier workflow for Calc cell user-defined
formats cleanup
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I often find Calc documents with many (sometimes several hundreds) unused cell
user formats. I want to clean this mess up, which comes from the documents long
life...
The user-defined formats list cleaning is currently done like this:
1. Format > Cell
2. Number tab
3. Category pane, select the User-defined entry
4. Format pane, select the format to remove
5. Click the X toolbutton at the bottom of the dialog
This sequence shows several problems when one wants to repeat the deletion
multiple times (repeat points 4 and 5 above).
A. Multiple selection in 4 is not possible
B. <Suppr> key usage is not supported in 4 and 5
C. After clicking the X toolbutton, the focus *always* goes away from the
User-defined entry to some other format.
Thus multiple deletions of user formats require *a lot* of (mouse) operations
which makes it at least tedious, at most impracticable. In my situation (I've
got documents with 400 user-defined formats which came over time!), the
dialogue is simply not usable (to the point I've been thinking at writing a
macro of sorts to simply do that...).
Allowing multiple selections would be the better option but it might pose
problems with other operations in the dialogue.
A good improvement start would be (1) to not switch focus after deletion, and
(2) to support the <Suppr> key. These 2 improvements would allow for full
keyboard usage in this situation. Not fully satisfactory but a good start.
This problem is a long-standing one from the OOo times and is still present in
v.7.5.
Steps to Reproduce:
1.Format > Cell
2. Number tab
3. Category pane, select the User-defined entry
4. Format pane, select the format to remove
5. Click the X toolbutton at the bottom of the dialogue
Actual Results:
Multiple user-defined formats painful to delete.
Expected Results:
Easier process
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.6.2 / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded
(tested present in 7.5 under Windows)
--
You are receiving this mail because:
You are the assignee for the bug.
