Infragistics Forums

I should have mentioned WorksheetView .PageLayout is a view only supported by Excel 2007, so if you're using an earlier version of Excel then yes it fallback to normal view. I don't think there is a way to get the Workbook to open as if the user had clicked Print | Print Preview on their own;...

Are you using the WebGridExcelExporter control to export to XLS? Because there is a security filter in the export control which tightly restricts the characters that can be specified in Worksheet names and Download filenames, and it could appear not to accept Russian or Japanese characters. It's...

Are you using the latest hot fix? This sounds like an issue reported in 2007 , that was fixed by a hot fix shortly after release. In the way of background, the "junk" values are probably the number of days since 1900. It is the underlying numeric way in which Excel represents date/times per...

[quote user="Cogenesis IT Consulting"] How can I cahnge the Font color in the Excel exporting worksheet. [/quote] Use the FormattedString and FormattedStringFont objects, for an example see my blog posting, http://blogs.infragistics.com/blogs/derekh/archive/2007/12/27/coloring-keywords-in-your...

Hello All, How do I use the ultraGridExcelExporter to export a ultrawingrid that has some data in it to an Excel file, but I don't want to include the column names? I tried using this overloaded Export(grid, workbook, startRow, startColumn) but it only gives me an Excel file where the column names...

I need to confure the xamDataGrid so that the first column is a row header and has the same look and feel as the column header. The row header isn't editable. The idea is that this will give me a grid which behaves like Excel (row and column headers). Does anyone have any idea how to do this..? None...

Hi!!! I have a problem when I'm exporting a datagrid which is grouped by 2 columns. the problem is that column values appears in a diferent column in the grid and in the excel file. When I group by 2 columns, summary values(Totals), move 2 columns right. Anyone else about what is happening. It`s...

Hi, The save method of the workbook takes the location where the excel file is to be created. oWorkbook.save("C:\Documents and settings\abc\desktop") Instead of hardcoding the location I want the user to select the location of where the excel is to be created. I would appreciate if some replies...

I can't find a way of programatically setting a header row to repeat on every printed page? This seams to be a missing feature of the Excel's PrintOptions class, or am I missing something? I'm using version 2008 vol 2.

I did try this but for some reason, when using the sepperate grid, it just returned without creating the Excel document, so I have removed AJAX from the grid for now until I have time to investigate further, although this has performance overheads as some of the reports can have a lot of rows. I did...