GemBox.Spreadsheet - .NET - V3.1 - Support

von GemBox Software - Produkttyp: Komponente / .NET Class / 100% Managed Code

Forum

GemBox.Spreadsheet Prof 3.1 veug2401 28-Jul-2008 15:33:15

How to set print range?
Antworten

GemBox.Spreadsheet tony.snowdon [United Kingdom] 08-Jul-2008 18:20:36

What is the limited functionality of free eval.
Antworten

GemBox.Spreadsheet t.vasya [Ukraine] 21-Feb-2008 09:23:47

I am trying to add a picture into the worksheet, but file created using SaveXls is not readable by MS Excel 2007 (mesage given by Excel is "File error:data may have been lost"). Excel 2003 opens this file without problems. And I cannot use SaveXlsx because compartibility with older version of Office is required.
Antworten

RE: GemBox.Spreadsheet zeljkos [Croatia] 21-Feb-2008 09:57:35

To use XLSX in older versions of MS Excel, use Microsoft Office Compatibility Pack: Microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
Since Microsoft changed how images are handled in XLS, GemBox.Spreadsheet generated XLS files with images may not work in Excel 2007 or Excel 2003 SP3. XLSX is a truly open specification so we recommend to users which need images, charts and pivot tables to use XLSX.
Antworten

GemBox.Spreadsheet Converting to HTML siburton [United Kingdom] 13-Feb-2008 22:29:13

I am trying to use the GemBox.Spreadsheet Free edition to convert an Excel spreadsheet to HTML.
I can't work out how to preserve the Excel cell formatting (eg date display format).
Can anyone help me?
Thanks
Antworten

RE: GemBox.Spreadsheet Converting to HTML zeljkos [Croatia] 15-Feb-2008 15:33:57

Hi,
If you want DateTime display format different than default, you need to use HtmlExporterOptions and override MethodCellValueToHtml with your custom method. This is an example how to provide custom methods to control every detail of HTML export: GemBoxSoftware.com/help/GemBox.Spreadsheet.HtmlExporterOptions.html
Zeljko
Antworten

GemBox.Spreadsheet luferma06 [Colombia] 02-Feb-2008 18:47:57

Hi I am testing your evaluation version, where could see examples of codes like open a existing woorkbook, save, read and write in a spreadsheet of a woorkbook, and more examples for a program that I am developing in visual basic 2005 using your control, please give the URL where is this examples, please need help, many thanks
Antworten

RE: GemBox.Spreadsheet zeljkos [Croatia] 15-Feb-2008 15:27:29

The best collection of samples is available if you install GemBox.Spreadsheet Free version from: ComponentSource.com/products/gembox-spreadsheet/downloads.html
Only URL that I can give that contains read/write/load/save examples is: GemBoxSoftware.com/GBSpreadsheet.htm#Features

Zeljko
Antworten

GemBox.Spreadsheet vennegoor.marieke [The Netherlands] 24-Jul-2007 14:17:53

I can't find any posibility to add validations to cells (like setting the maximum length of a filed or a selection list). Is this possible?
Antworten

RE: GemBox.Spreadsheet zeljkos [Croatia] 07-Aug-2007 16:13:05

Dropdown / data validation is currently supported only via workbook templates, it is not supported in API. So, you can create an empty XLS file with desired cells with data validation settings, load it to GemBox.Spreadsheet with ExcelFile.LoadXls() method, insert all other data and formatting, and then save with ExcelFile.SaveXls() method.
Antworten

GemBox.Spreadsheet sadikin_halim [Indonesia] 11-Jul-2007 02:26:04

Dear all,

My problem is related to setting margin in printout of Excel file since the default value of margin is 0.75 and i need to set it to be zero (0) . If i set it from Excel i have to set every time i changed to another Excel file. Is there any options in GemBox syntax that i can use from the ASP .NET using VB script.
Antworten

RE: GemBox.Spreadsheet zeljkos [Croatia] 07-Aug-2007 16:22:47

Currently, you can only set HeaderMargin and FooterMargin in GemBox.Spreadsheet API. However, you can set other margins using templates (loading existing xls file as a template and then modifying it). Set correct left and right margins in the template file.
Antworten

GemBox.ExcelLite kasten [USA] 20-Jun-2006 17:40:22

Can gembox.excelLite be distributed to clients in a cllent-server configuration?
Antworten

ExcelLite Christian [Chile] 13-May-2006 18:07:30

Is Support for Web Forms .NET?
Antworten

RE: ExcelLite zeljko (GemBox Software) 14-Jun-2006 10:20:23

Yes, Web Forms (ASP.NET) are supported. Check live Web Demo at: GemBoxSoftware.com/WebDemo
Our technical department also gives support for ASP.NET.
Antworten