GdPicture.NET.14
GdPicture14 Namespace / GdPictureDocumentConverter Class / SpreadsheetMaximumContentWidthPerSheet Property
Example





In This Topic
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
'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).
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");
    }
}
See Also