Spreadsheetgear provides ability to create PrintPreview window - using WorkbookView.PrintPreview(). But it seems impossible to modify that window. That function returns void and there are no properties to control the visual content of that window. Please, say me I'm wrong.... Have I missed something? ...
I have a C# application that uses SpreadsheetGear's WorkbookView control. A user wants to be able to have changes he makes to comments on a cell saved. Does anyone know of a way to capture changes when a user edits a comment. The cell edit events are not fired when a comment is edited and I can not find any way to capture changes a user...
I am using Spreadsheetgear to create and modify charts. I can create a chart and modify the data easily, however, I cannot seem to modify the orientation of text the way that I want. The text lies on the x-axis and I am trying to get it to display at a 45 degree angle. I can do this manually by right clicking on the chart and manual...
I'm evaluating the SpreadsheetGear component for Excel file manipulation. However, out of the box the fonts look slightly blurred or hazy when the same spreadsheet is viewed side-by-side with Excel. Is there some anti-aliasing setting I'm missing? Or is this by design? ...
Dear Stackoverflow community. Development Platform: .NET 2.0 Platform: ASP.NET Spreadsheetgear: 2008 Language: C# Is there a way to retrieve the Length in bytes of a workbook without copying it/saving it to another object? I went through the documentation and several attempts with no success. I am saving the workbook by using the Sav...
I am using Spreadsheetgear to create charts in Excel. I create a column chart with an axis title on the y-axis. chart.Axes[SpreadsheetGear.Charts.AxisType.Value].HasTitle = true; chart.Axes[SpreadsheetGear.Charts.AxisType.Value].AxisTitle.Text = "Market Value"; However, the axis tile is in a horizontal orientation. I want it in a vert...
How to add filter to excel work sheet columns using SpreadsheetGear? ...
Hey How to validate integer and float in excel using spreadsheet gear. Thanks in Advance Avinash ...
I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files. I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work. So, apart from Excel itself, are there any other compone...
My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel. For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, ...
How to read Excel data having Number format ;;; ie hidden value in C# using spreadsheet gear. ...
How to prevent selection of cell/row and copy/cut of data from excel sheet,created dynamically in c# using SpreadSheetGear. ...
Is it possible to run existing excel macros in Spreadsheetgear? ...
Hello, I've decided to try SpreadsheetGear to generate excel workbooks. But on the very first workbook I've met "Number stored as text" problem. The problem doesn't go away even if I apply formatting to the cells (I tried to apply formatting before and after setting cell values) like this: r = worksheet.Cells[1, i, grid.Rows.Count - 1,...
Is there a way to hide the A,B,C column headers and 1,2,3 row headers in the SpreadsheetGear 2010 control? We are using this as a display only control and showing these headings gives the impression that the data can be edited. Thanks. ...
Hi, I have Spreadsheetgear and I'm wondering if anyone knows if 2009 edition supports PivotCharts, does anyone know how to do this? Cheers, Doga ...
The requirement is to get the chart data range programmatically via SpreadSheetGear. It seems there is no API to return chart data range directly in SpreadSheetGear, the only way is to calculate the range. What I am doing now is to go through all the Series in the chart, get the starting/ending row/column and compose them to range object...