Page Align Bottom (Spread.WinForms.5.dotNet35)

Page Align Bottom (Spread.WinForms.5.dotNet35)

Posted by: heidi on 4 February 2019, 8:31 am EST

• 

  heidi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 February 2019, 8:31 am EST

  Hi,

  I’m using Spread.WinForms.5.dotNet35 in Visual Studio Professional 2015.
  
  I need to output my spreadsheet content from the bottom up (instead of top down) . I need to do this for both screen and printed output. Is there a way to align the output to the bottom?

  So instead of this…

  
  
  Row0,Col0 Row0,Col1 Row0,Col2
  
  Row1,Col0 Row1,Col1 Row1,Col2
  
  Row2,Col0 Row2,Col1 Row2,Col2
  
  
  
  
  
  
  
  
  
  
  
  …
  
  

  I need this…

  
  
  
  
  
  
  
  
  
  
  
  
  …
  
  Row0,Col0 Row0,Col1 Row0,Col2
  
  Row1,Col0 Row1,Col1 Row1,Col2
  
  Row2,Col0 Row2,Col1 Row2,Col2
  
  

  Thanks in advance,
  
  Heidi

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 5 February 2019, 7:04 am EST

  Hello Heidi,

  The only workaround for your request I can think of it to include new line characters in Header’s text as given in code below:-

  printset.Header = "Page Header " + vbCrLf + vbCrLf + vbCrLf 
  

  Hope it helps.

  Thanks,
  
  Reeva