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

            Bug ID: 171108
           Summary: Want ability to cap, rather than set, widths of
                    columns
           Product: LibreOffice
           Version: 26.8.0.0 alpha0+ master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: needsUXEval
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]
            Blocks: 108364, 127204

Sometimes, we are faced with the need to limit the widths of some columns,
while some columns have acceptable widths.

This typically happens when column widths have not been set explicitly; and
some columns have cells with long text, while othert columns don't, or _have_
been set explicitly. I experience this most frequently when importing a CSV or
text file.

To reduce the widths of those columns, there are two things we can do right
now:

* Select individual columns and set their individual widths.
* Select all or almost-all columns and set a single width for all of them.

The first option is tedious; and the second option undoes the work already done
choosing appropriate width for narrower columns, and forces you to then set
those widths manually again, or have them overly wide with not enough columns
visible in the document pane.

I suggest that a capability be introduced to apply a width _cap_, i.e. to have
LibreOffice reduce the widths of all selected columns, which are above some
limit value, to that value - without increasing the width of narrower columns.

UI-wise, this can be realized by adding some kind of  toggle to the Format >
Columns > Width... dialog. It could be a checkbox (although the exact wording
of the label might be a little tricky), or it could be a two-state radio button
with the labels corresponding to the two actions, e.g. "Set" and "Cap" or
something like that.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108364
[Bug 108364] [META] Table/Row/Column/Cell management function bugs and
enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=127204
[Bug 127204] [META] Formatting bugs and Improvements
-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to