Auto-alignment, auto-size cells

[ndrogers]

Options should be provided to automatically align columns, rows, or both in tandem.

[ndrogers]

@PaulMansour @mkromberg
Auto alignment of columns appears to be done by Excel, by measuring a specific width, not as a property of a column.

  <cols>
    <col min="1" max="1" width="18.453125" bestFit="1" customWidth="1"/>
    <col min="2" max="2" width="27.81640625" bestFit="1" customWidth="1"/>
    <col min="3" max="3" width="28.453125" bestFit="1" customWidth="1"/>
  </cols>

Attempting to include bestFit without the customWidth and width properties reduce the columns to a width of 0. I am unclear at this time how to calculate the width property.

<cols>                                                     
  <col min="1" max="1" bestFit="1" customWidth="1"></col>  
  <col min="2" max="2" bestFit="1" customWidth="1"></col>  
  <col min="3" max="3" bestFit="1" customWidth="1"></col>  
</cols>                                                    

<cols>                                     
  <col min="1" max="1" bestFit="1"></col>  
  <col min="2" max="2" bestFit="1"></col>  
  <col min="3" max="3" bestFit="1"></col>  
</cols>   

[PaulMansour]

Ok, given the XML, I think we should just have a ColumnWidths property of the range object, and leave setting the size up to the user. Each element is the width of the corresponding column in the range. It looks like the actual value unit is the width of single (average) char in the default font. So for a 10 digit number, one might set it to 11, or, say, 13 or 14 to handle commas, dollar signs., etc.