Description: UI. A checkbox for default column width rather odd UI choice width downsides Steps to Reproduce: 1. Open Calc 2. Right click on column A 3. Select Column width 4. Uncheck default value 5. Press OK 6. Reopen the dialog Column width -> checkbox checked again. So it's not an independent setting. It will be checked if the value is 2,26 cm 7. Go into width field, change the value by removing 6 by backspace and pressing 0 8. Notice that default value is still being checked. It only updates when you exit the spinbox. However the dialog isn't that big to be inclined to do so. So it appears to be the default value Actual Results: Unchecking default value does nothing Expected Results: Instead of a checkbox a button labeled: default value Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5ff701226b00963312cb2a78e77966d012b79c82 CPU threads: 8; OS: macOS 13.4.1; UI render: Skia/Raster; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
It's very unlikely that you find the exact value, which is 64 points or 1280 twips, which is 0.88888" or 2.25775cm (see also bug 154788 comment 21). Except via double click between the column headers that should run .uno:SetOptimalColumnWidth. Another question is a) if we need to reset to some arbitrary default value at all, and b) if this should rather be done with a button or just by clearing the input field. The checkbox is even more weird on the Optimal Width dialog (guess it defines a minimum there). Excel has no means in this dialog to reset the width to the default.