Hi Jerry,
I put together a small sample demonstrating applying SUM function over a range.
Forums_Sum_Range_1184.zip
Please let us know if you see the problem in this sample.
Regarding your formatting problem, we have noticed similar problems and have corrected them. Please test with beta version 2.0.2.0 and let us know if the problem exists. Please put together a small sample or send us the code snippet you are using.
I have sent you a separate email with the download instructions for version 2.0.2.0.
Best Regards,
Stephen.
>After exporting data to an Excel file with ExcelRW, I am unable to change the cell formatting (from Excel) when opening the exported file in Excel.
>
>Using the SUM function on a range of cells also will not work.
>
>Is this a problem with Excel or with ExcelRW?
>
>Thanks,
>
>Jerry
>
>
>
>
>