Stack Overflow
Stack Overflow

Questions tagged [spreadsheetgear]

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear LLC is a privately held software publisher located in Lenexa, Kansas. The company was founded by Joe Erickson in 2003 to develop a new generation of Microsoft Excel compatible spreadsheet components for Microsoft .NET and Silverlight.

With a singular focus on spreadsheet technology and unparalleled experience, SpreadsheetGear is committed to being the leader in spreadsheet components.

Resources

254 questions
1
vote
1 answer

Getting point values from a SpreadsheetGear 2010 chart series

I'm using SpreadsheetGear 2010 to draw column charts, and wish to loop through all data points, colouring the negative ones red... But I cannot see a way to get to the "value" of the point as I loop through. The following (interpreting the data…
Chris B
  • 709
  • 2
  • 14
  • 32
1
vote
1 answer

Changing Spreadsheetgear axis title orientation on a column chart

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 =…
Daniel
  • 5,602
  • 4
  • 33
  • 36
1
vote
0 answers

Attack Vectors into Microsoft Excel

We are writing a (web) application that will include a function that will read data to and from Excel. Some of these inputs will come directly from the user. I'm trying to assess whether there are any significant attack vectors here. Obviously we…
Chris
  • 3,487
  • 3
  • 25
  • 37
1
vote
2 answers

How to get range of last column excel (spreadsheetgear)

I'm trying to get the total number of columns so that i can set my range from column C to N column. I'm trying to go through each column and pull out the data i need into an array until i reach the last column with data in it. I tried the below…
Marc Howard
  • 395
  • 2
  • 6
  • 25
1
vote
0 answers

How to show Spreadsheet Gear Workbook in Webpage?

I want to show Spreadsheet Gear Workbook in Webpage. I have Google it but couldn't find answer. How to do this?
Jankya
  • 966
  • 2
  • 12
  • 34
1
vote
0 answers

SpreadsheetGear in WPF - binding cell value to property in MVVM

Is it possible to bind an object's property to a SpreadsheetGear cell value in a MVVM application? Or alternatively is it possible to bind any WPF UI component to the cell value? I need to reflect a value in a cell (IRange, holding a formula) in a…
Nuts
  • 2,755
  • 6
  • 33
  • 78
1
vote
1 answer

Clone SpreadsheetGear worksheet

How to copy and duplicate an existing IWorksheet object in SpreadsheetGear? I want to make identical worksheet based on another worksheet (all values, formulas, named ranges etc. should follow).
Nuts
  • 2,755
  • 6
  • 33
  • 78
1
vote
1 answer

How can i change Error message?

I'm using worksheet protection IWorksheet.ProtectContents. If i try to change something there is message: "Locked cells cannot be modified when protection is enabled". So is there a way to change text and title of this message or though hide it?
Max Meleshko
  • 43
  • 4
1
vote
1 answer

Spreadsheet gear Chart's x axis date is appearing as whole number

I am generating an output using spreadsheet gear which contains chart as output and its XAxis has date and y axis has numbers to plot the chart. At the end, application will copies the source workbook sheets to new workbook's spreadsheet. While…
Venkatramanan Lakshmanan
  • 63
  • 10
1
vote
1 answer

Workaround or alternative to spreadsheetgear image(chart).GetBitmap()?

I'm crawling "lots" (100K+) of excel files using spreadsheetgear, however i found out that when Spreadsheetgear hits a chart with lots of points, everything breaks loose: memory isn't released & it takes up a lot of memory as well as being very…
Ronan Thibaudau
  • 3,413
  • 3
  • 29
  • 78
1
vote
4 answers

SpreadSheetGear WorkbookView - Cells

I have a SpreadSheetGear WorkbookView in my form. The SpreadSheetGear WorkbookView has filled with excel file 10 rows and 10 columns. I want to get the data from the cells using the code below: for (int i = 0; i < cells.Range.RowCount; i++) { …
Ventsislav Vulchev
  • 26
  • 1
  • 4
1
vote
1 answer

SaveToStream then write to BLOB mess up the Excel file

I'm trying to save a SpreadsheetGear Excel workbook to a BLOB field thru a DbAdapter Try Dim stream As New System.IO.MemoryStream() customFormatWorkBook.SaveToStream(stream, SpreadsheetGear.FileFormat.Excel8) Dim bytes(stream.Length - 1)…
Teejay
  • 7,210
  • 10
  • 45
  • 76
1
vote
0 answers

Detecting Circular References in Spreadsheetgear Workbook

Has anyone discovered how to detect circular references in a Spreadsheetgear Workbook control or creating custom code to detect it? There is no available Property in Spreadsheetgear, so i am hoping someone has built a workaround that they could…
Estate Master
  • 193
  • 3
  • 13
1
vote
1 answer

Spreadsheetgear: Exporting from DataGrid and DataList to single Excel file plus formatting

Previously before installing SpreadSheetGear, I manage to have an export button that can export all the correct data from both the DataList and DataGrid into an Excel file, but the formatting is a big problem. After every row of data from the…
ariellll
  • 33
  • 8
1
vote
1 answer

SpreadsheetGear - Create a workbookview by code

How do I create a workbookview using Spreadsheetgear with code. I do not want to use the workbookview control on the form, I want to create it dynamically, then place it on a tab control all by code.
crcarpenter
  • 15
  • 3
1 2 3
…
16 17