SpreadsheetMaximumContentWidthPerSheet Property (GdPictureDocumentConverter)

In This Topic

Decimal value indicating the maximum width of the sheet content, in millimeters. Maximum content width ignores margins. When multiple pages are required to render a sheet, the content width will be the sum of the content width of each page. If set to zero or less, no limitation will be applied.

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
Public Property SpreadsheetMaximumContentWidthPerSheet As Single

public float SpreadsheetMaximumContentWidthPerSheet {get; set;}

public read-write property SpreadsheetMaximumContentWidthPerSheet: Single;

public function get,set SpreadsheetMaximumContentWidthPerSheet : float

public: __property float get_SpreadsheetMaximumContentWidthPerSheet();
public: __property void set_SpreadsheetMaximumContentWidthPerSheet( 
   float value
);

public:
property float SpreadsheetMaximumContentWidthPerSheet {
   float get();
   void set (    float value);
}

Property Value

The default value is 7000.

Example

Loading and converting a .xlsx with SpreadsheetMaximumContentWidthPerSheet and SpreadsheetMaximumContentHeightPerSheet set to 0 (no limitation).

VB.NET
C#

Using gdpictureDocumentConverter As New GdPictureDocumentConverter()
    gdpictureDocumentConverter.SpreadsheetMaximumContentWidthPerSheet = 0
    gdpictureDocumentConverter.SpreadsheetMaximumContentHeightPerSheet = 0
    Dim status As GdPictureStatus = gdpictureDocumentConverter.LoadFromFile("test_xlsx.xlsx", GdPicture14.DocumentFormat.DocumentFormatXLSX)
    If status = GdPictureStatus.OK Then
        MessageBox.Show("The file has been loaded successfully.", "GdPicture")
        status = gdpictureDocumentConverter.SaveAsPDF("Converted.pdf", PdfConformance.PDF)
        If status = GdPictureStatus.OK Then
            MessageBox.Show("The file has been saved successfully.", "GdPicture")
        Else
            MessageBox.Show("Failed to save file. Status: " + status.ToString(), "GdPicture")
        End If
    Else
        MessageBox.Show("Failed to load file. Status: " + status.ToString(), "GdPicture")
    End If
End Using

using (GdPictureDocumentConverter gdpictureDocumentConverter = new GdPictureDocumentConverter())
{
    gdpictureDocumentConverter.SpreadsheetMaximumContentWidthPerSheet = 0;
    gdpictureDocumentConverter.SpreadsheetMaximumContentHeightPerSheet = 0;
    GdPictureStatus status = gdpictureDocumentConverter.LoadFromFile("test_xlsx.xlsx", GdPicture14.DocumentFormat.DocumentFormatXLSX);
    if (status == GdPictureStatus.OK)
    {
        MessageBox.Show("The file has been loaded successfully.", "GdPicture");
        status = gdpictureDocumentConverter.SaveAsPDF("Converted.pdf", PdfConformance.PDF);
        if (status == GdPictureStatus.OK)
        {
            MessageBox.Show("The file has been saved successfully.", "GdPicture");
        }
        else
        {
            MessageBox.Show("Failed to save file. Status: " + status.ToString(), "GdPicture");
        }
    }
    else
    {
        MessageBox.Show("Failed to load file. Status: " + status.ToString(), "GdPicture");
    }
}

Reference

GdPictureDocumentConverter Class
GdPictureDocumentConverter Members