We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Column Width + Template File Setting Problems

Hi I have an application (C#) that will print information to excel file , I have a template excel (repbldgFormat.xls) file that Has a setting for columns width each column in the sheet has different size , In addition there is a two Images file , I set those Images as (Don’t Move or size with cells) at the template file. On My application there is a grid of information, the user has the ability to hide or display some columns on the applications grid, then the report on the excel file depends on this result if column(A (in the application is hidden then column lets say (10) at the excel file should be hidden and The first column in the file should increased by the size of the hidden column. When I tried to do this function I found the following problem results: 1) At the saved file , the Images are Moved from its position if some columns hided. 2) At the saved file the function of increasing the column size not works. Attached with my message the procedure syntax I comment in the syntax the position where the problem occurred by this comments: ///----> the Problems for Me Starts from Here //The Problem Starts Here //The Columnwidth Not Accepting the New Value of Width. Note : The office version is 2000. Thanks excelRwProblem_9526.zip

1 Reply

AD Administrator Syncfusion Team January 12, 2005 03:26 AM UTC

Hi Mohammad, Could you please send me the template file in the direc trac incident that you have created regarding this issue. Thanks. Best regards, Stephen. >Hi > > I have an application (C#) that will print information to excel file , I have a template excel (repbldgFormat.xls) file that Has a setting for columns width each column in the sheet has different size , In addition there is a two Images file , I set those Images as (Don’t Move or size with cells) at the template file. >On My application there is a grid of information, the user has the ability to hide or display some columns on the applications grid, then the report on the excel file depends on this result if column(A (in the application is hidden then column lets say (10) at the excel file should be hidden and The first column in the file should increased by the size of the hidden column. >When I tried to do this function I found the following problem results: >1) At the saved file , the Images are Moved from its position if some columns hided. >2) At the saved file the function of increasing the column size not works. >Attached with my message the procedure syntax >I comment in the syntax the position where the problem occurred by this comments: >///----> the Problems for Me Starts from Here >//The Problem Starts Here >//The Columnwidth Not Accepting the New Value of Width. > >Note : The office version is 2000. > >Thanks > > >excelRwProblem_9526.zip > >

Loader.
Live Chat Icon For mobile
Up arrow icon