Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-513

should not autofit a column with wrap text cells only

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.9.0
    • 5.8.0
    • None
    • Security Level: Jimmy
    • None
    • None

      Steps to Reproduce

      1. import the attached file
      2. double click column B to autofit it

      Current Result

      enlarge the column width

      Expected Result

      don't resize the column width

      Debug Information

      • I have verified that Excel and Google sheet don't resize a column in this case
      • According to https://trumpexcel.com/autofit-excel/#When-you-have-applied-wrap-text

        when you have applied wrap text to cell and you try to autofit the column. This is less of autofit not working and more by design. Since you have applied wrap text, Excel doesn't know what is the column width it should use when you autofit.

        After all, wrap text means that any text would be wrapped in such a way that it would remain within the cell. In such a case, trying to autofit the column won't do anything. You can, however, adjust the column width manually.

            jumperchen jumperchen
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: