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

should not autofit a column with wrap text cells only

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: