keikai renders a best-fit column width quite differently from Excel

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Critical
    • 6.1.0
    • Affects Version/s: 6.0.0
    • Component/s: None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. import the file and compare column A width with Excel

      Current Result

      Column A is much narrower

      Expected Result

      end users expect it should look rough the same width as Excel

      Debug Information

      • the column is bestFit="1". It's produced by entering a long text, enable bestFit, then reducing the cell content to 1 character. Excel doesn't shrink cell width when removing characters under best-fit enabled.

      Workaround

      • remove bestfit column width calculation in Spreadsheet.getColumnPosition()

            Assignee:
            jumperchen
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: