Hi,

I am using UltraGridExcelExporter Export method to data from UltraGrid to Excel. During the export, I am receiving an exception for trying to set a string value with more than 32767 characters into a cell. My work around is to intercept this exception during RowExporting event and create a new worksheet setting the value there but split into multiple cells. I want to copy the first row's value and formatting from "Sheet1" to the new page. I am able to copy the values but formatting does not change even when I try to manually set it. I tried using CellFormat.SetFormatting method and nothing works. What is the best approach to this or does that method not work as I assume it should.

Thanks,

RayExample.zip