.NET (Core and Framework)

private void SaveScrollPosition()
{
  if ( Loading ) return;

  var document = _Control.Document;
  if ( document == null ) return;

  var body = document.Body;
  if ( body == null ) return;

  if ( body.ScrollLeft != 0 || body.ScrollTop != 0 )
  {
    ScrollPositionX = body.ScrollLeft;
    ScrollPositionY = body.ScrollTop;
    return;
  }

  // for html with a DOC tag
  var htmls = document.GetElementsByTagName( "HTML" );
  if ( htmls == null ) return;
  if ( htmls.Count == 0 ) return;

  var html = htmls[ 0 ];
  if ( html == null ) return;

  if ( html.ScrollLeft != 0 || html.ScrollTop != 0 )
  {
    ScrollPositionX = html.ScrollLeft;
    ScrollPositionY = html.ScrollTop;
    return;
  }
}

----------------------------------
Be excellent to each other

AND (upper(TRIM("STATUS")) LIKE ('%' || upper(TRIM(nvl(:STATUS,'%')) || '%')

Collin Jasnoch wrote:

It would be nice if the icon propogated over from the actual project... but I guess you can only ask for so much from MS.

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="2" x:FullColumns="1"
   x:FullRows="1">
   <Row>
    <Cell><Data ss:Type="String">Hello</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>1</ActiveRow>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>