I have written a bit of code that generates the xml needed to display an Excel Workbook with multiple worksheets. I have created a tabbed panel with 5 different grids one per panel.
One of the features of the spreadsheet class is to grab the width of each column and create the same size column in Excel, this works well, except if the grid has not been displayed. In other words every tab that you display, the coresponding grid widths convert to Excel fine, the ones that you have not clicked get the data properly, but the sizes are very small, but not all the same size. To get the size of the column I use; Math.ceil(dg.columns[i].width) Any clues as to what might be going on, or better yet how to solve it? Paul
