sysperfana/heapanalyser/Libraries/Engine/HeapComparisonLib/CSV/Comparers/SlackSpace.cs
/*
* Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* - Redistributions of source code must retain the above copyright notice,
* this list of conditions and the following disclaimer.
* - Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
* - Neither the name of Nokia Corporation nor the names of its contributors
* may be used to endorse or promote products derived from this software
* without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
*
* Initial Contributors:
* Nokia Corporation - initial contribution.
*
* Contributors:
*
* Description:
*
*/
using System;
using System.Runtime.InteropServices;
using Microsoft.Office.Interop.Excel;
using SymbianExcelUtils;
namespace HeapComparisonLib.CSV.Comparers
{
internal class SlackSpace : ComparerBase
{
#region Constructors & destructor
public SlackSpace( Worksheet aSheet, string aFileName1, string aFileName2 )
: base( aSheet, aFileName1, aFileName2 )
{
}
#endregion
#region API
public override string DeltaFormula( int aIndex )
{
int column = 4;
return Utils.MakeSummationFormula( 3, Row - 2, column, Sheet );
}
public override void PrepareWorksheetReadyForData()
{
Sheet.Name = "Slack Space";
//
Range r = null;
//
Utils.SetValue( Row, 1, Sheet, "Thread" );
r = Utils.SetValue( Row, 2, Sheet, "Slack Space" );
r.AddComment( FileName1 );
r = Utils.SetValue( Row, 3, Sheet, "Slack Space" );
r.AddComment( FileName2 );
Utils.SetValue( Row, 4, Sheet, "Delta" );
//
Utils.MakeBoxedTitleRow( Row, 4, Sheet, 0xFF0000 );
//
NextRow();
NextRow();
}
public override void FinaliseWorksheet()
{
// Make totals
NextRow();
Utils.SetValue( Row, 1, Sheet, "Totals:" );
Utils.SetValue( Row, 2, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 2) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 2) + ")" );
Utils.SetValue( Row, 3, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 3) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 3) + ")" );
Utils.SetValue( Row, 4, Sheet, DeltaFormula( 0 ) );
Utils.BoldRow( Row, Sheet );
// Calculate column sizes
Utils.AutoFitColumn( 1, Sheet, 70.0 );
Utils.AutoFitColumn( 2, Sheet );
Utils.AutoFitColumn( 3, Sheet );
Utils.AutoFitColumn( 4, Sheet );
}
public override void Compare( CSVThread aMaster, CSVThread aOther )
{
Utils.SetValue( Row, 1, Sheet, aMaster.FullName );
if ( !aMaster.IsDefault )
Utils.SetValue( Row, 2, Sheet, aMaster.FreeSpaceSlack.ToString() );
if ( !aOther.IsDefault )
Utils.SetValue( Row, 3, Sheet, aOther.FreeSpaceSlack.ToString() );
//
if ( aMaster.IsDefault || aOther.IsDefault )
{
Utils.GetRangeByColumnAndRow( Row, 1, Row, 1, Sheet ).Font.Bold = true;
}
long delta = aMaster.FreeSpaceSlack - aOther.FreeSpaceSlack;
Utils.SetValue( Row, 4, Sheet, ( delta * -1).ToString() );
// Colourise line according to difference
int colour = 0x000000; // black
if ( aOther.FreeSpaceSlack > aMaster.FreeSpaceSlack )
{
colour = 0x0000FF; // red
}
else if ( aOther.FreeSpaceSlack < aMaster.FreeSpaceSlack )
{
colour = 0xFF0000; // blue
}
Utils.SetRangeFontColour( Row, 4, Row, 4, Sheet, colour );
//
NextRow();
}
#endregion
}
}