Closed zulqasar closed 1 year ago
I will have to review this more. The problem I had in trying to set the column to the best fit is how to account for long strings. This could result in a very wide column which is limited to 256 in Excel.
This method now works in Release 39.
I just started using this awesome class. I had a need for bestfit/auto fit for column. For some reason when this attribute is set, it never works. We need to calculate the width at design time.
*-- Added maxwidth N(16,9) field to xl_columns cursor in createWorkingCursors method
*-- in setCellValue method in the end between this.RestoreVFPSettings () and Catch to loException added this code
-- add tnBestfitFactor as the last parameter in setCellValue method . Also add lcKey and lnWidth to the locals on top